is it possible to pass a parameter to a VIEW(s) when connecting using DataStage.
Can you show the SQL query difference of this for a table and a view? or is there no difference how the query is made?
parameter to a view
Moderators: chulett, rschirm, roy
-
Kirtikumar
- Participant
- Posts: 437
- Joined: Fri Oct 15, 2004 6:13 am
- Location: Pune, India
What do you mean by passing param to view?
When you use a param in the query which is accessing view, the param value gets replaced when the SQL is prepared and executed.
E.g. if you have view EmpDet on Employee table and you use select query on the view with a parameter in the query, DS will prepare it by substituting the param value. DS does not know if it is a view or a table. It just prepared the query to database and database then does the work substituting view def in the query and executing it.
When you use a param in the query which is accessing view, the param value gets replaced when the SQL is prepared and executed.
E.g. if you have view EmpDet on Employee table and you use select query on the view with a parameter in the query, DS will prepare it by substituting the param value. DS does not know if it is a view or a table. It just prepared the query to database and database then does the work substituting view def in the query and executing it.
Regards,
S. Kirtikumar.
S. Kirtikumar.
View doesnt make any differenct with table with respect to Datastage. Query were made similar to table. If you were refering to creation of the Table or view, you dont have any direct option to create a view but using user defined query, you can. And passing the parameter as well.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'