{var%20f='http://v.t.sina.com.cn/share/share.php?appkey=1515056452',u=z||d.location,p=['&url=',e(u),'&title=',e(t||d.title),'&source=',e(r),'&sourceUrl=',e(l),'&content=',c||'gb2312','&pic=',e(p||'')].join('');function%20a(){if(!window.open([f,p].join(''),'mb',['toolbar=0,status=0,resizable=1,width=440,height=430,left=',(s.width-440)/2,',top=',(s.height-430)/2].join('')))u.href=[f,p].join('');};if(/Firefox/.test(navigator.userAgent))setTimeout(a,0);else%20a();})(screen,document,encodeURIComponent,'','','https://www.manongdao.com/data/attach/logo/logo.png', '推荐 爱情/是我丢掉的垃圾 的问题《IBM DB2 created schema is not visible?》','https://www.manongdao.com/q-933328.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}
I create a new login and user name while installing the db2 DBMS. After installation I installed IBM data studio and then connected to DB2. I created schema and a table for test purpose. But I can't see this schema while I write sql query in data studio query editor (code asist). I also can't see this schema while I connect from netbean services. Is there any issue with privileged as I provided all privileged while creating schema to the user. I am using DB2 express edition.
相关问题
- NOT DISTINCT query in mySQL
- Flush single app django 1.9
- keeping one connection to DB or opening closing pe
- Mysql-installer showing error : Memoy could not be
- Android Room Fetch data with dynamic table name
相关文章
- Connection pooling vs persist connection mysqli
- Escape percentage sign DB2 SQL
- Speed up sqlFetch()
- How Do I Seed My Database in the setupBeforeClass
- I set a MySQL column to “NOT NULL” but still I can
- Where in Django can I run startup code that requir
- Google OAuth 2.0 User id datatype for MYSQL
- Restore deleted records in PostgreSQL
in db2 you have to predefine the statements its not like oracle or sql where you can commit with a button..... i think after creating a schema you might have forgotten to set the default schema and system path... that might be the reason
You need to run the query or commit the statement in Db2 as submitted in comment.
Pheraps it coulb be usefull, even I use DataStudio
In my case database manager is DB2 for z/OS; you can try to change it ...