Enforce data type constraints when writing to text files
Posted: Tue Sep 06, 2005 6:52 pm
I would like to see DataStage enforce data type constraints when writing to a text file, something similar as currently occurs when writing to a database table.
While I'm aware that in this case it's the database engine enforcing the constraint, it would prove useful in some cases if there was a switch that enforced data types when writing to a sequential stage.
I'm currently working on a data conversion exercise and the target for the conversion includes text files. At the moment I have to use stage variables to confirm data type definitions and while this is fine for limited datasets, it becomes troublesome when there are many columns.
many thanks in advance ...
While I'm aware that in this case it's the database engine enforcing the constraint, it would prove useful in some cases if there was a switch that enforced data types when writing to a sequential stage.
I'm currently working on a data conversion exercise and the target for the conversion includes text files. At the moment I have to use stage variables to confirm data type definitions and while this is fine for limited datasets, it becomes troublesome when there are many columns.
many thanks in advance ...