db2 create/load via IXF generates error SQL0104N & SQLSTATE=42601
The following example:
db2 -v load from tab14.ixf of ixf modified by noheader create into STATHIST_TABLES
Generates the following message:
load from tab14.ixf of ixf modified by noheader create into STATHIST_TABLES
SQL0104N An unexpected token "END-OF-STATEMENT" was found following
"<identifier>". Expected tokens may include: "REMOTE". SQLSTATE=42601
can anyone tell me why?
I do know the files were generated on a UNIX box and I am now loading into w2k machine.
need answer ASAP thus the 500 points