DSXchange

kumar_s

You cannot update the key in the table using upsert method. So you should be checking it in DS and need to replace or update the whole record. Do a lookup and if matches, insert two records one with Validto = (validfrom-1) and another with 9999-12-31. And so the manipulation of Validto = (validfrom-...

kumar_s

Can the type 19 directory be found under Project Directory? Buy I could not find it?

kumar_s

Try

Code: Select all

cd $DSHOME
bin/dssh
>LOGTO {Project_name}

Make sure you can able to login to project through TCL.

kumar_s

Is it possible to build a Wrapper stage with set of unix commands?

kumar_s

What is the target stage?
What is that you want from the target stage?
Is it an database and do you need a query?
If so

Code: Select all

Select ColA from <Table> where ColB in (Select ColB from <Table> where ColA = #Input#)

As suggested, more you be clear, more quickly you get the result.

kumar_s

Each Passive stage is a single process.
All the active stage consicutive to each other will be again considired as single process.

kumar_s

Gives out the number of records consumed by each player for the run. (So I am not sure whether this variable is available in Server Edition)

kumar_s

How about turning on APT_RECORD_COUNT envirnmental variable (Not sure about Server edition)

kumar_s

What you get if you execute

Code: Select all

netstat -a | grep dsrpc

from command prompt?[/code]

kumar_s

Easy way to find the time taken for a job to finish sucessfully, can be found from Direcotr. So you can make sample job which can read a sample (but with large amount of similar data) to write into oracle stage. Make sure you dont have any other application or jobs runing on the server. Rerun form s...

kumar_s

Not sure whether you can compress multiple files using this stage. But you can execute all the unix commands from ExecuteCommand Activity in Job Sequence or through Before/After Subroutine.

kumar_s

Once I had such scenario from Comnand Activity, which replies 0 - Success, 1 - Warining, 2 - Error. Though I handled all the error code in the trigger section, it throwed me unhaldled error for reply 1. We manage to solve by giving 'Otherwise' trigger only for that condition.

kumar_s

Can you post the full error log. It might give the clear picutre.
Sometimes the truncating warning may be related to this post.
http://www.dsxchange.com/viewtopic.php? ... highlight=

kumar_s

Hi, I'm getting the folowing error when a job is opened or compiled. Cannot Open File BP_11.0 Cannot Open File BP_11. Can anyone help me out in solving this issue? Thanks, Vimali Might be your job got corrupted. Not suer what information will be stored in BP_nn/BP_nn.O. Just to reconfirm it is RT_B...

kumar_s

sendmk wrote:i knew i can transformer and @outrownum=1, but i want to use only stage variables

thx

What stops you to use @outrownum?
Whats special in Stage variable?
And pls let us know who you get the uniqe records out using @outrownum without using stage variable?

DSXchange

Search found 5168 matches

Re: Error: Cannot open file BP_11