Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Protocol Constants


Contents

Function codes

Function code

Value

CAS_FC_END_TRAN

1

CAS_FC_PREPARE

2

CAS_FC_EXECUTE

3

CAS_FC_GET_DB_PARAMETER

4

CAS_FC_SET_DB_PARAMETER

5

CAS_FC_CLOSE_REQ_HANDLE

6

CAS_FC_CURSOR

7

CAS_FC_FETCH

8

CAS_FC_SCHEMA_INFO

9

CAS_FC_OID_GET

10

CAS_FC_OID_PUT

11

CAS_FC_DEPRECATED1

12

CAS_FC_DEPRECATED2

13

CAS_FC_DEPRECATED3

14

CAS_FC_GET_DB_VERSION

15

CAS_FC_GET_CLASS_NUM_OBJS

16

CAS_FC_OID_CMD

17

CAS_FC_COLLECTION

18

CAS_FC_NEXT_RESULT

19

CAS_FC_EXECUTE_BATCH

20

CAS_FC_EXECUTE_ARRAY

21

CAS_FC_CURSOR_UPDATE

22

CAS_FC_GET_ATTR_TYPE_STR

23

CAS_FC_GET_QUERY_INFO

24

CAS_FC_DEPRECATED4

25

CAS_FC_SAVEPOINT

26

CAS_FC_PARAMETER_INFO

27

CAS_FC_XA_PREPARE

28

CAS_FC_XA_RECOVER

29

CAS_FC_XA_END_TRAN

30

CAS_FC_CON_CLOSE

31

CAS_FC_CHECK_CAS

32

CAS_FC_MAKE_OUT_RS

33

CAS_FC_GET_GENERATED_KEYS

34

CAS_FC_LOB_NEW

35

CAS_FC_LOB_WRITE

36

CAS_FC_LOB_READ

37

CAS_FC_END_SESSION

38

CAS_FC_GET_ROW_COUNT

39

CAS_FC_GET_LAST_INSERT_ID

40

CAS_FC_CURSOR_CLOSE

41

CAS_FC_PREPARE_AND_EXECUTE

42

 

Database parameters

 

Parameter type

Value

CCI_PARAM_ISOLATION_LEVEL  

1

CCI_PARAM_LOCK_TIMEOUT     

2

CCI_PARAM_MAX_STRING_LENGTH

3

CCI_PARAM_AUTO_COMMIT      

4

 

Query prepare modes

 

Parameter type

Value

CCI_PREPARE_NORMAL     

0x00

CCI_PREPARE_INCLUDE_OID

0x01

CCI_PREPARE_UPDATABLE  

0x02

CCI_PREPARE_QUERY_INFO 

0x04

CCI_PREPARE_HOLDABLE   

0x08

CCI_PREPARE_CALL       

0x40

 

Statement execution types

 

Schema execution type

Value

NORMAL                

0

GET_BY_OID            

1

GET_SCHEMA_INFO       

2

GET_AUTOINCREMENT_KEYS

3

 

Statement types

 

Statement type

Value

CUBRID_STMT_ALTER_CLASS

0

CUBRID_STMT_ALTER_SERIAL

1

CUBRID_STMT_COMMIT_WORK

2

CUBRID_STMT_REGISTER_DATABASE

3

CUBRID_STMT_CREATE_CLASS

4

CUBRID_STMT_CREATE_INDEX

5

CUBRID_STMT_CREATE_TRIGGER

6

CUBRID_STMT_CREATE_SERIAL

7

CUBRID_STMT_DROP_DATABASE

8

CUBRID_STMT_DROP_CLASS

9

CUBRID_STMT_DROP_INDEX

10

CUBRID_STMT_DROP_LABEL

11

CUBRID_STMT_DROP_TRIGGER

12

CUBRID_STMT_DROP_SERIAL

13

CUBRID_STMT_EVALUATE

14

CUBRID_STMT_RENAME_CLASS

15

CUBRID_STMT_ROLLBACK_WORK

16

CUBRID_STMT_GRANT

17

CUBRID_STMT_REVOKE

18

CUBRID_STMT_STATISTICS

19

CUBRID_STMT_INSERT

20

CUBRID_STMT_SELECT

21

CUBRID_STMT_UPDATE

22

CUBRID_STMT_DELETE

23

CUBRID_STMT_CALL

24

CUBRID_STMT_GET_ISO_LVL

25

CUBRID_STMT_GET_TIMEOUT

26

CUBRID_STMT_GET_OPT_LVL

27

CUBRID_STMT_SET_OPT_LVL

28

CUBRID_STMT_SCOPE

29

CUBRID_STMT_GET_TRIGGER

30

CUBRID_STMT_SET_TRIGGER

31

CUBRID_STMT_SAVEPOINT

32

CUBRID_STMT_PREPARE

33

CUBRID_STMT_ATTACH

34

CUBRID_STMT_USE

35

CUBRID_STMT_REMOVE_TRIGGER

36

CUBRID_STMT_RENAME_TRIGGER

37

CUBRID_STMT_ON_LDB

38

CUBRID_STMT_GET_LDB

39

CUBRID_STMT_SET_LDB

40

CUBRID_STMT_GET_STATS

41

CUBRID_STMT_CREATE_USER

42

CUBRID_STMT_DROP_USER

43

CUBRID_STMT_ALTER_USER

44

CUBRID_STMT_CALL_SP

0x7e

CUBRID_STMT_UNKNOWN

0x7f

 

Data types

 

Data type

Value

CCI_U_TYPE_UNKNOWN

0

CCI_U_TYPE_NULL

0

CCI_U_TYPE_CHAR

1

CCI_U_TYPE_STRING

2

CCI_U_TYPE_NCHAR

3

CCI_U_TYPE_VARNCHAR

4

CCI_U_TYPE_BIT

5

CCI_U_TYPE_VARBIT

6

CCI_U_TYPE_NUMERIC

7

CCI_U_TYPE_INT

8

CCI_U_TYPE_SHORT

9

CCI_U_TYPE_MONETARY

10

CCI_U_TYPE_FLOAT

11

CCI_U_TYPE_DOUBLE

12

CCI_U_TYPE_DATE

13

CCI_U_TYPE_TIME

14

CCI_U_TYPE_TIMESTAMP

15

CCI_U_TYPE_SET

16

CCI_U_TYPE_MULTISET

17

CCI_U_TYPE_SEQUENCE

18

CCI_U_TYPE_OBJECT

19

CCI_U_TYPE_RESULTSET

20

CCI_U_TYPE_BIGINT

21

CCI_U_TYPE_DATETIME

22

CCI_U_TYPE_BLOB

23

CCI_U_TYPE_CLOB

24

 

Schema types

 

Schema type

Value

CCI_SCH_CLASS

1

CCI_SCH_VCLASS

2

CCI_SCH_QUERY_SPEC

3

CCI_SCH_ATTRIBUTE

4

CCI_SCH_CLASS_ATTRIBUTE

5

CCI_SCH_METHOD

6

CCI_SCH_CLASS_METHOD

7

CCI_SCH_METHOD_FILE

8

CCI_SCH_SUPERCLASS

9

CCI_SCH_SUBCLASS

10

CCI_SCH_CONSTRAIT

11

CCI_SCH_TRIGGER

12

CCI_SCH_CLASS_PRIVILEGE

13

CCI_SCH_ATTR_PRIVILEGE

14

CCI_SCH_DIRECT_SUPER_CLASS

15

CCI_SCH_PRIMARY_KEY

16

CCI_SCH_IMPORTED_KEYS

17

CCI_SCH_EXPORTED_KEYS

18

CCI_SCH_CROSS_REFERENCE

19

 

Transaction isolation levels

 

Transaction isolation level

Value

TRAN_UNKNOWN_ISOLATION

0x00

TRAN_COMMIT_CLASS_UNCOMMIT_INSTANCE

0x01

TRAN_COMMIT_CLASS_COMMIT_INSTANCE

0x02

TRAN_REP_CLASS_UNCOMMIT_INSTANCE

0x03

TRAN_REP_CLASS_COMMIT_INSTANCE

0x04

TRAN_REP_CLASS_REP_INSTANCE

0x05

TRAN_SERIALIZABLE

0x06

TRAN_DEFAULT_ISOLATION

0x01

comments powered by Disqus
Page info
viewed 697 times
translations en
Author
posted last year by
CUBRID
Contributors
updated last year by
View revisions
Share this article