View previous topic :: View next topic
|
Author |
Message |
Vishu
New User
Joined: 23 Mar 2009 Posts: 22 Location: Bangalore
|
|
|
|
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 |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
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 |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
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 |
|
|
Srihari Gonugunta
Active User
Joined: 14 Sep 2007 Posts: 295 Location: Singapore
|
|
|
|
Vishu,
Verify the column name
In the error messages, alongwith the SQLCODE you can also see the column name/table name which is not proper. |
|
Back to top |
|
|
Vishu
New User
Joined: 23 Mar 2009 Posts: 22 Location: Bangalore
|
|
|
|
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 |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
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 |
|
|
Terry Heinze
JCL Moderator
Joined: 14 Jul 2008 Posts: 1249 Location: Richfield, MN, USA
|
|
|
|
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. |
|
Back to top |
|
|
|