DSXchange

Wondering if DataStage 7x is compatible with Windows vista ??

I agree with Chulett on "interrogating the logs".. and hence I would try to achieve this by using a After stage routine, to generate the job report or say colelcting all the messages other than Information messages and then search for some key words e.g "Row Truncation" or "...

Use a link partitioner to split your file into parts... use an apporpriate Spliting logic ( hashed / Round Robin etc..) you may check the Link Partitioner's help. Since you want to chunk the file into 5000 rows each, use this constraint in the Transformr stage which is reading the fille @INROWNUM>0 ...

Why not write a small job, which filters out the data from the file. Put the desired constraint, say Col1 = Value1, and create a new output file.

I use this approach instead of waiting for "Not responding" to become "Responding"

Sorry for the wrong English usage.

Thx for the info !

Hi Ray,

Nice info, thx

Hey, is there any resoultion been provided by IBM? Any patch etc ?

Do u guys agree that Stopped/Restartable is not a restartable state ?

If such be the casem then can u plz guide me for handling this requirement :

" If two jobs start parallely, and either of them aborts, then the other must also abort, such that both the jobs are restartable."

May try to use DOS Command, DIR to list the files sorted by date modified and date created.
You have the list of files to chose

Hi, The Sequence design is this job design . The idea behind using the Exception handler is to stope execution of all running jobs in case of any Job / Sequences in this sequence abort. Now, in my case this is what is happening: The Job ExtractEPMData aborts and this is caught by Exception handler. ...

Hi, I am facing a problem, like this: The job design is this Job Design . Now the sequence has 2 environment variables, $APEPMSYNCH and $AMEPMSYNCH. I am testing for the values of these variables on the trigger link of Nested Condition stage, "AP_EPM" and "AM_EPM". Now, when I co...

yes, after the first messaeg, these are also there: DSGetProjectInfo(..) DSGetJobInfo(..) DSExecute(...) DSMakeJobReport(..) DSGetNewestLogId(..) DSGetLogEntry(..) DSLogInfo(..) Can I use PRINT stmnt to log some infomational messages, rather than using DSLogInfo(..) ? I believe that using DSLogInfo ...

Hi, I am having the same problem, as discussed in this post, http://www.dsxchange.com/viewtopic.php?t=106443 . In my case, I am using an After Stage routine, and the job started the routine but did not finish it. And the job even though has completed, finished with Aborted status. Now why I say that...

Hi,

Is there any alternative way of adding new job parameters or including new Environment variables to all the existing jobs ??

Wrong Forum...

Anyways, in Server jobs we use Jobstaus in the CLI command, dsjob, which returns the job's status.....

HTH,
Asit