Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

DB2 ERROR with a select query

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> COBOL Programming
View previous topic :: :: View next topic  
Author Message
sivasaras

New User


Joined: 29 Sep 2007
Posts: 90
Location: chenna/i-

PostPosted: Fri Jul 23, 2010 4:06 pm    Post subject: DB2 ERROR with a select query
Reply with quote

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
Back to top
View user's profile Send private message

expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Fri Jul 23, 2010 4:08 pm    Post subject: Re: DB2 ERROR
Reply with quote

sivasaras wrote:
kindly let me know it is very urgent

It can't be that urgent because you have given insufficient details for anyone to be able to help you.

Anyway, all urgency is YOURS and yours alone.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6968
Location: porcelain throne

PostPosted: Fri Jul 23, 2010 4:10 pm    Post subject:
Reply with quote

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?
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Jul 23, 2010 8:18 pm    Post subject:
Reply with quote

Hello,

How did something so completely untested get into Production . . . icon_sad.gif
Back to top
View user's profile Send private message
sambit_mech

New User


Joined: 14 Jul 2010
Posts: 13
Location: India

PostPosted: Mon Jul 26, 2010 4:32 pm    Post subject:
Reply with quote

The best reply is that of Dick's. icon_rolleyes.gif
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Mon Jul 26, 2010 5:37 pm    Post subject:
Reply with quote

Both of them has their first name as Dick icon_wink.gif.
Back to top
View user's profile Send private message
GaganGarg

Active User


Joined: 31 Mar 2010
Posts: 134
Location: India

PostPosted: Mon Jul 26, 2010 5:42 pm    Post subject:
Reply with quote

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
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> COBOL Programming All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SQL - select data available in index Nileshkul DB2 3 Mon Jun 26, 2017 1:30 am
No new posts Need DB2 query to fetch previous row ! Chandan1993 DB2 10 Sat Jun 03, 2017 10:43 am
No new posts DB2 Program abending without giving a... rahulgarg14 DB2 7 Mon May 29, 2017 8:10 pm
No new posts Getting error while opening a variabl... apandey1 COBOL Programming 5 Fri May 05, 2017 12:22 pm
No new posts IDC2902I Error tzeche ABENDS & Debugging 2 Tue Mar 28, 2017 11:39 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us