Re: output date field from a flat file into a variable

[Sam_L <lennon_s_j@xxxxxxxxxxx>]

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).