DSXchange

Hello, I have a following error in one of my jobs: LKP_DIAGNOSIS_BRIDGE,0: Ignoring duplicate entry at table record 720; no further warnings will be issued for this table I know what the error means, and can fix it, but the question I have is: If there are several rows returned from a reference tabl...

Thanks, I have also called IBM and they have indicated it might require a procedure to manually change attribute.

I am in a project that is not read-only.

These really should not be read-only. All the jobs (parallel and sequence) all the shared containers etc can be edited. How they came to be, I don't know.

Thanks
Anil

Hello,

I have user written routines in the designer that are read-only. Is there a way to make them write-able?
I cannot edit, save or compile these routines, since they read-only.

Thanks

Hello,

Is it possible to use a variable in a sequence activity to call a sequence or a parallel job? If so, how?

Thanks

IBM issued a patch for this

Used T-SQL to create the pivot

A patch has been issued which we will aplly this Monday

Thank you.

I have a job that inserts rows into a table in a sql server database. I set up a DRS stage with "Truncate table then insert rows" for the "update action". I set the array size to 15000 and the transaction size to 50000. I found out from the sql server DBA that it was inserting on...

A PMR with IBM has been created

I can use the 1st occurence for C1 and the last for C2. Ditto for D.
Can you explain how to use the stage variables in a transformer to accomplish this?
Thanks

PIVOT

Thanks

Can someone help me in configuring the Pivot Stage? The input data coming in is

A, B, C, D

and I need the output to be:

A, B, C1, C2, D1, D2

Example:
Input:

12345 aaaa c1 d1
12345 aaaa c2 d2

Output:
12345 aaaa c1 c2 d1 d2

Thank you

Hello, I have a job that executes a stored procedure. The procedure requires one parameter, which is passed to it from a DRS stage using a select from a sql server table. Thus you can bring in one or more rows as input to the sp. The sp stage is configured to "Execute procedure for each row&quo...