Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

how can we solve -818 errror and -180 errror

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> ABENDS & Debugging
View previous topic :: :: View next topic  
Author Message
namashlr
Currently Banned

New User


Joined: 27 Aug 2006
Posts: 5

PostPosted: Tue Sep 26, 2006 8:11 pm    Post subject: how can we solve -818 errror and -180 errror
Reply with quote

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

let me know....
Back to top
View user's profile Send private message

UmeySan

Active Member


Joined: 22 Aug 2006
Posts: 755
Location: Germany

PostPosted: Tue Sep 26, 2006 8:20 pm    Post subject: Re: how can we solve -818 errror and -180 errror
Reply with quote

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
View user's profile Send private message
marimuthu_G

New User


Joined: 25 Feb 2008
Posts: 8
Location: India

PostPosted: Mon Mar 17, 2008 11:56 am    Post subject: FETCH TIMESTAMP VALUE AND WRITE INTO SEQUENTIAL FILE
Reply with quote

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
View user's profile Send private message
ksk

Active User


Joined: 08 Jun 2006
Posts: 356
Location: New York

PostPosted: Mon Mar 17, 2008 5:29 pm    Post subject:
Reply with quote

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
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6968
Location: porcelain throne

PostPosted: Mon Mar 17, 2008 6:18 pm    Post subject:
Reply with quote

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
View user's profile Send private message
stodolas

Active Member


Joined: 13 Jun 2007
Posts: 632
Location: Wisconsin

PostPosted: Mon Mar 17, 2008 6:46 pm    Post subject:
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> ABENDS & Debugging All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts DB2: How to solve -805 DB2 Sql code trushant.w Mainframe Interview Questions 3 Fri Oct 04, 2013 3:47 pm
No new posts VSAM - Length Errror in CICS Thamilselvi CICS 12 Wed Aug 08, 2012 4:53 pm
No new posts how to solve -904 in cobol db2 program. Escapa DB2 3 Tue Jul 19, 2011 5:34 pm
No new posts Solve file status code 46 Robert Sample COBOL Programming 20 Tue May 04, 2010 4:07 pm
No new posts CSKL:EZY1295E BIND CALL FAILURE.Pleas... tiger_wen CICS 19 Thu Feb 04, 2010 10:39 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us