× 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.



I see nothing in any of these posts that cannot be done in SQL in DB2. I
personally don't have sufficient knowledge of SQL to do it, but I guarantee
there are others on this list that can.


--
Jim Oberholtzer
Agile Technology Architects


-----Original Message-----
From: WEB400 [mailto:web400-bounces@xxxxxxxxxxxx] On Behalf Of Steve Richter
Sent: Friday, May 04, 2018 10:49 AM
To: Web Enabling the IBM i (AS/400 and iSeries) <web400@xxxxxxxxxxxx>
Subject: Re: [WEB400] mysql does not have table functions?

no, I mean table functions. as asked in this question:
https://stackoverflow.com/questions/23421771/how-to-return-table-from-mysql-
function

DB2 has table functions. SQL SERVER also:
https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/sql/linq/how-t
o-use-table-valued-user-defined-functions

I checked maria DB and it does not appear to have them either.

here are some comparison charts. But does not mention table functions.
https://en.wikipedia.org/wiki/Comparison_of_relational_database_management_s
ystems


On Fri, May 4, 2018 at 11:21 AM, Jim Oberholtzer <
midrangel@xxxxxxxxxxxxxxxxx> wrote:

If you are asking if you can get a list of tables in a database, list
of databases, or the schema of the tables inside a database, yes you
can get all of that from MySQL. Remember MySQL is now longer updated by
anyone. I
think Maria might be the better option. 15 minutes inside the
documentation will show you.

What databases are there: "show databases"
What is the schema: "show schema"
What tables are in the database: "use database", then "show tables"

https://dev.mysql.com/doc/refman/8.0/en/show-databases.html

As to Maria having more features than DB2, not ever going to happen.
Maria is a fine database and does an excellent job, but comparing it
to DB2 which is an Enterprise Class full service database is a bit
like comparing a Yugo car to a Lincoln Navigator. Two different classes
of database/car.


--
Jim Oberholtzer
Agile Technology Architects


-----Original Message-----
From: WEB400 [mailto:web400-bounces@xxxxxxxxxxxx] On Behalf Of Steve
Richter
Sent: Friday, May 04, 2018 9:57 AM
To: Web Enabling the AS400 / iSeries <web400@xxxxxxxxxxxx>
Subject: [WEB400] mysql does not have table functions?

is that true, mySQL does not support functions that return tables?
Was expecting mySQL to have more features than DB2, not less.
--
This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400)
mailing list To post a message email: WEB400@xxxxxxxxxxxx To
subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/web400.


--
This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400)
mailing list To post a message email: WEB400@xxxxxxxxxxxx To
subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/web400.


--
This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) mailing
list To post a message email: WEB400@xxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit: https://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/web400.



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.