IBM Books

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

°Ë»öÀ» À§ÇÑ Content UDF Çü½Ä

Content UDF´Â ¿À¹ö·ÎµåµÇ¸ç, UDF¸¦ »ç¿ëÇÏ´Â ¹æ¹ý¿¡ µû¶ó ¼­·Î ´Ù¸¥ Çü½ÄÀ» °®°Ô µÇ´Â °ÍÀ» ÀǹÌÇÕ´Ï´Ù. Çü½ÄÀº ´ÙÀ½°ú °°½À´Ï´Ù.

Çü½Ä 1: ¿ÀºêÁ§Æ®¸¦ Ŭ¶óÀÌ¾ðÆ® ¹öÆÛ ¶Ç´Â Ŭ¶óÀÌ¾ðÆ® ÆÄÀÏ·Î °Ë»öÇÕ´Ï´Ù.

Content(
     handle,                      /* object handle */
  );

Çü½Ä 2: ¿ÀºêÁ§Æ® ¼¼±×¸ÕÆ®¸¦ Ŭ¶óÀÌ¾ðÆ® ¹öÆÛ ¶Ç´Â Ŭ¶óÀÌ¾ðÆ® ÆÄÀÏ·Î °Ë»öÇÕ´Ï´Ù.

Content(
     handle,                      /* object handle */
     offset,                      /* offset where retrieval begins */
     size                         /* number of bytes to retrieve */
  );

Çü½Ä 3: ¿ÀºêÁ§Æ®¸¦ ¼­¹ö ÆÄÀÏ·Î °Ë»öÇÕ´Ï´Ù.

Content(
     handle,                      /* object handle */
     target_file,                 /* server file name */
     overwrite                    /* 0=Do not overwrite target file if it exists */
                                  /* 1=Overwrite target file */
 
  );

¶ÇÇÑ Content UDF´Â À̹ÌÁö ¿ÀºêÁ§Æ®ÀÇ °æ¿ì¿¡ ÇÑÇØ ´ÙÀ½ Çü½ÄÀ» Æ÷ÇÔÇÕ´Ï´Ù.

Çü½Ä 4: Çü½Ä º¯È¯À» »ç¿ëÇÏ¿© À̹ÌÁö¸¦ Ŭ¶óÀÌ¾ðÆ® ¹öÆÛ ¶Ç´Â ÆÄÀÏ·Î °Ë»öÇÕ´Ï´Ù.

Content(
     handle,                      /* object handle */
     target format                /* target format */
       );

Çü½Ä 5: Çü½Ä º¯È¯À» »ç¿ëÇÏ¿© ¿ÀºêÁ§Æ®¸¦ ¼­¹ö ÆÄÀÏ·Î °Ë»öÇÕ´Ï´Ù.

Content(
     handle,                      /* object handle */
     target_file,                 /* server file name */
     overwrite,                   /* 0=Do not overwrite target file if it exists */
                                  /* 1=Overwrite target file */
     target format                /* target format */
 
  );

Çü½Ä 6: Çü½Ä º¯È¯ ¹× Ãß°¡ º¯°æÀ» »ç¿ëÇÏ¿© ¿ÀºêÁ§Æ®¸¦ Ŭ¶óÀÌ¾ðÆ® ¹öÆÛ ¶Ç´Â ÆÄÀÏ·Î °Ë»öÇÕ´Ï´Ù.

Content(
     handle,                      /* object handle */
     target format,              /* target format */
     conversion_options           /* conversion options */
  );

Çü½Ä 7: Çü½Ä º¯È¯ ¹× Ãß°¡ º¯°æÀ» »ç¿ëÇÏ¿© ¿ÀºêÁ§Æ®¸¦ ¼­¹ö ÆÄÀÏ·Î °Ë»öÇÕ´Ï´Ù.

Content(
     handle,                 /* object handle */
     target_file,            /* server file name */
     overwrite,              /* 0=Do not overwrite target file if it exists */
                             /* 1=Overwrite target file */
     target format,          /* target format */
     conversion_options      /* conversion options */
  );

¿¹¸¦ µé¾î, ´ÙÀ½ÀÇ ¸í·É¹®Àº Á÷¿ø Å×ÀÌºí¿¡¼­ ¼­¹ö¿¡ ÀÖ´Â ÆÄÀÏ·Î À̹ÌÁö¸¦ °Ë»öÇÕ´Ï´Ù. (À̰ÍÀº Çü½Ä 3¿¡ ´ëÀÀÇÕ´Ï´Ù.)

EXEC SQL SELECT CONTENT(                 /* retrieval UDF */
       PICTURE,                          /* image handle */
       '/employee/images/ajones.bmp',    /* target file */
       1)                                /* overwrite target file */
FROM EMPLOYEE
WHERE NAME = 'Anita Jones';

C ÀÀ¿ëÇÁ·Î±×·¥¿¡ ÀÖ´Â ´ÙÀ½ ¸í·É¹®Àº Á÷¿ø Å×ÀÌºí¿¡¼­ ¼­¹ö¿¡ ÀÖ´Â ÆÄÀÏ·Î À̹ÌÁö¸¦ °Ë»öÇÕ´Ï´Ù. À̹ÌÁö Çü½ÄÀº °Ë»öµÉ ¶§ º¯È¯µË´Ï´Ù. (À̰ÍÀº Çü½Ä 5¿¡ ´ëÀÀÇÕ´Ï´Ù.)

EXEC SQL BEGIN DECLARE SECTION;
  char hvImg_fname[255];
EXEC SQL END DECLARE SECTION;
 
EXEC SQL SELECT CONTENT(                   /* retrieval UDF */
       PICTURE,                            /* image handle */
       '/employee/images/ajones.bmp',      /* target file */
       1,                                  /* overwrite target file */
       'GIF')                              /* target format */
INTO :hvImg_fname
FROM EMPLOYEE
WHERE NAME = 'Anita Jones';


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