Search found 47 matches

by NBALA
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
by NBALA
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...