DSXchange

Kumar, i tested it out and it was working fine. Rasi thank you as well for your input. But does DSEport also allows for routine and other components of a project. If yes then what are the parameters. Is there a documentation that i could refer to?

Thank you in advance.

Hi All, Here is the command line i use to export a particular job using dscmdexport. C:\Progra~1\Ascential\DataStage\dscmdexport.exe /U=dsstg1 /P=password /H=172.32.9.63 /JOB=CIF10CCDSIFM01 DSS_UAT2 test.dsx DSS_UAT2 is the project name. test.dsx is the export file name. When i execute the line i am...

DataStage Version: 7.0 DS Server: AIX 5.2, IP: 172.29.1.88, UID: user1, PWD: dstage1 DS Client : Win XP Hi All, Our DS is installed in a AIX server and we access the projects through DS Client tools running in Win XP. Few days ago the server abnormally stopped but after the server was rebooted we we...

Hi All, I am having multiple users assigned to multiple DS projects. The issue is all the users need to be assigned different user roles. I checked in the DS Administrator->Project Properties -> Permissions but it allows only fo Group and Users as a whole. Basically this is what i want to do: Projec...

Hi, I have this query and i need to know how to concatenate this query in DS. Have a job with User-defined SQL and passing a sql file as the query source. My column definition will have one single Varchar(2500). Problem is i do not know how to concatenate this query.Kindly help. SELECT (case when a....

Hi All, I am having close to 25 different queries accessing multiple table within a same database.I strictly need to execute the query one by one. My job: db2/udb->transformer->seq file For my Source[db2/udb], i used the {FILE} command for it to extract the query from a SQL file. My objective was to...

Dear Poornagirija, My team wants a routine or job that over a period of time extracts the content of rt_log table details for certain monitoring process. The system will extract details from RT_LOG say every 15mins and make sense of the information and display the output as a text file. I dont know ...

Hi All, I am new to datastage and i need to know how to extract the log details from the RT_LOG table. The thing is i went through this forum and there were so many informations available and i dont know how to use them. Could some one kindly help me by giving a routine or a job that extracts the RT...

Hi there D, I have been trying to something similar to what you have done but i am getting no where.I am new to DS. I need to get the log dumps and then i came across your forum. I am not sure on how to use in DS, whether i create it a function or job etc. Could you help me kindly. I sense what you ...