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?

View previous topic View next topic 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

View previous topic View next topic Back to top

- Similar topics

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