»çÀü Á¤ÀÇµÈ Æ¯Á¤ FORTRAN µ¥ÀÌÅÍ À¯ÇüÀº µ¥ÀÌÅͺ£À̽º °ü¸® ÇÁ·Î±×·¥ Ä÷³ À¯Çü¿¡ ÇØ´çÇÕ´Ï´Ù. ÀÌ·± FORTRAN µ¥ÀÌÅÍ À¯ÇüÀº È£½ºÆ® º¯¼ö·Î ¼±¾ðÇÒ ¼ö ÀÖ½À´Ï´Ù.
Ç¥ 34´Â °¢ Ä÷³ À¯Çü¿¡ ÇØ´çÇÏ´Â FORTRAN µ¥ÀÌÅÍ À¯ÇüÀ» ³ªÅ¸³À´Ï´Ù. »çÀü ó¸® ÄÄÆÄÀÏ·¯¿¡¼ È£½ºÆ® º¯¼ö ¼±¾ðÀ» ãÀ¸¸é ÇØ´ç SQL À¯Çü °ªÀ» ÆÇº°ÇÕ´Ï´Ù. µ¥ÀÌÅͺ£À̽º °ü¸® ÇÁ·Î±×·¥¿¡¼ ÀÌ °ªÀ» »ç¿ëÇÏ¿© ÀÀ¿ëÇÁ·Î±×·¥°ú ÀÚü¿¡¼ ±³È¯µÈ µ¥ÀÌÅ͸¦ º¯È¯ÇÕ´Ï´Ù.
ÁÖ: | ¸ðµç DB2 È£½ºÆ® ¾ð¾î¿¡¼ DATALINK µ¥ÀÌÅÍ À¯Çü¿¡ ´ëÇÑ È£½ºÆ® º¯¼ö Áö¿øÀº ¾ø½À´Ï´Ù. |
Ç¥ 34. FORTRAN ¼±¾ð¿¡ ¸ÊÇεǴ SQL µ¥ÀÌÅÍ À¯Çü
SQL Ä÷³ À¯Çü1 | FORTRAN µ¥ÀÌÅÍ À¯Çü | SQL Ä÷³ À¯Çü ¼³¸í |
---|---|---|
SMALLINT (500 ¶Ç´Â 501) | INTEGER*2 | ºÎÈ£ÀÖ´Â 16ºñÆ® Á¤¼ö |
INTEGER (496 ¶Ç´Â 497) | INTEGER*4 | ºÎÈ£ÀÖ´Â 32ºñÆ® Á¤¼ö |
REAL2 (480 ¶Ç´Â 481) | REAL*4 | ´ÜÁ¤¹Ð ºÎµ¿ ¼Ò¼öÁ¡ |
DOUBLE3 (480 ¶Ç´Â 481) | REAL*8 | ¹èÁ¤¹Ð ºÎµ¿ ¼Ò¼öÁ¡ |
DECIMAL(p,s) (484 ¶Ç´Â 485) | Á¤È®ÇÑ ÇØ´ç µ¥ÀÌÅÍ À¯Çü ¾øÀ½, REAL*8 »ç¿ë | ÆÑµÈ 10Áø¼ö |
CHAR(n) (452 ¶Ç´Â 453) | CHARACTER*n | n ±æÀÌÀÇ °íÁ¤ ±æÀÌ ¹®ÀÚ¿. ¿©±â¼ nÀÇ ¹üÀ§´Â 1 - 254. |
VARCHAR(n) (448 ¶Ç´Â 449) | SQL TYPE IS VARCHAR(n) ¿©±â¼ nÀÇ ¹üÀ§´Â 1 - 32 672 | °¡º¯ ±æÀÌ ¹®ÀÚ¿ |
LONG VARCHAR (456 ¶Ç´Â 457) | SQL TYPE IS VARCHAR(n) ¿©±â¼ nÀÇ ¹üÀ§´Â 32 673 - 32 700 | ±ä °¡º¯ ±æÀÌ ¹®ÀÚ¿ |
CLOB(n) (408 ¶Ç´Â 409) | SQL TYPE IS CLOB (n) ¿©±â¼ nÀÇ ¹üÀ§´Â 1 - 2 147 483 647 | ´ëÇü ¿ÀºêÁ§Æ®(LOB) °¡º¯ ±æÀÌ ¹®ÀÚ¿ |
CLOB À§Ä¡ ÁöÁ¤ÀÚ º¯¼ö4 (964 ¶Ç´Â 965) | SQL TYPE IS CLOB_LOCATOR | ¼¹öÀÇ CLOB ¿£ÅÍÆ¼¸¦ ½Äº°ÇÕ´Ï´Ù. |
CLOB ÆÄÀÏ ÂüÁ¶ º¯¼ö4 (920 ¶Ç´Â 921) | SQL TYPE IS CLOB_FILE | CLOB µ¥ÀÌÅ͸¦ Æ÷ÇÔÇÑ ÆÄÀÏÀÇ ¼³¸íÀÚ |
BLOB(n) (404 ¶Ç´Â 405) | SQL TYPE IS BLOB(n) ¿©±â¼ nÀÇ ¹üÀ§´Â 1 - 2 147 483 647 | ´ëÇü ¿ÀºêÁ§Æ®(LOB) °¡º¯ ±æÀÌ 2Áø ¹®ÀÚ¿ |
BLOB À§Ä¡ ÁöÁ¤ÀÚ º¯¼ö4 (960 ¶Ç´Â 961) | SQL TYPE IS BLOB_LOCATOR | ¼¹öÀÇ BLOB ¿£ÅÍÆ¼¸¦ ½Äº°ÇÕ´Ï´Ù. |
BLOB ÆÄÀÏ ÂüÁ¶ º¯¼ö4 (916 ¶Ç´Â 917) | SQL TYPE IS BLOB_FILE | BLOB µ¥ÀÌÅ͸¦ Æ÷ÇÔÇÑ ÆÄÀÏÀÇ ¼³¸íÀÚ |
DATE (384 ¶Ç´Â 385) | CHARACTER*10 | 10¹ÙÀÌÆ® ¹®ÀÚ¿ |
TIME (388 ¶Ç´Â 389) | CHARACTER*8 | 8¹ÙÀÌÆ® ¹®ÀÚ¿ |
TIMESTAMP (392 ¶Ç´Â 393) | CHARACTER*26 | 26¹ÙÀÌÆ® ¹®ÀÚ¿ |
´ÙÀ½Àº Áö¿øµÇ´Â °¢ µ¥ÀÌÅÍ À¯Çü¿¡ ´ëÇØ ¼±¾ðµÈ È£½ºÆ® º¯¼ö¸¦ Æ÷ÇÔÇÑ »ùÇà SQL ¼±¾ð ÀýÀÔ´Ï´Ù.
EXEC SQL BEGIN DECLARE SECTION INTEGER*2 AGE /26/ INTEGER*4 DEPT REAL*4 BONUS REAL*8 SALARY CHARACTER MI CHARACTER*112 ADDRESS SQL TYPE IS VARCHAR (512) DESCRIPTION SQL TYPE IS VARCHAR (32000) COMMENTS SQL TYPE IS CLOB (1M) CHAPTER SQL TYPE IS CLOB_LOCATOR CHAPLOC SQL TYPE IS CLOB_FILE CHAPFL SQL TYPE IS BLOB (1M) VIDEO SQL TYPE IS BLOB_LOCATOR VIDLOC SQL TYPE IS BLOB_FILE VIDFL CHARACTER*10 DATE CHARACTER*8 TIME CHARACTER*26 TIMESTAMP INTEGER*2 WAGE_IND EXEC SQL END DECLARE SECTION
´ÙÀ½Àº Áö¿øµÇ´Â FORTRAN µ¥ÀÌÅÍ À¯Çü¿¡ ´ëÇÑ Ãß°¡ ±ÔÄ¢ÀÔ´Ï´Ù.