× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. February 2022

Re: [IBMiOSS] UDF works in STRSQL but not over ODBC using Python

On Fri, Feb 11, 2022 at 12:04 PM John Yeung <gallium.arsenide@xxxxxxxxx> wrote:

On Fri, Feb 11, 2022 at 11:01 AM Birgitta Hauser <Hauser@xxxxxxxxxxxxxxx> wrote:

... and why won't you simply use System Naming conventions instead of SQL
Naming conventions?

1. SQL naming is the default when I connect via pyodbc.
2. I don't know, or keep forgetting, how to change to system naming in pyodbc.
3. I generally like to keep my SQL as dialect-agnostic as I can.

4. System naming doesn't save me much if anything. If I use system
naming, that saves me one SQL statement (to adjust the path). But it
costs me an additional setting on the connection (see points 1 and 2
above). I think on balance, I actually find it easier to set the path.
Or even just use qualified names.

John Y.

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.