Not able to fetch Date from SYSIBM.SYSDUMMY1

kiran_tm · New User Joined: 01 Jul 2009 Posts: 1 Location: India

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]

dbzTHEdinosauer · Posted: Wed Sep 15, 2010 11:08 pm

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.

dick scherrer · Posted: Thu Sep 16, 2010 12:18 am

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.