topic Re: allbase/isql in Operating System - HP-UX

allbase/isql

srinivas_6 — Wed, 21 Mar 2001 02:18:33 GMT

Hi,
If i want to store the entire output of any sql
query in to an output file(say select * from table; ), how can i do ?
i am using allbase/isql with hp-9000 server.
also if i wants to check the length of a perticuler column in a table , how can i do ?
Please guide me .

Thanks in advance

SRINIVAS

Re: allbase/isql

Jesper Sivertsen — Wed, 28 Mar 2001 07:27:55 GMT

Hi there

To get column definition on a table use:
isql> info

To save the contents of a table into a file use:
isql> unload
Then isql wil ask you the right questions !

You can find the documentation of isql on http://docs.hp.com

God luck
Jesper