Page 3 of 4

Re: Db2 error help

PostPosted: Thu Dec 08, 2011 7:14 pm
by coldplay1991
See this image..

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

Re: Db2 error help

PostPosted: Thu Dec 08, 2011 7:15 pm
by coldplay1991
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

Re: Db2 error help

PostPosted: Thu Dec 08, 2011 7:19 pm
by db2sysdba
check your input data

I hope you have mentioned wrongly...

EVENT_TYPE column starts from 10

Happy Learning,
db2sysdba

Re: Db2 error help

PostPosted: Thu Dec 08, 2011 7:30 pm
by coldplay1991
is it the right format, so how will it be like only start or will it be like 10-17

Re: Db2 error help

PostPosted: Thu Dec 08, 2011 7:31 pm
by NicC
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]

Re: Db2 error help

PostPosted: Thu Dec 08, 2011 7:43 pm
by db2sysdba
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

Re: Db2 error help

PostPosted: Thu Dec 08, 2011 7:55 pm
by coldplay1991
Trying by the way are you available on IMs?

Re: Db2 error help

PostPosted: Thu Dec 08, 2011 8:02 pm
by coldplay1991
and it starts from 9 not 10. Where 10. that 08 is something else which is in my screenshot it always is 08 lo;

Re: Db2 error help

PostPosted: Thu Dec 08, 2011 8:20 pm
by db2sysdba
I couldn't understand your last post.
Clear with better explanation!
Have you tried by 10-17?, If so what is O/P?

Re: Db2 error help

PostPosted: Thu Dec 08, 2011 9:24 pm
by coldplay1991
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) )           
/*