Statements (49)
| Predicate | Object |
|---|---|
| gptkbp:instanceOf |
programming technique
|
| gptkbp:commonIn |
enterprise applications
legacy systems |
| gptkbp:contrastsWith |
dynamic SQL
|
| gptkbp:enables |
database access
cursor management SQL error diagnostics SQL queries in code SQL statements in procedural code batch processing of SQL statements commit and rollback operations compile-time SQL checking database independence in code error code handling via SQLCODE or SQLSTATE fetching query results into variables integration of business logic and data access parameter passing between SQL and host language static SQL execution transaction demarcation in code |
| gptkbp:firstAppearance |
1970s
|
| gptkbp:host_languages_include |
gptkb:COBOL
gptkb:Java gptkb:Ada gptkb:Fortran gptkb:PL/I gptkb:Pascal C |
| https://www.w3.org/2000/01/rdf-schema#label |
embedded SQL
|
| gptkbp:integration |
SQL statements
host programming languages |
| gptkbp:relatedTo |
dynamic SQL
host variables |
| gptkbp:requires |
precompiler
SQL preprocessor host variable declaration |
| gptkbp:standardizedBy |
gptkb:ISO
gptkb:ANSI |
| gptkbp:supports |
gptkb:Oracle
gptkb:MySQL gptkb:Microsoft_SQL_Server gptkb:PostgreSQL gptkb:IBM_DB2 |
| gptkbp:used_in |
application programs
|
| gptkbp:usedFor |
error handling
data manipulation data definition transaction control |
| gptkbp:bfsParent |
gptkb:ObjectScript
|
| gptkbp:bfsLayer |
7
|