how to create shared container for oracle

[sekr]

Hi all,

my source is oracle ! i want to create shared conatiner for orcale ..
i have done shared conatiner for flat files .
but im getting confused creating shared container for oracle stage

example :-

select salray,basesalary from emp where dept = 10 and age = 30.

here i have 3 columns in oracle stage salary,dept, age
4th one basesalary that i had added in output column.
i have created shared container for this example XXXS
this i want to use in another job.
how to do this !

[ArndW]

A shared container is DataStage's way of doing what a compiled language does in subroutines. It does not make sense to make a shared container, or even a normal container, for a source read stage unless the exact same query with the same columns and parameters is used everywhere.

The documentation is pretty clear with examples of shared containers, have you looked at it?

[sekr]

I got ..........i was bit confused but atlast i did it
thnks all

Hi all,

my source is oracle ! i want to create shared conatiner for orcale ..
i have done shared conatiner for flat files .
but im getting confused creating shared container for oracle stage

example :-

select salray,basesalary from emp where dept = 10 and age = 30.

here i have 3 columns in oracle stage salary,dept, age
4th one basesalary that i had added in output column.
i have created shared container for this example XXXS
this i want to use in another job.
how to do this !