IBM Books

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

FindTrackName


Image Audio Video
  X  

MIDI ¿Àµð¿À¿¡¼­ ÁöÁ¤ À̸§ ÁöÁ¤µÈ Æ®·¢ ¹øÈ£¸¦ ¸®ÅÏÇÕ´Ï´Ù.

Include ÆÄÀÏ

dmbaudio.h

±¸¹®

>>-FindTrackName--(--handle--,--trackname--)-------------------><
 

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

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

trackname(VARCHAR(255))
Ž»öµÇ´Â Æ®·¢ À̸§. Audio Extender´Â Á¦°øµÈ À̸§°ú Á¤È®È÷ ÀÏÄ¡ÇÏ´Â Æ®·¢ À̸§À» ãÀ» °ÍÀÔ´Ï´Ù.

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

ÁöÁ¤ ¾Ç±â À̸§ÀÇ À̸§ ÁöÁ¤µÈ Æ®·¢ ¹øÈ£(SMALLINT). ÁöÁ¤ Æ®·¢ À̸§ÀÌ ¹ß°ßµÇÁö ¾Ê´Â´Ù¸é °ª -1ÀÌ ¸®Åϵ˴ϴÙ. ³Î(NULL) °ªÀÌ ±âŸ Çü½ÄÀÇ ¿Àµð¿À¿¡ ´ëÇØ ¸®Åϵ˴ϴÙ.

¿¹

Robert SmithÀÇ MIDI ¿Àµð¿À ·¹ÄÚµù¿¡ WELCOMEÀ̶ó´Â Æ®·¢ÀÌ ÀÖ´ÂÁö ÆÇº°ÇϽʽÿÀ. ¿Àµð¿À ·¹ÄÚµùÀº employee Å×À̺íÀÇ sound Ä÷³¿¡ ÀúÀåµË´Ï´Ù.

EXEC SQL BEGIN DECLARE SECTION;
      short hvTrack;
EXEC SQL END DECLARE SECTION;
 
EXEC SQL SELECT FINDTRACKNAME(SOUND,
          'WELCOME')
      INTO :hvTrack
      FROM EMPLOYEE
      WHERE NAME = 'Robert Smith';


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