RE: DDL for timestamp column.

[Tommy Holden <Tommy.Holden@xxxxxxxxx>]

Untested but I believe if you use the %FIELDS() function that would suffice vs using views


Thanks,
Tommy Holden

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Luis Rodriguez
Sent: Tuesday, August 22, 2017 11:26 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Re: DDL for timestamp column.

John,

Raul has a good point here. In RPG, when you do a WRITE it outputs all the record's columns to the table. In this case (AFAIK), the DEFAULT value has no effect (hence the suggestion for using a view)..

Regards,
Luis

On Tue, Aug 22, 2017 at 10:54 AM <JRusling@xxxxxxxxxxx> wrote:

> Thanks Raul good to know,
>
> This table will only get written to, so not a problem.
>
> John
>
> <snip>
> The timestamp with default will be set for write when is not in the 
> list of fields.? If you want to write from RPG you can create a view 
> without the timestamp.
> </snip>
> <br />
> The information in this email is confidential and may be legally 
> privileged.
> It is intended solely for the addressee. Access to this email by 
> anyone else is unauthorized. If you are not the intended recipient, 
> any disclosure, copying, distribution or any action taken or omitted 
> to be taken in reliance on it, is prohibited and may be unlawful.
> --
> 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.
>
> Please contact support@xxxxxxxxxxxx for any subscription related 
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: http://amzn.to/2dEadiD