Page 2 of 4

Re: Db2 error help

PostPosted: Thu Dec 08, 2011 5:27 pm
by coldplay1991
You didnt read my SQL, There is WHEN lol.

Re: Db2 error help

PostPosted: 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

PostPosted: 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

PostPosted: Thu Dec 08, 2011 6:01 pm
by NicC
Obviously not an expert then - the real 'expert' is the manual.

Re: Db2 error help

PostPosted: Thu Dec 08, 2011 6:03 pm
by coldplay1991
He wrote the manual. Lol.

Re: Db2 error help

PostPosted: Thu Dec 08, 2011 6:13 pm
by NicC
Well then, he has forgotten what he has written.

Re: Db2 error help

PostPosted: 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

PostPosted: 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

PostPosted: Thu Dec 08, 2011 6:50 pm
by coldplay1991
SAME -104 :( OMG I AM DOOMED.

Re: Db2 error help

PostPosted: Thu Dec 08, 2011 6:58 pm
by db2sysdba
Kindly provide the input dataset first row with cols position in coded format.