IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Get the result into the defined two host variavables


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
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
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: 463

PostPosted: Mon Sep 05, 2005 7:47 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts first column truncated in search result IBM Tools 13
No new posts access the last host command CLIST & REXX 2
No new posts SDSF like solution in EJES (store com... All Other Mainframe Topics 4
No new posts executing XCTL command in COBOL witho... CICS 10
No new posts File transfer from host with filler f... TSO/ISPF 15
Search our Forums:

Back to Top