I was trying to use the function "TRIM" in PLI. qw gives an explanation.
but when i tried using it in my program. It is giving a compile error.
Error Message:"IDENTIFIER 'TRIM' IS NOT DECLARED. EXTERNAL ENTRY ASSUMED. 'TRIM' EXPLICITLY DECLARED BUILTIN BUT IS NOT A BUILTIN FUNCTION NAME.DECLARATION DELETED."
Find my piece of code below:
DCL (STG, TRIM) BUILTIN;
In_field CHAR (5) INIT('');
Out_field CHAR(LENGTH(In_field)) VARYING
Out_field = TRIM(In_Field, ' ');