473,320 Members | 2,107 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

ODBC doesn't support stored procedures? This can't be true

In Chip Irek's "A PRIMER ON USING DB2 WITH .NET" (www.15seconds.com),
he states that "...ODBC doesn't support DB2 stored procedures. So if
you are building an application heavily dependant on stored
procedures, you need to eliminate ODBC as your access method and
consider OleDb or the managed provider."

Mr Irek is an IBM Architect with Global Services and according to the
article, someone with .NET experience.

Now, I'd ask Mr Irek this question myself, but my email comes back
undeliverable.

Does he mean this for just for .NET applications? This can't mean for
all applications.

Any IBM colleague of Mr Irek able to clarify this?
Nov 12 '05 #1
24 3765
Looks to me like both ODBC and OLE-DB both don't support result sets for
DB2 stored procs. Search http://www.microsoft.com on "ODBC DB2 Stored
Procedures" and "OLE-DB DB2 Stored Procedures".

Larry Edelstein

Benjamin Doyle wrote:
In Chip Irek's "A PRIMER ON USING DB2 WITH .NET" (www.15seconds.com),
he states that "...ODBC doesn't support DB2 stored procedures. So if
you are building an application heavily dependant on stored
procedures, you need to eliminate ODBC as your access method and
consider OleDb or the managed provider."

Mr Irek is an IBM Architect with Global Services and according to the
article, someone with .NET experience.

Now, I'd ask Mr Irek this question myself, but my email comes back
undeliverable.

Does he mean this for just for .NET applications? This can't mean for
all applications.

Any IBM colleague of Mr Irek able to clarify this?


Nov 12 '05 #2
Looks to me like both ODBC and OLE-DB both don't support result sets for
DB2 stored procs. Search http://www.microsoft.com on "ODBC DB2 Stored
Procedures" and "OLE-DB DB2 Stored Procedures".

Larry Edelstein

Benjamin Doyle wrote:
In Chip Irek's "A PRIMER ON USING DB2 WITH .NET" (www.15seconds.com),
he states that "...ODBC doesn't support DB2 stored procedures. So if
you are building an application heavily dependant on stored
procedures, you need to eliminate ODBC as your access method and
consider OleDb or the managed provider."

Mr Irek is an IBM Architect with Global Services and according to the
article, someone with .NET experience.

Now, I'd ask Mr Irek this question myself, but my email comes back
undeliverable.

Does he mean this for just for .NET applications? This can't mean for
all applications.

Any IBM colleague of Mr Irek able to clarify this?


Nov 12 '05 #3
The MS information you reference only applies to using the MS Host
Integration Server drivers, which use a totally different connectivity
system, and these drivers are ludicrously crippled. DB2 Connect provides a
much better solution for accessing your mainframe DB2.

I'm not sure Benjamin was even asking about access mainframe data, and I'm
reasonaby certain he isn't using HIS, as he posted his question here.

"Larry" <La***@nospam.net> wrote in message
news:Bv**********************@news4.srv.hcvlny.cv. net...
Looks to me like both ODBC and OLE-DB both don't support result sets for
DB2 stored procs. Search http://www.microsoft.com on "ODBC DB2 Stored
Procedures" and "OLE-DB DB2 Stored Procedures".

Larry Edelstein

Benjamin Doyle wrote:
In Chip Irek's "A PRIMER ON USING DB2 WITH .NET" (www.15seconds.com),
he states that "...ODBC doesn't support DB2 stored procedures. So if
you are building an application heavily dependant on stored
procedures, you need to eliminate ODBC as your access method and
consider OleDb or the managed provider."

Mr Irek is an IBM Architect with Global Services and according to the
article, someone with .NET experience.

Now, I'd ask Mr Irek this question myself, but my email comes back
undeliverable.

Does he mean this for just for .NET applications? This can't mean for
all applications.

Any IBM colleague of Mr Irek able to clarify this?

Nov 12 '05 #4
The MS information you reference only applies to using the MS Host
Integration Server drivers, which use a totally different connectivity
system, and these drivers are ludicrously crippled. DB2 Connect provides a
much better solution for accessing your mainframe DB2.

I'm not sure Benjamin was even asking about access mainframe data, and I'm
reasonaby certain he isn't using HIS, as he posted his question here.

"Larry" <La***@nospam.net> wrote in message
news:Bv**********************@news4.srv.hcvlny.cv. net...
Looks to me like both ODBC and OLE-DB both don't support result sets for
DB2 stored procs. Search http://www.microsoft.com on "ODBC DB2 Stored
Procedures" and "OLE-DB DB2 Stored Procedures".

Larry Edelstein

Benjamin Doyle wrote:
In Chip Irek's "A PRIMER ON USING DB2 WITH .NET" (www.15seconds.com),
he states that "...ODBC doesn't support DB2 stored procedures. So if
you are building an application heavily dependant on stored
procedures, you need to eliminate ODBC as your access method and
consider OleDb or the managed provider."

Mr Irek is an IBM Architect with Global Services and according to the
article, someone with .NET experience.

Now, I'd ask Mr Irek this question myself, but my email comes back
undeliverable.

Does he mean this for just for .NET applications? This can't mean for
all applications.

Any IBM colleague of Mr Irek able to clarify this?

Nov 12 '05 #5
Not sure how reliable your source is, but:
http://publib.boulder.ibm.com/infoce...d/t0007399.htm

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Nov 12 '05 #6
Not sure how reliable your source is, but:
http://publib.boulder.ibm.com/infoce...d/t0007399.htm

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Nov 12 '05 #7
Hello Serge,

IIRC we went over a closely related topic (not ODBC but static SQL) in a
slightly different context a while back, when I indicated my wish for IBM to
implement the same functionality on DB2 UDB as had been available on DB2 for
MVS
(OS/390, z/OS) - in particular, for result sets to CALL statements. That is,
support for the ASSOCIATE LOCATORS statement in conjunction with the related
CALL statement enhancements
(http://publib.boulder.ibm.com/epubs/pdf/dsnsqj10.pdf).

I'd still like to see this support. Its omission makes porting code
unnecessarily "hard" (impossible might be more accurate).

"Serge Rielau" <sr*****@ca.eye-be-em.com> wrote in message
news:c6**********@hanover.torolab.ibm.com...
Not sure how reliable your source is, but:
http://publib.boulder.ibm.com/infoce...d/t0007399.htm
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab


Nov 12 '05 #8
Hello Serge,

IIRC we went over a closely related topic (not ODBC but static SQL) in a
slightly different context a while back, when I indicated my wish for IBM to
implement the same functionality on DB2 UDB as had been available on DB2 for
MVS
(OS/390, z/OS) - in particular, for result sets to CALL statements. That is,
support for the ASSOCIATE LOCATORS statement in conjunction with the related
CALL statement enhancements
(http://publib.boulder.ibm.com/epubs/pdf/dsnsqj10.pdf).

I'd still like to see this support. Its omission makes porting code
unnecessarily "hard" (impossible might be more accurate).

"Serge Rielau" <sr*****@ca.eye-be-em.com> wrote in message
news:c6**********@hanover.torolab.ibm.com...
Not sure how reliable your source is, but:
http://publib.boulder.ibm.com/infoce...d/t0007399.htm
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab


Nov 12 '05 #9
Must have been a while ago. Associate locator went into V7.1 GA
http://publib.boulder.ibm.com/infoce...n/r0005645.htm

Cheers
Serge

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Nov 12 '05 #10
Must have been a while ago. Associate locator went into V7.1 GA
http://publib.boulder.ibm.com/infoce...n/r0005645.htm

Cheers
Serge

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Nov 12 '05 #11
Thanks everyone for you input.

As it happens, I have programmers writing Java and .NET apps and
planning to connect to mainframe DB2 z/OS v7.1 through DB2 Connect /
DB2 UDB v8 Federated.

When one of them came across this article by Mr Irek, there were
concerns about how to proceed. It didn't seem to make sense that
there'd be this stored procedure limitation, but there it was from an
IBM .NET master.

Benjamin Doyle
Nov 12 '05 #12
Thanks everyone for you input.

As it happens, I have programmers writing Java and .NET apps and
planning to connect to mainframe DB2 z/OS v7.1 through DB2 Connect /
DB2 UDB v8 Federated.

When one of them came across this article by Mr Irek, there were
concerns about how to proceed. It didn't seem to make sense that
there'd be this stored procedure limitation, but there it was from an
IBM .NET master.

Benjamin Doyle
Nov 12 '05 #13
ASSOCIATE LOCATORS isn't in the UDB 8.1.4 documentation under DB2
Information Centre - Reference - SQL - SQL Statements (jumps from ALTER VIEW
to BEGIN DECLARE SECTION). Although it is listed in the section on SQL
Control Statements (your URL also points here), it is documented there as
only being permitted inside an SQL procedure (Note 1 under SQL control
statements - SQL Procedure). Also the documentation for ASSOCIATE LOCATORS
is missing the standard Invocation and Authorization sections that are
typical of normal SQL statements that I can embed in a host program. A quick
check with a test program verifies that the documentation is correct.

To clarify, I'm talking about the DB2/MVS ASSOCIATE LOCATORS statement
(introduced in DB2 V5, wasn't it?) that allows an application with an
embedded CALL statement to process the result sets returned by that CALL.
This functionality is missing in UDB embedded SQL, although it's available
in the CLI API. The UDB ASSOCIATE LOCATORS is semantically something
different, it merely has the same spelling.

"Serge Rielau" <sr*****@ca.eye-be-em.com> wrote in message
news:c6**********@hanover.torolab.ibm.com...
Must have been a while ago. Associate locator went into V7.1 GA
http://publib.boulder.ibm.com/infoce...n/r0005645.htm
Cheers
Serge

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

Nov 12 '05 #14
ASSOCIATE LOCATORS isn't in the UDB 8.1.4 documentation under DB2
Information Centre - Reference - SQL - SQL Statements (jumps from ALTER VIEW
to BEGIN DECLARE SECTION). Although it is listed in the section on SQL
Control Statements (your URL also points here), it is documented there as
only being permitted inside an SQL procedure (Note 1 under SQL control
statements - SQL Procedure). Also the documentation for ASSOCIATE LOCATORS
is missing the standard Invocation and Authorization sections that are
typical of normal SQL statements that I can embed in a host program. A quick
check with a test program verifies that the documentation is correct.

To clarify, I'm talking about the DB2/MVS ASSOCIATE LOCATORS statement
(introduced in DB2 V5, wasn't it?) that allows an application with an
embedded CALL statement to process the result sets returned by that CALL.
This functionality is missing in UDB embedded SQL, although it's available
in the CLI API. The UDB ASSOCIATE LOCATORS is semantically something
different, it merely has the same spelling.

"Serge Rielau" <sr*****@ca.eye-be-em.com> wrote in message
news:c6**********@hanover.torolab.ibm.com...
Must have been a while ago. Associate locator went into V7.1 GA
http://publib.boulder.ibm.com/infoce...n/r0005645.htm
Cheers
Serge

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

Nov 12 '05 #15
ASSOCIATE LOCATOR in DB2 for Multiplatforms is indeed not a regular SQL
Statement (similar to SET).
I don't think it is semantically different though. Can you clarify?

I'm trying to run down whether the CLI-API is the only interface.
My asumption was that associate locator is parsed by PREP in e.g. SQL
embedded in C.

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Nov 12 '05 #16
ASSOCIATE LOCATOR in DB2 for Multiplatforms is indeed not a regular SQL
Statement (similar to SET).
I don't think it is semantically different though. Can you clarify?

I'm trying to run down whether the CLI-API is the only interface.
My asumption was that associate locator is parsed by PREP in e.g. SQL
embedded in C.

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Nov 12 '05 #17
On DB2 for (MVS, OS/390, z/OS), I can process the result set of a CALL in a
(PL/I, COBOL, C) program.

On DB2 UDB I cannot do this, as ASSOCIATE LOCATOR is only permitted in an
SQL Procedure, and cannot be embedded in a host program. That is, your
assumption is incorrect.
"Serge Rielau" <sr*****@ca.eye-be-em.com> wrote in message
news:c6**********@hanover.torolab.ibm.com...
ASSOCIATE LOCATOR in DB2 for Multiplatforms is indeed not a regular SQL
Statement (similar to SET).
I don't think it is semantically different though. Can you clarify?

I'm trying to run down whether the CLI-API is the only interface.
My asumption was that associate locator is parsed by PREP in e.g. SQL
embedded in C.

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

Nov 12 '05 #18
On DB2 for (MVS, OS/390, z/OS), I can process the result set of a CALL in a
(PL/I, COBOL, C) program.

On DB2 UDB I cannot do this, as ASSOCIATE LOCATOR is only permitted in an
SQL Procedure, and cannot be embedded in a host program. That is, your
assumption is incorrect.
"Serge Rielau" <sr*****@ca.eye-be-em.com> wrote in message
news:c6**********@hanover.torolab.ibm.com...
ASSOCIATE LOCATOR in DB2 for Multiplatforms is indeed not a regular SQL
Statement (similar to SET).
I don't think it is semantically different though. Can you clarify?

I'm trying to run down whether the CLI-API is the only interface.
My asumption was that associate locator is parsed by PREP in e.g. SQL
embedded in C.

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

Nov 12 '05 #19
Indeed it is. :-(

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Nov 12 '05 #20
Indeed it is. :-(

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Nov 12 '05 #21
Now that we agree that DB2 UDB canot process stored procedure result sets in
embedded SQL, in contrast to host DB2, which has been able to do so for a
long time, I obviously need to ask:

Are ther any plans to enhance DB2 UDB to give it host compatibility for
processing results sets from stored procedures via embedded SQL?

"Serge Rielau" <sr*****@ca.eye-be-em.com> wrote in message
news:c6**********@hanover.torolab.ibm.com...
Indeed it is. :-(

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

Nov 12 '05 #22
Now that we agree that DB2 UDB canot process stored procedure result sets in
embedded SQL, in contrast to host DB2, which has been able to do so for a
long time, I obviously need to ask:

Are ther any plans to enhance DB2 UDB to give it host compatibility for
processing results sets from stored procedures via embedded SQL?

"Serge Rielau" <sr*****@ca.eye-be-em.com> wrote in message
news:c6**********@hanover.torolab.ibm.com...
Indeed it is. :-(

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

Nov 12 '05 #23
Not to my knowledge.
IBM claims to be customer driven.
Feel free to put that claim to the test with a DCR.

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Nov 12 '05 #24
Not to my knowledge.
IBM claims to be customer driven.
Feel free to put that claim to the test with a DCR.

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Nov 12 '05 #25

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Andreas Lauffer | last post by:
I changed from Access97 to AccessXP and I have immense performance problems. Details: - Access XP MDB with Jet 4.0 ( no ADP-Project ) - Linked Tables to SQL-Server 2000 over ODBC I used...
0
by: Richard Lyko | last post by:
Can anyone explain to me the significance of the new procedures for implementing CLI/ODBC access to DB2/VM 7.2 from a UDB 8.1 client? The new procedures involve creating a bunch of stored...
0
by: Benjamin Doyle | last post by:
In Chip Irek's "A PRIMER ON USING DB2 WITH .NET" (www.15seconds.com), he states that "...ODBC doesn't support DB2 stored procedures. So if you are building an application heavily dependant on...
14
by: jj | last post by:
Is it possible to call a remote php script from within Access? I'm thinking something like: DoCMD... http://www.domain.com/scripts/dataquery.php DoCmd.OpenQuery "update_data", acNormal, acEdit...
1
by: Lyle Fairfield | last post by:
I created a new MS-SQL Database, "TestODBC". I made Table1 and StoredProcedure1. I made an ODBC DSN for that MS-SQL Database. I created a new AccessXP mdb, "TestODBC". I linked to the...
5
by: Zlatko Matić | last post by:
Hello. How can I call some functions on MSDE when working in .mdb ? Especially in-line functions which are similar to stored procedures. How can I use MSDE in-line functions as recordsource for...
4
by: Me | last post by:
I am writing a C#.NET application that is primarily intended to be used with SQL server. One of my concerns is that in the future I will have users who do not have or want to run SQL Server. That...
4
by: Stuart Ferguson | last post by:
I am currently writing code to execute SQL Server 2000 Stored procedured using the ODBC.NET SQL Server Driver. The particular stored procedure I am using has multiple paramaters which I have...
2
by: gene.ellis | last post by:
Hey Everyone, I am a stored procedures newbie, so I wanted to ask if it is possible to use them with PHP via an ODBC-ODBC bridge connected to a MS SQL server. I am simply use the commands from...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.