IBM DB2 创建的模式不可见? [英] IBM DB2 created schema is not visible?

问题描述

我在安装 db2 DBMS 时创建了一个新的登录名和用户名.安装后，我安装了 IBM Data Studio，然后连接到 DB2.我为测试目的创建了模式和表.但是当我在数据工作室查询编辑器(代码辅助)中编写 sql 查询时，我看不到这个模式.当我从 netbean 服务连接时，我也看不到这个模式.特权是否有任何问题，因为我在为用户创建架构时提供了所有特权.我正在使用 DB2 express 版本.

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.

推荐答案

您需要在 Db2 中运行查询或提交在评论中提交的语句.

You need to run the query or commit the statement in Db2 as submitted in comment.

这篇关于IBM DB2 创建的模式不可见?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！