level 1
LJ神枪手
楼主
DB2 V11.1,向表中导入数据出现警告(使用导入应用程序,DEl格式):
CALL SYSPROC.ADMIN_CMD( 'IMPORT FROM "C:\Users\Administrator\Desktop\临时1.csv" OF DEL MESSAGES ON SERVER INSERT INTO ADMINISTRATOR.ST_PARATABLE_SY' )
IWAQ0003W SQL warnings were found
SQLState=01H52 例程 "SYSPROC.ADMIN_CMD" 的执行已完成,但是执行期间至少遇到了一个错误 "SQL3196"。提供了更多信息。. SQLCODE=20397, SQLSTATE=01H52, DRIVER=4.19.56
Query execution time => 2 s: 948 ms
求告知原因,谢谢
2018年01月08日 02点01分
1
CALL SYSPROC.ADMIN_CMD( 'IMPORT FROM "C:\Users\Administrator\Desktop\临时1.csv" OF DEL MESSAGES ON SERVER INSERT INTO ADMINISTRATOR.ST_PARATABLE_SY' )
IWAQ0003W SQL warnings were found
SQLState=01H52 例程 "SYSPROC.ADMIN_CMD" 的执行已完成,但是执行期间至少遇到了一个错误 "SQL3196"。提供了更多信息。. SQLCODE=20397, SQLSTATE=01H52, DRIVER=4.19.56
Query execution time => 2 s: 948 ms
求告知原因,谢谢