| |
|
If this is your first visit, be sure to check out the FAQ by clicking the link above.
You may have to register before you can post: click the register link above to proceed.
To start viewing messages, select the forum that you want to visit from the selection below.
|
 |
04-02-08, 11:27
|
|
Window Washer
|
|
Join Date: Nov 2002
Location: Jersey
Posts: 10,303
|
|
|
DB2 Sprocs
|
|
Why doesn't IBM implement procedural internal sprocs? Do they all have to be external sprocs?
What a royal pain
|
|
04-02-08, 11:29
|
|
Registered User
|
|
Join Date: Apr 2008
Posts: 51
|
|
You have the option of writing them in a REAL programming language - the way all stored procs should be done, in my opinion
__________________
db2topgun.com
|
|
04-02-08, 11:38
|
|
Window Washer
|
|
Join Date: Nov 2002
Location: Jersey
Posts: 10,303
|
|
|
|
So T-SQL and PL-SQL are not "real" programming languages?
|
|
04-02-08, 11:49
|
|
Resident Curmudgeon
|
|
Join Date: Feb 2004
Location: In front of the computer
Posts: 12,605
|
|
Quote:
|
Originally Posted by SuperKuper
You have the option of writing them in a REAL programming language - the way all stored procs should be done, in my opinion
|
BAL ?
-PatP
|
|
04-02-08, 12:45
|
|
Window Washer
|
|
Join Date: Nov 2002
Location: Jersey
Posts: 10,303
|
|
|
|
04-02-08, 13:04
|
|
Registered User
|
|
Join Date: Apr 2008
Posts: 51
|
|
Quote:
|
Originally Posted by Brett Kaiser
So T-SQL and PL-SQL are not "real" programming languages?
|
Not even close 
__________________
db2topgun.com
|
|
04-02-08, 13:10
|
|
Registered User
|
|
Join Date: Apr 2008
Posts: 51
|
|
Quote:
|
Originally Posted by Pat Phelan
BAL ?
-PatP
|
IBM's 370 Assembler (aka Basic Assembler Language or BAL) is one of them. There are also a number of 3rd generation languages in which DB2 UDFs and stored procedures can be written, e.g. COBOL, C, FORTRAN, PL/I, etc.
__________________
db2topgun.com
|
|
04-02-08, 13:49
|
|
Registered User
|
|
Join Date: Jan 2007
Location: Jena, Germany
Posts: 2,662
|
|
DB2 stored procedures can be written in the standard-compliant SQL PL dialect. So the question would rather be: why are you still sticking to an older DB2 version that does not have this feature yet? 
__________________
Knut Stolze
IBM DB2 Analytics Accelerator
IBM Germany Research & Development
|
|
04-02-08, 13:51
|
|
Window Washer
|
|
Join Date: Nov 2002
Location: Jersey
Posts: 10,303
|
|
Such as?
What version are you talking about?
I'm on Big Iron, and hell we're just getting off 7.2
|
|
04-02-08, 14:17
|
|
Registered User
|
|
Join Date: Jan 2007
Location: Jena, Germany
Posts: 2,662
|
|
I don't know if DB2 for iSeries has it, but DB2 z/OS and DB2 LUW have both SQL PL support in stored procs. I believe this was introduced in DB2 z/OS V8 - and even earlier in DB2 LUW.
__________________
Knut Stolze
IBM DB2 Analytics Accelerator
IBM Germany Research & Development
|
|
04-02-08, 15:53
|
|
Window Washer
|
|
Join Date: Nov 2002
Location: Jersey
Posts: 10,303
|
|
|
|
04-02-08, 16:20
|
|
:-)
|
|
Join Date: Jun 2003
Location: Toronto, Canada
Posts: 4,449
|
|
|
|
04-03-08, 04:43
|
|
Registered User
|
|
Join Date: Jan 2007
Location: Jena, Germany
Posts: 2,662
|
|
|
|
04-03-08, 09:05
|
|
Window Washer
|
|
Join Date: Nov 2002
Location: Jersey
Posts: 10,303
|
|
OK, but in the example, in the SQL Sproc, I don't see any procedural code
|
|
| Thread Tools |
Search this Thread |
|
|
|
| Display Modes |
 Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|
dBforums
>
DB2 Sprocs
