• INCITS/ISO/IEC 7816-7 : 1999

    Superseded A superseded Standard is one, which is fully replaced by another Standard, which is a new edition of the same Standard.

    IDENTIFICATION CARDS - INTEGRATED CIRCUIT(S) CARDS WITH CONTACTS - PART 7: INTERINDUSTRY COMMANDS FOR STRUCTURED CARD QUERY LANGUAGE (SCQL)

    Available format(s):  Hardcopy, PDF

    Superseded date:  17-02-2020

    Language(s):  English

    Published date:  01-01-2005

    Publisher:  Information Technology Industry Council

    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)

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

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

    Document Type Standard
    Product Note Reconfirmed 1999
    Publisher Information Technology Industry Council
    Status Superseded

    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