DSXchange

1. Define required date parameters in a job.
2. Select the DB stage that suits your DB, fill-in credentials & use your SQL;
Pass the parameters defined in step 1 to the WHERE clause.
3. Write the output to file

what is the auto-purge setting in pre-upgrade and post-upgrade?

did you find a way?

virtusadsuser wrote:it's an type of access. Datastage user will not allowed to edit the job in designer.

That is called as "DataStage Operator" role. Can you respond to Eric's questions?

karthik_j013 wrote:all 100 records contains amount from the source file) only few records amount is loaded like 30 records and the rest is loaded with 0.

So are you sure that 100 records are loaded/updated?

What do you mean by read-only user in the context of DataStage?

Deepa, you need to try from your end. Your current output is p1 p,q1 p,q,x2 p,q,x,y2 p,q,x,y,z2 Now, it is time to think how to use rownum column for concatenation. If current rownum is same as previous, then concatenate (other) column to stageVar. Otherwise, assign the column to stageVar. ---------...

that means you have not selected the right partitioning/sorting method in the second transformer.

Atleast, try in sequential mode and see if everything looks fine.

What problem are you facing? You are getting p,2,1 q,3,1 Pass col1 & rownum in one stream and col2 & rownum is another stream. Apply the concatenation logic in both transformer stages and get outputs as shown below 1,p 1,p,q 1,2 1,2,3 Get the first record after desc sort & funnel them to...

Almost there..

Convert all known/expected delimiters to single character & then select the first field using field function.

oh..

Job aborted with some error and that's fine. Did you check what is actually passed to the job at the first place? I am asking you this for the second time

Try $PROJDEF

2 more Craig

If you are able to login & open/edit the job in Designer but this error during the run, i would contact support.

lsnovick wrote:Attempting to Cleanup after ABORT raised in stage testEMPLoad..BeforeJob

What stage is testEMPLoad? Did you develop this job from scratch or took a copy of existing job? You don't see anything in BeforeJob or JobControl tab of Job Properties?