1.2.18 Output Attributes
Output Field Attribute Types
Specify how a field is displayed when it is used for output in a function or a form.
Rules
Allowable values will vary by 1.1 Field Types. Grouping include:
- SAA/CUA Attributes - Functions Only
- Record Stamping - Create & Update
- GUI Attributes - Functions Only
- UD Reporting Attributes - Functions Only
Output Attributes
Specify the field attribute to be displayed when it is used for output in a function or form
Rules
Common Attributes
Allowable values for Common Attributes are:
|
Attribute
|
Description / comments
|
|
ASQN
|
Allow *SQLNULL assignment.
|
|
BL
|
Display blinking.
|
|
CBOX
|
Present field value as a GUI WIMP Check Box.
|
|
CDTX
|
Stamped with the date (*SYSFMT8) that the record was created or last updated.
|
|
CS
|
Display with column separators.
|
|
CYDX
|
Stamped with the date (CCYYMMDD) that the record was created or last updated.
|
|
DATX
|
Stamped with the date (*SYSFMT) that the record was created or last updated.
|
|
DUTC
|
Display in UTC. DateTimes only.
|
|
FUNX
|
Stamped with the name of the LANSA function or component that either created or last updated the record.
|
|
HI
|
Display in high intensity.
|
|
ISO
|
Display in ISO Format. Date, Time, and DateTime only.
|
|
JNMX
|
Stamped with the name of the job that either created or last updated the record.*
|
|
JNRX
|
Stamped with the number of the job that either created or last updated the record.*
|
|
ND
|
Non-display (hidden field).
|
|
PROX
|
Stamped with the name of the LANSA Process that either created or last updated the record.
|
|
RA
|
Auto record advance field
|
|
SBIN
|
Store in binary format. This is a special attribute provided for fields that need to contain imbedded packed or signed fields. Refer to the LANSA Application Design Guide (Use of Hex Values, Attributes, Hidden/Imbedded Decimal Data).
|
|
SREV
|
Store in reverse format. This is a special attribute provided for bidirectional languages. Refer to The SREV Field Attribute in the LANSA Multilingual Application Design Guide.
|
|
SUNS
|
Store integer values as unsigned binary values
|
|
SUNI
|
Store in Unicode. This is a special attribute which allows data from different languages to be stored in the database without data loss through code page conversion. For new fields, field type NChar or NVarChar is recommended, rather than adding the SUNI attribute.
|
|
SUTC
|
Store in the database in UTC. Datetimes only.
|
|
TCDX
|
Stamped with the DateTime (HHMMSS+*SYSFMT8) that the record was created or last updated.
|
|
TDSX
|
Stamped with the DateTime (HHMMSS+*SYSFMT) that the record was created or last updated.
|
|
TIMX
|
Stamped with the time (HHMMSS) that the record was created or last updated.
|
|
TYDX
|
Stamped with the DateTime (HHMMSSYYMMDD) that the record was created or last updated.
|
|
Urxx
|
Associate field with a User Defined Reporting Attribute (URxx). Provides access to IBM i DDS statements for printer files.
|
|
SAA/CUA Attributes – Functions Only
Allowable values for SAA/CUA Attributes – Functions Only are:
|
Attribute
|
Description / comments
|
|
ABCH
|
Action (menu) bar and pull-down choices
|
|
FKCH
|
Function key information
|
|
PBBR
|
Brackets
|
|
PBCE
|
Protected field (emphasized)
|
|
PBCH
|
Choices shown on menu
|
|
PBCM
|
Field column headings
|
|
PBCN
|
Protected field (normal)
|
|
PBEE
|
Input capable field (emphasized)
|
|
PBEN
|
Input capable field (normal)
|
|
PBET
|
Emphasized text
|
|
PBFP
|
Field prompt / label or description details
|
|
PBGH
|
Group headings
|
|
PBIN
|
Instructions to user
|
|
PBNT
|
Normal text
|
|
PBPI
|
Panel identifier
|
|
PBPT
|
Panel title
|
|
PBSC
|
Choice last selected from menu
|
|
PBSI
|
Scrolling information
|
|
PBSL
|
Separator line
|
|
PBUC
|
Choices that are not available
|
|
PBWB
|
Pop-up window border
|
|
Colors – Functions Only
Allowable values for Colors – Functions Only are:
|
Attribute
|
Description / comments
|
|
BLU
|
Display with color blue.
|
|
GRN
|
Display with color green.
|
|
PNK
|
Display with color pink.
|
|
RED
|
Display with color red.
|
|
TRQ
|
Display with color turquoise.
|
|
WHT
|
Display with color white.
|
|
YLW
|
Display with color yellow.
|
|
Record Stamping – Create
Allowable values for Record Stamping – Create are:
|
Attribute
|
Description / comments
|
|
CDTC
|
Stamped with the date (*SYSFMT8) that the record was created.
|
|
CYDC
|
Stamped with the date (CCYYMMDD) that the record was created.
|
|
DATC
|
Stamped with the date (*SYSFMT) that the record was created.
|
|
FUNC
|
Stamped with the name of the LANSA function or component that created the record.
|
|
JNMC
|
Stamped with the name of the job that created the record.*
|
|
JNRC
|
Stamped with the number of the job that created the record.*
|
|
PROC
|
Stamped with the name of the LANSA Process that created the record.
|
|
TCDC
|
Stamped with the DateTime (HHMMSS+*SYSFMT8) that the record was created.
|
|
TCYC
|
Stamped with the DateTime (YYYY-MM-DD HH:MM:SS) that the record was created.
|
|
TDSC
|
Stamped with the DateTime (HHMMSS+*SYSFMT) that the record was created.
|
|
TIMC
|
Stamped with the time (HHMMSS) that the record was created.
|
|
TYDC
|
Stamped with the DateTime (HHMMSSYYMMDD) that the record was created.
|
|
USRC
|
Stamped with the name of the user that created the record.*
If *LONG_USER_AUDIT is enabled then the user name will be the audit user (up to 256 characters) if the SET_SESSION_VALUE USER_AUDIT has been set, otherwise the current authenticated user name is used if available, otherwise the current user name is used.
If *LONG_USER_AUDIT is not enabled then the user name will be the audit user (up to 10 characters) if the SET_SESSION_VALUE USER_AUDIT has been set, otherwise the current user name is used.
|
|
YMDC
|
Stamped with the date (YYMMDD) that the record was created.
|
|
Record Stamping – Create & Update
Allowable values for Create & Update are:
|
Attribute
|
Description / comments
|
|
CDTX
|
Stamped with the date (*SYSFMT8) that the record was created or last updated.
|
|
CYDX
|
Stamped with the date (CCYYMMDD) that the record was created or last updated.
|
|
DATX
|
Stamped with the date (*SYSFMT) that the record was created or last updated.
|
|
FUNX
|
Stamped with the name of the LANSA function or component that either created or last updated the record.
|
|
JNMX
|
Stamped with the name of the job that either created or last updated the record.*
|
|
JNRX
|
Stamped with the number of the job that either created or last updated the record.*
|
|
PROX
|
Stamped with the name of the LANSA Process that either created or last updated the record.
|
|
TCDX
|
Stamped with the DateTime (HHMMSS+*SYSFMT8) that the record was created or last updated.
|
|
TCYX
|
Stamped with the DateTime (YYYY-MM-DD HH:MM:SS) that the record was created or last updated.
|
|
TDSX
|
Stamped with the DateTime (HHMMSS+*SYSFMT) that the record was created or last updated.
|
|
TIMX
|
Stamped with the time (HHMMSS) that the record was created or last updated.
|
|
TYDX
|
Stamped with the DateTime (HHMMSSYYMMDD) that the record was created or last updated.
|
|
USRX
|
Stamped with the name of the user that either created or last updated the record.*
If *LONG_USER_AUDIT is enabled then the user name will be the audit user (up to 256 characters) if the SET_SESSION_VALUE USER_AUDIT has been set, otherwise the current authenticated user name is used if available, otherwise the current user name is used.
If *LONG_USER_AUDIT is not enabled then the user name will be the audit user (up to 10 characters) if the SET_SESSION_VALUE USER_AUDIT has been set, otherwise the current user name is used.
|
|
YMDX
|
Stamped with the date (YYMMDD) that the record was created or last updated.
|
|
Record Stamping - Update
Allowable values for record stamping are:
|
Attribute
|
Description / comments
|
|
CDTU
|
Stamped with the date (*SYSFMT8) that the record was last updated.
|
|
CYDU
|
Stamped with the date (CCYYMMDD) that the record was last updated.
|
|
DATU
|
Stamped with the date (*SYSFMT) that the record was last updated.
|
|
FUNU
|
Stamped with the name of the LANSA function or component that last updated the record.
|
|
JNMU
|
Stamped with the name of the job that last updated the record.*
|
|
JNRU
|
Stamped with the number of the job that last updated the record.*
|
|
PROU
|
Stamped with the name of the LANSA Process that last updated the record.
|
|
TCDU
|
Stamped with the DateTime (HHMMSS+*SYSFMT8) that the record was last updated.
|
|
TCYU
|
Stamped with the DateTime (YYYY-MM-DD HH:MM:SS) that the record was last updated.
|
|
TDSU
|
Stamped with the DateTime (HHMMSS+*SYSFMT) that the record was last updated.
|
|
TIMU
|
Stamped with the time (HHMMSS) that the record was last updated.
|
|
TYDU
|
Stamped with the DateTime (HHMMSSYYMMDD) that the record was last updated.
|
|
USRU
|
Stamped with the name of the user that last updated the record.*
If *LONG_USER_AUDIT is enabled, then the user name will be the audit user (up to 256 characters) if the SET_SESSION_VALUE USER_AUDIT has been set, otherwise the current authenticated user name is used if available, otherwise the current user name is used.
If *LONG_USER_AUDIT is not enabled, then the user name will be the audit user (up to 10 characters) if the SET_SESSION_VALUE USER_AUDIT has been set, otherwise the current user name is used.
|
|
YMDU
|
Stamped with the date (YYMMDD) that the record was last updated.
|
|
GUI Attributes – Functions Only
Allowable values for GUI Attributes – Functions Only are:
|
Attribute
|
Description / comments
|
|
CBOX
|
Present field value as a GUI WIMP Check Box.
|
|
DDxx
|
Drop Down**
Represents the field with the corresponding GUI WIMP construct.
|
|
PBnn
|
Push Button **
|
|
RBnn
|
Radio Button **
|
|
UD Reporting Attributes – Functions Only
Allowable values for UD Reporting Attributes – Functions Only are:
|
Attribute
|
Description / comments
|
|
Urxx
|
Where xx is any alphanumeric combination except for blank characters.
|
|
Warnings
- The single asterisked (*) stamping attributes can be used (in the repository only) to indicate that certain fields in file definitions should be automatically stamped during INSERT and/or UPDATE operations.
- The double asterisked (**) attributes the field with the corresponding GUI WIMP construct. Refer to GUI WIMP Constructs for more information.
Tips & Techniques
- Only one color can be specified for a field.
- Use of colors may affect other attributes.
Platform Considerations
- IBM i: Refer to IBM manual Data Description Specifications for more details. Keywords that should be reviewed are COLOR and DSPATR.
Also See
1.2.17 Input Attributes
Ý 1.2 Field Definitions