Using SQL in application programming

Affiliates: 1 $how to earn
Pay with:
i agree with "Terms for Customers"
Sold: 1 last one 22.01.2009
Refunds: 0

Uploaded: 05.11.2007
Content: sql_3c.rar 50,5 kB
Loyalty discount! If the total amount of your purchases from the seller Eugene Marsakov more than:
30 $the discount is35%
20 $the discount is20%
If you want to know your discount rate, please provide your email:

Description

TABLE OF CONTENTS


Введение…………………………………………………………………………...4
1 Overview of the built-in SQL ............................................................... ... 7
1.1 Executing SQL DBMS ............................................. 9
2 Basic concepts of embedded SQL .......................................... ... 12
2.1 Compiling programs with built-in SQL ................................. ..13
2.2 Implementation of the program with built-in SQL ................................. ..16
2.2.1 Data protection during .......................................... 17
2.2.2 Automatic reflow ............................................. ... 18
3 Simple instructions embedded SQL .......................................... ... 20
3.1 Ads tables .................................................................. ..21
3.2 Ads errors .................................................................. 22
3.2.1 The variable SQLCODE ............................................................ 23
3.2.2 Variable SQLSTATE ......................................................... ..24
3.2.3 Instructions WHENEVER ......................................................... 26
3.3 Use of the basic variables ............................................. 28
3.3.1 Announcement of basic variables ............................................. ... 28
3.3.2 Basic variables and data types .......................................... ..30
3.3.3 Basic variables and values \u200b\u200bNULL ....................................... .31
4 The sample data from the built-in SQL ................................. ..34
4.1 queries that return a single record .......................................... ... 35
4.1.1 Error retrieving records ................................................ 36
4.1.2 Sample values \u200b\u200bNULL ......................................................... .37
4.1.3 Sample data from the use of structures ................................. ..39
4.1.4 Input and output host variables ................................. ... 40
4.2 requests that return a set of records ....................................... ... 41
4.2.1 Cursors .............................................................................. .42
4.2.1.1 Instructions DECLARE CURSOR .......................................... .... 42
4.2.1.2 Instructions OPEN ............................................................... .44
4.2.1.3 Instructions FETCH ............................................................ ... 45
4.2.1.4 Instructions CLOSE ............................................................ ... 47
4.2.2 Cursors random access .......................................... ... 47
5 Remove and update data using cursors .................. 50
6 cursors and transaction processing ................................................... .54
Заключение……………………………………………………………………….56
Bibliographic list ............................................................ ..58
Приложения……………………………………………………………………...59

Feedback

0
No feedback yet.
Period
1 month 3 months 12 months
0 0 0
0 0 0
In order to counter copyright infringement and property rights, we ask you to immediately inform us at support@plati.market the fact of such violations and to provide us with reliable information confirming your copyrights or rights of ownership. Email must contain your contact information (name, phone number, etc.)