ÀÀ¿ëÇÁ·Î±×·¥ °³¹ß ¾È³»¼­


FORTRAN¿¡¼­ Áö¿øµÇ´Â SQL µ¥ÀÌÅÍ À¯Çü

»çÀü Á¤ÀÇµÈ Æ¯Á¤ 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¹ÙÀÌÆ® ¹®ÀÚ¿­
Notes:
  1. SQL Ä÷³ À¯Çü ¾Æ·¡¼­ ù¹øÂ° ¼ýÀڴ ǥ½Ã±â º¯¼ö°¡ Á¦°øµÇÁö ¾ÊÀº °æ¿ì¸¦ ³ªÅ¸³»¸ç µÎ ¹øÂ° ¼ýÀڴ ǥ½Ã±â º¯¼ö°¡ Á¦°øµÈ °æ¿ì¸¦ ³ªÅ¸³À´Ï´Ù. Ç¥½Ã±â º¯¼ö´Â ³Î(NULL) °ªÀ» ³ªÅ¸³»°Å³ª Àý´ÜµÈ ¹®ÀÚ¿­ÀÇ ±æÀ̸¦ À¯ÁöÇÏ´Â µ¥ ÇÊ¿äÇÕ´Ï´Ù. À̵éÀº ÇØ´ç µ¥ÀÌÅÍ À¯Çü¿¡ ´ëÇØ SQLDAÀÇ SQLTYPE¿¡ ³ªÅ¸³ª´Â °ªÀÔ´Ï´Ù.
  2. FLOAT(n) ¿©±â¼­ 0 < n < 25´Â REALÀÇ µ¿ÀǾîÀÔ´Ï´Ù. SQLDA¿¡¼­ REAL°ú DOUBLE »çÀÌÀÇ Â÷ÀÌÁ¡Àº ±æÀÌ °ª(4 ¶Ç´Â 8)ÀÔ´Ï´Ù.
  3. ´ÙÀ½ SQL À¯ÇüÀº DOUBLEÀÇ µ¿ÀǾîÀÔ´Ï´Ù.
    • FLOAT
    • FLOAT(n) ¿©±â¼­ 24 < n < 54
    • DOUBLE PRECISION
  4. ÀÌ´Â Ä÷³ À¯ÇüÀÌ ¾Æ´Ñ È£½ºÆ® º¯¼ö À¯ÇüÀÔ´Ï´Ù.

´ÙÀ½Àº Áö¿øµÇ´Â °¢ µ¥ÀÌÅÍ À¯Çü¿¡ ´ëÇØ ¼±¾ðµÈ È£½ºÆ® º¯¼ö¸¦ Æ÷ÇÔÇÑ »ùÇà 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 µ¥ÀÌÅÍ À¯Çü¿¡ ´ëÇÑ Ãß°¡ ±ÔÄ¢ÀÔ´Ï´Ù.


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