BorlandTalk.com Forum Index BorlandTalk.com
Borland discussion newsgroups
 
Archives   FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

DB2 SQL tools

 
Post new topic   Reply to topic    BorlandTalk.com Forum Index -> Delphi As400
View previous topic :: View next topic  
Author Message
server
Guest





PostPosted: Sat Feb 19, 2005 8:27 pm    Post subject: DB2 SQL tools Reply with quote



message unavailable
Back to top
Golem
Guest





PostPosted: Sat Feb 19, 2005 8:27 pm    Post subject: Re: DB2 SQL tools Reply with quote



Jannie Nel wrote:

Quote:
Hi,

I'm wondering if there are any PC (read Windows) tools for managing a
DB2 database on the AS400.

The tool should be able to setup new databases, create/modify tables,
run SQL and most of all - create/modify stored procedures.

The tool can be commercial or open source.

Any info would be appreciated.

Jannie.
You can use DBNAVIGATOR a tool with Client Access.


Enjoy with it
Back to top
Ted Reilly
Guest





PostPosted: Wed Feb 23, 2005 10:28 pm    Post subject: Re: SQL Explorer shows "double" tables Reply with quote



Might be you've installed iSeries Client Access? There are issues with
this.

Ted


"Joe Harbin" <joe.harbin (AT) state (DOT) mn.us> wrote in message
news:41fe47b7$1 (AT) newsgroups (DOT) borland.com...
Quote:

After installing a new version of Client Access, Borland's SQL Explorer
shows a double listing of all tables in each ODBC alias.

Surely this is an ODBC driver issue, but I can't find any documentation to
help. Any ideas? TIA.
Back to top
Joe Harbin
Guest





PostPosted: Thu Feb 24, 2005 8:29 pm    Post subject: Re: SQL Explorer shows "double" tables Reply with quote

Ted, yes, we recently installed an iSeries Client Access upgrade. Do you know where I can find info on the "double table" problem? TIA.

"Ted Reilly" <it@brake-eng.com> wrote:
Quote:
Might be you've installed iSeries Client Access? There are issues with
this.

Ted
Back to top
Joe Harbin
Guest





PostPosted: Fri Feb 25, 2005 9:12 pm    Post subject: Re: SQL Explorer shows "double" tables Reply with quote

Found solution by installing latest service pack patch from IBM. Previous version had an ODBC driver problem.
Back to top
Display posts from previous:   
Post new topic   Reply to topic    BorlandTalk.com Forum Index -> Delphi As400 All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2006 phpBB Group
SEO toolkit © 2004-2006 webmedic.