But first you should create your stored procedure in the destination database MYSAMPLE.
但是,首先应该在目标数据库mysample中创建存储过程。
Until now, only an empty copy of table SALES in the target database MYSAMPLE has been created.
到目前为止,只在目标数据库mysample中创建了sales表的空拷贝。
The cause of the error message is the way the connection to the database was established: db2 "connect to MYSAMPLE".
这个错误消息是由于建立数据库连接的方式造成的:db 2 “CONNECTTO MYSAMPLE ”。
This XML schema will be registered in DB2's internal repository under the SQL schema user1 and the XML schema mysample.
这个XML模式将被注册到SQL 模式user1和 XML 模式 mysample下的DB2内部存储库中。
As you want to execute the following statements against the target database MYSAMPLE, you alter the CONNECT statement accordingly.
因为希望对目标数据库mysample执行下面的语句,所以要相应地修改CONNECT语句。
To do so, you start with deleting all the rows that you have just imported in table SALES in the target database MYSAMPLE as Listing 16 shows.
为此,首先删除刚才在目标数据库mysample中的sales表中导入的所有行,见清单16。
The user mapping defines how the authorization ID at the local database (MYSAMPLE) is mapped to an authorization ID at the remote database (SAMPLE).
用户映射定义本地数据库(MYSAMPLE)中的授权ID如何映射到远程数据库(SAMPLE)中的授权id。
Before executing the statements in file sales.ddl against the target database MYSAMPLE, open the file in a text editor and make two changes to the generated statements.
在对目标数据库mysample执行sales . ddl文件中的语句之前,在文本编辑器中打开此文件并对生成的语句做两处修改。
Before executing the statements in file sales.ddl against the target database MYSAMPLE, open the file in a text editor and make two changes to the generated statements.
在对目标数据库mysample执行sales . ddl文件中的语句之前,在文本编辑器中打开此文件并对生成的语句做两处修改。
应用推荐