Enforce data type constraints when writing to text files

Do you have features you'd like to see in future releases of DataStage, MetaStage, Parameter Manager, Version Control or one of the other tools represented on this forum? Post your ideas here!

Moderators: chulett, rschirm

Post Reply
javier perez
Participant
Posts: 4
Joined: Tue Jun 28, 2005 5:03 pm
Location: Brisbane, Australia

Enforce data type constraints when writing to text files

Post by javier perez »

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 ...
Post Reply