DSXchange

How to deploy development project to production using package mechanisam?
Kindly mention steps required for package deployment.

Ok I have to check with ETL Server Administrator, Also need to verify send mail commands working or not.

I Need to send Email from Datastage job, I use Notification Activity stage of Sequence Job. 1: When I pass all parameters in Notification Tab of Notification Activity stage like; SMTP server name; Sender Email address; Recipients Email address; Email Subject and Email body then it gives that message...

A little lost with no question mark in your post. What you've designed should allow the sequence to run each job one after the other without regard to the status of each job. If that is not happening, tell us what IS happening. Sorry for Question Mark missing in post next time we care..... :idea: Y...

I design a sequense job like JOB1 ==> JOB2 ==> JOB3 .... ==> JOBn What conditions applied that the next job trigger without the dependence of the previous job status.Whatever the previous job stats Its Finish with OK or WARNINGs OR job ABORTED with whatever the reason, But sequencer triger next job ...

Please can you explain in detail...

We have a shell script that runs on Windows and we want to run that file in Linux through DataStage. File contents are as; param( [string]$sourcepath, [string]$targetpath ) $OWlogtext = "`nStarted at " + (Get-Date).ToString() $CommandName = $MyInvocation.MyCommand.Name $OWlogfilename = $Co...

As I have a file with data and a delimeter '='. I want to read data and passes to parameters using uservariable stage in Sequence Job. But routine is not reading the data. I haven't DS Routine commands which read the file. Code with loop is giving nothing it returns the default value of 'Ans' as def...

I need to read data from a text file using DataStage routine. I have a piece of code but its not working. Filename is an Argument which have the File Path. OPENSEQ Filename TO H.FILE1 THEN CALL DSLogInfo("******************** File " : H.FILE1 : " opened successfully", "JobCo...

Here is my understanding regarding your above solutions: First solution you suggested is to use looping sequence with user variable stage and 2nd solution is to make a server job with USERSTATUS. I have couple of questions here: In your first solution, how can i access the table in user variable sta...

@chulett. I dont understand your looping sequence solution. I think, in sequential file stage we can read multiple files as mentioned below: file1.txt file2.txt file3.txt I have read that with above approach we can read multiple files but in my case flat file names are picked at run time. so we need...

I want to read all the files at a time after their file names have been fetched from the table.

We need to read multiple files in sequential file stage. File names +paths are picked from a table. After picking file names and paths from table, how can we store them in a variable so that we can use variable in other sequential stage or use in sequence job?