Re: Date/Time fields in DB file

Greg,

If the date/time/timestamp fields are *NOT* defined in the RPG program
and a record is added, it will automatically contain the current
date/time value instead of the *Loval values. The way to do that is to
create a LF or view that does not contain those fields, but only
contains the original fields, without the date/time fields. The easiest
way to accomplish this with an existing application (IMHO) is to rename
the original PF to a new name and name the new LF/view the original
name. That way, no application changes are required.

-mark

On 8/10/2023 1:57 PM, Greg Wilburn wrote:

I recently added an ISO date and ISO time field to an existing database

file (DDS). This file is populated by our TrustedLink EDI software when we
receive an inbound PO. I guess I had hoped it would capture the date/time
the record was created. Tli support says the EDI translator won't update
those "automatically".

Anyone know of a method of getting these fields to update with current

info upon creation? Otherwise, I'll have to update them in my RPG
processing program.

TIA,
Greg
[Logo]<https://www.totalbizfulfillment.com/> Greg Wilburn
Director of IT
301.895.3792 ext. 1231
301.895.3895 direct
gwilburn@xxxxxxxxxxxxxxxxxxxxxxx<mailto:gwilburn@xxxxxxxxxxxxxxxxxxxxxxx

1 Corporate Dr
Grantsville, MD 21536

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.