DSXchange

Thanks ray.wurlod. Just one question before I do that. Do I just add it in as I would for any "user defined" environment variable? I suppose It means the enviroment variable "APT_IMPEXP_ALLOW_ZERO_LENGTH_FIXED_NULL" Yes chulett, Can we now add that Enviroment variable in the proj...

Well Chulett, Of course. However, like most of the time, there's more than one way to skin this cat. All I was attempting to point out was that (in my opinion) the focus on just warnings was too narrow, but that rather you should handle all outcomes outside of the 'OK' box. Of course NOT. There are ...

I stand by my solution and claim that no "other" solution is required to meet the need described in pat_raman2000's two posts. ray.wurlod You may. But, your solution does not face the requirement clearly. Please look at his requirement for a while. My requirement is when it encounters war...

dstage443 wrote:@INROWNUM or @OUTROWNUM was the one that worked for me

Can you please let me know how did you do that?

Do you have the value of the Job parameter to mean the last line number which is supplied by the user or extracted from the table by any other job?

Why not just use @OUTROWNUM system variable, perhaps added to a constant (starting value) supplied as a job parameter? If the Starting value is supplied by the user, 1. Can we go with this solution into production? 2. How user determines the last record line number in the table? Please clarify thes...

Why not just use @OUTROWNUM system variable, perhaps added to a constant (starting value) supplied as a job parameter? If the Starting value is supplied by the user, 1. Can we go with this solution into production? 2. How user determines the last record line number in the table? Please clarify thes...

OK chulett, but a clarification is now needed. Please... What I would setup would still involve that trailing Sequencer so that each job has a full set up triggers associated with them, including the last one. In addition to the 'OK' trigger that passes execution on to the job step, I would use an '...

Good Lord. Re-read my post, which is a simple and complete solution. You've made it unnecessarily complicated, given some incomplete information and need to understand that a Sequence must abort to be restartable. ps. The Sequencer is needed unless you really want to hang all of that extra crap off...

ray.wurlod, Then you must build this in - "automatic" handling only applies when a job (or other) activity actually fails - aborts Automatically handle job runs that fail. Select this to have DataStage automatically handle failing jobs within a sequence (this means that you do not have to ...

I am having sequential dependencies with multiple job activities.I have created custom conditional option with job_activity1.jobstatus=0 that is job needs to go second job when there is ok condition .Sequncer works well when there is abort condition (status =2).it restarts from where it left when a...

But, i feel my question is still alive, as, for me, your words did not seem to be highly related the question. Maybe i am waiting for chulett to give his opinions. I would like to redefine my question as simple as below. Is there anyway to create(if not found already) an Environment variable for spe...

The original question was marked "parallel job" and I answered thus. This discomfort comes, only when it is a Parallel Job , on which i came to give enough focus with experimental result. If it is fortunately a Server Job, File Stage can be used to get records after the Transformer Stage ...

ArndW wrote:No, deletion of jobs and categories can only be done through the clients.

Can't we do it from the Server as -

1. Opening the DataStage Shell(dssh) of the Project
2. Executing the following query

In other words you need a surragate key. many ways to achieve this. There are out of the box key management routines or manage key generation on your own. Search the forum for posts on surrogate key generation. I suppose Surrogate Key Generator is in Parallel Job palette not in Server Job palette. ...

Hope,

Did you have any intermediate stage that is in between Source and Target Stages as to have a removal of other columns or only in the Source Stage?