SQL0104N when running load with ; delimiter

Toad for IBM DB2
1

Hi,

Having issue with load from client when using ‘;’ as column delimiiter:

LOAD CLIENT FROM
‘D:\tmp\DB2ADMIN.LOAD_TEST.del’ OF DEL
MODIFIED BY COLDEL; DECPT. REPLACE INTO “DB2ADMIN”.“LOAD_TEST” STATISTICS NO ALLOW NO ACCESS;

Error 09/24/2013 2:15:54 PM 0:00:00.043 - DB2 Database Error: ERROR [42601] [IBM][DB2/LINUXX8664] SQL0104N An unexpected token ““DB2ADMIN”” was found following “DECPT. REPLACE INTO”. Expected tokens may include: “JOIN”. 3 0

It seems for toad COLDEL; is end of 1st statement…

Load script is generated from browser>tables>utilities>load table

Thank you,

Ivan

2

If you will have a ; in your statement make sure your script statement delimiter is not set to ; in Tools | options.

See image for more details

delim.png
delim.png799×503 42 KB

3

Thank you Jeff,

with # as statement delimiter everything works ok.

Regards,

Ivan