AIX | HP-UX | OS/2 | OS/390 | OS/400 | SCO | SUN | Win NT |
X | X | X | X | X | X | X | X |
¸ñÀû
Å×ÀÌºí º¯¼ö ¸ñÂ÷¸¦ ÆÄÀÏ ³¡¿¡ ±â·ÏÇÕ´Ï´Ù.
Çü½Ä
@DTWF_APPEND(filename, transform, delimiter, table, retry, rows)
°ª
ÀÚ·á À¯Çü | ¸Å°³º¯¼ö | »ç¿ë | ¼³¸í |
---|---|---|---|
¹®ÀÚ¿ | ÆÄÀϸí | INOUT | º¯¼öÀÇ ³»¿ëÀÌ Ãß°¡µÇ´Â ÆÄÀÏÀÇ À̸§. ¼º°øÀûÀΠȣÃâ ¿Ï·á ÈÄ¿¡ ÀÌ ¸Å°³º¯¼ö´Â ¿ÏÀüÇÑ ÆÄÀϸíÀ» ¸®ÅÏÇÕ´Ï´Ù. |
¹®ÀÚ¿ | transform | IN | ÆÄÀÏÀÇ Çü½ÄÀº ´ÙÀ½°ú °°½À´Ï´Ù.
|
¹®ÀÚ¿ | ºÐ¸®¹®ÀÚ | IN | °ªÀÇ ³¡À» Ç¥½ÃÇÏ´Â ¹®ÀÚ¿. ÀÌ ¸Å°³º¯¼ö´Â ´ë¼Ò¹®ÀÚ¸¦ ±¸ºÐÇÕ´Ï´Ù. transformÀÌ ASCIITEXTÀÎ °æ¿ì ¹«½ÃµË´Ï´Ù. |
Å×À̺í | table | IN | ·¹Äڵ带 ÀÐ¾î µéÀÌ´Â Å×ÀÌºí º¯¼ö. |
Á¤¼ö | Àç½Ãµµ | IN | ÆÄÀÏÀ» Áï½Ã ÷ºÎÇÒ ¼ö ¾ø´Â °æ¿ì, Àç½Ãµµ Ƚ¼ö. »ý·«½Ã, Àç½Ãµµ¸¦ ÇÏÁö ¾Ê½À´Ï´Ù. |
Á¤¼ö | rows | IN | ÷ºÎÇÒ Å×À̺íÀÇ ÃÖ´ë Çà ¼ö. »ý·«½Ã, ¸ðµç ÇàÀ» ÷ºÎÇÕ´Ï´Ù. 0À» ÁöÁ¤ÇÏ¸é ¸ðµç ÇàÀ» ÷ºÎÇÕ´Ï´Ù. |
¿¹
¿¹Á¦ 1:
%DEFINE { myFile = "c:/private/myfile" myTable = %TABLE %} @DTWF_APPEND(myFile, "DELIMITED", " ;", myTable)
¿¹Á¦ 2:
%DEFINE { myFile = "c:/private/myfile" myTable = %TABLE %} @DTWF_APPEND(myFile, "ASCIITEXT", " ;", myTable)
¿¹Á¦ 3:
%DEFINE { myFile = "c:/private/myfile" myTable = %TABLE %} @DTWF_APPEND(myFile, "ASCIITEXT", " ;", myTable, "0", "10")
AIX | HP-UX | OS/2 | OS/390 | OS/400 | SCO | SUN | Win NT |
X | X | X | X | X | X | X | X |
¸ñÀû
DTWF_OPEN·Î ¿¸° ÆÄÀÏÀ» ´Ý½À´Ï´Ù.
Çü½Ä
@DTWF_CLOSE(filename, retry)
°ª
ÀÚ·á À¯Çü | ¸Å°³º¯¼ö | »ç¿ë | ¼³¸í |
---|---|---|---|
¹®ÀÚ¿ | ÆÄÀϸí | INOUT | ´ÝÀ» ÆÄÀϸí. ¼º°øÀûÀΠȣÃâ ¿Ï·á ÈÄ¿¡ ÀÌ ¸Å°³º¯¼ö´Â ¿ÏÀüÇÑ ÆÄÀϸíÀ» ¸®ÅÏÇÕ´Ï´Ù. |
Á¤¼ö | Àç½Ãµµ | IN | ÆÄÀÏÀ» Áï½Ã ´ÝÀ» ¼ö ¾ø´Â °æ¿ì Àç½ÃµµµÇ´Â Ƚ¼ö. »ý·«½Ã °ªÀº Àç½Ãµµ¸¦ ÇÏÁö ¾Ê´Â °ÍÀÔ´Ï´Ù. |
¿¹
¿¹Á¦ 1:
@DTWF_CLOSE(myFile, "5")
AIX | HP-UX | OS/2 | OS/390 | OS/400 | SCO | SUN | Win NT |
X | X | X | X | X | X | X | X |
¸ñÀû
ÆÄÀÏ¿¡¼ ·¹Äڵ带 »èÁ¦ÇÕ´Ï´Ù. (ºó ÆÄÀÏÀº »èÁ¦ÇÏÁö ¾Ê½À´Ï´Ù. )
Çü½Ä
@DTWF_DELETE(filename, transform, delimiter, retry, rows, startrow)
°ª
ÀÚ·á À¯Çü | ¸Å°³º¯¼ö | »ç¿ë | ¼³¸í |
---|---|---|---|
¹®ÀÚ¿ | ÆÄÀϸí | INOUT | ·¹Äڵ带 »èÁ¦ÇÒ ÆÄÀϸí. ¼º°øÀûÀΠȣÃâ ¿Ï·á ÈÄ¿¡ ÀÌ ¸Å°³º¯¼ö´Â ¿ÏÀüÇÑ ÆÄÀϸíÀ» ¸®ÅÏÇÕ´Ï´Ù. |
¹®ÀÚ¿ | transform | IN | ÆÄÀÏÀÇ Çü½ÄÀº ´ÙÀ½°ú °°½À´Ï´Ù.
|
¹®ÀÚ¿ | ºÐ¸®¹®ÀÚ | IN | °ªÀÇ ³¡À» Ç¥½ÃÇÏ´Â ¹®ÀÚ¿. ÀÌ ¸Å°³º¯¼ö´Â ´ë¼Ò¹®ÀÚ¸¦ ±¸ºÐÇÕ´Ï´Ù. transformÀÌ ASCIITEXTÀÎ °æ¿ì ¹«½ÃµË´Ï´Ù. |
Á¤¼ö | Àç½Ãµµ | IN | ·¹Äڵ带 Áï½Ã »èÁ¦ÇÒ ¼ö ¾ø´Â °æ¿ì Àç½ÃµµµÇ´Â Ƚ¼ö. »ý·«½Ã °ªÀº Àç½Ãµµ¸¦ ÇÏÁö ¾Ê´Â °ÍÀÔ´Ï´Ù. |
Á¤¼ö | rows | IN | »èÁ¦ÇÒ ÃÖ´ë Çà ¼ö. »ý·«½Ã °ªÀº ¸ðµç ÇàÀ» »èÁ¦ÇÏ´Â °ÍÀÔ´Ï´Ù. 0À» ÁöÁ¤ÇÏ¸é ¸ðµç ÇàÀÌ »èÁ¦µË´Ï´Ù. |
Á¤¼ö | startrow | INOUT | »èÁ¦¸¦ ½ÃÀÛÇÒ Çà ¹øÈ£. °ª 1Àº ù¹øÂ° Çà¿¡¼ »èÁ¦°¡ ½ÃÀÛµÊÀ» ÀǹÌÇÕ´Ï´Ù. ÀÌ °ªÀÌ ÆÄÀÏÀÇ Àüü Çà ¼öº¸´Ù Å« °æ¿ì, ¸¶Áö¸· ·¹ÄÚµå·Î °ªÀÌ º¯°æµÇ°í ¿À·ù°¡ ¹ß»ýÇÕ´Ï´Ù. »ý·«½Ã, 1¿¡¼ ½ÃÀÛÇÕ´Ï´Ù. |
¿¹
¿¹Á¦ 1:
%DEFINE { myFile = "c:/private/myfile" myTable = %TABLE myWait = "5000" myRows = "2" %} @DTWF_DELETE(myFile, "Delimited", "|", myWait, myRows)
¿¹Á¦ 2:
%DEFINE { myFile = "c:/private/myfile" myTable = %TABLE myStart = "1" myRows = "2" %} @DTWF_DELETE(myFile, "Asciitext", "|", "0", myRows, myStart)
AIX | HP-UX | OS/2 | OS/390 | OS/400 | SCO | SUN | Win NT |
X | X | X | X | X | X | X | X |
¸ñÀû
·¹Äڵ带 ÆÄÀÏ¿¡ »ðÀÔÇÕ´Ï´Ù.
Çü½Ä
@DTWF_INSERT(filename, transform, delimiter, table, retry, rows, startrow)
°ª
ÀÚ·á À¯Çü | ¸Å°³º¯¼ö | »ç¿ë | ¼³¸í |
---|---|---|---|
¹®ÀÚ¿ | ÆÄÀϸí | INOUT | ·¹Äڵ带 »ðÀÔÇÒ ÆÄÀϸí. ¼º°øÀûÀΠȣÃâ ¿Ï·á ÈÄ¿¡ ÀÌ ¸Å°³º¯¼ö´Â ¿ÏÀüÇÑ ÆÄÀϸíÀ» ¸®ÅÏÇÕ´Ï´Ù. |
¹®ÀÚ¿ | transform | IN | ÆÄÀÏÀÇ Çü½ÄÀº ´ÙÀ½°ú °°½À´Ï´Ù.
|
¹®ÀÚ¿ | ºÐ¸®¹®ÀÚ | IN | °ªÀÇ ³¡À» Ç¥½ÃÇÏ´Â ¹®ÀÚ¿. ÀÌ ¸Å°³º¯¼ö´Â ´ë¼Ò¹®ÀÚ¸¦ ±¸ºÐÇÕ´Ï´Ù. transformÀÌ ASCIITEXTÀÎ °æ¿ì ¹«½ÃµË´Ï´Ù. |
Å×À̺í | table | IN | Å×ÀÌºí¿¡ ·¹Äڵ带 »ðÀÔÇÒ Å×ÀÌºí º¯¼ö. |
Á¤¼ö | Àç½Ãµµ | IN | ÆÄÀÏ¿¡ Áï½Ã ±â·ÏÇÒ ¼ö ¾ø´Â °æ¿ì Àç½ÃµµµÇ´Â Ƚ¼ö. »ý·«½Ã, Àç½Ãµµ¸¦ ÇÏÁö ¾Ê½À´Ï´Ù. |
Á¤¼ö | rows | IN | Å×À̺í·ÎºÎÅÍ »ðÀÔÇÒ ÃÖ´ë Çà ¼ö. »ý·«½Ã, ¸ðµç ÇàÀ» »ðÀÔÇÕ´Ï´Ù. °ª 0Àº ¸ðµç ÇàÀ» »ðÀÔÇÕ´Ï´Ù. |
Á¤¼ö | startrow | INOUT | »ðÀÔÀ» ½ÃÀÛÇÒ Çà ¹øÈ£. 1À» ÁöÁ¤Çϸé ù¹øÂ° Çà¿¡¼ »ðÀÔÀÌ ½ÃÀ۵˴ϴÙ. ÀÌ °ªÀÌ ÆÄÀÏÀÇ Àüü Çà ¼öº¸´Ù Å« °æ¿ì, ¸¶Áö¸· ·¹ÄÚµå·Î °ªÀÌ º¯°æµÇ°í ¿À·ù°¡ ¹ß»ýÇÕ´Ï´Ù. »ý·«½Ã, 1¿¡¼ ½ÃÀÛÇÕ´Ï´Ù. |
¿¹
¿¹Á¦ 1:
%DEFINE { myFile = "c:/private/myfile" myTable = %TABLE myWait = "3000" %} @DTWF_INSERT(myFile, "Delimited", "|", myTable, myWait)
¿¹Á¦ 2:
%DEFINE { myFile = "c:/private/myfile" myTable = %TABLE myStart = "1" myRows = "2" %} @DTWF_INSERT(myFile, "Asciitext", "|", myTable, "0", myRows, myStart)
AIX | HP-UX | OS/2 | OS/390 | OS/400 | SCO | SUN | Win NT |
X | X | X | X | X | X | X | X |
¸ñÀû
ÆÄÀÏÀ» ¸í½ÃÀûÀ¸·Î ¿±´Ï´Ù. DTWF_OPEN´Â ÆÄÀÏÀ» ¿¸° »óÅ·ΠÀ¯ÁöÇÏ¸ç ±×·¸Áö ¾ÊÀº °æ¿ì °¢ Ç÷§ ÆÄÀÏ Á¶ÀÛ ÈÄ¿¡ ÆÄÀÏÀ» ´Ý½À´Ï´Ù.
¼º´É ÆÁ: ÆÄÀÏÀ» ¿©´Â Ƚ¼ö¸¦ ÁÙÀÌ·Á¸é DTWF_OPENÀ» »ç¿ëÇϽʽÿÀ.
ÆÄÀÏÀº DTWF_CLOSE¸¦ »ç¿ëÇÏ¿© ´Ý°Å³ª ¸ÅÅ©·Î 󸮰¡ ¿Ï·áµÉ ¶§±îÁö ¿¸° »óŸ¦ À¯ÁöÇÕ´Ï´Ù.
Çü½Ä
@DTWF_OPEN(filename, mode, retry)
°ª
ÀÚ·á À¯Çü | ¸Å°³º¯¼ö | »ç¿ë | ¼³¸í |
---|---|---|---|
¹®ÀÚ¿ | ÆÄÀϸí | INOUT | ¿ ÆÄÀϸí. ¼º°øÀûÀΠȣÃâ ¿Ï·á ÈÄ¿¡ ÀÌ ¸Å°³º¯¼ö´Â ¿ÏÀüÇÑ ÆÄÀϸíÀ» ¸®ÅÏÇÕ´Ï´Ù. |
¹®ÀÚ¿ | ¸ðµå | IN | ¿äûµÇ´Â ¾×¼¼½º À¯ÇüÀº ´ÙÀ½°ú °°½À´Ï´Ù.
|
Á¤¼ö | Àç½Ãµµ | IN | ÆÄÀÏÀ» Áï½Ã ¿ ¼ö ¾ø´Â °æ¿ì Àç½Ãµµ Ƚ¼ö. »ý·«½Ã, Àç½Ãµµ¸¦ ÇÏÁö ¾Ê½À´Ï´Ù. |
¿¹
¿¹Á¦ 1:
%DEFINE { myFile = "c:/private/myfile" myMode = "r+" %} @DTWF_OPEN(myFile, myMode, "1000")
AIX | HP-UX | OS/2 | OS/390 | OS/400 | SCO | SUN | Win NT |
X | X | X | X | X | X | X | X |
¸ñÀû
ÆÄÀÏ¿¡¼ Å×ÀÌºí º¯¼ö·Î ·¹Äڵ带 Àоî¿É´Ï´Ù.
Çü½Ä
@DTWF_READ(filename, transform, delimiter, table, retry, rows, startrow, columns)
°ª
ÀÚ·á À¯Çü | ¸Å°³º¯¼ö | »ç¿ë | ¼³¸í |
---|---|---|---|
¹®ÀÚ¿ | ÆÄÀϸí | INOUT | Å×ÀÌºí º¯¼ö·Î ·¹Äڵ带 ÀÐÀ» ÆÄÀϸí. ¼º°øÀûÀΠȣÃâ ¿Ï·á ÈÄ¿¡ ÀÌ ¸Å°³º¯¼ö´Â ¿ÏÀüÇÑ ÆÄÀϸíÀ» ¸®ÅÏÇÕ´Ï´Ù. |
¹®ÀÚ¿ | transform | IN | ÆÄÀÏÀÇ Çü½ÄÀº ´ÙÀ½°ú °°½À´Ï´Ù.
|
¹®ÀÚ¿ | ºÐ¸®¹®ÀÚ | IN | °ªÀÇ ³¡À» Ç¥½ÃÇÏ´Â ¹®ÀÚ¿. ÀÌ ¸Å°³º¯¼ö´Â ´ë¼Ò¹®ÀÚ¸¦ ±¸ºÐÇÕ´Ï´Ù. transformÀÌ ASCIITEXTÀÎ °æ¿ì ¹«½ÃµË´Ï´Ù. |
Å×À̺í | table | OUT | ÆÄÀÏ ·¹Äڵ带 ÀÐ¾î ³ÖÀ» Å×ÀÌºí º¯¼ö. |
Á¤¼ö | Àç½Ãµµ | IN | ÆÄÀÏÀ» Áï½Ã ÀÐÀ» ¼ö ¾ø´Â °æ¿ì, Àç½Ãµµ Ƚ¼ö. »ý·«½Ã, Àç½Ãµµ¸¦ ÇÏÁö ¾Ê½À´Ï´Ù. |
Á¤¼ö | rows | INOUT | Å×À̺í·Î ÀоîµéÀÏ ÆÄÀÏ ·¹ÄÚµåÀÇ ÃÖ´ë ¼ö. »ý·«½Ã, ¸ðµç ·¹Äڵ带 Àаųª, Å×À̺íÀÌ ²Ë Âû¶§±îÁö ÀнÀ´Ï´Ù. °ª 0Àº ÆÄÀÏ ³¡±îÁö Àд °ÍÀ» ÀǹÌÇÕ´Ï´Ù. °á°ú Å×À̺íÀÇ Çà ¼ö°¡ ¸®Åϵ˴ϴÙ. |
Á¤¼ö | startrow | IN | Àб⸦ ½ÃÀÛÇÒ ÆÄÀÏÀÇ ·¹ÄÚµå. »ý·«½Ã, ù¹øÂ° ·¹Äڵ忡¼ Àб⠽ÃÀÛÇÕ´Ï´Ù. |
Á¤¼ö | Ä÷³ | OUT | Å×À̺íÀÇ Ä÷³ ¼ö¸¦ ¸®ÅÏÇÕ´Ï´Ù. |
¿¹
¿¹Á¦ 1:
%DEFINE { myFile = "c:/private/myfile" myTable = %TABLE myWait = "1000" %} @DTWF_READ(myFile, "DELIMITED", ";", myTable, myWait)
¿¹Á¦ 2:
%DEFINE { myFile = "c:/private/myfile" myTable = %TABLE myWait = "0" myRows = "0" myStartrow = "1" myColumns = "" %} @DTWF_READ(myFile, "DELIMITED", ";", myTable, myWait, myRows, myStartrow, myColumns)
¿¹Á¦ 3:
%DEFINE { myFile = "c:/private/myfile" myTable = %TABLE %} @DTWF_READ(myFile, "ASCIITEXT", ";", myTable, myColumns) @DTW_TB_TABLE(myTable,"BORDER","")
AIX | HP-UX | OS/2 | OS/390 | OS/400 | SCO | SUN | Win NT |
X | X | X | X | X | X | X | X |
¸ñÀû
Àüü ÆÄÀÏÀ» »èÁ¦ÇÕ´Ï´Ù.
Çü½Ä
@DTWF_REMOVE(filename, retry)
°ª
ÀÚ·á À¯Çü | ¸Å°³º¯¼ö | »ç¿ë | ¼³¸í |
---|---|---|---|
¹®ÀÚ¿ | ÆÄÀϸí | INOUT | »èÁ¦ÇÒ ÆÄÀϸí. ¼º°øÀûÀΠȣÃâ ¿Ï·á ÈÄ¿¡ ÀÌ ¸Å°³º¯¼ö´Â ¿ÏÀüÇÑ ÆÄÀϸíÀ» ¸®ÅÏÇÕ´Ï´Ù. |
Á¤¼ö | Àç½Ãµµ | IN | ÆÄÀÏÀ» Áï½Ã »èÁ¦ÇÒ ¼ö ¾ø´Â °æ¿ì Àç½Ãµµ Ƚ¼ö. »ý·«½Ã, Àç½Ãµµ¸¦ ÇÏÁö ¾Ê½À´Ï´Ù. |
¿¹
¿¹Á¦ 1:
%DEFINE myFile = "c:/private/myfile" @DTWF_REMOVE(myFile)
¿¹Á¦ 2:
%DEFINE { myFile = "c:/private/myfile" myWait = "2000" %} @DTWF_REMOVE(myFile, myWait)
AIX | HP-UX | OS/2 | OS/390 | OS/400 | SCO | SUN | Win NT |
X | X | X | X | X | X | X | X |
¸ñÀû
Å×ÀÌºí º¯¼ö·Î ¹®ÀÚ¿ Ž»ö °á°ú¸¦ ¸®ÅÏÇÕ´Ï´Ù.
Çü½Ä
@DTWF_SEARCH(filename, transform, delimiter, table, searchFor, retry, rows, startrow)
°ª
ÀÚ·á À¯Çü | ¸Å°³º¯¼ö | »ç¿ë | ¼³¸í |
---|---|---|---|
¹®ÀÚ¿ | ÆÄÀϸí | INOUT | Ž»öÇÒ ÆÄÀϸí. ¼º°øÀûÀΠȣÃâ ¿Ï·á ÈÄ¿¡ ÀÌ ¸Å°³º¯¼ö´Â ¿ÏÀüÇÑ ÆÄÀϸíÀ» ¸®ÅÏÇÕ´Ï´Ù. |
¹®ÀÚ¿ | transform | IN | ÆÄÀÏ Çü½ÄÀº ´ÙÀ½°ú °°½À´Ï´Ù.
|
¹®ÀÚ¿ | ºÐ¸®¹®ÀÚ | IN | °ªÀÇ ³¡À» Ç¥½ÃÇÏ´Â ¹®ÀÚ¿. ÀÌ ¸Å°³º¯¼ö´Â ´ë¼Ò¹®ÀÚ¸¦ ±¸ºÐÇÕ´Ï´Ù. transformÀÌ ASCIITEXTÀÎ °æ¿ì ¹«½ÃµË´Ï´Ù. |
Å×À̺í | table | OUT | Ž»ö °á°ú°¡ À§Ä¡ÇÒ Å×ÀÌºí º¯¼ö. transform
ÀÌ DELIMITEDÀÎ °æ¿ì ´ÙÀ½ÀÇ ¼¼ Ä÷³ÀÌ ¸®Åϵ˴ϴÙ.
|
¹®ÀÚ¿ | searchFor | IN | Ž»öÇÒ ¹®ÀÚµéÀÇ ¹®ÀÚ¿. |
Á¤¼ö | Àç½Ãµµ | IN | ÆÄÀÏÀ» Áï½Ã Ž»öÇÒ ¼ö ¾ø´Â °æ¿ì Àç½Ãµµ Ƚ¼ö. »ý·«½Ã, Àç½Ãµµ¸¦ ÇÏÁö ¾Ê½À´Ï´Ù. |
Á¤¼ö | rows | INOUT | Å×À̺í·Î ÀоîµéÀÏ ÃÖ´ë Çà ¼ö. »ý·«½Ã, ¸ðµç ÇàÀ» Àаųª Å×À̺í ÀÌ ²Ë Âû¶§±îÁö ÀнÀ´Ï´Ù. 0À» ÁöÁ¤ÇÏ¸é ÆÄÀÏ ³¡±îÁö ÀнÀ´Ï´Ù. ÀÌ ¸Å°³º¯¼ö¿¡ ÀÇÇØ °á°ú Å×À̺íÀÇ Çà ¼ö°¡ ¸®Åϵ˴ϴÙ. |
Á¤¼ö | startrow | IN | Ž»öÀ» ½ÃÀÛÇÒ ÆÄÀÏÀÇ ·¹ÄÚµå. »ý·«½Ã °ªÀº 1ÀÔ´Ï´Ù. Áï, ù¹øÂ° ·¹Äڵ忡¼ Ž»öÀ» ½ÃÀÛÇÕ´Ï´Ù. |
¿¹
¿¹Á¦ 1:
%DEFINE { myFile = "c:/private/myfile" myTable = %TABLE myWait = "1000" mySearch = "0123456789abcdef" @DTWF_SEARCH(myFile, "DELIMITED", ";", myTable, mySearch, myWait)
¿¹Á¦ 2:
%DEFINE { myFile = "c:/private/myfile" myTable = %TABLE mySearch = "answer:" myWait = "0" myRows = "0" myStartrow = "1" %} @DTWF_SEARCH(myFile, "DELIMITED", ";", myTable, mySearch, myWait, myRows, myStartrow)
AIX | HP-UX | OS/2 | OS/390 | OS/400 | SCO | SUN | Win NT |
X | X | X | X | X | X | X | X |
¸ñÀû
Å×ÀÌºí º¯¼ö·ÎºÎÅÍ ÆÄÀÏ ·¹Äڵ带 °»½ÅÇÕ´Ï´Ù.
Çü½Ä
@DTWF_UPDATE(filename, transform, delimiter, table, retry, rows, startrow)
°ª
ÀÚ·á À¯Çü | ¸Å°³º¯¼ö | »ç¿ë | ¼³¸í |
---|---|---|---|
¹®ÀÚ¿ | ÆÄÀϸí | INOUT | Å×ÀÌºí º¯¼ö·ÎºÎÅÍ ·¹Äڵ尡 °»½ÅµÇ´Â ÆÄÀϸí. ¼º°øÀûÀΠȣÃâ ¿Ï·á ÈÄ¿¡ ÀÌ ¸Å°³º¯¼ö´Â ¿ÏÀüÇÑ ÆÄÀϸíÀ» ¸®ÅÏÇÕ´Ï´Ù. |
¹®ÀÚ¿ | transform | IN | ÆÄÀÏ Çü½ÄÀº ´ÙÀ½°ú °°½À´Ï´Ù.
|
¹®ÀÚ¿ | ºÐ¸®¹®ÀÚ | IN | °ªÀÇ ³¡À» Ç¥½ÃÇÏ´Â ¹®ÀÚ¿. ÀÌ ¸Å°³º¯¼ö´Â ´ë¼Ò¹®ÀÚ¸¦ ±¸ºÐÇÕ´Ï´Ù. transformÀÌ ASCIITEXTÀÎ °æ¿ì ¹«½ÃµË´Ï´Ù. |
Å×À̺í | table | IN | ÆÄÀÏ ·¹Äڵ尡 °»½ÅµÉ ÇØ´ç Å×ÀÌºí º¯¼ö. |
Á¤¼ö | Àç½Ãµµ | IN | ÆÄÀÏ¿¡ Áï½Ã ±â·ÏÇÒ ¼ö ¾ø´Â °æ¿ì Àç½Ãµµ Ƚ¼ö. »ý·«½Ã, Àç½Ãµµ¸¦ ÇÏÁö ¾Ê½À´Ï´Ù. |
Á¤¼ö | rows | IN | Å×ÀÌºí¿¡¼ °»½ÅÇÒ ÃÖ´ë ·¹ÄÚµå ¼ö. »ý·«½Ã, ¸ðµç ·¹Äڵ带 °»½ÅÇÕ´Ï´Ù. °ª 0Àº ÆÄÀÏÀÇ ¸ðµç ÇàÀ» °»½ÅÇÏ´Â °ÍÀ» ÀǹÌÇÕ´Ï´Ù. |
Á¤¼ö | startrow | INOUT | °»½ÅÇÒ Ã¹¹øÂ° ÆÄÀÏ ·¹ÄÚµå. »ý·«½Ã °ªÀº 1ÀÔ´Ï´Ù. Áï, ÆÄÀÏÀÇ ½ÃÀÛ ºÎºÐ¿¡¼ °»½ÅÀÌ ½ÃÀ۵˴ϴÙ. ÀÌ °ªÀÌ ÆÄÀÏÀÇ Àüü ·¹ÄÚµå ¼öº¸´Ù Å« °æ¿ì, ÆÄÀÏÀÇ ¸¶Áö¸· ·¹ÄÚµå ¹øÈ£¸¦ Ç¥½ÃÇϵµ·Ï °ªÀÌ º¯°æµÇ°í ¿À·ù°¡ ¹ß»ýÇÕ´Ï´Ù. |
¿¹
¿¹Á¦ 1:
%DEFINE { myFile = "c:/private/myfile" myTable = %TABLE myWait = "1500" myRows = "2" %} @DTWF_UPDATE(myFile, "Delimited", "|", myTable, myWait, myRows)
¿¹Á¦ 2:
%DEFINE { myFile = "c:/private/myfile" myTable = %TABLE myStart = "1" myRows = "2" %} @DTWF_UPDATE(myFile, "Asciitext", "|", myTable, "0", myRows, myStart)
AIX | HP-UX | OS/2 | OS/390 | OS/400 | SCO | SUN | Win NT |
X | X | X | X | X | X | X | X |
¸ñÀû
Å×ÀÌºí º¯¼ö ¸ñÂ÷¸¦ ÆÄÀÏ¿¡ ±â·ÏÇÕ´Ï´Ù.
Çü½Ä
@DTWF_WRITE(filename, transform, delimiter, table, retry, rows, startrow)
°ª
ÀÚ·á À¯Çü | ¸Å°³º¯¼ö | »ç¿ë | ¼³¸í |
---|---|---|---|
¹®ÀÚ¿ | ÆÄÀϸí | INOUT | Å×ÀÌºí º¯¼öÀÇ ·¹Äڵ带 ±â·ÏÇÒ ÆÄÀϸí. ¼º°øÀûÀΠȣÃâ ¿Ï·á ÈÄ¿¡ ÀÌ ¸Å°³º¯¼ö´Â ¿ÏÀüÇÑ ÆÄÀϸíÀ» ¸®ÅÏÇÕ´Ï´Ù. |
¹®ÀÚ¿ | transform | IN | ÆÄÀÏ Çü½ÄÀº ´ÙÀ½°ú °°½À´Ï´Ù.
|
¹®ÀÚ¿ | ºÐ¸®¹®ÀÚ | IN | °ªÀÇ ³¡À» Ç¥½ÃÇÏ´Â ¹®ÀÚ¿. ÀÌ ¸Å°³º¯¼ö´Â ´ë¼Ò¹®ÀÚ¸¦ ±¸ºÐÇÕ´Ï´Ù. transformÀÌ ASCIITEXTÀÎ °æ¿ì ¹«½ÃµË´Ï´Ù. |
Å×À̺í | table | IN | ÇàÀ» ÆÄÀÏ·Î ¹ÝÃâÇÏ´Â µ¥ »ç¿ëµÇ´Â Å×ÀÌºí º¯¼ö. |
Á¤¼ö | Àç½Ãµµ | IN | ÆÄÀÏ¿¡ Áï½Ã ±â·ÏÇÒ ¼ö ¾ø´Â °æ¿ì Àç½Ãµµ Ƚ¼ö. »ý·«½Ã, Àç½Ãµµ¸¦ ÇÏÁö ¾Ê½À´Ï´Ù. |
Á¤¼ö | rows | IN | ±â·ÏÇÒ ÆÄÀÏ ·¹ÄÚµåÀÇ ÃÖ´ë ¼ö. »ý·«½Ã, Àüü Å×À̺íÀ» ¾¹´Ï´Ù. °ª 0Àº ÆÄÀÏ ³¡±îÁö ¸ðµç ·¹Äڵ带 ¾²´Â °ÍÀ» ÀǹÌÇÕ´Ï´Ù. |
Á¤¼ö | startrow | INOUT | ÆÄÀÏ ³»¿¡¼ ¾²±â¸¦ ½ÃÀÛÇÒ ·¹ÄÚµå ¹øÈ£. »ý·«½Ã °ªÀº 1ÀÔ´Ï´Ù. Áï, ù¹øÂ° ·¹Äڵ忡¼ ½ÃÀÛÇÕ´Ï´Ù. ÆÄÀÏ ¹üÀ§¸¦ ³Ñ¾î¼´Â °ªÀÌ ÁöÁ¤µÇ´Â °æ¿ì, ÆÄÀÏÀÇ ¸¶Áö¸· Çà¿¡ ¿À·ù°¡ ¹ß»ýÇÕ´Ï´Ù. |
¿¹
¿¹Á¦ 1:
%DEFINE { myFile = "c:/private/myfile" myTable = %TABLE %} @DTWF_WRITE(myFile, "DELIMITED", ";", myTable)
¿¹Á¦ 2:
%DEFINE { myFile = "c:/private/myfile" myTable = %TABLE %} @DTWF_WRITE(myFile, "ASCIITEXT", ";", myTable, "5000")
¿¹Á¦ 3:
%DEFINE { myFile = "c:/private/myfile" myTable = %TABLE %} @DTWF_WRITE(myFile, "ASCIITEXT", ";", myTable, "5000", "10", "50")