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