I am trying to convert a integer datatype into varchar datatype using the Modify stage to prevent the warnings to appear in the Director Logs but after using the statement 'lookup_ustring_from_int32', the job immediately stopped due to severe error.
Below are the error logs I encountered with this syntax.
1st time
main_program: Error parsing modify adapter: Error in binding: Unknown conversion: lookup_ustring_from_int32
Expected destination field selector, got: ")"; input:
cust_numb:string=lookup_ustring_from_int32(cust_numb)
;
subr_numb = subr_numb
;
artm_type = artm_type
;
blpd_code = blpd_code
;
2nd time
main_program: Error parsing modify adapter: Expected ';' or end, got: "cust_numb"; input:
cust_numb:string=lookup_ustring_from_int32 cust_numb
;
subr_numb = subr_numb
;
artm_type = artm_type
;
blpd_code = blpd_code
;
Does anyone know what is the proper syntax for this?
![Sad :(](./images/smilies/icon_sad.gif)