Вся предоставленная на этом сервере информация собрана нами из разных источников. Если Вам кажется, что публикация каких-то документов нарушает чьи-либо авторские права, сообщите нам об этом.
You write your program in C with some
special SQL things.
For declaring variables that can be used in
SQL statements you need to
put them in a special declare section.
You use a special syntax for the SQL queries.
Before compiling you run the file through
the embedded SQLC
preprocessor and it converts the SQL statements you used
to function
calls with the variables used as arguments. Both variables that are used
as input to the SQL statements and variables that will
contain the
result are passed.
Then you compile and at link time you link with a special library that
contains the functions used. These functions (actually it is mostly one
single function) fetches the information from the arguments, performs
the SQL query using the ordinary interface
(libpq) and puts back
the result in the arguments dedicated for output.
Then you run your program and when the control arrives to
the SQL
statement the SQL statement is performed against
the database and you
can continue with the result.
