hello friends
my question is to confirm what i found, may be i am wrong ............
i think we cannot use shared container as lookup in datastage server jobs, if i am wrong please let me know more info on it.
thanks,
sachin.
Can we use shared container as lookup in datastage server
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
thanks i could use containers for lookup, but now i have one more question, reading through Datastage Designer Guide chpt 5 on local container, an example is shown for local container implementation using ODBC stage.
my question is in first diagram it is shown,
ODBC_0------>Dslink2----->CONTAINER----->Dslink3------>ODBC_1.
in second diagram it is shown.
ContainerInput------>dslink2----->ODBC_0------>Dslink5-----------.
so we have to declare ODBC_0 stage twice once in local container and other in job design, which is redundant.
please explain.
thanks,
sachin.
my question is in first diagram it is shown,
ODBC_0------>Dslink2----->CONTAINER----->Dslink3------>ODBC_1.
in second diagram it is shown.
ContainerInput------>dslink2----->ODBC_0------>Dslink5-----------.
so we have to declare ODBC_0 stage twice once in local container and other in job design, which is redundant.
please explain.
thanks,
sachin.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You would have had to create two ODBC stages even without the local container, because passive stages can not open their outputs until their inputs are closed - with one stage only your design would have a deadly embrace situation.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
No, as noted that is specific to the job design of the example, not the fact that a container is involved. Use or non-use of a container does not change how anything works or the stages involved, it just 'collects' them into a logical unit. Use them (local containers) to 'simplify' a complicated job design by showing a more 'high-level' overview of the job on the canvas. Details can then be had by drilling into the containers if desired.sachin1 wrote:so we have to declare ODBC_0 stage twice once in local container and other in job design, which is redundant.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers