View previous topic :: View next topic
|
Author |
Message |
sarath16581
New User
Joined: 11 Jun 2005 Posts: 8
|
|
|
|
Can we pass DB2 host variables to a subprogram if so how. Can we use select query in the subprogram with the variables from main program. |
|
Back to top |
|
|
Cristopher
New User
Joined: 31 Jul 2008 Posts: 53 Location: NY
|
|
|
|
Quote: |
Can we pass DB2 host variables to a subprogram if so how |
You dont't have to pass the variables , but the values in the variables.
You receive the values in some ws variable of your subprogram and use it into the the queries.
Or you can include the DCLGEN of the table in your subprogram and use the host variables as per your need.
Some one would be able to suggest concrete ways to achieve your requirement if you can elaborate a little more.
Cris |
|
Back to top |
|
|
|