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
No new posts JCL to Set Return code based on DB2 S... vinu78 DB2 17 Mon Mar 13, 2017 9:47 pm
No new posts scheduling between OPC and TWS give u... nsbl IBM Tools 2 Sun Mar 12, 2017 5:35 pm
No new posts DB2 9.1.0 not move values to Host-Var... Miguel Fernandez DB2 8 Wed Jan 25, 2017 8:24 pm
No new posts DB2 9.1.0 not move values to Host-Var... Miguel Fernandez DB2 0 Wed Jan 25, 2017 8:23 pm
No new posts DB2 9.1.0 not move values to Host-Var... Miguel Fernandez DB2 0 Wed Jan 25, 2017 8:21 pm


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