DB2 ERROR with a select query

sivasaras · New User Joined: 29 Sep 2007 Posts: 93 Location: chenna/i-

hi all,

I ran a job in production which has a select query and the result will store into a ps file.
when i ran the job it gave maxxcc=04

the error i got is
INPUT STATEMENT WAS NOT A FULL SELECT ON A SINGLE TABLE.
LOAD STATEMENT WILL NEED MODIFICATION

kindly let me know it is very urgent

thanks in advance
Siva

expat · Posted: Fri Jul 23, 2010 4:08 pm

dbzTHEdinosauer · Posted: Fri Jul 23, 2010 4:10 pm

did you bother to check if there was any output?
did you bother to check the documentation for the utility that you used?

did you bother to think about the message that was provided?

dick scherrer · Posted: Fri Jul 23, 2010 8:18 pm

Hello,

How did something so completely untested get into Production . . .

sambit_mech · New User Joined: 14 Jul 2010 Posts: 13 Location: India

The best reply is that of Dick's.

Anuj Dhawan · Posted: Mon Jul 26, 2010 5:37 pm

Both of them has their first name as Dick

.

GaganGarg · Active User Joined: 31 Mar 2010 Posts: 134 Location: India

Hi sivasaras,

The thing that you are talking about is not an error. That is just a warning that arises in two cases:

1. If the Unload query contains only the selected columns from the table you want to unload. I mean , suppose, if 10 columns are there in a table and you want to unload only 5 columns then system will throw the warning u mentioned.

2. Suppose you want to select all the 10 columns ( suppose your table is having 10 columns) and instead of giving SELECT * from Table, you are using SELECT COL1, COL1,.....COL10 from table even then it will show the warning that you mentioned.

So, The maxcc=4. no need to worry about this warning if you are following any of the above cases. But if you want to LOAD some table after UNLOAD, then LOAD statement generated in SYSPUNCH you need to modify. I hope it is clear.

Thanks
Gagan