IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

How to find the field name causes SQLCODE -310


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Sanjoy

New User


Joined: 19 Oct 2005
Posts: 19

PostPosted: Wed Dec 27, 2006 2:02 pm
Reply with quote

I have a DB2 table having more than 150 columns. During insert into that table i am getting -310 but SQLCA is not providing the field name for which it is getting. Is there any way to get the field name along with the sqlcode?
Back to top
View user's profile Send private message
mainframelover

New User


Joined: 27 Dec 2006
Posts: 6
Location: Bangalore

PostPosted: Wed Dec 27, 2006 2:56 pm
Reply with quote

how many decimal host variables are there?
Back to top
View user's profile Send private message
Sanjoy

New User


Joined: 19 Oct 2005
Posts: 19

PostPosted: Thu Dec 28, 2006 2:24 am
Reply with quote

almost 150
Back to top
View user's profile Send private message
priyesh.agrawal

Senior Member


Joined: 28 Mar 2005
Posts: 1448
Location: Chicago, IL

PostPosted: Mon Jan 01, 2007 7:10 am
Reply with quote

You should find more details on Detector Options in case you have platinum tool in your shop to access DB-2 environment.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Replace Multiple Field values to Othe... DFSORT/ICETOOL 12
No new posts To find whether record count are true... DFSORT/ICETOOL 6
No new posts Find the size of a PS file before rea... COBOL Programming 13
No new posts Join 2 files according to one key field. JCL & VSAM 3
No new posts How to move the first field of each r... DFSORT/ICETOOL 5
Search our Forums:

Back to Top