Re: Date/Time fields in DB file

Yep! And we've had several posts wondering why it doesn't do that in this case - look for Greg's latest post.


Someone else mentioned journaling to get what Greg wants - nice idea, I think.


Cheers
Vern


On Fri, 11 Aug, 2023 at 1:02 PM, Justin Taylor <jtaylor.0ab@xxxxxxxxx> wrote:


To: midrange-l

Per IBM:
" If the DFT keyword is not specified, the default value is the current
date."
" If the DFT keyword is not specified, the default value is the current
time."
https://www.ibm.com/docs/en/i/7.5?topic=80-dft-default-keywordphysical-files-only


date: Thu, 10 Aug 2023 17:57:06 +0000

from: Greg Wilburn <gwilburn@xxxxxxxxxxxxxxxxxxxxxxx<mailto:gwilburn@xxxxxxxxxxxxxxxxxxxxxxx>>
subject: Date/Time fields in DB file

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/><https://www.totalbizfulfillment.com/>> Greg Wilburn
Director of IT
301.895.3792 ext. 1231
301.895.3895 direct
gwilburn@xxxxxxxxxxxxxxxxxxxxxxx<mailto:gwilburn@xxxxxxxxxxxxxxxxxxxxxxx><mailto:gwilburn@xxxxxxxxxxxxxxxxxxxxxxx<mailto:gwilburn@xxxxxxxxxxxxxxxxxxxxxxx>>
1 Corporate Dr
Grantsville, MD 21536
www.totalbizfulfillment.com<http://www.totalbizfulfillment.com><http://www.totalbizfulfillment.com<http://www.totalbizfulfillment.com>>