Re: DDL for timestamp column.

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.


On 08/22/2017 08:47 AM, Luis Rodriguez wrote:

Also, if you are not referencing your timestamp column in your Insert
statements, you could define a default value for your timestamp. Something
like:

Tstamp timestamp not null default current timestamp

HTH,
Regards,
Luis

Sent from my Moto G phone. Please excuse my brevity.

On Aug 22, 2017 08:37, "Gord Hutchinson" <gordm1@xxxxxxxxxxxxxxx> wrote:

I think this is what you are looking for:

ColName Timestamp Not Null
For Each Row on Update as Row Change Timestamp


Gord



On Tue, Aug 22, 2017 at 8:29 AM, <JRusling@xxxxxxxxxxx> wrote:

I want to have a timestamp in a ddl described table that auto populates on
insert for a small project I'm trying to do quick and have had little luck
finding an example. </end whine>

Anyone have an example and or a link?

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

--
Gord Hutchinson
TST Overland Express
--
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

-- Este e-mail fue enviado desde el Mail Server del diario ABC Color --
-- Verificado por Anti-Virus Corporativo Symantec --