db2 linux下 load数据有关问题

db2 linux下 load数据问题
第一次接触db2 下面的语句好多都不懂啥意思 ，在window下db2cmd下运行时可以正常加载数据

SQL code

load client from i_cb_jtsja_20110331.dat  of del modified by coldel0x03 keepblanks usedefaults nochardel MESSAGES ODS_I_CB_JTSJA.log  replace into ODS.ODS_I_CB_JTSJA

在linux下运行就报错

HTML code

SQL3501W  The table space(s) in which the table resides will not be placed in backup pending state since forward recovery is disabled for the database.SQL3418W  The NOCHARDEL file type modifier should not be specified if the data was exported using DB2. It is provided to support vendor data files that do not have character delimiters.SQL3109N  The utility is beginning to load data from file "/home/skptusr/odsdata/data/i_cb_jtsja_20110331.dat".SQL2036N  The path for the file or device "/home/skptusr/odsdata/data/i_cb_jtsja_20110331.dat" is not valid.SQL3107W  There is at least one warning message in the message file.Number of rows read         = 0Number of rows skipped      = 0Number of rows loaded       = 0Number of rows rejected     = 0Number of rows deleted      = 0Number of rows committed    = 0

我确定路径没问题，写绝对路径和在数据文件目录下执行都记录的日志都是这样，请高手帮解答

[解决办法]
导出的语句给出来一下，然后就可以判断导入语句怎么写的

查看更多 下一篇