Embedded SQL for C and SQL Server
Table of contents
-
Programming Embedded SQL for C
- Getting Started with Embedded SQL for C
- Call-level Method
- Embedded SQL Method
- Embedded SQL Programming
- Embedded SQL Steps
- Including Embedded SQL Statements
- Connecting to a Database
- Using Static and Dynamic Statements
- Using Host Variables
- Using Cursors
- Managing Transactions
- Using the SQLCA Data Structure
- Embedded SQL for C Reference
-
Embedded SQL Statements
- BEGIN DECLARE SECTION
- CLOSE
- CONNECT TO
- DECLARE CURSOR
- DELETE (POSITIONED)
- DELETE (SEARCHED)
- DESCRIBE
- DISCONNECT
- END DECLARE SECTION
- EXECUTE
- EXECUTE IMMEDIATE
- FETCH
- GET CONNECTION
- OPEN
- PREPARE
- SELECT INTO
- SET ANSI_DEFAULTS
- SET CONCURRENCY
- SET CONNECTION
- SET CURSOR_CLOSE_ON_COMMIT
- SET CURSORTYPE
- SET FETCHBUFFER
- SET OPTION
- SET SCROLLOPTION
- UPDATE
- UPDATE (Searched)
- WHENEVER
- Building Applications
- Steps for Building an Application
- Embedded SQL Applications at Run Time
- Processing Embedded SQL Statements
- Access Plans and Bind Files
- Running the nsqlprep Precompiler
- Compiling and Linking Embedded SQL Applications
- Debugging Embedded SQL Programs
- Advanced Programming
- Data Type Mapping for Embedded SQL
- Selectively Bypassing the Creation of Access Plans
- Defining Cursors
- Embedded SQL for C Samples