DSXchange

After appending " | dir " to the command "d:\progra~1\winzip\winzip32.exe -min -e c:\File_Name.zip c:\", the problem still remains. As I understand, the command "d:\progra~1\winzip\winzip32.exe -min -e c:\File_Name.zip c:\ |dir" actually opens the winzip32.exe but the u...

Hi ArndW ,
I did't get exactly , i.e. add "| dir" to your command line?If possible If possible Will u pl explain me ..

Regards
Luk

Hi Ray, Thanks for the response..... I m executing following command to Unzip files from Before job subroutine d:\progra~1\winzip\winzip32.exe -min -e c:\File_Name.zip c:\ Here c:\ is my source file path and i want to keep the unzipped file in the same path itself . When i execute above command, i m...

Thanks Kenneth Bland AND DSguru2B for the response,

DSguru2B will u pl help me in how can i Zip/Unzip files through routine.
Thanks in Advance

Hi Gurus,

I want to Unzip files which are in specified directory using routine or someother way (and once Unzipping is done next job will extract those files). If anyone have idea about on this pl guide me.

Both DataStage client and Server are installed in Windows environment.

Kind Regards
Luk

Hi Kim,

Thanks a lot.

Kind Regards
LUK

Dear Kim, I have modified the query like this, SELECT DS_JOBOBJECTS.OLETYPE as StageName, DS_JOBS.NAME as JobName, DS_JOBOBJECTS.NAME as LinkName, DS_JOBS.CATEGORY as Category FROM DS_JOBOBJECTS, DS_JOBS WHERE OBJIDNO = JOBNO Group by StageName, JobName, LinkName, Category ; And i m getting Job name...

Thanks for the inputs Ray,


But want to get all the Names of the Stages in each job from my Project.

Just like NAME, CATEGORY,LINK_NAME FROM DS_JOBS and DS_JOBOBJECTS for getting job name, link name and category.

Kind Regards
LUK

Thanks for u r reply Kim, The code (dsx) which u have given (EtlStats) to query the Universe and to generate job reports is really awesome. From EtlStas from LoadEtlJobLink Job, it is giving Job Name , Link Name and Category. Will it possible to get all the names given to Stages in the job using que...

Hi Gurus, By querying on Universe, we can get all the job names and Link names from the Universe. Same way, How to query all the Stage names from Universe. Eg: I have given stage names in a Job as src_finance , tfm_finance,tgt_finance . How to query these stage names from DS Universe Kind Regards LUK

dscnn wrote:Hi,

Can ProfileStage jobs be called from DataStage? How to call them, if it is possible? I can't see anything about it in ProfileStage documentation.

Hi,
As far as my Knowledge, Can't call PS jobs from DS. Only we will have to import the Jobs generated by PS into DS.

Cheers
Luk

Thank U Bland.

Hi,

Can any one tell me What are the Sheduling tools available to Shedule the Datastage jobs except Cron.And which one is better to shedule the Datastage Jobs.

Regards
Luck

Hi,
Can any tell What is the Version of new IBM Web Sphere Datastage.

I mean is this new release with any version number like Ascential Datastage 7.1,7.5 ...etc. or just simply it is IBM Web Sphere Datastage.

Cheers

Luck

Hi All,

Can any one kindly provide what are the Hardware requirements for Server and PX Jobs .

I request what is the recommended Hardware requirement for Installing Server and PX.

Thanks in Advance,

Lucky