SQL/MP Programming Manual for C
Index
HP NonStop SQL/MP Programming Manual for C—429847-008
Index-3
C
Character processing rules (CPRL) 
procedures (continued)
CPRL_GETNUMTABLE_ 11-18
CPRL_GETSPECIALTABLE_ 11-19
CPRL_GETUPSHIFTTABLE_ 11-20
CPRL_INFO_ 11-20
CPRL_READOBJECT_ 11-22
CPRL_UPSHIFT_ 11-23
CHAR_AS_ARRAY option, SQL 
pragma 2-7, 6-7
CHAR_AS_STRING option, SQL 
pragma 6-7
CHECK clause, SQL compiler 6-18
CHECK option syntax 8-10
CLEARONPURGE attribute, similarity 
check rules 8-12
CLOSE statement 4-24
CLOSE TABLES option, FREE 
RESOURCES statement 4-2, 4-24
Closing tables and views 4-2
COBOL as host language 1-1
Coding rules for embedding SQL 
statements 3-1
Collation
automatic SQL recompilation 8-3
CPRL_COMPAREOBJECTS_ 
procedure 8-15
similarity check 8-15
Collation buffer, determining length 10-7
Collector process, EMS B-5
Colon (:) with host variable 1-2, 2-6
Column headings, similarity check 
rules 8-12
Comments
Declare Section 2-2
similarity check rules 8-12
COMMIT WORK statement 10-28
Communications area, SQL
See SQLCA structure
Compilation
automatic recompilation 8-5
C compiler syntax 6-9
Compilation (continued)
C source file 1-5
dynamic SQL statements 6-23
explicit SQL 6-13, 6-14
COMPILE clause, SQL compiler 6-20
CONTROL TABLE directive C-3
Conversational interface
See SQL Conversational Interface 
(SQLCI)
Conversion, between SQL and C data 2-5
CONVERTTIMESTAMP function 4-10
COPY command and lost open error 4-3
Copying SQL files, effect on SQL 
validity 8-2
CPRL_AREALPHAS_ procedure 11-4
CPRL_ARENUMERICS_ procedure 11-5
CPRL_ARE_ procedure 11-3
CPRL_COMPARE1ENCODED_ 
procedure 11-6
CPRL_COMPAREOBJECTS_ 
procedure 8-15, 11-8
CPRL_COMPARE_ procedure 11-7
CPRL_DECODE_ procedure 11-9
CPRL_DOWNSHIFT_ procedure 11-10
CPRL_ENCODE_ procedure 11-11
CPRL_GETALPHATABLE_ 
procedure 11-12
CPRL_GETCHARCLASSTABLE_ 
procedure 11-13
CPRL_GETDOWNSHIFTTABLE_ 
procedure 11-14
CPRL_GETFIRST_ procedure 11-15
CPRL_GETLAST_ procedure 11-16
CPRL_GETNEXTINSEQUENCE_ 
procedure 11-17
CPRL_GETNUMTABLE_ procedure 11-18
CPRL_GETSPECIALTABLE_ 
procedure 11-19
CPRL_GETUPSHIFTTABLE_ 
procedure 11-20
CPRL_INFO_ procedure 11-20
CPRL_READOBJECT_ procedure 11-22
CPRL_UPSHIFT_ procedure 11-23










