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

Problem in cursor


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

New User


Joined: 02 Jun 2010
Posts: 4
Location: hyderabad

PostPosted: Sat Oct 09, 2010 2:08 am
Reply with quote

hi to all,
in my cobol-db2 prog iam getting this
*************
DSNH206I W
DSNHANAL LINE 58 COL 13 STATEMENT REFERENCES COLUMN '2001',
WHICH IS NOT DECLARED IN THE SPECIFIED TABLE(S)
DECLARE CUR CURSOR FOR SELECT*FROM SAEMP WHERE EMPID='2001'

compilation with 4 and exec with 0
it doesn't perform any operation.
plz help me out
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


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

PostPosted: Sat Oct 09, 2010 3:25 am
Reply with quote

Hello,

Is empid numeric?

If it is, '2001' is an invalid literal. . .
Back to top
View user's profile Send private message
samiuddinarif

New User


Joined: 02 Jun 2010
Posts: 4
Location: hyderabad

PostPosted: Sat Oct 09, 2010 2:23 pm
Reply with quote

yes it is numeric
ya my problem is solved
thank you
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


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

PostPosted: Sat Oct 09, 2010 8:54 pm
Reply with quote

You're welcome - thank you for posting it is working icon_smile.gif

d
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 Map Vols and Problem Dataset All Other Mainframe Topics 2
No new posts z/vm installation problem All Other Mainframe Topics 0
No new posts Job scheduling problem. JCL & VSAM 9
No new posts Problem with IFTHEN=(WHEN=GROUP,BEGIN... DFSORT/ICETOOL 5
No new posts Need to add field to copybook, proble... COBOL Programming 14
Search our Forums:

Back to Top