Db2 error help



IBM's flagship relational database management system

Re: Db2 error help

Postby coldplay1991 » Thu Dec 08, 2011 5:27 pm

You didnt read my SQL, There is WHEN lol.
coldplay1991
 
Posts: 59
Joined: Tue Nov 15, 2011 5:47 am
Has thanked: 0 time
Been thanked: 0 time

Re: Re: Db2 error help

 

Re: Db2 error help

Postby 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
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 2690
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisys (almost)
Has thanked: 4 times
Been thanked: 105 times

Re: Db2 error help

Postby coldplay1991 » Thu Dec 08, 2011 5:37 pm

An IBM expert : Told me you have to use WHEN. (My professor)
coldplay1991
 
Posts: 59
Joined: Tue Nov 15, 2011 5:47 am
Has thanked: 0 time
Been thanked: 0 time

Re: Db2 error help

Postby NicC » Thu Dec 08, 2011 6:01 pm

Obviously not an expert then - the real 'expert' is the manual.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 2690
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisys (almost)
Has thanked: 4 times
Been thanked: 105 times

Re: Db2 error help

Postby coldplay1991 » Thu Dec 08, 2011 6:03 pm

He wrote the manual. Lol.
coldplay1991
 
Posts: 59
Joined: Tue Nov 15, 2011 5:47 am
Has thanked: 0 time
Been thanked: 0 time

Re: Db2 error help

Postby NicC » Thu Dec 08, 2011 6:13 pm

Well then, he has forgotten what he has written.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 2690
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisys (almost)
Has thanked: 4 times
Been thanked: 105 times

Re: Db2 error help

Postby 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'               
db2sysdba
 
Posts: 18
Joined: Wed Sep 28, 2011 4:14 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Db2 error help

Postby 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
db2sysdba
 
Posts: 18
Joined: Wed Sep 28, 2011 4:14 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Db2 error help

Postby coldplay1991 » Thu Dec 08, 2011 6:50 pm

SAME -104 :( OMG I AM DOOMED.
coldplay1991
 
Posts: 59
Joined: Tue Nov 15, 2011 5:47 am
Has thanked: 0 time
Been thanked: 0 time

Re: Db2 error help

Postby db2sysdba » Thu Dec 08, 2011 6:58 pm

Kindly provide the input dataset first row with cols position in coded format.
db2sysdba
 
Posts: 18
Joined: Wed Sep 28, 2011 4:14 pm
Has thanked: 0 time
Been thanked: 0 time

PreviousNext

Return to DB2

 


  • Related topics
    Replies
    Views
    Last post