Re: Porting over to Third Partry Product
>
> > minh@wpi.edu (Minh Pham) writes:
> > how do I convert all of the Database over to an ANSCII raw data
> > format?
>
> Try to start isql and execute something like the following:
>
> unload to 'filename'
> select * from tablename>
> You get fields delimited with |
> If you want another delimiter use:
>
> unload to 'filename' delimiter 'x'
> select * from tablename>
Helps if you have the table names:
{foo.sql}
OUTPUT TO tmp.sql WITHOUT HEADINGS
SELECT "unload to ", tabname, ".unl delimiter 'x' select * from ", tabname
FROM systables
WHERE tabid > 99
# from the os
isql database foo.sql
isql database tmp.sql
tho I still prefer dbexport.
cheers
j.
_____________________________________________________________________________
Jack Parker - Hewlett Packard, DMD/IS Boise, Idaho, USA
jparker@hpbs3645.boi.hp.com Back in Boise
_____________________________________________________________________________
If anything can go wrong, fix it. To hell with Murphy.
_____________________________________________________________________________
Any opinions expressed herein are my own and not those of my employers.
_____________________________________________________________________________