DBxEnableTable API(¿©±â¼ x´Â ¿Àµð¿ÀÀÇ °æ¿ì a, À̹ÌÁöÀÇ °æ¿ì i ¶Ç´Â ºñµð¿ÀÀÇ °æ¿ì v) ¶Ç´Â ENABLE TABLE ¸í·ÉÀ» »ç¿ëÇÏ¿© DB2 Extender¿¡ ´ëÇÑ Å×À̺íÀ» »ç¿ë °¡´ÉÈÇϽʽÿÀ.
»ç¿ëÀÚ Å×À̺íÀ» »ç¿ë °¡´ÉÈÇÏ·Á¸é, °ü¸® Áö¿ø Å×À̺í(¹× ÇØ´ç »öÀÎ)À» º¸À¯ÇÒ Å×ÀÌºí °ø°£µµ ÁöÁ¤ÇØ¾ß ÇÕ´Ï´Ù. ÁöÁ¤µÈ Çϳª ÀÌ»óÀÇ Å×ÀÌºí °ø°£ÀÌ ³Î(NULL) °ªÀ» °¡Áú ¼ö ÀÖÀ¸¸ç, ÀÌ °æ¿ì ±âº» Å×ÀÌºí °ø°£ÀÌ »ç¿ëµË´Ï´Ù.
EEE Àü¿ë: ÆÄƼ¼Ç ȯ°æ¿¡¼ Extender¿¡ ´ëÇØ Å×À̺íÀ» »ç¿ë °¡´ÉÈÇÒ ¶§, ÁöÁ¤ÇÏ´Â Å×ÀÌºí °ø°£Àº ÆÄƼ¼ÇµÈ µ¥ÀÌÅͺ£À̽º ½Ã½ºÅÛ ³»ÀÇ ¸ðµç ³ëµå°¡ Æ÷ÇԵǴ ³ëµå ±×·ì¿¡ Á¤ÀǵǾî ÀÖ¾î¾ß ÇÕ´Ï´Ù. ¶ÇÇÑ, ÁöÁ¤µÈ Å×ÀÌºí °ø°£Àº »ç¿ëÀÚ Å×À̺í°ú µ¿ÀÏÇÑ ³ëµå ±×·ì¿¡ ÀÖ¾î¾ß ÇÕ´Ï´Ù.
EEE Àü¿ë: ÆÄƼ¼ÇµÈ µ¥ÀÌÅͺ£À̽º ȯ°æ¿¡¼ DB2 Extender Ä÷³À» ÆÄƼ¼Ç Ű Ä÷³À¸·Î »ç¿ëÇÒ ¼ö ¾ø½À´Ï´Ù.
»ç¿ëÀÚ Å×ÀÌºí¿¡ ´ëÇÑ Á¦¾î ¶Ç´Â º¯°æ ±ÇÇÑÀÌ ÇÊ¿äÇÕ´Ï´Ù. µ¥ÀÌÅͺ£À̽º¿¡ ÀÖ´Â Å×À̺íÀ» »ç¿ë °¡´ÉÈÇÏ·Á¸é, ¸ÕÀú µ¥ÀÌÅͺ£À̽º¸¦ »ç¿ë °¡´ÉÈÇØ¾ß ÇÕ´Ï´Ù.
´ÙÀ½ÀÇ ¿¹½Ã¿¡¼, Å×À̺íÀº ±âº» Å×ÀÌºí °ø°£À» »ç¿ëÇÏ¿© À̹ÌÁö¸¦ º¸À¯Çϵµ·Ï »ç¿ëÀÌ °¡´ÉȵǾî ÀÖ½À´Ï´Ù. µ¥ÀÌÅͺ£À̽º´Â ÀÌ¹Ì »ç¿ë °¡´ÉÇÕ´Ï´Ù.
API »ç¿ë: ´ÙÀ½ ¿¹¿¡¼ Å×À̺íÀ» »ç¿ë °¡´ÉÈÇϱâ Àü¿¡ ÄÚµå´Â Å×À̺íÀ» ÀÛ¼ºÇÏ°í º¯°æ»çÇ×À» È®¾àÇÕ´Ï´Ù. ¿¹½Ã¿¡´Â ÀϺΠ¿À·ù Á¡°Ë Äڵ尡 Æ÷ÇԵ˴ϴÙ. ¿ÏÀüÇÑ »ùÇà ÇÁ·Î±×·¥Àº SAMPLES ¼ºêµð·ºÅ丮ÀÇ ENABLE.C ÆÄÀÏ¿¡ ÀÖ½À´Ï´Ù.
±×¸² 11. Å×ÀÌºí »ç¿ëÀ» °¡´ÉÇÏ°Ô ÇÏ´Â »ùÇà ÄÚµå
SQLCHAR szCreate_DB2UDB[]="CREATE TABLE %s(%s mmdbsys.DB2Image, %s mmdbsys.DB2Video, %s mmdbsys.DB2Audio, artist varchar(25), title varchar(25) stock_no char(11), tw char(10), price char(10))"; SQLRETURN rc = SQL_SUCCESS; SQLINTEGER sqlcode = 0; char errorMsgText[MMDB_ERROR_MSG_TEXT_LEN+1]; char tableName[8+18+1] = "sobay_catalog"; char audioColumn[18+1] = "music"; char imageColumn[18+1] = "covers"; char videoColumn[18+1] = "video"; char *program = "enable"; char *step; /*-----create table --------------------------------------------------*/ printf("%s: Creating table ......\n", program); if (!SERVER_IS_DB2390) sprintf((char*) buffer, (char*) szCreate_DB2UDB, tableName, imageColumn, videoColumn, audioColumn): rc = SQLAllocStmt(hdbc, &hstmt); cliCheckError(SQL_NULL_HENV, hdbc, SQL_NULL_HSTMT, rc); rc = SQLExecDirect(hstmt, buffer, SQL_NTS); cliCheckError(SQL_NULL_HENV, SQL_NULL_HDBC, hstmt, rc); /*---- enable table for image extender ---------------------------------*/ printf("%s: Enabling table......\n", program); step="DBiEnableTable"; if (!SERVER_IS_DB2390) rc = DBiEnableTable(NULL,tableName); } if (rc < 0) { printf("%s: %s failed!\n", program, step); printMsg(rc); DBiGetError(&sqlcode, errorMsgText); if (sqlcode) printf("sqlcode=%i, "sqlcode"); printf("errorMsgText=%s\n", errorMsgText); } else if (rc > 0) { printf("%s: %s, warning detected.\n", program, step); printMsg(rc); DBiGetError(&sqlcode, errorMsgText); printf("warningMsgText=%s\n", errorMsgText); } else printf("%s: %s OK\n", program, step) /*---- end of enable table --------------------------------------------*/ |
db2ext ¸í·ÉÇà »ç¿ë: ÀÌ ¿¹½Ã¿¡¼, Å×À̺íÀº ÀÌ¹Ì Á¸ÀçÇÏ¸ç µ¥ÀÌÅͺ£À̽º°¡ »ç¿ë °¡´ÉÇÕ´Ï´Ù.
enable table employee for db2image