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

[CRPence <CRPbottle@xxxxxxxxx>]

  So instead of "I can get" as a statement, the question is "How can I 
get"; i.e. consistent with what seemingly was attempted to be implied in 
the "Subject:" line [but a /date field/ is not an option for a flat-file].

  Because there is no embedded SQL for CL, and the WHERE-clause in the 
SQL SELECT shown, why not just use the CL RCVF which is the CL interface 
to the database?  For example:

   DCLF admadmrec /* flat file with same name for Fmt and Fld */
    ...
   RCVF /* a /defined/ declaration for &var could eliminate CHGVAR */
   chgvar &var %sst(&admadmrec 9 8)
    ...

  There are other and probably better ways, but contained solely within 
the CLP, that is quite simple and /fits/ within the language.

  Of course given much fuller details about the overall scenario and 
what is by-definition already established and unchanging, along with the 
other /requirements/ [like those unchanging things are], some better 
ideas might be able to be offered.  As it is now, the reader has no idea 
of the background and goals; e.g. how or why the flat-file is being 
created and thus the reader can not suggest if that data might better be 
stored in a data area or ???

Regards, Chuck

On 30 Jul 2013 16:58, A Paul wrote:
> I am hoping there must be a way to get 1. by using SQL (as written
> in my earlier email) in CL, that is what I am looking for...
>  <<SNIP>>
>
> On Tue, Jul 30, 2013 at 5:07 PM, A Paul wrote:
>
> > 1. I can get the date (&var) by using SQL given below
> >  SELECT substr(admadmrec, 9, 8) from admfile
> >
> > <<SNIP>>
> >
> > On Tue, Jul 30, 2013 at 4:25 PM, A Paulwrote:
> >
> > > <<SNIP>>
> > >
> > > 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)
> > > <<SNIP>>