how can we solve -818 errror and -180 errror

namashlr · New User Joined: 27 Aug 2006 Posts: 5

Hi,
How can we solve -818 error and -180 error

let me know....

UmeySan

Hi !

-818 Compile, Link & Bind
-180 Correct the value of the programm field
Not having the right format for time, date or timestamp

Regards, UmeySan

marimuthu_G · New User Joined: 25 Feb 2008 Posts: 8 Location: India

HI ,
i have to FETCH TIMESTAMP VALUE (of a table AND WRITE INTO SEQUENTIAL FILE) and then use this file to poulate a nother table...its giving me -180 error.....how to remove this..
thanx in advance

ksk · Posted: Mon Mar 17, 2008 5:29 pm Post subject:

Marimuthu_G,

Raise your question with new tiopic.

As UmeySan told, -180 is incorrect format of Timestamp. Post where you are getting the error.

KSK

dbzTHEdinosauer · Posted: Mon Mar 17, 2008 6:18 pm Post subject:

if you select a Timestamp field into (or fetch a cursor) a host variable, insure the host variable is defined as pic x(26).

stodolas · Posted: Mon Mar 17, 2008 6:46 pm Post subject:

Seems odd to me also to select a value from DB2, write it to a file, and write it back to DB2.... Unless you are crossing subsystems...