I've got your meaning from your first mail.
What you do with ij prompt is also under the help
of the classes in package org.apache.derby.impl.tools.ij,
so I think it may be a way to write come C program to
call the codes in that package. But I haven't done that before.

And I think Thomas Nielsen's answer is pretty helpful.

2007/6/14, yarono < yarono@il.ibm.com>:

What I'm trying to do is to create DB's and shut them down - all from my code
in c.

My current status is that I'm able to perform the above functions (meaning
create DB and shutdown) via the ij prompt, run my code to perform table
creation, insertions, etc.. The shutdown and creation of the db's is done
through the ij prompt, while the rest of my code is in c.

I want the whole thing to be done in c.

Thomas Nielsen - Sun Microsystems - Trondheim, Norway wrote:
> hi yarono,
> What exactly do you want to do?
> - fork a new process to run ij (with or without a SQL script)?
> - execute SQL commands from C?
> If you are trying to fork a new process running ij, then please refer to
> a suitable OS programmers guide on how to do this.
> If you are trying to execute SQL in C, then you're looking for a ODBC
> driver. Derby does not come with a (free) ODBC driver, so your options
> are to buy a (DRDA capable) ODBC driver, or use a ODBC-JDBC bridge
> driver with the Derby JDBC driver. Not aware of any free ODBC-JDBC
> bridge drivers off the top of my head if free is what you are looking for.
> Hope this helps :)
> Cheers,
> Thomas
> yarono wrote:
>> Is there a way to run the 'ij commands' in my code (written in c), just
>> as I
>> execute SQL statements?
> --
> Thomas Nielsen

View this message in context: http://www.nabble.com/running-ij-commands-from-a-code-in-c-tf3897645.html#a11116070
Sent from the Apache Derby Users mailing list archive at Nabble.com.