×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
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>>
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.