Instead of creating a temporary table I'd suggest to create a temporary view
and read this view:
create View qtemp/zz_Date
as (SELECT substr(admadmrec, 9, 8) MyDate
from admfile)
You'd still need a DCLF ZZ_Date and a RCVF.
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von Sam_L
Gesendet: Thursday, 01.8 2013 01:34
An: Midrange Systems Technical Discussion
Betreff: Re: output date field from a flat file into a variable
As others have noted, DCLF and RCVF on admfile may be the answer.
If, however, you are doing some complicated SQL over a largish file to get
your date (which seems a bit unlikely if admfile is a flat file) an SQL
command with this might work:
create table qtemp/zz_Date as (
SELECT
substr(admadmrec, 9,8) MyDate
from admfile
) with data
You'd still need a DCLF ZZ_Date and a RCVF.
Of course, this is a little trickier to compile.
Sam
On 7/30/2013 6:25 PM, A Paul wrote:
Hi
I am looking to do date comparison in CL program.
I get the date from a flat file with the below SQL SELECT
substr(admadmrec, 9,8)
from admfile
the value is in format yyyymmdd.
How do you output this date into a variable (&VAR) to compare with
another variable(&DATE) that picks APPLICATION DATE in the same format
20130608(yyyymmdd).
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at
http://archive.midrange.com/midrange-l.
midrange.com
