Datastage OS/390 - Validate numeric fields
Posted: Thu Aug 24, 2000 11:12 am
Hello
Im using Datastage OS/390, and i need to validade, in my input file, the numeric fields. So i use a transformer, and in each numeric field, i do this instruction
IF FIELD001 IS NUMERIC THEN FIELD001ELSE 0 END
What im doing is testing if a field is numeric, and if its i move the numeric field else zero. The input field and the output field, are numeric.
But when i complie, in Datastage, give me the next error
Error: 100013 Columns cannot be mapped due to data type incompatibility.
Who can i do validate, of a numeric field ?
regards
Rui Soares
Rui Soares
NOVABASE - Data Quality - Mi
Tlm : +351 . 96 347 0840
Tel ( BES ) : +351 .21 416 8000 ( ext 266372)
Mail : RUI.SOARES@NOVABASE.PT
Im using Datastage OS/390, and i need to validade, in my input file, the numeric fields. So i use a transformer, and in each numeric field, i do this instruction
IF FIELD001 IS NUMERIC THEN FIELD001ELSE 0 END
What im doing is testing if a field is numeric, and if its i move the numeric field else zero. The input field and the output field, are numeric.
But when i complie, in Datastage, give me the next error
Error: 100013 Columns cannot be mapped due to data type incompatibility.
Who can i do validate, of a numeric field ?
regards
Rui Soares
Rui Soares
NOVABASE - Data Quality - Mi
Tlm : +351 . 96 347 0840
Tel ( BES ) : +351 .21 416 8000 ( ext 266372)
Mail : RUI.SOARES@NOVABASE.PT