¸í·ÉÇà 󸮱⸦ »ç¿ëÇÏ¿© DB2 ¸í·É, SQL¹®, ¿î¿µ üÁ¦ ¸í·ÉÀ» ÀÔ·ÂÇÒ ¼ö ÀÖ½À´Ï´Ù. ÀÌ´Â ´ÙÀ½°ú °°Àº ¸ðµå·Î ÀÛµ¿ÇÕ´Ï´Ù.
DB2 ¸í·É âÀ» È£ÃâÇÏ·Á¸é ´ÙÀ½°ú °°ÀÌ ÇϽʽÿÀ.
»ç¿ëÀÚ ¿î¿µ üÁ¦ ÇÁ·ÒÇÁÆ®¿¡¼ db2cmd ¸í·ÉÀ» ÀÔ·ÂÇÏ¿© DB2 ¸í·É âÀ» È£ÃâÇÒ ¼öµµ ÀÖ½À´Ï´Ù.
¸í·É âÀ» ÅëÇØ ¸í·ÉÀ» ÀÔ·ÂÇÏ´Â °æ¿ì¿¡´Â db2 Á¢µÎºÎ¸¦ ¹Ýµå½Ã Æ÷ÇÔ½ÃÄÑ¾ß ÇÕ´Ï´Ù. ¿¹¸¦ µé¸é, ´ÙÀ½°ú °°½À´Ï´Ù.
db2 list database directory
![]() | DB2 ¸í·É¿¡ »ç¿ë ÁßÀÎ ¿î¿µ üÁ¦¿¡¼ Ư¼ö Àǹ̸¦ °®´Â ¹®ÀÚ°¡ µé¾î ÀÖÀ» °æ¿ì,
Á¦´ë·Î ¼öÇàµÉ ¼ö ÀÖµµ·Ï ¸í·ÉÀ» µû¿ÈÇ¥·Î ¹¾î¼ ÀÔ·ÂÇØ¾ß ÇÕ´Ï´Ù.
¿¹¸¦ µé¸é, * ¹®ÀÚ°¡ ¿î¿µ üÁ¦¿¡¼ Ưº°ÇÑ Àǹ̸¦ °®´õ¶óµµ ´ÙÀ½ ¸í·ÉÀº employee Å×À̺íÀÇ ¸ðµç Á¤º¸¸¦ °Ë»öÇÕ´Ï´Ù. db2 "select * from employee" |
ÇÑ ÇàÀ» ¹þ¾î³ª´Â ±ä ¸í·É¾î¸¦ ÀÔ·ÂÇÏ·Á¸é ÇàÀÇ ³¡¿¡ °ø¹éÀ» ÁÖ°í Çà °è¼Ó ¹®ÀÚÀÎ "\"¸¦ ÀÔ·ÂÇØ¾ß ÇÕ´Ï´Ù. ±×·± ´ÙÀ½ Enter ۸¦ ´·¯ ´ÙÀ½ ÇàÀ¸·Î ¸í·ÉÀ» °è¼ÓÇÕ´Ï´Ù. ¿¹¸¦ µé¸é, ´ÙÀ½°ú °°½À´Ï´Ù.
db2 select empno, function, firstname, lastname, birthdate, from \ db2 (cont.) => employee where function='service' and \ db2 (cont.) => firstname='Lily' order by empno desc
´ëÈ½Ä ÀÔ·Â ¸ðµå¿¡¼ ¸í·ÉÇà 󸮱⸦ È£ÃâÇÏ·Á¸é ´ÙÀ½À» ¼öÇàÇϽʽÿÀ.
»ç¿ëÀÚ ½Ã½ºÅÛ ÇÁ·ÒÇÁÆ®¿¡¼ db2cmd ¸í·É ´ÙÀ½¿¡ db2 ¸í·ÉÀ» ÀÔ·ÂÇØµµ ´ëÈ½Ä ÀÔ·Â ¸ðµå·Î ¸í·ÉÇà 󸮱⸦ È£ÃâÇÒ ¼ö ÀÖ½À´Ï´Ù.
´ëÈ½Ä ÀÔ·Â ¸ðµå¿¡¼ ÇÁ·ÒÇÁÆ®´Â ´ÙÀ½°ú °°½À´Ï´Ù.
db2 =>
´ëÈ½Ä ÀÔ·Â ¸ðµå¿¡¼´Â db2¸¦ Á¢µÎ¾î·Î ÇÏ´Â DB2 ¸í·ÉÀº ÀÔ·ÂÇÒ Çʿ䰡 ¾øÀ¸¸ç, ´ë½Å DB2 ¸í·É¸¸ ÀÔ·ÂÇϽʽÿÀ. ¿¹¸¦ µé¸é, ´ÙÀ½°ú °°½À´Ï´Ù.
db2 => list database directory
¿î¿µ üÁ¦ ¸í·ÉÀ» ´ëÈ½Ä ¸ðµå·Î ÀÔ·ÂÇÏ·Á¸é, ¿î¿µ üÁ¦ ¸í·É ¾Õ¿¡ ´À³¦Ç¥(!)¸¦ µÎ½Ê½Ã¿À. ¿¹¸¦ µé¸é, ´ÙÀ½°ú °°½À´Ï´Ù.
db2 => !dir
ÇÑ ÇàÀ» ¹þ¾î³ª´Â ±ä ¸í·É¾î¸¦ ÀÔ·ÂÇÏ·Á¸é ÇàÀÇ ³¡¿¡ °ø¹éÀ» ÁÖ°í Çà °è¼Ó ¹®ÀÚÀÎ "\"¸¦ ÀÔ·ÂÇØ¾ß ÇÕ´Ï´Ù. ±×·± ´ÙÀ½ Enter ۸¦ ´·¯ ´ÙÀ½ ÇàÀ¸·Î ¸í·ÉÀ» °è¼ÓÇÕ´Ï´Ù. ¿¹¸¦ µé¸é, ´ÙÀ½°ú °°½À´Ï´Ù.
db2 select empno, function, firstname, lastname, birthdate, from \ db2 (cont.) => employee where function='service' and \ db2 (cont.) => firstname='Lily' order by empno desc
´ëÈ½Ä ÀÔ·Â ¸ðµå¸¦ ³¡³»·Á¸é, quit ¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ.
Command Reference¿¡¼ CLP¸¦ »ç¿ëÇÏ´Â °í±Þ ÁÖÁ¦¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀ» ÂüÁ¶ÇϽʽÿÀ.