[Info-ingres] COPY command support

[Karl Schendel]

I suspect that the issue is running via DBI.  COPY depends on a very tight
coupling between server and client, and requires a lot of client side support.
It's really only supported from LIBQ (ie, embedded SQL library), although
with enough code one can make it work via the OpenAPI as well.

I don't know what DBI uses but it's probably impractical to implement a COPY
with it.  The best bet is to run select retrievals and do a bit of formatting
once the rows come out of dbi.

Karl


> On Mar 8, 2016, at 6:39 PM, pwhite peercore <pwhite at peercore.com.au> wrote:
> 
> Hi Saumya,
> 
> What operating system are you running?
> 
> The copy statement was working fine in Ingres 2.0
> 
> Please try running copydb from the operating system command prompt.
> 
> 	copydb mydb mytable
> or
> 	copydb -c mydb mytable
> 
> This generates two files copy.in and copy.out which you then use to import
> and export data from the database.
> Both copy.in and copy.out contain examples of the copy statement.
> 
> See simple example here:
> http://en.allexperts.com/q/Ingres-3317/Ingres-flat-files-unix.htm
> 
> Paul
> 
> 
> 
> -----Original Message-----
> From: info-ingres-bounces at lists.planetingres.org
> [mailto:info-ingres-bounces at lists.planetingres.org] On Behalf Of saumya
> saxena
> Sent: Wednesday, 9 March 2016 12:56 AM
> To: info-ingres at lists.planetingres.org
> Subject: [Info-ingres] COPY command support
> 
> Hi experts,
> 
> I'm using ingresdbi2.0 for executing queries. I have a requirement of
> executing COPY command to dump the table data to flat file. But found there
> is no support for it, please advice what can be done for it ?
> 
> Thanks,
> Saumya 
> _______________________________________________
> Info-ingres mailing list
> Info-ingres at lists.planetingres.org
> http://lists.planetingres.org/mailman/listinfo/info-ingres
> 
> _______________________________________________
> Info-ingres mailing list
> Info-ingres at lists.planetingres.org
> http://lists.planetingres.org/mailman/listinfo/info-ingres