View previous topic :: View next topic |
Author |
Message |
bullfighter Beginner
Joined: 15 Apr 2005 Posts: 26 Topics: 9
|
Posted: Thu Apr 21, 2005 2:51 pm Post subject: Dynamic or Static sqls |
|
|
Hi,
We run a lot of Easytrieves accessing DB2 on our mainframe.
We have the below steps in our programs
1. DECLARE CURSOR CUR1
2. OPEN CUR1
3. FETCH CUR1
4. CLOSE CUR1
Are we using dynamic sqls or Static sqls.?
I have this doubt because we dont mention any Plan name when we submit our jobs, but I dont think its dynamic as we dont have the Prepare step.
Thanks |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12372 Topics: 75 Location: San Jose
|
Posted: Thu Apr 21, 2005 3:19 pm Post subject: |
|
|
bullfighter,
Yes you are execueting Dynamic Sql in easytrieves. The module DQSPSCV will prepare your sql statements on the fly for you. Look for the loadmodule DQSPSCV in your Steplib dataset.
Hope this helps...
Cheers
Kolusu _________________ Kolusu
www.linkedin.com/in/kolusu |
|
Back to top |
|
|
bullfighter Beginner
Joined: 15 Apr 2005 Posts: 26 Topics: 9
|
Posted: Thu Apr 21, 2005 4:00 pm Post subject: |
|
|
I could not find a module like DQSPSCV at all, is the preparation done someother way.
thanks |
|
Back to top |
|
|
|
|