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

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

Join the forum, it's quick and easy

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

Get Answers for all your queries on IBM i (AS/400).
PMS Information Systems
Would you like to react to this message? Create an account in a few clicks or log in to continue.

What are stamping attributes and Name some Stamping attributes?

Go down

What are stamping attributes and Name some Stamping attributes? Empty What are stamping attributes and Name some Stamping attributes?

Post  maran 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.

maran
maran
Admin

Posts : 442
Join date : 2009-07-24

https://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