View previous topic :: View next topic
|
Author |
Message |
samiuddinarif
New User
Joined: 02 Jun 2010 Posts: 4 Location: hyderabad
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Is empid numeric?
If it is, '2001' is an invalid literal. . . |
|
Back to top |
|
|
samiuddinarif
New User
Joined: 02 Jun 2010 Posts: 4 Location: hyderabad
|
|
|
|
yes it is numeric
ya my problem is solved
thank you |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
You're welcome - thank you for posting it is working
d |
|
Back to top |
|
|
|