...
CAST ( FRSTNAME || ' ' || LASTNAME AS CHAR ( 61 ) CCSID 37 )
The CCSID of a field in a view can be found using the command line program, DSPFFD:
| Code Block |
|---|
Data Field Buffer Buffer Field Column
Field Type Length Length Position Usage Heading
EMP_NAME CHAR 61 63 1 Input EMPLOYEE_NAME
Alternative name . . . . . . . . . . . . :
EMPLOYEE_NAME
Variable length field
Coded Character Set Identifier . . . . . : 65535
Derived field text . . . . . . . . . . . :
FRSTNAME || ' ' || LASTNAME |