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
 

 

Get the result into the defined two host variavables

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

New User


Joined: 19 Aug 2005
Posts: 13

PostPosted: Mon Sep 05, 2005 7:18 pm    Post subject: Get the result into the defined two host variavables
Reply with quote

Pls let me know that the following query will be run suceesfully or not?.
if not pls give me the reason.

SELECT MONTH(CURRENT TIMESTAMP - '2004-09-05') ,
YEAR( CURRENT TIMESTAMP - '2004-05-09')
INTO : WS-MONTH,
: WS-YEAR) from sysdummy1;


here the i want to get the result into the defined two host variavables
this i have to code in my program.

Pls can anyone give right answer?.

thanks?ards,
shiva
Back to top
View user's profile Send private message

Rupesh.Kothari

Member of the Month


Joined: 27 Apr 2005
Posts: 464

PostPosted: Mon Sep 05, 2005 7:47 pm    Post subject: Re: Hi friends
Reply with quote

Hi shiva001,

Please give appropriate title line so that it can use for future reference or search.

I guess, to convert the difference into days,months or years we can use some calculation.

Regards
Rupesh
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
This topic is locked: you cannot edit posts or make replies. Rexx to create GDG by scanning JJ result krish.deepu CLIST & REXX 5 Tue Oct 25, 2016 5:32 pm
No new posts Getting list of tables defined under ... kishpra DB2 2 Wed Aug 24, 2016 10:36 am
This topic is locked: you cannot edit posts or make replies. How to run and see the result of DFH$... lind sh CICS 2 Wed Jul 27, 2016 7:04 pm
No new posts Update the Sortout file with record c... karthik_sripal SYNCSORT 8 Tue May 17, 2016 8:52 pm
No new posts PC to Host for unicode file Tom Steiner TSO/ISPF 5 Mon May 16, 2016 10:38 pm


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