Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CONCAT removing trailing spaces SQLCODE -433

Status
Not open for further replies.
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.


 
Star Dust now!
Answer was
UPDATE blah-blah-blah
SET TRACK_REF_NO = RTRIM(TRACK_REF_NO) CONCAT 'XYZ'
Thanks to IBM Manuals.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top