CONNECT TO CMPDB USER "arradm" USING ; EXPORT TO "C:\ProgramFiles\IBM\SQLLIB\DB2\WEBCPTAB.IXF" OF IXF MESSAGES "C:\ProgramFiles\IBM\SQLLIB\DB2\WEBCPTAB.EXM" SELECT * FROM SPDB2.SERIAL_HDD; CONNECT TO ARR_TEST USER "db2admin" USING ; IMPORT FROM "C:\ProgramFiles\IBM\SQLLIB\DB2\WEBCPTAB.IXF" OF IXF MESSAGES "C:\ProgramFiles\IBM\SQLLIB\DB2\WEBCPTAB.IMM" CREATE INTO SPDB2.SERIAL_HDD IN USERSPACE1; CONNECT RESET;
CONNECT TO CMPDB USER "arradm" USING ; EXPORT TO "C:\personal\fujisawa\1111.IXF" OF IXF MESSAGES "C:\personal\fujisawa\1111.EXM" SELECT * FROM SPDB2.SERIAL_HDD where date(storets) between '2007-01-12' and '2007-01-13'; CONNECT RESET;
1 条评论:
CONNECT TO CMPDB USER "arradm" USING ;
EXPORT TO "C:\ProgramFiles\IBM\SQLLIB\DB2\WEBCPTAB.IXF" OF IXF MESSAGES "C:\ProgramFiles\IBM\SQLLIB\DB2\WEBCPTAB.EXM" SELECT * FROM SPDB2.SERIAL_HDD;
CONNECT TO ARR_TEST USER "db2admin" USING ;
IMPORT FROM "C:\ProgramFiles\IBM\SQLLIB\DB2\WEBCPTAB.IXF" OF IXF MESSAGES "C:\ProgramFiles\IBM\SQLLIB\DB2\WEBCPTAB.IMM" CREATE INTO SPDB2.SERIAL_HDD IN USERSPACE1;
CONNECT RESET;
CONNECT TO CMPDB USER "arradm" USING ;
EXPORT TO "C:\personal\fujisawa\1111.IXF" OF IXF MESSAGES "C:\personal\fujisawa\1111.EXM" SELECT * FROM SPDB2.SERIAL_HDD where date(storets) between '2007-01-12' and '2007-01-13';
CONNECT RESET;
发表评论