View previous topic :: View next topic
|
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 |
|
|
UmeySan
Active Member
Joined: 22 Aug 2006 Posts: 771 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: 355 Location: New York
|
|
|
|
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
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
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
Active Member
Joined: 13 Jun 2007 Posts: 632 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 |
|
|
|