RE: jdbc: fn LOCATE

[Zabach, Elke]

Hi,

 

sorry, I missed the question.

 

LOCATE is available in SAP DB , sqlmode internal.

 

We decided not to point to that function in the reference manual

because there is another one with the same functionality.

Otherwise (we had this, more than once, we hate this) those

questions like:

you have two things doing the same. Why? Which should I use ?

would occur.

 

Elke

SAP Labs Berlin

-----Original Message-----
From: Artin Modaresi [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 26, 2003 2:06 PM
To: Dittmar, Daniel
Subject: JDBC driver FN LOCATE

Hi,

Im a developer at cypoint group. We have an application that is written in a general way that it should work with all sql relational databases. It is already tested and works 100% with oracle and MS sql server, and Im trying to run it with sap db as well. I need the LOCATE scalar funtion in the jdbc driver for this.  I thought of sending you a link to the jdbc requirements page for developers at sun's site. What it says there is basically that scalar functions should be provided by the driver for the functions that the particular database supports and that it should provide a list of the functions it has. Then a list of scalar functions that the jdbc should have if the databse supports them is presented. LOCATE is one of the functions. Its in the string functions section. http://java.sun.com/products/jdbc/driverdevs.html 

We would like to file a request for its support. It would come very handy as the database seems to support all other things we need, and also has the INDEX function for this perticular need.

Best regards,

anton modaresi

systems developer,

Cypoint Innovation

 

 

-----Original Message-----

From: Dittmar, Daniel [mailto:[EMAIL PROTECTED]

Sent: den 25 februari 2003 15:21

To: Richard Damoser; [EMAIL PROTECTED]

Subject: RE: jdbc: fn LOCATE

 

> Release 7.4 will add support for user defined functions, so

> this will allow you to mimic functions from other SQL dialects.

It will be in 7.4.4, which is still a few months away.

Daniel Dittmar

--

Daniel Dittmar

SAP DB, SAP Labs Berlin

[EMAIL PROTECTED]

http://www.sapdb.org/

 

-----Original Message-----

From: Dittmar, Daniel [mailto:[EMAIL PROTECTED]

Sent: den 25 februari 2003 15:06

To: Richard Damoser; [EMAIL PROTECTED]

Subject: RE: jdbc: fn LOCATE

 

> is there any plans from SAP's side to implement the function

> LOCATE into

> the driver to comply with Sun's standard?

We didn't found any indication that LOCATE is part of the JDBC standard (as Sun is generally quiet about the actual SQL that gets passed through the JDBC methods).

Release 7.4 will add support for user defined functions, so this will allow you to mimic functions from other SQL dialects.

Daniel Dittmar

--

Daniel Dittmar

SAP DB, SAP Labs Berlin

[EMAIL PROTECTED]

http://www.sapdb.org/