1、 National Standard of CanadaCAN/CSA-ISO/IEC 7816-7:02(ISO/IEC 7816-7:1999)International Standard ISO/IEC 7816-7:1999 (first edition, 1999-03-01), has been adopted without modification(IDT) as CSA Standard CAN/CSA-ISO/IEC 7816-7:02, which has been approved as a National Standard of Canadaby the Stand
2、ards Council of Canada.ISBN 1-55324-731-0 March 2002Identification cards Integrated circuit(s)cards with contacts Part 7:Interindustry commands for Structured CardQuery Language (SCQL)Cartes didentification Cartes circuit(s) intgr(s) contacts Partie 7: Commandes intersectorielles pour langage dinter
3、rogation de cartestructure (SCQL)Reference numberISO/IEC 7816-7:1999(E)The Canadian Standards Association (CSA), The Standards Council of Canada is theunder whose auspices this National Standard has been coordinating body of the National Standards system, produced, was chartered in 1919 and accredit
4、ed by a federation of independent, autonomousthe Standards Council of Canada to the National organizations working towards the furtherStandards system in 1973. It is a not-for-profit, development and improvement of voluntarynonstatutory, voluntary membership association standardization in the nation
5、al interest.engaged in standards development and certification The principal objects of the Council are to foster activities. and promote voluntary standardization as a means CSA standards reflect a national consensus of of advancing the national economy, benefiting theproducers and users including
6、manufacturers, health, safety, and welfare of the public, assisting consumers, retailers, unions and professional and protecting the consumer, facilitating domestic organizations, and governmental agencies. The and international trade, and furthering internationalstandards are used widely by industr
7、y and commerce cooperation in the field of standards.and often adopted by municipal, provincial, and A National Standard of Canada is a standard whichfederal governments in their regulations, particularly in has been approved by the Standards Council ofthe fields of health, safety, building and cons
8、truction, Canada and one which reflects a reasonableand the environment. agreement among the views of a number of capableIndividuals, companies, and associations across individuals whose collective interests provide to theCanada indicate their support for CSAs standards greatest practicable extent a
9、 balance ofdevelopment by volunteering their time and skills to representation of producers, users, consumers, andCSA Committee work and supporting the Associations others with relevant interests, as may be appropriateobjectives through sustaining memberships. The more to the subject in hand. It nor
10、mally is a standardthan 7000 committee volunteers and the 2000 which is capable of making a significant and timelysustaining memberships together form CSAs total contribution to the national interest.membership from which its Directors are chosen. Approval of a standard as a National Standard ofSust
11、aining memberships represent a major source of Canada indicates that a standard conforms to theincome for CSAs standards development activities. criteria and procedures established by the StandardsThe Association offers certification and testing Council of Canada. Approval does not refer to theservi
12、ces in support of and as an extension to its technical content of the standard; this remains thestandards development activities. To ensure the continuing responsibility of the accreditedintegrity of its certification process, the Association standards-development organization.regularly and continua
13、lly audits and inspects products Those who have a need to apply standards arethat bear the CSA Mark. encouraged to use National Standards of CanadaIn addition to its head office and laboratory complex whenever practicable. These standards are subject in Toronto, CSA has regional branch offices in ma
14、jor to periodic review; therefore, users are cautioned centres across Canada and inspection and testing to obtain the latest edition from the organizationagencies in eight countries. Since 1919, the preparing the standard.Association has developed the necessary expertise to The responsibility for ap
15、proving National Standards meet its corporate mission: CSA is an independent of Canada rests with theservice organization whose mission is to provide an Standards Council of Canadaopen and effective forum for activities facilitating the 270 Albert Street, Suite 200exchange of goods and services thro
16、ugh the use of Ottawa, Ontario, K1P 6N7standards, certification and related services to meet Canadanational and international needs.For further information on CSA services, write toCanadian Standards Association178 Rexdale BoulevardToronto, Ontario, M9W 1R3CanadaAlthough the intended primary applica
17、tion of this Standard is stated in its Scope, it is importantto note that it remains the responsibility of the users to judge its suitability for their particular purpose.Registered trade-mark of Canadian Standards AssociationIdentification cards Integrated circuit(s) cards with contacts Part 7:CAN/
18、CSA-ISO/IEC 7816-7:02 Interindustry commands for Structured Card Query Language (SCQL)March 2002 Canadian Standards Association CSA/1CAN/CSA-ISO/IEC 7816-7:02Identification cards Integratedcircuit(s) cards with contacts Part 7: Interindustry commands forStructured Card Query Language(SCQL)CSA Prefac
19、eStandards development within the Information Technology sector is harmonized with internationalstandards development. Through the CSA Technical Committee on Information Technology (TCIT),Canadians serve as the Canadian Advisory Committee (CAC) on ISO/IEC Joint Technical Committee 1 onInformation Te
20、chnology (ISO/IEC JTC1) for the Standards Council of Canada (SCC), the ISO memberbody for Canada and sponsor of the Canadian National Committee of the IEC. Also, as a member of theInternational Telecommunication Union (ITU), Canada participates in the International Telegraph andTelephone Consultativ
21、e Committee (ITU-T).This International Standard was reviewed by the CSA TCIT under the jurisdiction of the StrategicSteering Committee on Information Technology and deemed acceptable for use in Canada. (Acommittee membership list is available on request from the CSA Project Manager.) From time to ti
22、me,ISO/IEC may publish addenda, corrigenda, etc. The CSA TCIT will review these documents for approvaland publication. For a listing, refer to the CSA Information Products catalogue or CSA Info Update orcontact a CSA Sales representative. This Standard has been formally approved, without modificatio
23、n, bythese Committees and has been approved as a National Standard of Canada by the Standards Council ofCanada.March 2002 Canadian Standards Association 2002All rights reserved. No part of this publication may be reproduced in any form whatsoever without the prior permission ofthe publisher. ISO/IEC
24、 material is reprinted with permission. Where the words “this International Standard” appear in thetext, they should be interpreted as “this National Standard of Canada”. Inquiries regarding this National Standard of Canada should be addressed to Canadian Standards Association 178 Rexdale Boulevard,
25、 Toronto, Ontario, Canada M9W 1R31-800-463-6727 416-747-4044www.csa.caB CReference numberISO/IEC 7816-7:1999(E)INTERNATIONALSTANDARDISO/IEC7816-7First edition1999-03-01Identification cards Integrated circuit(s)cards with contacts Part 7:Interindustry commands for Structured CardQuery Language (SCQL)
26、Cartes didentification Cartes circuit(s) intgr(s) contacts Partie 7: Commandes intersectorielles pour langage dinterrogation de cartestructure (SCQL)ISO/IEC 7816-7:1999(E) ISO/IEC 1999All rights reserved. Unless otherwise specified, no part of this publication may be reproduced or utilized in any fo
27、rm or by any means, electronicor mechanical, including photocopying and microfilm, without permission in writing from the publisher.ISO/IEC Copyright Office Case postale 56 CH-1211 Genve 20 SwitzerlandiiContents1 Scope 12 Normative references 13 Terms and definitions .14 Symbols (and abbreviated ter
28、ms) 25 SCQL database concept .25.1 SCQL database .25.2 SCQL tables.35.3 SCQL views .45.4 SCQL system tables and dictionaries 55.5 SCQL user profiles .76 SCQL related commands 76.1 General aspects 76.2 Grouping and encoding of commands.86.3 Notation and special codings96.4 Status bytes.106.5 Coding o
29、f identifiers.116.6 Security attributes of tables, views and users.126.7 Linking user ids to INSERT and UPDATE operations.127 Database operations127.1 CREATE TABLE 127.2 CREATE VIEW .137.3 CREATE DICTIONARY157.4 DROP TABLE.167.5 DROP VIEW .17 ISO/IECISO/IEC 7816-7:1999(E)iii7.6 GRANT . 187.7 REVOKE.
30、 197.8 DECLARE CURSOR 207.9 OPEN 227.10 NEXT 237.11 FETCH 237.12 FETCH NEXT . 247.13 INSERT. 257.14 UPDATE . 267.15 DELETE 278 Transaction management . 288.1 General concept 288.2 Transaction operations 299 User management 319.1 General concept 319.2 User operations 32Annex A (informative) Usage of
31、SCQL operations 36ISO/IEC 7816-7:1999(E) ISO/IECivForewordISO (the International Organization for Standardization) and IEC (the International Electrotechnical Commission)form the specialized system for worldwide standardization. National bodies that are members of ISO or IECparticipate in the develo
32、pment of International Standards through technical committees established by therespective organization to deal with particular fields of technical activity. ISO and IEC technical committeescollaborate in fields of mutual interest. Other international organizations, governmental and non-governmental
33、, inliaison with ISO and IEC, also take part in the work.In the field of information technology, ISO and IEC have established a joint technical committee, ISO/IEC JTC 1.Draft International Standards adopted by the joint technical committee are circulated to national bodies for voting.Publication as
34、an International Standard requires approval by at least 75 % of the national bodies casting a vote.International Standard ISO/IEC 7816-7 was prepared by Joint Technical Committee ISO/IEC JTC 1, Informationtechnology, Subcommitte SC 17, Identification cards and related devices.ISO/IEC 7816 consists o
35、f the following parts, under the general title Identification cards Integrated circuit(s) cardswith contacts : Part 1: Physical characteristics Part 2: Dimensions and location of the contacts Part 3: Electronic signals and transmission protocols Part 4: Interindustry commands for interchange Part 5:
36、 Numbering system and registration procedure for application identifiers Part 6: Interindustry data elements Part 7: Interindustry commands for Structured Card Query Language (SCQL) Part 8: Security related interindustry commandsAnnex A of this part of ISO/IEC 7816 is for information only. ISO/IECIS
37、O/IEC 7816-7:1999(E)vIntroductionThis part of ISO/IEC 7816 is one of a series of standards describing the parameters for integrated circuit(s) cardswith contacts and the use of such cards for international interchange.These cards are identification cards intended for information exchange negotiated
38、between the outside and theintegrated circuit in the card. As a result of an information exchange, the card delivers information (computationresults, stored data), and/or modifies its content (data storage, event memorization).During the preparation of this part of ISO/IEC 7816, information was gath
39、ered concerning relevant patents uponwhich application of this part of ISO/IEC 7816 might depend. Relevant patents were identified in France, the patentholder is Gemplus. However, ISO cannot give authoritative or comprehensive information about evidence, validity orscope of patents or like rights.Th
40、e patent holder has stated that licenses will be granted in appropriate terms to enable application of this part ofISO/IEC 7816, provided that those who seek licenses agree to reciprocate.Further information is available fromGEMPLUSB.P. 10013881 GEMENOS CEDEXFRANCEINTERNATIONAL STANDARD ISO/IEC ISO/
41、IEC 7816-7:1999(E)1Identification cards Integrated circuit(s) cards with contacts Part 7:Interindustry commands for Structured Card Query Language (SCQL)1 ScopeThis part of ISO/IEC 7816 specifies the concept of a SCQL database (SCQL = Structured Card Query Language based on SQL, see ISO 9075)and the
42、 related interindustry enhanced commands.2 Normative referencesThe following normative documents contain provisions which, through reference in this text, constitute provisions ofthis part of ISO/IEC 7816. For dated references, subsequent amendments to, or revisions of, any of thesepublications do n
43、ot apply. However, parties to agreements based on this part of ISO/IEC 7816 are encouraged toinvestigate the possibility of applying the most recent editions of the normative documents indicated below. Forundated references, the latest edition of the normative document referred to applies. Members o
44、f ISO and IECmaintain registers of currently valid International Standards.ISO/IEC 9075:1992, Information technology Database languages SQL2.ISO/IEC 7816-4:1995, Information technology Identification cards Integrated circuit(s) cards with contacts Part 4: Interindustry commands for interchange.ISO/I
45、EC 7816-6:1996, Identification cards Integrated circuit(s) cards with contacts Part 6: Interindustry dataelements.3 Terms and definitionsFor the purposes of this part of ISO/IEC 7816, the following definitions apply.3.1database basic userSCQL user with no inherent rights3.2database filestructured se
46、t of database objects (tables, views, dictionaries) representing the content of a database3.3database object ownerSCQL user with the special right to create and drop objects and to manage privileges on these objects3.4database ownerinitial SCQL user which manages objects and users of the databaseISO
47、/IEC 7816-7:1999(E) ISO/IEC23.5dictionaryview on a system table3.6system tabletable maintained by the card for managing the database structure and database access3.7tabledatabase object with a unique name and structured in columns and rows3.8viewlogical subset of a table4 Symbols (and abbreviated te
48、rms)For the purposes of this part of ISO/IEC 7816, the following abbreviations apply:APDU Application protocol data unitAPI Application programming interfaceDB DatabaseDB_O Database ownerDBBU Database basic userDBF Database fileDBOO Database object ownerDF Dedicated fileDO Data objectICC Integrated
49、circuit(s) cardIFD Interface deviceMF Master fileSCQL Structured card query languageSQL Structured query languageTLV Tag, length, value5 SCQL database concept5.1 SCQL databaseA database in a card according to this part of ISO/IEC 7816 is called a SCQL database (SCQL = Structured CardQuery Language), since the commands for accessing are based on SQL-functionality (see ISO 9075) and codedaccording to the principles of interindustry commands as defined in ISO/IEC 7816-4. The database itself is astruc
