DSXchange

My bad... that's really a typo when I posted the question. But in the actual case, it really has a dash. So this does not work either: DSPath="/DS/Ascential/DataStage/DSEngine/bin" paramvals="-param JOB_ID=98246 -param PREVRUNDT='2010-03-20 18:00:00' -param CURRRUNDT='2010-03-21 18:00...

Yes, that worked by adding -param before each parameter. Thank you. I am going to put this code in a shell script. I have something like DSPath="/DS/Ascential/DataStage/DSEngine/bin" paramvals="param JOB_ID=98246 -param PREVRUNDT='2010-03-20 18:00:00' -param CURRRUNDT='2010-03-21 18:0...

I have entered the following in unix command line: /DS/Ascential/DataStage/DSEngine/bin/dsjob -run -jobstatus -wait -mode NORMAL -param JOB_ID=98246 PREVRUNDT="2010-03-20 18:00:00" CURRRUNDT="2010-03-21 18:00:00" -warn 50 APPPRJ Load_Target It errored out with the following messa...

My bad.. you're right. It is DSLogFatal. When I have this in the Stage variable Derivation area, it does not even compile: If DSLink89.retval <> 'NO DATA FOUND' then Call DSLogFatal("No Data, "Acct Load") else 0 What I'm up to is to abort the job when the read value is ' NO DATA FOUND...

I'd like to abort the job when the value of a column is not equal to 'DATA FOUND'. I tried using the transformer's stage variable: If retval <> 'DATA FOUND' then Call DSTransformError("No Data, "Acct Load") else 0 This is also not working with DSLogAbort. Is routine necessary or can i...

Hi, I will need to invoke a server job sequence through Unix, and I can only depend on the return values to determine if the job completed successfully, still running, failed/aborted or finished with warning. Based on these return values, it will take the next course. Can you please help me with the...

Hi dsxuserrio, we are also planning to use subversion. It feels great to know we're in the same boat. I would appreciate if you can let me know how you are doing things in subversion. - Do you have individual dsx files for each job, sequence, routine? - What are the objects you version (job, sequenc...

Hi Craig, we know about the version control. However, it does not serve the same purpose as the one which has check-in/check-out/merge/branch/lock features. I think DS version control is mainly to keep history. Anyone using version control system, I just would like to know how they manage the creati...

We are planning to use versioning tool for our project. We primarily use DataStage. The problems we are facing are: - we are not aware of any migration tool that can handle DSX files. The files have to be manually deployed/compiled to Production environment. - if a new release has 50 jobs, we have t...

Our user have to drop 5 excel files. Each file loads to its corresponding table. Now, they wanted to have one excel file with 5 different sheets instead for their ease of maintenance. How is it possible (without manual intervention) that I load each sheet to a different table? Or any workaround you ...

Hi,
My company is trying for a job scheduler. Our jobs run via DataStage, unix shell script and Oracle procedures. I would like a comparison of the schedulers available in the market. Any article, white paper or any document you may share will be greatly appreciated. thank you.

I have a database stage which queries from a table of Job Names. It passes it to a transformer. In the transformer, i have the following derivations: DSGetJobInfo(Lnk_Fr_table.job_name,DSJ.JOBSTATUS) DSGetJobInfo(Lnk_Fr_table.job_name,DSJ.JOBSTARTTIMESTAMP) DSGetJobInfo(Lnk_Fr_table.job_name,DSJ.JOB...

We are interested in using a third party scheduler. An open source would be ideal in terms of cost. I would appreciate it if you can suggest any - we will study and evaluate it. I've heard good feedbacks on Control-M. We can also resort to buying but am not sure how much it is per license/user. Any ...

It has the header (which is also in the category .dsx) + its own individual scripts. Something like: BEGIN HEADER CharacterSet "CP1252" ExportingTool "Ascential DataStage Export" ToolVersion "4" ServerName "My_Server" ToolInstanceID "My_Project" MDIS...

Check this post : http://www.dsxchange.com/viewtopic.php?t=113429&highlight=cutter I tried to use this script to create individual .DSX files for each job inside the category which I exported. When I did the export, I only checked 'Job Designs' as Component and 'By Category' as Option. When I r...