Search found 69 matches

by ganesh123
Thu Feb 22, 2007 1:26 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Validation
Replies: 9
Views: 1409

On the lighther side, if weels have not been re-invented we would have struck with

http://patentpending.blogs.com/patent_p ... 154_pm.jpg
by ganesh123
Thu Feb 22, 2007 1:08 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Validation
Replies: 9
Views: 1409

As you want to remember the past value of sequence better to write a subroutine :


Please send a test data, I want to know the column position in your file
by ganesh123
Thu Feb 22, 2007 12:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Accessing CSV files on local drive
Replies: 13
Views: 4210

No its not possible becoz your server software is loaded on Unix box. So you have to FTP to unix.

On your local machine there is only client part.
by ganesh123
Tue Feb 20, 2007 6:19 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: FTP text file from CD
Replies: 9
Views: 1433

Thank you DSGuru and Kumar. I really appreciate your time.
by ganesh123
Tue Feb 20, 2007 5:59 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: FTP text file from CD
Replies: 9
Views: 1433

So I guess I have to design 2 jobs in sequence

1) FTP the txt file from CD to Unix box
2) Use this file as source

Seq_txt_File------------TX--------------Database

Is this correct ?
by ganesh123
Tue Feb 20, 2007 5:55 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: FTP text file from CD
Replies: 9
Views: 1433

Hey kumar I donot have to mount the CD on unix, I have to mount it on my PC (client)which is windows and then start the job to run.
by ganesh123
Tue Feb 20, 2007 3:32 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: FTP text file from CD
Replies: 9
Views: 1433

I want to do every thing automatic, just insert CD in drive and run the job from DS. Is it possible ?
by ganesh123
Tue Feb 20, 2007 3:31 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: FTP text file from CD
Replies: 9
Views: 1433

I mean I am getting new files in Compact Disk.(CD) :o
by ganesh123
Tue Feb 20, 2007 3:26 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: FTP text file from CD
Replies: 9
Views: 1433

FTP text file from CD

Hi Gurus, I want to perform following task : I am getting new text file every month in CD format. Now by DS which is installed in UNIX I want to run the job whose input file will be this file from CD. So I need to FTP text file from my client machine CD drive to UNIX. For this I want to write the sc...