ISO/IEC INTERNATIONAL STANDARD 7816-7 First edition 1999-03-01 Identification cards Integrated circuit(s) cards with contacts - Part 7: Interindustry commands for Structured Card Query Language (SCQL) Cartes d'identification Cartes a circuit(s) intégré(s) a contacts Partie 7: Commandes intersectorielles pour langage d'interrogation de carte structurée (SCQL) IEC Reference number ISO/IEC 7816-7:1999(E) Not for Resale ISO/IEC 7816-7:1999(E) Contents 1 Scope 2 Normative references 3 Terms and definition 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 user: 6.7 Linking user ids to INSERT and UPDATE operations... .12 7 Database operations .12 7.1 CREATE TABLE 12 7.2 CREATE VIEW. .13 7.3 CREATE DICTIONARY .15 7.4 DROP TABLE. 16 7.5DROPVIEW @ISO/IEC1999 All rights reserved. Unless otherwise specified, no part of this publication may be reproduced or utilized in any form or by any means, electronic or mechanical, including photocopying and microfilm, without permission in writing from the publisher. ISO/IEC Copyright Office · Case postale 56 · CH-1211 Geneve 20 · Switzerland Printed in Switzerland ational Organization for Standardizatior Not for Resal @ ISO/IEC ISO/IEC 7816-7:1999(E) 7.6 GRANT 7.7REVOKE 19 7.8 DECLARECURSOR 7.9 OPEN. 22 7.10 NEXT 23 7.11 FETCH. .23 7.12 FETCH NEXT .24 7.13INSER 25 7.14UPDATE. ..26 7.15DELETE 27 8 Transaction management, 28 8.1 General concept.. 8.2 Transaction operations 29 9 User management. ..31 9.1 General concept... 9.2 User operations 32 Annex A (informative) Usage of ScQL operations Copyright International Organization for Standardization ili Not for Resale