IBM Mainframe Forum

by **coldplay1991** » Thu Dec 08, 2011 7:14 pm

See this image..

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

by **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

by **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

by **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

by **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]

by **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

by **coldplay1991** » Thu Dec 08, 2011 7:55 pm

Trying by the way are you available on IMs?

by **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;

by **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?

by **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.

Select all

//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) )
/*

IBM Mainframe Forum

Db2 error help

Re: Db2 error help

Re: Db2 error help

Re: Db2 error help

Re: Db2 error help

Re: Db2 error help

Re: Db2 error help

Re: Db2 error help

Re: Db2 error help

Re: Db2 error help

Re: Db2 error help