[Openroad-users] unsubscribe

[rwright at bcs.org.uk]

Quoting Durwin Wright <durwin.wright at ingres.com>:

> I do not know if it can be called from OpenROAD.  I recall a VDBA project
> where they were going to expose a number of VDBA components as ActiveX
> controls.
>
> I will try to find out if it can be called from OpenROAD.  Conceptually, it
> uses COPY TABLE to import and export the data.  It is essentially a wizard
> written in MFC, yuck :-( that uses Ingres Embedded SQL/C to access the LIBQ
> component.  There is no reason that the same technique could not be
> replicated using OpenROAD.
>
> COPY TABLE is implemented by the LIBQ component of the Ingres Front Ends.
> The OpenROAD runtime sits directly on top of LIBQ and has access to the same
> functionality.  Maybe someone has written something in OpenROAD already that
> does this and they are willing to share.
>
> This is the type of project that could become an eventually OpenROAD
> community project.
>
> 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:43 AM
> To: openroad-users at peerlessit.com
> Subject: Re: [Openroad-users] Importing data - Copy statement
>
> 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
>
>
>
> _______________________________________________
> 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
>