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