ALTIBASE开发培训.ppt

1. Altibase CLI Overview (1) Overview (2) Overview (3) CLI API Groups (1) Basic Programming Steps (1) Notes When Implementing Programs (1) Notes When Implementing Programs (2) Copyright 2000, Altibase Co., Ltd ALTIBASE开发培训 天津南开创元信息技术有限公司 韩国Altibase公司 CONTENTS 1. Altibase CLI CLI Overview CLI API Groups Basic Programming Steps Notes when implementing Programs Sample - Basic Call Level Interface CLI Is Standard- Altibase CLI complies with X/OPEN CLI standard specification- So you can find easily useful sample and documents ex) Altibase, MSDN (ODBC) , DB2, Informix, Postgres, …- Enables you to write database independent applications.  Difference between CLI and Embedded SQL. - Ex) SQLExecDirect(stmt, “delete from t1”, SQL_NTS)EXEC SQL delete from T1; - E-SQL (SESC, ProC) needs precompile step. - Below two things is my personal opinions. - E-SQL is more easy in development and source readability. - In C++ Object-Oriented Style develop method, CLI can be more good choice than E-SQL. CLI API Functions Groups Environment/Connection Managementex) SQLAllocEnv() , SQLDriverConnect() SQL Statement Processingex) SQLPrepare() , SQLExecute() Attribute Processingex) SQLSetConnectAttr() , SQLSetStmtAttr() Meta Information Processing ex) SQLTables() Environment/Connection Management SQL Statement Processing SQLAllocEnv SQLAllocConnect SQLAllocStmt SQLFreeEnv SQLFreeConnect SQLFreeStmt SQLDriverConnect SQLConnect SQLDisconnect SQLPrepare SQLBindParameter SQLExecute SQLNumResultColsSQLDescribeCol SQLRowCount SQLGetData SQLBindColSQLFetch SQLExecDirect SQLEndTran Attribute Processing Meta Information Processing SQLSetEnvAttr SQLSetConnectAttr SQLSetStmtAttr ? ex) Array Insert / Update SQLTables SQLColumns SQLProcedures SQLPrimaryKeys SQLForeignKeys SQLStatistics CLI API Groups (2) SQLProcedureColumnsSQLSpecialColumns SQLTablePrivilegs SQLRETURN SQLAllocEnv(SQLHENV *env) rc = SQLAllocEnv(henv); // Allocates an environment handle and