CONTENTS Title Page Copyright Page Preface Part I CDO Commands 1 Command Descriptions @ (At Sign) Command ATTACH Command ATTACH TO COMPOSITE Command CHANGE COLLECTION Command CHANGE CONTEXT Command CHANGE DATABASE Command CHANGE FIELD Command CHANGE FILE_ELEMENT CHANGE GENERIC Command CHANGE PARTITION Command CHANGE PROTECTION Command CHANGE RECORD Command CHANGE RECORD: Record Change Clause CHANGE RECORD: Alignment Change Clause CHANGE RECORD: Structure Change Clause CHANGE RECORD: Variant Change Clause CLEAR NOTICES Command CLOSE FILE_ELEMENT Command CONSTRAIN Command COPY Command DEFINE COLLECTION Command DEFINE CONTEXT Command DEFINE DATABASE Command DEFINE DIRECTORY Command DEFINE FIELD Command DEFINE FILE_ELEMENT DEFINE GENERIC Command DEFINE GENERIC: Relationship Mbr Options Clause DEFINE KEY Command DEFINE PARTITION Command DEFINE PROTECTION Command DEFINE RECORD Command DEFINE RECORD: Included Name Clause DEFINE RECORD: Structure Clause DEFINE RECORD: Variant Clause DEFINE REPOSITORY Command DEFINE RMS_DATABASE Command DELETE COLLECTION Command DELETE CONTEXT Command DELETE DATABASE Command DELETE DIRECTORY Command DELETE FIELD Command DELETE FILE_ELEMENT Command DELETE GENERIC Command DELETE PARTITION Command DELETE PROTECTION Command DELETE RECORD Command DELETE REPOSITORY Command DELETE RMS_DATABASE Command DETACH FROM COMPOSITE Command DIRECTORY Command EDIT Command ENTER Command EXIT Command EXTRACT Command HELP Command MERGE Command MOVE REPOSITORY Command ON Command OPEN FILE_ELEMENT Command PROMOTE Command PURGE Command REMOVE Command REPLACE Command RESERVE Command SET CONTEXT Command SET DEFAULT Command SET KEY Command SET OUTPUT Command SET VERIFY Command SHOW ALL Command SHOW COLLECTION Command SHOW CONTEXT Command SHOW DATABASE Command SHOW DEFAULT Command SHOW FIELD Command SHOW FILE_ELEMENT Command SHOW GENERIC Command SHOW KEY Command SHOW NOTICES Command SHOW PARTITION Command SHOW PRIVILEGES Command SHOW PROTECTION Command SHOW PROTOCOL Command SHOW RECORD Command SHOW REPOSITORIES Command SHOW RESERVATIONS Command SHOW RMS_DATABASE Command SHOW UNUSED Command SHOW USED_BY Command SHOW USES Command SHOW VERSION Command SHOW WHAT_IF Command SPAWN Command UNRESERVE Command UPDATE Command VERIFY Command Part II CDO Parameters 2 Field and Record Properties ARRAY Field or Record Property BASED ON Field Property The COMPUTED BY Field Property CURRENCY_SIGN Field Property DATATYPE Field Property DATATYPE Field Property: Decimal String Data Types DATATYPE Field Property: Fixed Point Data Types DATATYPE Field Property: Floating Point Data Types DECIMAL_POINT Field Property DISPLAY_SCALE Field Property EDIT_STRING Field Property FILLER Field Property GENERIC Field Property HELP_TEXT Field Property INITIAL_VALUE Field Property INPUT_VALUE Field Property JUSTIFIED Field Property MISSING_VALUE Field Property NAME Field or Record Property OCCURS Field Property OCCURS...DEPENDING Record Property QUERY_HEADER Field Property QUERY_NAME Field Property VALID IF Field Property 3 File Definition, Area, and Key Properties File Definition Properties Area Properties Key Properties 4 Expressions Value Expressions Value Expressions: Character String Literals Value Expressions: Numeric Literals Conditional Expressions Record Selection Expression (RSE) 5 CDO Edit Strings Alphabetic Character Alphanumeric Character T : Long Text Character X : Any Character Comma Character Date, Day, and Time Characters D : Day Number Character H : Twelve Hour Mode Character J : Julian Digit Character M : Month Name Character N : Month Number Character P : Minute Character Q : Second Character R : Twenty-Four Hour Mode Character W : Weekday Name Character Y : Year Character % : AM/PM Character * : Fraction Second Character Decimal Point Character Digit Characters F : Hexadecimal Digit Character 7 : Octal Digit Character 9 : Decimal Digit Character Encoded Sign Characters C : Encoded Minus Character G : Encoded Sign Character K : Encoded Plus Character Exponent Character Floating Characters S : Floating Sign Character Z: Floating Zero Replace Character - : Floating Minus + : Floating Plus $ : Floating Currency Character \ : Floating Blank Character Literal Characters Logical Character Lowercase Character Minus Literal Character Minus Parentheses Character Missing Separator Character Repeat Count Character Uppercase Character A Mapping of Keywords with the DEFINE_RMS_DATABASE Command B Repository Logical Names Table TABLES 1 Documentation Conventions 1-1 Wildcard Rules for the COPY Command 1-2 Redefineable Key Names and Terminal Designations 1-3 Error Handling if Action is CONTINUE 1-4 Error Handling if Action is STOP 2-1 Values for SEGMENT_TYPE 2-2 Fixed-Point Data Types 2-3 Floating-Point Data Types 2-4 Complex Numbers 4-1 Arithmetic Operators 4-2 Statistical Operators 4-3 Quotation Marks in Character String Literals 4-4 Mathematical Relational Operators 5-1 Translation of CDO Edit Strings for Languages and Products 5-2 Translation of Characters in Floating Zero Replace Edit Strings 5-3 Translation of CDO Literal Edit Strings 5-4 Translation of CDO Minus Literal Edit Strings A-1 Mapping of Keywords to Symbolic Field Offsets A-2 Mapping of Keywords to Symbolic Constants A-3 Mapping of Keywords to Symbolic Bit Offsets A-4 Mapping of CDO Area Properties to RMS Symbolic Field Offsets A-5 Mapping of CDO Position Type Options to XAB$B_ALN Symbolic Constants A-6 Mapping of CDO Key Properties to RMS Symbolic Field Offsets B-1 CDD/Repository Logical Names