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
 

 

Not able to fetch Date from SYSIBM.SYSDUMMY1

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

New User


Joined: 01 Jul 2009
Posts: 1
Location: India

PostPosted: Wed Sep 15, 2010 10:59 pm    Post subject: Not able to fetch Date from SYSIBM.SYSDUMMY1
Reply with quote

HI,

From one of the program, i am trying to query on the SYSIBM.SYSDUMMY1 table to obtain the future date, by adding to 1 month, 3 month , 6 month & 12 month to the date passed.

This program is called from many modules in all the places its working fine and its returning date, but in one program its returning spaces. however, for the same input with sane date format as a standalone its working fine.

Thinking that the variable might be not correctly initialized, i tried passing the date in different ways, but didn't work.

so could you please help me out to sort out this issue, please refer the attachment of the program flow taken while executing code in debugging mode.



[img] [/img][/code]
Back to top
View user's profile Send private message

dbzTHEdinosauer

Global Moderator


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

PostPosted: Wed Sep 15, 2010 11:08 pm    Post subject:
Reply with quote

if it works for others and not for one,
the I would suggest insuring that
  • the definition of the USING parms in the CALL statement are the same as programs that work
  • and that the CALL statement is the same as others that work


by the way, unless you are using a cusor, you would be SELECTing not FETCHing.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Sep 16, 2010 12:18 am    Post subject:
Reply with quote

Hello,

Many of our members may not download attachments. Please do not post them.

When you want to post a "screenshot" from a 3270-screen, simply use Copy/Paste and the "Code" this. No typing is required. This will improve appearance and preserve alignment.

Suggest you become familiar/comfortable with the Preview as well. You can see your post as it will appear to the forum rather than how it looks in the Reply Edotor.

If you do not have this fixed yet, suggest you post (Copy/Paste/Code) whatever is in that attachment as well as the problem code.
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 Date and time format in CICS Chandru3183 CICS 2 Sat Mar 18, 2017 12:46 pm
No new posts How to get current date -1 and curren... murali.andaluri DFSORT/ICETOOL 3 Wed Mar 08, 2017 2:09 pm
No new posts Overlay the system date Danielle.Filteau SYNCSORT 4 Fri Mar 03, 2017 1:16 am
No new posts ERM-Diagram of SysIBM-Catalog-Tables Auryn DB2 2 Fri Feb 17, 2017 6:22 pm
No new posts Checking Current date vickey_dw DFSORT/ICETOOL 1 Wed Feb 08, 2017 11:14 pm


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