IBM Books

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

Height


Image Audio Video
X   X

Çȼ¿ ´ÜÀ§·Î À̹ÌÁö³ª ºñµð¿À ÇÁ·¹ÀÓÀÇ ³ôÀ̸¦ ¸®ÅÏÇÕ´Ï´Ù.

Include ÆÄÀÏ

À̹ÌÁö
dmbimage.h

ºñµð¿À
dmbvideo.h

±¸¹®

>>-Height--(--handle--)----------------------------------------><
 

¸Å°³º¯¼ö(µ¥ÀÌÅÍ À¯Çü)

handle(DB2IMAGE ¶Ç´Â DB2VIDEO)
À̹ÌÁö³ª ºñµð¿À ÇÚµéÀÌ ÀÖ´Â Ä÷³ À̸§À̳ª È£½ºÆ® º¯¼ö.

¸®ÅÏ °ª(µ¥ÀÌÅÍ À¯Çü)

Çȼ¿ ´ÜÀ§ÀÇ ³ôÀÌ(INTEGER)

¿¹

employee Å×À̺íÀÇ picture Ä÷³¿¡¼­ 500 Çȼ¿º¸´Ù ªÀº ¸ðµç À̹ÌÁöÀÇ ÆÄÀÏ À̸§À» È®º¸ÇϽʽÿÀ.

EXEC SQL BEGIN DECLARE SECTION;
 char hvImg_fname[251];
EXEC SQL END DECLARE SECTION;
 
EXEC SQL SELECT FILENAME(PICTURE)
     INTO :hvImg_fname
     FROM EMPLOYEE
     WHERE HEIGHT(PICTURE)<500;


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