By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,364 Members | 1,645 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,364 IT Pros & Developers. It's quick & easy.

More than 254 chars in text DB2 client

P: n/a
GB
For various connectivity reasons to my employer's network, I
frequently find myself using the telnet-based DB2 client for Sun.
Unfortunately, on this client:

- The return key submits an SQL query
- Input length for a single line is limited to 254 characters

Does anyone know a way to enter more than 254 characters or to
indicate that the input continues to the next line?

Thanks,

Gary
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Ian
GB wrote:
For various connectivity reasons to my employer's network, I
frequently find myself using the telnet-based DB2 client for Sun.
Unfortunately, on this client:

- The return key submits an SQL query
- Input length for a single line is limited to 254 characters

Does anyone know a way to enter more than 254 characters or to
indicate that the input continues to the next line?


Use "db2 -t" which sets the statement terminator to a semi-colon.
Example:
db2inst1@server $ db2 -t
(c) Copyright IBM Corporation 1993,2002
Command Line Processor for DB2 SDK 8.1.4

You can issue database manager commands and SQL statements from the command
prompt. For example:
db2 => connect to sample
db2 => bind sample.bnd

For general help, type: ?.
For command help, type: ? command, where command can be
the first few keywords of a database manager command. For example:
? CATALOG DATABASE for help on the CATALOG DATABASE command
? CATALOG for help on all of the CATALOG commands.

To exit db2 interactive mode, type QUIT at the command prompt. Outside
interactive mode, all commands must be prefixed with 'db2'.
To list the current command option settings, type LIST COMMAND OPTIONS.

For more detailed help, refer to the Online Reference Manual.

db2 => connect to sample;

Database Connection Information

Database server = DB2/SUN 8.1.4
SQL authorization ID = IANBJOR
Local database alias = SAMPLE

db2 => select
db2 (cont.) => count(*)
db2 (cont.) => from
db2 (cont.) => syscat.tables
db2 (cont.) => ;

1
-----------
261

1 record(s) selected.

db2 =>


-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.