SQL commands in C-code ????

[Paul Murray]

Gurus,

I am trying to write a small C program which will perform sqlplus "select" and "insert" commands.

Does anyone know of a reference site (pref. with examples) on how to accomplish this as simply as possible ??

As you probably have ascertained -- I am totally new to C-programming, so no laughing please !! :-)


Cheers in advance,
PaulM.

PS -- OS = HPUXv11, N/L-Class Servers.

[Dan Hetzel]

Hi Paul,

Here is a nice URL to start with.
You'll find plenty of links to tutorials ans examples for embedded SQL.

http://cplus.about.com/compute/cplus/msub10.htm

Best regards,

[Andreas Voss · Accepted solution]

Hi,

if you want to get stdout from sqlplus you can use the popen() call ie:

#include

main()
{
char cmd[1024];
char linebuf[1024];
FILE *fp;

sprintf(cmd, "sqlpus ......");
fp = popen(cmd, "r");
while(fgets(linebuf, sizeof(linebuf), fp) != NULL)
{
/* do what ever you will do with the data */
}
pclose(fp);
}

Regards