260 likes | 401 Views
Figure 10.1 Fragment of an embedded SQL program written in C. Figure 10.2 Adding some status processing. Figure 10.3A The use of connection and transaction statements in a C program with embedded SQL statements whose purpose is to deregister a student from a course. (continued on next slide).
E N D
Figure 10.1Fragment of an embedded SQL program written in C.
Figure 10.3AThe use of connection and transaction statements in a C program with embedded SQL statements whose purpose is to deregister a student from a course. (continued on next slide)
Figure 10.3B (continued)The use of connection and transaction statements in a C program with embedded SQL statements whose purpose is to deregister a student from a course. (continued on next slide)
Figure 10.3C (continued)The use of connection and transaction statements in a C program with embedded SQL statements whose purpose is to deregister a student from a course.
Figure 10.4AUsing cursors. (continued on next slide)
Figure 10.6A Using a cursor to scan a table. (continued on next slide)
Figure 10.7AA stored procedure that deregisters a student from a course. (continued on next slide)
Figure 10.7B (continued)A stored procedure that deregisters a student from a course. (continued on next slide)
Figure 10.7C (continued)A stored procedure that deregisters a student from a course.
Figure 10.8AExample of using GET DESCRIPTOR. (continued on next slide)
Figure 10.11AFragment of JDBC program using a cursor. (continued on next slide)
Figure 10.11B (continued)Fragment of JDBC program using a cursor.
Figure 10.12A A fragment of a Java program using JDBC. (continued on next slide)
Figure 10.12B (continued)A fragment of a Java program using JDBC. (continued on next slide)
Figure 10.12C (continued)A fragment of a Java program using JDBC.
Figure 10.14Skeleton of procedure calls needed for ODBC in a C program.
Figure 10.15Effect of using a KEYSET_DRIVEN cursor to retrieve records from Transcript.