BS ISO/IEC 7816-7:1999
Current
The latest, up-to-date edition.
Identification cards. Integrated circuit(s) cards with contacts Interindustry commands for structured cards query language (SCQL)
Hardcopy , PDF
English
15-09-1999
Important note : All end users must be registered with an Account prior to user licenses being assigned.
1 Scope
2 Normative references
3 Terms and definitions
4 Symbols (and abbreviated terms)
5 SCQL database concept
5.1 SCQL database
5.2 SCQL tables
5.3 SCQL views
5.4 SCQL system tables and dictionaries
5.5 SCQL user profiles
6 SCQL related commands
6.1 General aspects
6.2 Grouping and encoding of commands
6.3 Notation and special codings
6.4 Status bytes
6.5 Coding of identifiers
6.6 Security attributes of tables, views and users
6.7 Linking user ids to INSERT and UPDATE operations
7 Database operations
7.1 CREATE TABLE
7.2 CREATE VIEW
7.3 CREATE DICTIONARY
7.4 DROP TABLE
7.5 DROP VIEW
7.6 GRANT
7.7 REVOKE
7.8 DECLARE CURSOR
7.9 OPEN
7.10 NEXT
7.11 FETCH
7.12 FETCH NEXT
7.13 INSERT
7.14 UPDATE
7.15 DELETE
8 Transaction management
8.1 General concept
8.2 Transaction operations
9 User management
9.1 General concept
9.2 User operations
Annex A (informative) Usage of SCQL operations
Covers the concept of a SCQL database (SCQL = Structured Card Query Language based on SCQL, see ISO 9075) and the relative interindustry enhanced commands.
| Committee |
IST/17
|
| DevelopmentNote |
Supersedes 97/641650 DC (05/2005)
|
| DocumentType |
Standard
|
| Pages |
46
|
| PublisherName |
British Standards Institution
|
| Status |
Current
|
| Supersedes |
This part of ISO/IEC7816 specifies
-
the concept of a SCQL database (SCQL=Structured Card Query Language based on SQL, see ISO9075) and
-
the related interindustry enhanced commands.
| Standards | Relationship |
| ISO/IEC 7816-7:1999 | Identical |
| ISO/IEC 7816-6:2016 | Identification cards — Integrated circuit cards — Part 6: Interindustry data elements for interchange |
| ISO/IEC 9075:1992 | Information technology — Database languages — SQL |
| ISO/IEC 7816-4:2013 | Identification cards Integrated circuit cards Part 4: Organization, security and commands for interchange |
Access your standards online with a subscription
Features
-
Simple online access to standards, technical information and regulations.
-
Critical updates of standards and customisable alerts and notifications.
-
Multi-user online standards collection: secure, flexible and cost effective.