I am currently trying to load data from e.txt into tablea. I am getting error.
db2 connect to qw01p user wcs using abc
db2 "LOAD CLIENT FROM /dswork/ECONT/output/interface/e.txt OF DEL MODIFIED BY coldel| SAVECOUNT 0 ROWCOUNT 0 WARNINGCOUNT 0 MESSAGES XTMPRTI1.txt
REPLACE into WCSADM.TABLEA (DIVITEMSKU,LOCN,RGN,REGULARPRICE,CLEARANCEPRICE,PROMOPRICE1,PROMOENDTIME1,PROMOPRICE2,PROMOENDTIME2,PROMOPRICE3,PROMOENDTIME3,PROMOENDDATE) STATISTICS NO
COPY NO DATA BUFFER 8 SORT BUFFER 0 CPU_PARALLELISM 0 DISK_PARALLELISM 0 INDEXING MODE AUTOSELECT ALLOW NO ACCESS"
This is giving be following error
SQL0104N An unexpected token "END-OF-STATEMENT" was found following
"<identifier>". Expected tokens may include: "REMOTE". SQLSTATE=42601
thanks