Substring from Column

Mandatory.

Specify the source column (real or virtual) in the physical table or the record contents of the physical table (*RECORD) that is to be used for the substring operation.

...

• The column should only contain the digits 0-9. Any other character, including a sign character ('+' or '-'), will give unpredictable results.
• Substring is performed from left to right, therefore if a column containing '123.45' is substringed into position 1 of a signed (6,2) column (which is initially set to *ZERO), the value will be set to 1234.50.

Also See

Start Position