M
Member 310024
Guest
I work on an IBM-9672-Z47 mainframe using MVS DB2.
I want to write a JCL/SQL to do a data-fix on a number of DB2 records.
I want to modify the value within a 30 char DB2 field,
by appending 'XYZ' to the field value, BUT the append is
not to be after the trailing spaces - it is to be before the trailing spaces.
(Also, of course, the number of leading characters will vary from record to record.)
So SET FIELD = FIELD CONCAT 'XYZ' would not work.
SQLCODE -433 (TOO LONG)
Has anyone had this problem before?
Thanks in advance.
I want to write a JCL/SQL to do a data-fix on a number of DB2 records.
I want to modify the value within a 30 char DB2 field,
by appending 'XYZ' to the field value, BUT the append is
not to be after the trailing spaces - it is to be before the trailing spaces.
(Also, of course, the number of leading characters will vary from record to record.)
So SET FIELD = FIELD CONCAT 'XYZ' would not work.
SQLCODE -433 (TOO LONG)
Has anyone had this problem before?
Thanks in advance.