MVSFORUMS.com

mayuri · Beginner Joined: 26 Aug 2006 Posts: 17 Topics: 4

hi all,

i have a table with has two Timestamp columns. i also have a corresponding DCLGEN for the table which i'm using in my Cobol-DB2 pgm. when i run the pgm i'm getting sqlcode of 180 at the fetch statement. i knw that 180 is occured due to invalid date or time or timestamp column.
I'm using a DCLGEN created by the DBA. the corresponding host variable for the timespramp column has X(26).
also i'm not facing any problems with other tables which have timestamp columns.(i'm using DCLGEN for the other tables aslo).

plz help in figuring out what the problem is..

thanks

Mayuri

kolusu · Posted: Thu Nov 02, 2006 7:53 am Post subject:

mayuri,

Does the timestamp field contain NULLS? If so do you have a null ind check ?

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

mayuri · Beginner Joined: 26 Aug 2006 Posts: 17 Topics: 4

hi Kolusu

The Timestamp fields are NOT NULL

Regards
Mayuri

dbzTHEdinosauer · Posted: Fri Nov 03, 2006 8:02 am Post subject:

what is your SQL?
_________________
Dick Brenholtz
American living in Varel, Germany

dbzTHEdinosauer · Posted: Fri Nov 03, 2006 1:45 pm Post subject:

actually,your declare curso sql. you receive the 180 because a host variable for date or ts is bad. you don't get 180's from db2 columns.
_________________
Dick Brenholtz
American living in Varel, Germany