Stack Overflow
Stack Overflow

Questions tagged [embedded-sql]

Embedded SQL is the term used for a method of inlining SQL statements with the source code of another programming language, called host language.

Embedded SQL is the term used for a method of inlining SQL statements with the source code of another programming language, called host language.

Examples of embedded SQL are:

112 questions
0
votes
2 answers

How can implement a procedure in ESQL (an internal procedure) from Oracle database

I create a store procedure in Oracle db that insert Customer to my Table this is my code : CREATE OR REPLACE PROCEDURE THP.INSERT_CUSTOMER( P_CUSTNAME IN VARCHAR2, P_CUSTLAST IN VARCHAR2, P_CUSTFATHER …
Sina Zeinali
  • 15
  • 2
  • 11
0
votes
0 answers

Configuring MySql server in my C project

I have a problem where I need to include a MYSQL-server into my C Project (VS 2008). The program uses a built-in library from other software which tries to collect and stores some part of data. I have searched the internet for Embedded SQL and I end…
DOOM
  • 1,170
  • 6
  • 20
0
votes
1 answer

WMB: In ESQL, is it possible to connect to a datasource defined as a JDBCProvider configurable service in lieu of ODBC DSN?

I'm inheriting an existing WMB flow that is ESQL-centric (Compute nodes) that accesses its database via an ODBC DSN. I'd prefer to use a configurable service for database access in lieu of an ODBC DSN, which is what I use with Java-centric flows…
bug11
  • 366
  • 3
  • 15
0
votes
1 answer

Insert array with PostgreSQL ECPG

I am using ECPG with PostgreSQL 8.4. I have a function which takes a struct containing pointers to a couple of dynamically allocated, "null"-terminated arrays of integers (I have defined null in this case to be -1, as there is no need for negative…
Edward
  • 1,786
  • 1
  • 15
  • 33
-1
votes
1 answer

Embedded SQL in Dev C++

So I have this sample C++ program I got from IBM (How to connect and disconnect from a database) in Embedded SQL section (see: http://www.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.apdv.samptop.doc/doc/r0011556.html) Im using Dev…
HanSoloQue
  • 19
  • 4
-2
votes
1 answer

How to display constraint using ESQL/C?

I have to output the constraint in my PostgreSQL using ESQL/C that I have set before directly with SQL. Below is the constraint I need to print out. ALTER TABLE p ADD CONSTRAINT check_name_of_det CHECK ((name = 'Screw' AND n_det = 'P6') OR n_det…
karver35
  • 31
  • 1
  • 7
-2
votes
1 answer

embedded sql in c,how to check if records exist

I have tried these: 1.if (EXEC SQL EXIST SELECT ...) 2.EXEC SQL IF EXIST SELECT ... but none of these work,any help?
Tee
  • 91
  • 2
  • 9
1 2 3 4 5 6 7
8