IBM Books

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

AlignValue


Image Audio Video
  X X

WAVE ¿Àµð¿À³ª ºñµð¿ÀÀÇ ¿Àµð¿À Æ®·¢¿¡¼­ »ùÇÃ´ç ¹ÙÀÌÆ® ¼ö¸¦ ¸®ÅÏÇÕ´Ï´Ù. WAVE´Â »ùÇôç ÇϳªÀÇ ¹ÙÀÌÆ®("¹ÙÀÌÆ® ¸ÂÃã"À¸·Î ¾ð±ÞµÈ 8ºñÆ® ¸ð³ë)³ª »ùÇÃ´ç µÎ °³ÀÇ ¹ÙÀÌÆ®("´Ü¾î ¸ÂÃã"À¸·Î ¾ð±ÞµÈ 8ºñÆ® ½ºÅ×·¹¿À) ¶Ç´Â »ùÇÃ´ç ³× °³ÀÇ ¹ÙÀÌÆ®("µÎ ´Ü¾î ¸ÂÃã"À¸·Î ¾ð±ÞµÈ 16ºñÆ® ½ºÅ×·¹¿À)¸¦ »ç¿ëÇÏ¿© ±×°ÍÀÇ µ¥ÀÌÅ͸¦ ÀúÀåÇÒ ¼ö ÀÖ½À´Ï´Ù.

Include ÆÄÀÏ

¿Àµð¿À
dmbaudio.h

ºñµð¿À
dmbvideo.h

±¸¹®

>>-AlignValue--(--handle--)------------------------------------><
 

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

handle(DB2AUDIO ¶Ç´Â DB2VIDEO)
¿Àµð¿À ÇÚµéÀ» Æ÷ÇÔÇÏ´Â Ä÷³ À̸§À̳ª È£½ºÆ® º¯¼ö.

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

WAVE ¿Àµð¿À³ª ºñµð¿À¿¡ ÀÖ´Â ¿Àµð¿À Æ®·¢ÀÇ »ùÇà °ª´ç ¹ÙÀÌÆ® ¼ö(SMALLINT). °¡´ÉÇÑ °ªÀº ´ÙÀ½°ú °°½À´Ï´Ù.

1
¹ÙÀÌÆ® ¸ÂÃã

2
´Ü¾î ¸ÂÃã

4
µÎ ´Ü¾î ¸ÂÃã

³Î(Null) °ª
±âŸ Çü½ÄÀÇ ¿Àµð¿À

¿¹

´Ü¾î ¸ÂÃãµÈ employee Å×À̺íÀÇ sound Ä÷³¿¡ ÀúÀåµÈ ¸ðµç ¿Àµð¿ÀÀÇ ÆÄÀÏ À̸§À» È®º¸ÇϽʽÿÀ.

EXEC SQL BEGIN DECLARE SECTION;
 char hvAud_fname[251];
EXEC SQL END DECLARE SECTION;
 
EXEC SQL SELECT FILENAME(SOUND)
      INTO :hvAud_fname
      FROM EMPLOYEE
      WHERE ALIGNVALUE(SOUND) = 2;

Anita Jones¿¡ ´ëÇÑ employee Å×À̺íÀÇ video Ä÷³¿¡ ÀúÀåµÈ ºñµð¿À¿¡ ÀÖ´Â ¿Àµð¿À Æ®·¢ÀÇ »ùÇà °ª´ç ¹ÙÀÌÆ® ¼ö¸¦ ãÀ¸½Ê½Ã¿À.

EXEC SQL BEGIN DECLARE SECTION;
      short hvAlign_val;
EXEC SQL END DECLARE SECTION;
 
EXEC SQL SELECT ALIGNVALUE(VIDEO)
      INTO :hvAlign_val
      FROM EMPLOYEE
      WHERE NAME='Anita Jones';


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