Re: IBMDB2I Storage Engine Question

Much of that is personal preference but you will find the user interface more intuitive, and it's mainly there for managing MySQL. both will work, just most folks that try Adminer continue to use it preferentially over phpMyAdmin.

Technically it's a smaller footprint, uses less memory (although that's a nitpik) etc.

Jim Oberholtzer
Chief Technical Architect
Agile Technology Architects


On 5/12/2011 9:34 AM, Matt Lavinder wrote:

I have phpMyAdmin as it came with Zend Server. How is Adminer better, out
of curiosity?


On Thu, May 12, 2011 at 10:13 AM, Jim Oberholtzer<midrangel@xxxxxxxxxx>wrote:

> 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