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 to recieve week number from sysibm.sydummy in PL1

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> PL/I & Assembler
View previous topic :: :: View next topic  
Author Message
ravi1

New User


Joined: 27 Apr 2006
Posts: 11

PostPosted: Fri Mar 13, 2009 12:39 pm    Post subject: How to recieve week number from sysibm.sydummy in PL1
Reply with quote

Hi

I have coded

Exec Sql

week(current date)
into :ws_week_num
from sysibm.sysdummy1;

I am not getting correct value 11 in whatever data type i choose to declare ws_week_num. I am getting zeroes.

Please suggest how to declare ws_week_num.

Note: I already tried the following
fixed bin(31,0)
pic '9999'.
fixed dec(3)

Ur suggestions needed.
Back to top
View user's profile Send private message

Gnanas N

Active Member


Joined: 06 Sep 2007
Posts: 788
Location: Chennai, India

PostPosted: Fri Mar 13, 2009 2:51 pm    Post subject:
Reply with quote

FIXED BIN(15) works for me.

Code:
DCL                   
  WEEK1 FIXED BIN(15);

Code:
EXEC SQL                                 
     SELECT WEEK(CURRENT DATE) INTO :WEEK1
           FROM SYSIBM.SYSDUMMY1;         
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 -> PL/I & Assembler All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts what is meaning of the number in dcl Martylin PL/I & Assembler 2 Thu Mar 09, 2017 7:18 am
No new posts Extract set of records matching on ac... bhaskar_kanteti DFSORT/ICETOOL 3 Mon Mar 06, 2017 7:19 am
No new posts GDG version number PANDU1 JCL & VSAM 4 Sat Mar 04, 2017 8:28 pm
No new posts ERM-Diagram of SysIBM-Catalog-Tables Auryn DB2 2 Fri Feb 17, 2017 6:22 pm
No new posts How to find the first monday of the w... abdulrafi COBOL Programming 10 Fri Nov 25, 2016 3:24 pm


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