IBM Books

Image, Audio, Video Extender °ü¸® ¹× ÇÁ·Î±×·¡¹Ö


Å×ÀÌºí »ç¿ë °¡´ÉÈ­

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


[ ÆäÀÌÁöÀÇ ¸Ç À§ | ÀÌÀü ÆäÀÌÁö | ´ÙÀ½ ÆäÀÌÁö | ¸ñÂ÷ | »öÀÎ ]