|
|
| Author |
Message |
namashlr
Currently Banned
New User
Joined: 27 Aug 2006
Posts: 5
|
|
|
|
Hi,
How can we solve -818 error and -180 error
let me know.... |
|
| Back to top |
|
 |
References
|
 Posted: Tue Sep 26, 2006 8:11 pm Post subject: Re: how can we solve -818 errror and -180 errror |
|
|
|
|
UmeySan
Senior Member
Joined: 22 Aug 2006
Posts: 624
Location: Germany
|
|
|
|
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 |
|
| Back to top |
|
|
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 |
|
| Back to top |
|
|
ksk
Active User
Joined: 08 Jun 2006
Posts: 253
Location: Pune
|
|
|
|
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 |
|
| Back to top |
|
|
dbzTHEdinosauer
Senior Member
Joined: 20 Oct 2006
Posts: 1373
Location: germany
|
|
|
|
if you select a Timestamp field into (or fetch a cursor) a host variable, insure the host variable is defined as pic x(26).
| Quote: |
FETCH TIMESTAMP VALUE
|
what are you actually selecting (fetching if it is a cursor). In all caps, this is not good db2 syntax. do you mean select/fetch the value of a timestamp column? |
|
| Back to top |
|
|
stodolas
Senior Member
Joined: 13 Jun 2007
Posts: 646
Location: Wisconsin
|
|
|
|
| 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... |
|
| Back to top |
|
|
|
|
