Re: Date/Time fields in DB file

[VERNON HAMBERG Owner <vhamberg@xxxxxxxxxxxxxxx>]

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>>