Search found 14 matches
- Thu Feb 01, 2018 10:45 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Stored Procedure stage with Longvarchar (CLOB)
- Replies: 16
- Views: 11318
>> 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 ...
- Thu Feb 01, 2018 9:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Stored Procedure stage with Longvarchar (CLOB)
- Replies: 16
- Views: 11318
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...
- Wed Jan 31, 2018 3:55 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Stored Procedure stage with Longvarchar (CLOB)
- Replies: 16
- Views: 11318
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...
- Sat Jan 20, 2018 1:12 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Stored Procedure stage with Longvarchar (CLOB)
- Replies: 16
- Views: 11318
- Thu Jan 18, 2018 11:38 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Stored Procedure stage with Longvarchar (CLOB)
- Replies: 16
- Views: 11318
- Thu Jan 18, 2018 5:35 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Stored Procedure stage with Longvarchar (CLOB)
- Replies: 16
- Views: 11318
Stored Procedure stage with Longvarchar (CLOB)
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...
- Sat Nov 18, 2017 12:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: call database after cdc stage
- Replies: 4
- Views: 3298
- Fri Nov 17, 2017 2:42 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: call database after cdc stage
- Replies: 4
- Views: 3298
call database after cdc stage
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...
- Fri Oct 13, 2017 9:38 am
- Forum: General
- Topic: division into jobs
- Replies: 4
- Views: 3402
- Fri Oct 13, 2017 6:52 am
- Forum: General
- Topic: division into jobs
- Replies: 4
- Views: 3402
division into jobs
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
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
- Mon Oct 09, 2017 4:11 am
- Forum: General
- Topic: manage lookup table by datastage
- Replies: 9
- Views: 4974
- Fri Oct 06, 2017 1:25 am
- Forum: General
- Topic: manage lookup table by datastage
- Replies: 9
- Views: 4974
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...
- Thu Oct 05, 2017 6:52 am
- Forum: General
- Topic: manage lookup table by datastage
- Replies: 9
- Views: 4974
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 ...
- Thu Oct 05, 2017 5:43 am
- Forum: General
- Topic: manage lookup table by datastage
- Replies: 9
- Views: 4974
manage lookup table by datastage
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
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