• 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)

    Available format(s):  Hardcopy, PDF

    Language(s):  English

    Published date:  15-09-1999

    Publisher:  British Standards Institution

    Add To Cart

    Table of Contents - (Show below) - (Hide below)

    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

    Abstract - (Show below) - (Hide below)

    Covers the concept of a SCQL database (SCQL = Structured Card Query Language based on SCQL, see ISO 9075) and the relative interindustry enhanced commands.

    Scope - (Show below) - (Hide below)

    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.

    General Product Information - (Show below) - (Hide below)

    Committee IST/17
    Development Note Supersedes 97/641650 DC (05/2005)
    Document Type Standard
    Publisher British Standards Institution
    Status Current
    Supersedes

    Standards Referencing This Book - (Show below) - (Hide below)

    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, flexibile and cost effective