[Openroad-users] Removing copy statements from copy.in

[Chris Wallace]

Gareth,
 
I'm out of the office at present, but I did create an awk script (from back in the 6.n days) that creates separate TABLE, INDEX, COPY, MODIFY, GRANT and I think OTHER.sql scripts from a copy.in.  You could modify this script to just extract the COPY statements and it'd place everything in the OTHER.sql.
 
I'll sent it to you when I'm back in the office (probably 1-2 hours).
 
Regards
Chris Wallace
General Manager
Management Information Systems (WA) Pty Ltd
Level 9, Ingres House
231 Adelaide Terrace, PERTH  WA  6000
Ph: (618) 9221-9221  Fax: (618) 9221-9224
Email: chris.wallace at ingres.com <mailto:chris.wallace at ingres.com> 
Web: http://www.miswa.com.au

________________________________

From: openroad-users-bounces at peerlessit.com on behalf of gareth.2.edwards at bt.com
Sent: Thu 6/26/2008 9:23 PM
To: openroad-users at peerlessit.com
Subject: [Openroad-users] Removing copy statements from copy.in



Hi,

Anyone have a script to remove the copy statements from the copy.in?

I want to just create all the tables/indexes etc, but don't want the
copy statements. My nawk/awk is rusty.

Cheers,
Gareth Edwards

BT Global Services
t: +44 (0)131 300 1907
e: Gareth.2.Edwards at BT.com

________________________________________________________________
OpenROAD-Users mailing list

You can maintain your subscription here:
http://www.peerlessit.com/mailman/listinfo/openroad-users

To unsubscribe click on this link
mailto:openroad-users-unsubscribe at peerlessit.com&subject=unsubscribe

To subscribe click on this link
mailto:openroad-users-subscribe at peerlessit.com&subject=subscribe


-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/ms-tnef
Size: 6303 bytes
Desc: not available
Url : http://www.peerlessit.com/pipermail/openroad-users/attachments/20080626/2e8040b4/attachment.bin