IBM Mainframe Forum

by **coldplay1991** » Thu Dec 08, 2011 5:27 pm

You didnt read my SQL, There is WHEN lol.

by **NicC** » Thu Dec 08, 2011 5:32 pm

And you did not read the manual, or read my post correctly, - the syntax for LOAD does not include the word WHEN

by **coldplay1991** » Thu Dec 08, 2011 5:37 pm

An IBM expert : Told me you have to use WHEN. (My professor)

by **NicC** » Thu Dec 08, 2011 6:01 pm

Obviously not an expert then - the real 'expert' is the manual.

by **coldplay1991** » Thu Dec 08, 2011 6:03 pm

He wrote the manual. Lol.

by **NicC** » Thu Dec 08, 2011 6:13 pm

Well then, he has forgotten what he has written.

by **db2sysdba** » Thu Dec 08, 2011 6:38 pm

Try this one

LOAD DATA INDDN SYSREC LOG YES REPLACE
INTO TABLE SHE00XX.AUDLOG
WHEN (9:16) = 'JOBINIT'

by **db2sysdba** » Thu Dec 08, 2011 6:38 pm

Try this LOAD card

LOAD DATA INDDN SYSREC LOG YES REPLACE
INTO TABLE SHE00XX.AUDLOG
WHEN (9:16) = 'JOBINIT'

Happy Learning,
db2sysdba

by **coldplay1991** » Thu Dec 08, 2011 6:50 pm

SAME -104

OMG I AM DOOMED.

by **db2sysdba** » Thu Dec 08, 2011 6:58 pm

Kindly provide the input dataset first row with cols position in coded format.

Db2 error help