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
 

 

SQLCODE= -204 while binding the job

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Vishu

New User


Joined: 23 Mar 2009
Posts: 22
Location: Bangalore

PostPosted: Tue Apr 14, 2009 8:27 pm    Post subject: SQLCODE= -204 while binding the job
Reply with quote

Hi,
I am getting the SQLCODE= -204 while binding the job.
What could be the reason behind that.
Facts:
1. The table I am trying to populate has been created by some other I.D.
2. I am using the following SQL code:

EXEC SQL
INSERT INTO TBSPLTR (TBS_PLAN_NAME,
TBS_LCALL_RATE,
TBS_SDCALL-RATE,
TBS_ICALL_RATE, etc.....

TBSPLTR being the table name.

Please let me know if I missed any details.
Back to top
View user's profile Send private message

dbzTHEdinosauer

Global Moderator


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

PostPosted: Tue Apr 14, 2009 8:31 pm    Post subject:
Reply with quote

I realize that you have no idea how to check things out on your own. So:

did you bother to look at the message in the bind listing?
How about sharing it with us if you still have no idea?
name IS AN UNDEFINED NAME
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Wed Apr 15, 2009 1:12 am    Post subject:
Reply with quote

Hello Visha,

This can help you with the SECRET DB2 CODES

Can i know, how you INSERT the data in the table TBSPLTR using SPUFI

Thank You,
Sushanth
Back to top
View user's profile Send private message
Srihari Gonugunta

Active User


Joined: 14 Sep 2007
Posts: 295
Location: Singapore

PostPosted: Wed Apr 15, 2009 11:31 am    Post subject:
Reply with quote

Vishu,
Verify the column name

Code:
TBS_SDCALL-RATE


In the error messages, alongwith the SQLCODE you can also see the column name/table name which is not proper.
Back to top
View user's profile Send private message
Vishu

New User


Joined: 23 Mar 2009
Posts: 22
Location: Bangalore

PostPosted: Wed Apr 15, 2009 2:25 pm    Post subject: Reply :
Reply with quote

Thanks all ,

The problem was related to the naming of the table in the sql code.
I mentioned it as

Code:
EXEC SQL
   INSERT INTO TBSPLTR
 
rather it should have been preceded by the U I.D which created the table. like:

Code:
EXEC SQL
   INSERT INTO USERID.TBSPLTR
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Wed Apr 15, 2009 2:51 pm    Post subject:
Reply with quote

GOOD. Thank You for saying how you resolved it.

In my shop we dont embud High Level Qualifiers in the SQL statement in COBOL program. We use a tool called LMF, we specify the qualifier there.

So it is easy for us to port the application from DEV -> MOD -> PROD
We don't have to change the coding in each PHASE.

Sushanth
Back to top
View user's profile Send private message
Terry Heinze

JCL Moderator


Joined: 14 Jul 2008
Posts: 1239
Location: Richfield, MN, USA

PostPosted: Wed Apr 15, 2009 9:43 pm    Post subject:
Reply with quote

sushanth bobby wrote:
Hello Visha,

This can help you with the SECRET DB2 CODES

Can i know, how you INSERT the data in the table TBSPLTR using SPUFI

Thank You,
Sushanth

Now that you've revealed the "secret codes", we're going to have to kill you. icon_lol.gif
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 -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts -419 SQL error when binding senthamizh DB2 2 Sun Jun 12, 2016 8:20 pm
No new posts SQLCODE-000000080N priya91 DB2 1 Mon Feb 01, 2016 4:35 pm
No new posts Need to understand SQLCODE = 12 rohanthengal DB2 3 Thu Nov 05, 2015 11:22 am
No new posts SQLCODE -922 in Batch-Cics program tr... kishpra CICS 2 Thu Sep 10, 2015 12:36 pm
No new posts SQLCODE -450 for stored procedure spoorni DB2 3 Fri Jan 16, 2015 2:45 am


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