AW: include current date in logical file

... and an SQL index cannot be accessed directly within an SQL statement,
but an SQL index can be used with native I/O like any keyed logical file,
i.e. in RPG it can be specified within the F-Specs, Read with CHAIN, READ
etc. OpCodes and updated or written with the appropriate UPDATE and WRITE
OpCodes.

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 rob@xxxxxxxxx
Gesendet: Tuesday, 21.5 2013 13:43
An: Midrange Systems Technical Discussion
Betreff: Re: include current date in logical file

With the index doing only ordering then you will have no problem adapting to
this new request.

There is some rudimentary selection capability in an index. It was really
only added there to allow DDL to replace about 90% of all DDS logical files.
90% of DDS logical files are R IIML01R
...
S ActRec comp('A')
K ItemNumber



Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail
to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: Booth Martin <booth@xxxxxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>,
Date: 05/20/2013 06:31 PM
Subject: Re: MIDRANGE-L Digest, Vol 12, Issue 1084
Sent by: midrange-l-bounces@xxxxxxxxxxxx




Not possible, so far as I know.

As an aside, I would mention this: In my experience, if you do succeed
with your goal, and you provide a fantastic report of today's orders,
surer than the ocean reaching the shore someone will marvel at it and
say "Now just add in a date selector so we can find orders for any day.
That shouldn't take long."


On 5/20/2013 5:22 PM, Crystal Reports wrote:

How do you refer to current date in DDS logical file?