DSXchange

I did like this: I declared two stage variables...mergedRow, i, and totalRecCount mergedRow = If @INROWNUM = i Then InputLink.col1 else mergedRow: InputLink.col1 i = i+1 (i has initial value 0) Now, in the output link from the transformer, I put a constraint @INROWNUM = totalRecCount I am getting to...

I have data in a sequential file. My data look like this:

25UB|23435
25XZ|89435
25MB|46377
25MD|38204
25YN|32048

I want to convert this data to:
25UB|23435|25XZ|89435|25MB|46377|25MD|38204|25YN|32048

Thanks

I have data in a sequential file. My data look like this:

25UB|23435
25XZ|89435
25MB|46377
25MD|38204
25YN|32048

I want to convert this data to:
25UB|23435|25XZ|89435|25MB|46377|25MD|38204|25YN|32048

My environment: DataStage 7.1 Parallel Extender in Unix server

Thanks

How would I do this vertical pivot in DataStage 7 Parallel Extender? Any design help...what stages to use? Thanks

There is no abort messages...job1 is finished with status OK. job2 is not executed at all and job0 'is running'. Even if I stop job0, it's not stopping. job0 is reset when I compile it again. How would I put logging statements to check errors? Is there any command like 'printout', or 'cout (C++'s)' ...

Thanks for your help. I'll try both of your approach (I have lot of time!). I tried Ray's way and I have job control code like this:[code] MyVariable = 10 * Setup job1, run it, wait for it to finish, and test for success hJob1 = DSAttachJob("job1", DSJ.ERRFATAL) If NOT(hJob1) Then Call DSL...

Hi:
I have two jobs (Job1 and Job2). I want to pass a value from Job1 to Job2 using parameter. Job1 finds a max(column1) and this max value has to be passed to Job2's parameter. How do I do this? Thanks for your help.

In PX, it is not allowing me to have more than one link to the target Oracle stage. Any other way by which I can achieve this? THanks

By the way, 'Transaction Control' is not displayed on the stage properties. I think, we have to do something with administrator to set 'Transaction Control' in PX.

OK. Now, if I want to catch the 'abort' signal (Do I have to use unix shell script or DS BASIC routine), how would I do that? Do you think 'catching abort signal and issuing rollback' seems to be possible solution? Could you give me some outline on how I should approach this? Thanks for your time.

Is it possible to insert rows in more than one table in a single database connection? I have a target stage as Oracle(9i) and it has three tables. What I want to do is that I want to connect to this target Oracle stage only once and insert rows in all three table. Please let me know how I can do thi...

Hi Chulett:
I'll post my error message with more details in a seperate thread soon (I want to try couple of things tomorrow before I post). Thanks.

Hi, I tried to extract data from a table (Oracle 9i) which has null values in Coulmn3. My job is like this: Oracle Stage --> Transformer --> Seq. File. When I run this job, I get error like this :'cannot export null field with out null handle'. I incorporated 'If then else' in transformer to check f...