More than 254 chars in text DB2 client

[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

[Ian]

Re: More than 254 chars in text DB2 client

GB wrote:[color=blue]
> 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?[/color]

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! =-----