DSXchange

Hi,

Am trying to compile a job with constraint as linkname.columname=039 in transformer.

1) inputcol datatype is smallint
2) checking the constraint alone in tranformer
3) same column goes as output


On compiling i got the following error in transformer stage.

1540-0849 (S) The octal literal "039" contains non-octal digits

I changed the constraint to linkname.columname=39,the job compiles fine and produced the rows with value 39.

May I know what exactly is happening inside the tranformer and why this octal conversion is taking place.

Can you try to change the input datatype as string / char and then try the constraint as linkname.columname="039".

Hi,

Please modify inputcol datatype is numeric instead of smallint. Hope it will work.

When i change constraint value as linkname.columname="039" string it works.

But,am keen on why there is a octal conversion happening in between when the constraint was given as integer value.

I have checked octal values which does not exist for 008,009,018,019,028,029,038,039, etc... (number ending with 8 and 9).

Please clarify.

Check the transformer code generated, if it helps

Hi Prem,

I have tested the same scenario.

1) inputcol datatype is smallint
2) checking the constraint alone in tranformer
3) same column goes as output

But I did constraint as : linkname.columname='039'

It works fine.

you can find the code for the Transformer within the RT_XXXX directories, you will find files with the stage name of the transformer. Please paste the code that you find there, that might help.

If not Ray always has a solution :D