Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Behaviour of SQL statements in static and dynamic calls

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> COBOL Programming
View previous topic :: :: View next topic  
Author Message
sudhakar_mainframe
Warnings : 1

New User


Joined: 29 Jun 2006
Posts: 25

PostPosted: Mon Sep 21, 2009 3:10 pm    Post subject: Behaviour of SQL statements in static and dynamic calls
Reply with quote

Can any one please explain how the SQL Statements behave in STATIC and DYNAMIC calls icon_question.gif

Thanks,
Sudhakar
Back to top
View user's profile Send private message

dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6968
Location: porcelain throne

PostPosted: Mon Sep 21, 2009 4:07 pm    Post subject:
Reply with quote

well, since static and dynamic calls have nothing to do with SQL,
hard to answer your question (and remain civil).
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Mon Sep 21, 2009 4:20 pm    Post subject:
Reply with quote

I started putting in comments for your question but then I just stuck to know, are you asking 1. about static and dynamic SQL statements execution? 2. or the question is related to static/dynamic calls of COBOL-subroutines, which in turn, involves embedded SQL? Please explain before we (I, for one) can help you.
Back to top
View user's profile Send private message
sudhakar_mainframe
Warnings : 1

New User


Joined: 29 Jun 2006
Posts: 25

PostPosted: Mon Sep 21, 2009 10:52 pm    Post subject: it is related to
Reply with quote

Hi Anuj,

It is related to sql statements in static and dynamic calls.

Thanks,
Sudhakar
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10274
Location: italy

PostPosted: Mon Sep 21, 2009 11:11 pm    Post subject: Reply to: Behaviour of SQL statements in static and dynamic
Reply with quote

Quote:
Can any one please explain how the SQL Statements behave in STATIC and DYNAMIC calls
Quote:
It is related to sql statements in static and dynamic calls.


not much diference... the uncertainity about what You want to know is still there

You can have...

dynamic subroutine calls with static SQL statements
static subroutine calls with dynamic SQL statements
dynamic subroutine calls with dynamic SQL statements
static subroutine calls with static SQL statements

again Your question is related to ...
1) dinamic/static generic subrotine calls
2) dynamic/static SQL statements

pleser reply with 1 or 2

the call to the dsn... stub will alway be a static one ( the stub will be part permanently of the load module )

if the reply is 2 take a look at
http://www.redbooks.ibm.com/abstracts/sg246418.html
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Tue Sep 22, 2009 11:29 am    Post subject:
Reply with quote

Hi Sudhakar,

Though I agree with Enrico -- confusion is still there, but being from non-english origin and reading through Dick's reply, I, for one probably got what you're asking about.

Enrico I believe his choice would be 1.

But having said that, I need to go on the same lines as Dick has said earlier -- static and dynamic calls in COBOL have nothing to do with SQL. Suggest you rephrase the question and possibly, you can let us know the origin of the question as well. Some one will be around with a suggestion then.
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Tue Sep 22, 2009 5:05 pm    Post subject:
Reply with quote

Probably a question concerning the logical unit of work.

In f.e. IDMS this can be quite confusing.

if this is your question, here's an attempt of an answer :

- A rollback will rollback everything until the last commit.
- A commit anywhere (main-program, static call routine, dynamic call routine) will commit everything.
- a goback does not commit.

the end of the main-program (without abend) does an (implicit) commit.

to put it in IDMS terms : There is only one "run-unit" and everything is in it.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> COBOL Programming All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts REXX - Dynamic file Creation d_sarlie CLIST & REXX 7 Tue Jun 27, 2017 7:30 pm
No new posts Dynamic output file creation in cobol... smileheal COBOL Programming 7 Thu Jun 15, 2017 10:53 pm
No new posts Dynamic split of files under groups sril.krishy DFSORT/ICETOOL 4 Mon Apr 17, 2017 1:09 pm
No new posts Dynamic array request/response contai... Suja.Sai CICS 2 Tue Jan 24, 2017 11:37 am
No new posts REXX DB2: Dynamic allocation of DB2.D... BHAS CLIST & REXX 3 Mon Dec 19, 2016 8:26 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us