Search found 116 matches

by basu.ds
Thu May 28, 2009 10:49 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Zip a file
Replies: 28
Views: 13870

Thanks chullett
I will search on forum
This is my new batch file

set path="C:\Program Files\WinRAR\";%path%
cd /d
winrar.exe a D:\TEST\abc.zip D:\TEST\abc.txt

Thanks a lot
by basu.ds
Thu May 28, 2009 10:25 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Zip a file
Replies: 28
Views: 13870

infact this is the error message i am getting "BeforeJob (ExecDOS): Error when executing command: zipfile.bat *** Output from command was: *** 'zipfile.bat' is not recognized as an internal or external command, operable program or batch file." batchfile code: c: cd program files cd winrar ...
by basu.ds
Thu May 28, 2009 10:15 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Zip a file
Replies: 28
Views: 13870

Thanks for all
This is the command i used to zip a file
c:program files\winrar\winrar.exe a d:\test\abd.zip d:\test\abc.txt
can any bod explore this command how to make work using datastage



Thaks a lot
by basu.ds
Thu May 28, 2009 6:52 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Zip a file
Replies: 28
Views: 13870

Thanks for all , i have installed winrar on mechine I am able to zip a file from command line usind dos command but i am not able to zip using DataStage by using same command then i tried create a batch file then i ran working fine from me but when i am using same batch file from datastage not worki...
by basu.ds
Tue May 26, 2009 10:36 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Zip a file
Replies: 28
Views: 13870

Thanks a lot for replies ,
I don't have any zip software installed in my windows system.i tried dos command but it is not working

command zip filename.csv
i tried zip filename.zip also
both are not working any idea please help me

Thanks in advance,
by basu.ds
Tue May 26, 2009 4:48 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Zip a file
Replies: 28
Views: 13870

Zip a file

Hi ,
Can any one help me on how to zip a csv file using datastage .i tried search in the forum but i did not find enough information .my requirement is that i have a file .i have to zip that file by job.

Thanks in advance,
by basu.ds
Mon Apr 27, 2009 11:53 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Oconv MCP is not working
Replies: 7
Views: 6720

Hi kamesh_sk
Yes your understanding is correct,
Please any one help me on this..




Thanks in advance,
by basu.ds
Mon Apr 27, 2009 10:57 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Oconv MCP is not working
Replies: 7
Views: 6720

but same conversion is working in 7.5.1 but not in 8.0.1
by basu.ds
Mon Apr 27, 2009 5:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: FTP stage -- invalid uri
Replies: 7
Views: 2902

Then how your expecting to work ftp stage?
by basu.ds
Mon Apr 27, 2009 4:59 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Oconv MCP is not working
Replies: 7
Views: 6720

Ans=Oconv(Arg1,"MCP") This Oconv-MCP function is supposed to remove any unprintable characters in "Arg1" But on Information server 8.0.1 -windows the MCP function returns the same value of Arg1 and does not remove the unprintable characters can any body explain why? Is this a bug...
by basu.ds
Mon Apr 27, 2009 4:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: FTP stage -- invalid uri
Replies: 7
Views: 2902

have you created any ftp user on your host mechine?
by basu.ds
Mon Apr 27, 2009 4:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: FTP stage -- invalid uri
Replies: 7
Views: 2902

Please try to connect from command prompt using your ftp details
If works then post the exact error and ftp uri you are using...
by basu.ds
Mon Apr 27, 2009 3:56 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: FTP stage -- invalid uri
Replies: 7
Views: 2902

This is a bug in ver8.0.1 carried from 7.5 also
The use of unix and windows slashes has not been established properly
use ftp://IP address/\path of file
by basu.ds
Mon Apr 27, 2009 3:42 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Oconv MCP is not working
Replies: 7
Views: 6720

Oconv MCP is not working

X=Oconv("John^CSmith^X1-234", "MCP") X = "John.Smith.1-234" The above is supposed to remove all unprintable characters but it is not working on informations server 8.0.1 on windows. It is returning the same value of the argument .can any one help.... Thanks in advance,
by basu.ds
Wed Apr 08, 2009 5:34 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: comparing with null values
Replies: 5
Views: 1853

reject means '0'