Page 2 of 4
Re: Db2 error help
Posted:
Thu Dec 08, 2011 5:27 pm
by coldplay1991
You didnt read my SQL, There is WHEN lol.
Re: Db2 error help
Posted:
Thu Dec 08, 2011 5:32 pm
by NicC
And you did not read the manual, or read my post correctly, - the syntax for LOAD does not include the word WHEN
Re: Db2 error help
Posted:
Thu Dec 08, 2011 5:37 pm
by coldplay1991
An IBM expert : Told me you have to use WHEN. (My professor)
Re: Db2 error help
Posted:
Thu Dec 08, 2011 6:01 pm
by NicC
Obviously not an expert then - the real 'expert' is the manual.
Re: Db2 error help
Posted:
Thu Dec 08, 2011 6:03 pm
by coldplay1991
He wrote the manual. Lol.
Re: Db2 error help
Posted:
Thu Dec 08, 2011 6:13 pm
by NicC
Well then, he has forgotten what he has written.
Re: Db2 error help
Posted:
Thu Dec 08, 2011 6:38 pm
by db2sysdba
Try this one
LOAD DATA INDDN SYSREC LOG YES REPLACE
INTO TABLE SHE00XX.AUDLOG
WHEN (9:16) = 'JOBINIT'
Re: Db2 error help
Posted:
Thu Dec 08, 2011 6:38 pm
by db2sysdba
Try this LOAD card
LOAD DATA INDDN SYSREC LOG YES REPLACE
INTO TABLE SHE00XX.AUDLOG
WHEN (9:16) = 'JOBINIT'
Happy Learning,
db2sysdba
Re: Db2 error help
Posted:
Thu Dec 08, 2011 6:50 pm
by coldplay1991
SAME -104
OMG I AM DOOMED.
Re: Db2 error help
Posted:
Thu Dec 08, 2011 6:58 pm
by db2sysdba
Kindly provide the input dataset first row with cols position in coded format.