INCITS/ISO/IEC 7816-7 : 1999 : R2005
Superseded
A superseded Standard is one, which is fully replaced by another Standard, which is a new edition of the same Standard.
View Superseded by
IDENTIFICATION CARDS - INTEGRATED CIRCUIT(S) CARDS WITH CONTACTS - PART 7: INTERINDUSTRY COMMANDS FOR STRUCTURED CARD QUERY LANGUAGE (SCQL)
Hardcopy , PDF
17-02-2020
English
01-01-2005
Important note : Users cannot be edited or removed once added to your Multi user PDF.
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
Describes the concept of a SCQL database (SCQL = Structured Card Query Language based on SQL, see ISO 9075) and the related interindustry enhanced commands.
| DocumentType |
Standard
|
| Pages |
44
|
| ProductNote |
Reconfirmed 2005
|
| PublisherName |
Information Technology Industry Council
|
| Status |
Superseded
|
| SupersededBy | |
| Supersedes |
| 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.