Db2 error help



IBM's flagship relational database management system

Re: Db2 error help

Postby coldplay1991 » Thu Dec 08, 2011 7:14 pm

See this image..

[img]http://aligajani.com/indigo/fileuploader/uploads/582712b1db91db065ff3298bc891f3b2.png
[/img]
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 coldplay1991 » Thu Dec 08, 2011 7:15 pm

Cols pos.

EVENT_TYPE           CHAR(8) NOT NULL,          (e.g JOBINIT)  9-16
   EVENT_QUAL           CHAR(8) NOT NULL,         (e.g  SUCCESS) 18-25
   TIME_WRITTEN         TIME NOT NULL,               (e.g time) 27-35
   DATE_WRITTEN         DATE NOT NULL,             (e.g date) 36-46
   SYSTEM_SMFID         CHAR(4) NOT NULL,       (e.g mvst)  48-51
   EVT_USER_ID          CHAR(8) NOT NULL,       (e.g she0015) 67-74
   EVT_GRP_ID           CHAR(8) NOT NULL,        (e.g unishe) 76-81
   JOB_NAME             CHAR(8) NOT NULL,         (e.g 000001) 1-8
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 7:19 pm

check your input data

I hope you have mentioned wrongly...

EVENT_TYPE column starts from 10

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 7:30 pm

is it the right format, so how will it be like only start or will it be like 10-17
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 7:31 pm

For my comments that WHEN is not in the syntax diagram - apologies - I was WRONG. Looking further, after the initial diagrams I noticed in the text WHEN being used. This appeared in syntax diagrams long after the text.

[grumble] Used to be a time when the syntax diagram(s) came first and the text after[/grumble]
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 7:43 pm

It depends on the each columns data type.

after seeing your input image

http://aligajani.com/indigo/fileuploader/uploads/582712b1db91db065ff3298bc891f3b2.png

I am bit confident you just alter the first column position only.

rest of the LOAD card is right.

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 7:55 pm

Trying by the way are you available on IMs?
coldplay1991
 
Posts: 59
Joined: Tue Nov 15, 2011 5:47 am
Has thanked: 0 time
Been thanked: 0 time

Re: Db2 error help

Postby coldplay1991 » Thu Dec 08, 2011 8:02 pm

and it starts from 9 not 10. Where 10. that 08 is something else which is in my screenshot it always is 08 lo;
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 8:20 pm

I couldn't understand your last post.
Clear with better explanation!
Have you tried by 10-17?, If so what is O/P?
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 9:24 pm

Hey. It's just not working. I have checked and verified the existence of my database and tables.
However, it still gives -104 error when it's not even there.
Here is my complete code.

Using a sample from the net modified to my needs and its not even outputting 1 column into the table.

//UTIL EXEC DSNUPROC,SYSTEM=DB1S,UID='TEMP',UTPROC='' 
//DSNUPROC.SYSREC DD DSN=SHE0015.AUDIT.LOG,DISP=SHR   
//DSNUPROC.SYSIN  DD *                                 
LOAD DATA                                             
     RESUME YES                                       
     INTO TABLE SHE0015.AUDLOG                         
     ( EVENT_TYPE   POSITION(1)    CHAR(8) )           
/*                                                     
coldplay1991
 
Posts: 59
Joined: Tue Nov 15, 2011 5:47 am
Has thanked: 0 time
Been thanked: 0 time

PreviousNext

Return to DB2

 


  • Related topics
    Replies
    Views
    Last post