Search found 5 matches

by FrankTheTank
Wed Mar 26, 2008 8:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: FTP Plug-In Stage - File Rename after FTP with stage?
Replies: 3
Views: 1322

How would I go about doing this? I tried using Telnet After Command, but I am getting the following error:

Xmit_File_FTP,0: Warning: GENERIC_FTP_FundRun_Job.Xmit_File_FTP: unable to execute Telnet command 'Telnet After Command'
by FrankTheTank
Tue Mar 25, 2008 10:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: FTP Plug-In Stage - File Rename after FTP with stage?
Replies: 3
Views: 1322

FTP Plug-In Stage - File Rename after FTP with stage?

Hello,

I have an ftp server that requires me to transmit the file in .TMP format, then rename to .TXT format. Is this something that is possible with the FTP Plug-In Stage?

Thanks.
by FrankTheTank
Thu May 05, 2005 8:01 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Adding Comma Separators
Replies: 8
Views: 2730

The Oconv function doesn't seem to work in Parellel jobs, which I am required to use for reasons beyond reason.

Also, I can not just use comma as a decimal seperator at the target file, because I need to keep this field right justified, and that throws it off.
by FrankTheTank
Wed May 04, 2005 2:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Adding Comma Separators
Replies: 8
Views: 2730

The current length is 16. I figure to be a max of 19 with comma separators.
by FrankTheTank
Wed May 04, 2005 2:34 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Adding Comma Separators
Replies: 8
Views: 2730

Adding Comma Separators

I currently have a job where I have a decimal value, where it needs the comma separators for the thousands. I need a way of putting those in while in a Char format, since I need to right justify the field with spaces. Example: Input from database: 49477404.97 Output to file: 49,477,404.97 Remember t...