Search found 47 matches
- Fri Jul 14, 2006 12:14 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: convert char to integer
- Replies: 10
- Views: 9078
Hi All, I have the similar question, I have data which is signed decimal value from source flat file. This field will have -/+ like ' -213.23004'. We need to keep the sign on the target (oracle number). How to do this using DS. Note: We are using DS 7.5 Please some one help me. Thanks in advance -NB
- Tue Jul 11, 2006 1:46 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Supress extra Carriage returns
- Replies: 21
- Views: 4971
Hi Krish, Seems you are retrieve from SQL server and the output data is stored in sequential ie flat file and you are tranfering (via FTP?) to the unix server. When tranfering (FTP?) set the transfer mode as ASCII, then you won't get the <CR><LF> character.( You can view this by opening the file usi...