Re: IBMDB2I Storage Engine Question

Matt:

One of the more annoying parts the integration is indeed the "" around
the object name. That is normal, and no you cannot change it to the
best of my knowledge. When you created the table, IBM i created the
collection for you called "test" (quotes part of the name). You can
access the data in "test" with any IBM tool or DBU etc without trouble.
I do it quite a bit.

If you download a tool called Adminer (http://www.adminer.org/) your
tasks will be somewhat easier. I just drop the whole adminer.php file
into the root where Zend is installed (/www/zendsvr/htdocs) and it
works. The file name for the Adminer might be something like:
adminer-2.3.2.php. I always drop the version numbers from the file name
to make it easy.

Jim Oberholtzer
Chief Technical Architect
Agile Technology Architects


On 5/12/2011 8:14 AM, Matt Lavinder wrote:

Just trying out the IBMDB2I storage engine. I know it isn't officially
supported anymore so don't remind me- I live on the edge.:)

I am creating a schema and table, and based on the Redbook (which might

be

wrong), if I use all uppercase and less than 10 characters for my

database

name and table name, the object created on the system should not have

quotes

in the name But I create TEST.MYTABLE and it is placed in

"test"."mytable"

on the system. Is there a way to keep tables created in MySQL from

having

quotes around the name?

Matt

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