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
 

 

opening the cursor

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
arunshan04

New User


Joined: 25 Apr 2009
Posts: 25
Location: chennai

PostPosted: Thu Nov 12, 2009 10:33 pm    Post subject: opening the cursor
Reply with quote

hai what is the meaning for the sqlcode = 18}

this message i got wile opening the cursor inside my stored procedure ?
Back to top
View user's profile Send private message

saiprasadh

Active User


Joined: 20 Sep 2006
Posts: 154
Location: US

PostPosted: Thu Nov 12, 2009 10:43 pm    Post subject:
Reply with quote

Hi Arun,


The SQL code is -180 . Can you post the query which is causing this SQL error.

Quote:
SQLCODE -180 SQLSTATE 22007
Bad data in Date/Time/Timestamp
String representation of DATE, TIME, TIMESTAMP is invalid


Thanks
Sai
Back to top
View user's profile Send private message
arunshan04

New User


Joined: 25 Apr 2009
Posts: 25
Location: chennai

PostPosted: Thu Nov 12, 2009 11:42 pm    Post subject:
Reply with quote

sorry sai i am in out of office...
is that any meaning for the special simbol.. '}'?
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10292
Location: italy

PostPosted: Thu Nov 12, 2009 11:53 pm    Post subject: Reply to: opening the cursor
Reply with quote

Quote:
18}


its the representation of a negative decimal zoned number
negative numbers
Code:
x'd0d1d2d3d4d5d6d7d8d9'
positive numbers
Code:
x'c0c1c2c3c4c5c6c7c8c9'
x'f0f1f2f3f4f5f6f7f8f9'
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 -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Mainframe Opening in Chennai ( 2 to 4... muralikrishnan_new Mainframe Jobs 0 Tue Jul 18, 2017 2:20 pm
No new posts Testing rerad cursor for status with ... John F Dutcher DB2 8 Fri May 19, 2017 9:35 pm
No new posts Getting error while opening a variabl... apandey1 COBOL Programming 5 Fri May 05, 2017 12:22 pm
This topic is locked: you cannot edit posts or make replies. Mainframe Opening in Allianz India- T... Rajesh Gopinathan Mainframe Jobs 0 Wed Apr 19, 2017 11:33 am
No new posts Getting -504 Cursor Name GTT-ARTS-CUR... Robin Sulsona DB2 2 Fri Mar 17, 2017 1:43 am


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