PMS Information Systems
Welcome to PMS Information Systems - IBM i (AS/400) Forum !!!

Get Answers for all your queries on IBM i (AS/400).

What are stamping attributes and Name some Stamping attributes?

Go down

What are stamping attributes and Name some Stamping attributes?

Post  maran on Sun Oct 14, 2012 11:32 pm

Stamping attributes can be used (in the data dictionary only) to indicate that certain fields in file definitions should be automatically "stamped" during INSERT and/or UPDATE operations:

Attribute
Description

USRC When a field with this attribute is in a file it should always contain the user profile name of the user that created the record.

USRU When a field with this attribute is in a file, it should always contain the user profile name of the user that last updated the record or be blank, if the record has never been updated.

JNMC When a field with this attribute is in a file it should always contain the name of the OS/400 job that was used to create the record

DATC
When a field with this attribute is in a file it should always contain the date that the record was created. All DAT date stamps are 6 digits long in system date format.

TIMC When a field with this attribute is in a file it should always contain the time that the record was created. All time stamps are 6 digits long in the format HHMMSS.

avatar
maran
Admin

Posts : 442
Join date : 2009-07-24

View user profile http://pmsinformationsystem.forumotion.net

Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum