DSXchange

and

>> to chop it up into chunks it in dbms x_control x_ret 1 <x> 1 x as value 1 </x> 2 <y> 2 y as value 2 </y> it is returned by stored procedure stage with cursor >> and then reassemble them in the job in job, yes xml output stage with use trigger column - x_control may be i wrong about xml output to ...

and

thanks for note but there are some moments: -- i'm talking not about pretty printing -- it's not well-formed xml please compare <test> <x> </test> <test> x as value </test> <test> </x> </test> and expectation <test> <x> x as value </x> </test> in last case xml contains one root and imho it have to b...

and

asorrell, chulett thanks i tried following - created sample table x_control x_ret 1 <x> 1 x as value 1 </x> 2 <y> 2 y as value 2 </y> - create oracle dbms procedure with cursor based on above table - in datastage add stored procedure stage - after stored procedure stage was added xml output for outp...

and

i have to shed some light to my previous reply if dbms stored procedure use only one row with clob value to return then it's ok to slice the clob up what if dbms stored procedure use cursor to return many rows ( my case ) and so in datastage you'll have many "chunks" of many row's clob and...

and

thanks chulett and asorrell I encountered this once and had to slice up the XML CLOB into manageable "chunks", send the pieces, and then reassemble them afterwards. That wasn't a preferred solution, but it worked. nice note can you please give me some hints on it did you slice up XML/CLOB ...

and

Hi all! I have job with a Stored Procedure stage and Oracle procedure like PROCEDURE TEST1(p_in1 in varchar2, p_out1 out clob) I have some trouble with output from the stored procedure stage :( If I set type for output in stored procedure stage as "varchar" the job works. But I need to ret...

and

hi
yes

1 cdc -> 2 call db -> 3 process some logic -> 4 call target

i need call db with data from cdc stage and return some data from then

and

hi all i have cdc stage in my job and after job will be invoked i need to call some sql statement in database ( oracle ) and pass/get data from 1 cdc -> 2 call db -> 3 process some logic -> 4 call target i'm interested in 2 step how to implement 2 step for calling database is it routine ? with oci c...

and

qt_ky, chulett

thanks for notes

as for

And we wrap them in a "framework" that knows how to back out any partially completed loads (where applicable)

can you add more hints for this please

i have not so much expirience and this will be interesting for me

thanks

and

hi all

i need to create two files (file set) for two lookups based on dbms data.

i can create two jobs for filling each file or one job for filling two files.

what is the best practice ?

one job per unit of job ? or may be one job per task

thanks

and

ray.wurlod wrote:The only tool you have in DataStage is the DataStage job.

it's a pity

thanks

and

thanks for note ok i try to describe in other view for example i have parallel job ( job1 ) which use some lookup ( L1 ). also i have another parallel job ( job2 ) which fill file for L1 of job1 from some source ( S1 ) so i want to know some ways and tools for working with S1 as idea 1) S1 can be so...

and

the lookup table is read into memory when the job starts is there some tool (may be with GUI ) for add/delete some data in it before i will use it ? in general i want to have some lookup ( may be mapping table ) managed by datastage. of course i can have some table in database then read it by some ...

and

hi

i'm try to find info about using datastage or its components for managing (add, delete, update) lookup table.

are there some tools (may be with GUI ) for this ?

or may be preferable way to administer such things are database, files ...

any ideas....

thanks

DSXchange

Search found 14 matches

Stored Procedure stage with Longvarchar (CLOB)

call database after cdc stage

division into jobs

manage lookup table by datastage