Re: include current date in logical file

On 5/20/13 6:12 PM, Gary Thompson wrote:

If I remember correctly, UDATE is an RPG construct, not available when you attempt to create your logical.

---
That's right.
But I suspect you could use UDATE in your record format DDS as a (6, 0) field and when you compile using the externally described file specs, it might initialize to the current JOB date, sometimes NOT EQUAL TO the SYSTEM date. I've never done that (ugh!) but it might work in that combination.

My recommendation: Do NOT try this at home, and *please, please* do NOT NOT NOT try it at work, one of us might have to do maintenance on the code! :-)

A word of caution, I recently discovered if you have a DDS-defined or SQL-defined DATE or TIMESTAMP or TIME field in a file, and insert a record using a field list but do not include that field name in the list for the values, the write will automatically use the current timestamp.

But please please don't do that either. For inserts, use all the values. (I like it when the column names list is used in the INSERT statement.

--Alan

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Crystal Reports
Sent: Monday, May 20, 2013 3:47 PM
To: midrange-l@xxxxxxxxxxxx
Subject: include current date in logical file

I want to create a logical file which would only include dates current

this does not compile:

I OHORDT COMP(EQ UDATE)
--
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.