HPE Community
Operating System - HP-UX
1753725 Members
4644 Online
108799 Solutions
New Discussion

allbase/isql

 
srinivas_6
Occasional Contributor

‎03-20-2001 06:18 PM

‎03-20-2001 06:18 PM

allbase/isql

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
allbase / isql problem
0 Kudos
Reply
1 REPLY 1
Jesper Sivertsen
Frequent Advisor

‎03-27-2001 11:27 PM

‎03-27-2001 11:27 PM

Re: allbase/isql

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
All in unix is files
0 Kudos
Reply
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.