I need to export file with certain fields. Where one of coulmn data has a CR.
record1 aaa bbb ccc
record2 ddd eee ffff
The spaces between the aaa bbb represents the New Line Char..
Now i need to remove this and need to export the field. That export file should not contain CR.
please Help me!!
This should be done using a UDF, check if oTranslate or oReplace is installed on your system, if not you should tell your DBA to do it :-)
Thanks for replying..
I dont have an option to use OReplace or OTranslate.. Is there any other way i can get out from it..
You can write an outmod to validate and preprocess export data records from Teradata Database before writing them to files on the client system.