[Openroad-users] Importing data - Copy statement

[gareth.2.edwards at bt.com]

Interesting. We're currently on 2 (and *cough* 6.4), but this code will
be running on Ingres 2006. 

Can the assistant be called programatically from OpenROAD? 


Cheers,
Gareth Edwards

BT Global Services 
tel: +44 (0)131 345 4671 
email: gareth.2.edwards at bt.com

-----Original Message-----
From: openroad-users-bounces at peerlessit.com
[mailto:openroad-users-bounces at peerlessit.com] On Behalf Of Durwin
Wright
Sent: Thursday, November 02, 2006 3:31 PM
To: 'International OpenROAD Users'
Subject: Re: [Openroad-users] Importing data - Copy statement

You may want to try the Ingres Import Assistant.  This was introduced in
Ingres 2.6 and was improved in Ingres 2006.  It is similar to the Import
Assistant that Microsoft provides for Access.

Durwin Wright | Sr. Architect | Durwin.Wright at ingres.com | Ingres | 500
Arguello Street | Suite 200 | Redwood City | CA | 94063 | USA  +1
650-587-5523 | fax: +1 650-587-5550 

-----Original Message-----
From: openroad-users-bounces at peerlessit.com
[mailto:openroad-users-bounces at peerlessit.com] On Behalf Of
gareth.2.edwards at bt.com
Sent: Thursday, November 02, 2006 7:12 AM
To: openroad-users at peerlessit.com
Subject: Re: [Openroad-users] Importing data - Copy statement

I've downloaded Sed for windows, so I'll have a play with that, which
should help with formatting prior to the copy.


Cheers,
Gareth Edwards

BT Global Services
tel: +44 (0)131 345 4671
email: gareth.2.edwards at bt.com

-----Original Message-----
From: openroad-users-bounces at peerlessit.com
[mailto:openroad-users-bounces at peerlessit.com] On Behalf Of
gareth.2.edwards at bt.com
Sent: Thursday, November 02, 2006 3:03 PM
To: openroad-users at peerlessit.com
Subject: Re: [Openroad-users] Importing data - Copy statement

I feared as much, thanks for the response Karl. 

As a complete stab in the dark, is there such a thing as VIM scripts?,
that I could possibly execute one of those against the file, to do the
substitutions?


Cheers,
Gareth Edwards

BT Global Services
tel: +44 (0)131 345 4671
email: gareth.2.edwards at bt.com

-----Original Message-----
From: openroad-users-bounces at peerlessit.com
[mailto:openroad-users-bounces at peerlessit.com] On Behalf Of Karl & Betty
Schendel
Sent: Thursday, November 02, 2006 1:49 PM
To: International OpenROAD Users
Subject: Re: [Openroad-users] Importing data - Copy statement

At 10:55 AM +0000 11/2/06, <gareth.2.edwards at bt.com> wrote:
>OR4.1, Win2000
>
>Hi All,
>
>Having not done much with the copy statement previously, I'm a litle
lost.
>
>I have to import some data, the two formats available are:
>
>1) Comma seperated, but every data value is in "quotes"
>2) Tab delimited, money values greater than 999 are in "quotes" and 
>also contain a comma to break the thousand/hundred value
>
>Are there any ways to deal with these imports? In particular the quoted
values??

There's no nice way to do it with copy.  The copy statement doesn't
really understand quoted values.  If you were running on a real OS I
would have suggested going with the tabbed form, and using something
like sed to strip out the quotes and commas.
Unless you have an equivalent tool for windows available (e.g. sed in
cygwin32), I'd say that your idea of reading the moneys into varchars
and working with them there is probably best.

Karl
_______________________________________________
Openroad-users mailing list
Openroad-users at peerlessit.com
http://peerlessit.com/mailman/listinfo/openroad-users



_______________________________________________
Openroad-users mailing list
Openroad-users at peerlessit.com
http://peerlessit.com/mailman/listinfo/openroad-users



_______________________________________________
Openroad-users mailing list
Openroad-users at peerlessit.com
http://peerlessit.com/mailman/listinfo/openroad-users

_______________________________________________
Openroad-users mailing list
Openroad-users at peerlessit.com
http://peerlessit.com/mailman/listinfo/openroad-users