On Tue, 2007-04-24 at 15:33 +0200, Rolf Theisinger wrote: > Hello ingres users, > > I am trying to copy a table to a file, but this does not work. > > This is my code: > // Query database > // queryText: "copy table myTable() into '/tmp/filename'" > IIapi_query(&queryParm); <snip>
the syntax for copy into/from within OpenAPI is: copy table myTable() into program copy table myTable() from program > This works fine, except that I get no output file. > If I use the sql terminal, everything works as expected and I get > an very nice table copy. > > So, can someone please explain me, what I have to do to make > this work with OpenAPI? Have a look at $II_SYSTEM/ingres/demo/api/apiscopy.c for an example copy into/from OpenAPI program regards grant -- Grant Croker, [EMAIL PROTECTED] Software Engineer, Ingres - http://ingres.com tel: +44 (0)1753 559505 UK / +34 676 518209 España _______________________________________________ Users mailing list [email protected] http://lists.ingres.com/mailman/listinfo/users
