Number Validation

[naren6876]

Hi,
My input record value must be Numeric and not decimal and not zero.

Any solution out there pls.

Thanks in advance.

[sachinkc]

1. Read it as varchar
2. Use the transformer to parse the numeric value\ validate it as you want
3. Send the output link to be processed to your "real" ETL
4. Read the BASIC pdf file that came with DataStage installation to help you with the routines\conditional statements Or search the DSXchange for an answer

Hi,
My input record value must be Numeric and not decimal and not zero.

Any solution out there pls.

Thanks in advance.

[naren6876]

Thanks. I got it

1. Read it as varchar
2. Use the transformer to parse the numeric value\ validate it as you want
3. Send the output link to be processed to your "real" ETL
4. Read the BASIC pdf file that came with DataStage installation to help you with the routines\conditional statements Or search the DSXchange for an answer

Hi,
My input record value must be Numeric and not decimal and not zero.

Any solution out there pls.

Thanks in advance.