Newbie question - looking for something like Interactive SQL 2

[Jacque]

I've just started using DB2 and would like to know if there is a command line query component like ISQL? I've found the command center and SQL Assist but I find them too slow and cumbersome, although this may just be due to the learning curve. I prefer to manually enter my queries and be able to hot key the execute command instead of having to use my mouse to click the execute button.

Also, any recommendations for a good DB2 reference book?

Thanks! Any help would be appreciated.
Cheers & TGIF!
Jacque

 

[MarcLodge]

Jacque,
there are many good db2 reference books out there, but it depends on what platform and language environment is going to be your main point fo call. It would be no good me recommending you a top tome for Cobol and OS/390 is you're going to be using Java and Oracle (or whatever). Also, sadly, the version of db2 plays a part also.
Let us know what you details are, and I'm sure you will get many further replies.
Marc

 

[sathyarams]

I quiet like WinSQL , which is a free download at

http://www.synametrics.com/

BTW, you are not alone in thinking that DB2's graphical tools are buggy ...

Sathyaram

More DB2 questions answered at

http://www.dbforums.com/f8

 

[gregsimpson]

Jacque,

the equivalent on a UNIX box of ISQL is quite simply db2. Entering db2 will give you a similar prompt and functionality comparable to isql.

Cheers
Greg

 

[Jacque]

Hi guys!

Marc,
Is this enough for a good recommendation.
Windows 2000 & XP
C #
DB2 v8.1.2.169

Sathyaram,
Thanks, I'll check WinSQL out.

Greg,
I wish I still had access to a UNIX box.

Cheers,
Jacque

 

[MarcLodge]

Jacque,
I read a write up a while ago of 'DB2 Universal Database V8 for Linux, Unix, and Windows: Database Administration Certification Guide' which rated it reasonably highly. On searching for it on Amazon, I found that Sathyarams has written a write up there on it, so may be able to give more info.
For the amazon listing see here:

http://www.amazon.co.uk/exec/obidos...54648/sr=1-2/ref=sr_1_0_2/026-0396627-1021210

 

[Jacque]

Thanks Marc,
That book sounds right up my alley, I'll check it out at my local bookstore.

Sathyaram,
Thanks for the review.

Cheers
Jacque

 

[gregsimpson]

Jacque,

what platofrm are you now running on?

Cheers
Greg

 

[gregsimpson]

Jacque,

what platform are you now running on?

Cheers
Greg

 

[Jacque]

Hi Greg,
Sorry for the delay - Windows for Intel.

Sathyaram,
Thanks for the tip on WinSQL,
Jacque

 

[gregsimpson]

Jacque,

Windows and all version of UDB contain the Command Line Processor(CLP). It is a text based application which is used to execute SQL statements and DB2 commands. You can create a database, catalog a database and issue dynamic SQL commands ffrom the CLP, if you don't wish yo use the DB2 Command Center graphical interface.

All SQL statements issued from the CLP are dynamically prepared and executed on the database server. The output, or result, of the SQL query is displayed on the screen by default.

Therefore as your on a windows platform simply entering

db2

should do what you require and bring up the CLP.

Cheers
Greg