Hard coded value is not populating to sequential file
Posted: Wed Jul 18, 2012 11:26 pm
Hi All,
My current job design is,
My requirement is to populate hardcoded value '&#' for the Nulls coming from the Database. The input column (say COL1) is read as char and the same is written to the file as varchar.
Hence, I have made use of Null Field Value=&# in the sequential file stage in Edit row section. However, this throws me error as below.
Thanks in advance.
My current job design is,
Code: Select all
DB2 Enterprise ---> Transformer ---> Sequential file
Hence, I have made use of Null Field Value=&# in the sequential file stage in Edit row section. However, this throws me error as below.
Could you please advice on this ?main_program: Syntax error: Error in "export" operator: Error in operator arg: In field "COL1": In property list: Expected "," or "}", got: "/", line 18
Encountered <eof> while seeking end of proplist
Expected ";", got: <eof>, line 31
Expected ";", got: <eof>, line 31
Error parsing schema: Expected ")", got: <eof>, line 31
Thanks in advance.