Re: Extracting SQL from Export files

From: Steve Adams <steveadams_at_acslink.net.au>
Date: 1997/06/24
Message-ID: <33b00cac.2662104@nntp.peg.apc.org>#1/1

Mike,

>>For the tables and indexes i can use the 'indexfile' option of import,
>>but how can
>>i extract other sql statements form an export file or from the database?
>>(i have tried exporting with show=y to a logfile but the file needs
>>substantial editing).
>>The database version is 7.3.2.3 running on Seqent. Please help!

I use the unix strings(1) command, which gives the sql statements one per line, but without the messy " characters everywhere.

HTH, Steve Adams Received on Tue Jun 24 1997 - 00:00:00 CDT