dbaccess tool

I would like DBACCESS and DBSCHEMA tools being installed on client machines to let developers checking database. But I did not see the executables( dbaccess, dbschema) there after I insatlled CSDK on the client machines. I copied them from db server machine to the client machines, but it does not work. How can I get it there? Thanks Quman

Dbaccess and dbschema are part of the database server package. You cannot install them on client machines. You CAN however, get very similar open source utilities from the IIUG Software Repository (www.iiug.org/software): IBM Tool IIUG Equivalent Repsitory Package dbaccess sqlcmd sqlcmd-80.00 dbschema myschema utils2_ak sqlcmd implements a query tool including all dbaccess 'info' commands, but only the command line interface (ie: dbaccess mydatabase - ) no menus. myschema implements all dbschema features except -hd with many extensions, enhancements and (if I must say so myself) improvements. Art S. Kagel ----- Original Message ----- From: Quman <ids@iiug.org> At: 6/14 15:42:42 I would like DBACCESS and DBSCHEMA tools being installed on client machines to let developers checking database. But I did not see the executables( dbaccess, dbschema) there after I insatlled CSDK on the client machines. I copied them from db server machine to the client machines, but it does not work. How can I get it there? Thanks Quman ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Thanks Art. I have another workaround would like to share. (1) copy two directories: msg/ and forms/ to client machine and (2) copy dbaccess and dbschema executables It works wonderful! Cheers, Quman On 6/14/06, ART KAGEL, .... <kagel@bloomberg.net> wrote: > > > Dbaccess and dbschema are part of the database server package. You cannot > install them on client machines. You CAN however, get very similar open > source > utilities from the IIUG Software Repository (www.iiug.org/software): > > IBM Tool IIUG Equivalent Repsitory Package > dbaccess sqlcmd sqlcmd-80.00 > dbschema myschema utils2_ak > > sqlcmd implements a query tool including all dbaccess 'info' commands, but > only > the command line interface (ie: dbaccess mydatabase - ) no menus. > > myschema implements all dbschema features except -hd with many extensions, > enhancements and (if I must say so myself) improvements. > > Art S. Kagel > > ----- Original Message ----- > From: Quman <ids@iiug.org> > At: 6/14 15:42:42 > > I would like DBACCESS and DBSCHEMA tools being installed on client > machines to let developers checking database. > > But I did not see the executables( dbaccess, dbschema) there after I > insatlled CSDK on the client machines. > I copied them from db server machine to the client machines, but it does > not work. > > How can I get it there? > > Thanks > Quman > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >

ART KAGEL, .... wrote: > Dbaccess and dbschema are part of the database server package. You cannot > install them on client machines. You CAN however, get very similar open source > utilities from the IIUG Software Repository (www.iiug.org/software): > > IBM Tool IIUG Equivalent Repsitory Package > dbaccess sqlcmd sqlcmd-80.00 > dbschema myschema utils2_ak > > sqlcmd implements a query tool including all dbaccess 'info' commands, but > only > the command line interface (ie: dbaccess mydatabase - ) no menus. > > myschema implements all dbschema features except -hd with many extensions, > enhancements and (if I must say so myself) improvements. > > Art S. Kagel > Or get SQSL also available from the IIUG software repository or my humble site. cli & curses interface available and loads more goodies -- Ciao, Marco ______________________________________________________________________________ Marco Greco /UK /IBM Standard disclaimers apply! Structured Query Scripting Language http://www.4glworks.com/sqsl.htm 4glworks http://www.4glworks.com Informix on Linux http://www.4glworks.com/ifmxlinux.htm

> > I would like DBACCESS and DBSCHEMA tools being installed on client > > machines to let developers checking database. > > > > But I did not see the executables( dbaccess, dbschema) there after I > > insatlled CSDK on the client machines. > > I copied them from db server machine to the client machines, but it does > > not work. > > > > How can I get it there? Check out Server Studio JE from AGS, Ltd. A basic version is included with IDS. The full version has far more features than DBAccess, including stored procedure debugging, sql syntax checking, data editing grids, visual object navigation, ER diagrams (version 6), built-in reports (extents, etc.), test data generation, schema diff between instances, single log-in for multiple instance, and so much more. www.serverstudio.com. It is a Java application so it runs on multiple platforms. Note, I am just a satisfied user. Sean Durity

Sure if you don't mind violating your license agreements. Not my choice. Check out Marco Greco's SQSL package also. It uses ESQL/C to emulate dbaccess including menu modes. I always forget that one. Art S. Kagel ----- Original Message ----- From: Quman <ids@iiug.org> At: 6/14 17:29:55 Thanks Art. I have another workaround would like to share. (1) copy two directories: msg/ and forms/ to client machine and (2) copy dbaccess and dbschema executables It works wonderful! Cheers, Quman On 6/14/06, ART KAGEL, .... <kagel@bloomberg.net> wrote: > > > Dbaccess and dbschema are part of the database server package. You cannot > install them on client machines. You CAN however, get very similar open > source > utilities from the IIUG Software Repository (www.iiug.org/software): > > IBM Tool IIUG Equivalent Repsitory Package > dbaccess sqlcmd sqlcmd-80.00 > dbschema myschema utils2_ak > > sqlcmd implements a query tool including all dbaccess 'info' commands, but > only > the command line interface (ie: dbaccess mydatabase - ) no menus. > > myschema implements all dbschema features except -hd with many extensions, > enhancements and (if I must say so myself) improvements. > > Art S. Kagel > > ----- Original Message ----- > From: Quman <ids@iiug.org> > At: 6/14 15:42:42 > > I would like DBACCESS and DBSCHEMA tools being installed on client > machines to let developers checking database. > > But I did not see the executables( dbaccess, dbschema) there after I > insatlled CSDK on the client machines. > I copied them from db server machine to the client machines, but it does > not work. > > How can I get it there? > > Thanks > Quman > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Just for completeness - Aubit4GL has a dbaccess "clone" (asql_i.4ae - aka adbaccess) Currently works well for Informix and postgres (asql_p.4ae). On Wednesday 14 June 2006 20:38, Quman wrote: > I would like DBACCESS and DBSCHEMA tools being installed on client > machines to let developers checking database. > > But I did not see the executables( dbaccess, dbschema) there after I > insatlled CSDK on the client machines. > I copied them from db server machine to the client machines, but it does > not work. > > How can I get it there? > > Thanks > Quman > > > *************************************************************************** >**** Forum Note: Use "Reply" to post a response in the discussion forum. -- Mike Aubury