CODEWITHSUNDEEP
jt400websphere
Anand Dhage
Anand Dhage

Reputation: 119

What is UPCRTD attribute in IBMi AS400?

Could anyone tell me what is does UPCRTD attribute mean in IBMi AS400 system? I guess this is a user profile creation date-time, but I didn't find any official documentation which simply says, that UPCRTD means user profile creation date time. Can anyone please refer any document I can find useful?

Upvotes: 0

Views: 2957

Answers (2)

Jack Woehr
Jack Woehr

Reputation: 36

UPRCRTD field is User Profile CReaTe Date

Upvotes: 0

nfgl
nfgl

Reputation: 3212

You will not find this detailed information in a document. UPCRTD is one of the column of the result table of the command DSPUSRPRF TYPE(*BASIC) OUTPUT(*OUTFILE)

You can see there that this table has the same structure as QADSPUPB when TYPE(*BASIC)

The by SQL wou can find information about the column or your machine

select
    TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, COLUMN_TEXT
from
    QSYS2.SYSCOLUMNS
where
    (TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME) = ('QSYS', 'QADSPUPB', 'UPCRTD');

gives

|TABLE_SCHEMA|TABLE_NAME|COLUMN_NAME|COLUMN_TEXT                                       |
|------------|----------|-----------|--------------------------------------------------|
|QSYS        |QADSPUPB  |UPCRTD     |Creation date: YYMMDD                             |

Upvotes: 1

Related Questions