IBM Books

Net.Data ÂüÁ¶¼­

Ç÷§ ÆÄÀÏ ÀÎÅÍÆäÀ̽º ÇÔ¼ö

DTWF_APPEND


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)

°ª

Ç¥ 76. DTWF_APPEND ¸Å°³º¯¼ö
ÀÚ·á À¯Çü ¸Å°³º¯¼ö »ç¿ë ¼³¸í
¹®ÀÚ¿­ ÆÄÀϸí INOUT º¯¼öÀÇ ³»¿ëÀÌ Ãß°¡µÇ´Â ÆÄÀÏÀÇ À̸§. ¼º°øÀûÀΠȣÃâ ¿Ï·á ÈÄ¿¡ ÀÌ ¸Å°³º¯¼ö´Â ¿ÏÀüÇÑ ÆÄÀϸíÀ» ¸®ÅÏÇÕ´Ï´Ù.
¹®ÀÚ¿­ transform IN ÆÄÀÏÀÇ Çü½ÄÀº ´ÙÀ½°ú °°½À´Ï´Ù.

  • ASCIITEXT - Ä÷³ °ªµé »çÀÌÀÇ °³Çà ¹®ÀÚ·Î Å×À̺íÀ» ÆÄÀÏ¿¡ ¾²°í ºÐ¸®¹®ÀÚ ¸Å°³º¯¼ö¸¦ ¹«½ÃÇÕ´Ï´Ù.

  • DELIMITED - ºÐ¸®¹®ÀÚ ¸Å°³º¯¼ö¿¡ ÁöÁ¤µÈ ºÐ¸®¹®ÀÚ·Î Å×À̺íÀ» ÆÄÀÏ¿¡ ¾¹´Ï´Ù.
¹®ÀÚ¿­ ºÐ¸®¹®ÀÚ 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")

DTWF_CLOSE


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)

°ª

Ç¥ 77. DTWF_CLOSE ¸Å°³º¯¼ö
ÀÚ·á À¯Çü ¸Å°³º¯¼ö »ç¿ë ¼³¸í
¹®ÀÚ¿­ ÆÄÀϸí INOUT ´ÝÀ» ÆÄÀϸí. ¼º°øÀûÀΠȣÃâ ¿Ï·á ÈÄ¿¡ ÀÌ ¸Å°³º¯¼ö´Â ¿ÏÀüÇÑ ÆÄÀϸíÀ» ¸®ÅÏÇÕ´Ï´Ù.
Á¤¼ö Àç½Ãµµ IN ÆÄÀÏÀ» Áï½Ã ´ÝÀ» ¼ö ¾ø´Â °æ¿ì Àç½ÃµµµÇ´Â Ƚ¼ö. »ý·«½Ã °ªÀº Àç½Ãµµ¸¦ ÇÏÁö ¾Ê´Â °ÍÀÔ´Ï´Ù.

¿¹

¿¹Á¦ 1:

@DTWF_CLOSE(myFile, "5")

DTWF_DELETE


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)

°ª

Ç¥ 78. DTW_DELETE ¸Å°³º¯¼ö
ÀÚ·á À¯Çü ¸Å°³º¯¼ö »ç¿ë ¼³¸í
¹®ÀÚ¿­ ÆÄÀϸí INOUT ·¹Äڵ带 »èÁ¦ÇÒ ÆÄÀϸí. ¼º°øÀûÀΠȣÃâ ¿Ï·á ÈÄ¿¡ ÀÌ ¸Å°³º¯¼ö´Â ¿ÏÀüÇÑ ÆÄÀϸíÀ» ¸®ÅÏÇÕ´Ï´Ù.
¹®ÀÚ¿­ transform IN ÆÄÀÏÀÇ Çü½ÄÀº ´ÙÀ½°ú °°½À´Ï´Ù.

  • ASCIITEXT - Ä÷³ °ªµé »çÀÌÀÇ °³Çà ¹®ÀÚ·Î Å×À̺íÀ» ÆÄÀÏ¿¡ ¾²°í ºÐ¸®¹®ÀÚ ¸Å°³º¯¼ö¸¦ ¹«½ÃÇÕ´Ï´Ù.

  • DELIMITED - ºÐ¸®¹®ÀÚ ¸Å°³º¯¼ö¿¡ ÁöÁ¤µÈ ºÐ¸®¹®ÀÚ·Î Å×À̺íÀ» ÆÄÀÏ¿¡ ¾¹´Ï´Ù.
¹®ÀÚ¿­ ºÐ¸®¹®ÀÚ 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)

DTWF_INSERT


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)

°ª

Ç¥ 79. DTWF_INSERT ¸Å°³º¯¼ö
ÀÚ·á À¯Çü ¸Å°³º¯¼ö »ç¿ë ¼³¸í
¹®ÀÚ¿­ ÆÄÀϸí INOUT ·¹Äڵ带 »ðÀÔÇÒ ÆÄÀϸí. ¼º°øÀûÀΠȣÃâ ¿Ï·á ÈÄ¿¡ ÀÌ ¸Å°³º¯¼ö´Â ¿ÏÀüÇÑ ÆÄÀϸíÀ» ¸®ÅÏÇÕ´Ï´Ù.
¹®ÀÚ¿­ transform IN ÆÄÀÏÀÇ Çü½ÄÀº ´ÙÀ½°ú °°½À´Ï´Ù.

  • ASCIITEXT - Ä÷³ °ªµé »çÀÌÀÇ °³Çà ¹®ÀÚ·Î Å×À̺íÀ» ÆÄÀÏ¿¡ ¾²°í ºÐ¸®¹®ÀÚ ¸Å°³º¯¼ö¸¦ ¹«½ÃÇÕ´Ï´Ù.

  • DELIMITED - ºÐ¸®¹®ÀÚ ¸Å°³º¯¼ö¿¡ ÁöÁ¤µÈ ºÐ¸®¹®ÀÚ·Î Å×À̺íÀ» ÆÄÀÏ¿¡ ¾¹´Ï´Ù.
¹®ÀÚ¿­ ºÐ¸®¹®ÀÚ 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)

DTWF_OPEN


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)

°ª

Ç¥ 80. DTWF_OPEN ¸Å°³º¯¼ö
ÀÚ·á À¯Çü ¸Å°³º¯¼ö »ç¿ë ¼³¸í
¹®ÀÚ¿­ ÆÄÀϸí INOUT ¿­ ÆÄÀϸí. ¼º°øÀûÀΠȣÃâ ¿Ï·á ÈÄ¿¡ ÀÌ ¸Å°³º¯¼ö´Â ¿ÏÀüÇÑ ÆÄÀϸíÀ» ¸®ÅÏÇÕ´Ï´Ù.
¹®ÀÚ¿­ ¸ðµå IN ¿äûµÇ´Â ¾×¼¼½º À¯ÇüÀº ´ÙÀ½°ú °°½À´Ï´Ù.

  • r - Àбâ À§ÇØ ±âÁ¸ÀÇ ÆÄÀÏÀ» ¿±´Ï´Ù.

  • w - ¾²±â À§ÇØ ÆÄÀÏÀ» ÀÛ¼ºÇÕ´Ï´Ù. (°°Àº À̸§ÀÇ ÆÄÀÏÀÌ ÀÖ´Â °æ¿ì ±âÁ¸ÀÇ ÆÄÀÏÀº ¾ø¾îÁý´Ï´Ù. )

  • a - ÷ºÎÇϱâ À§ÇØ ÆÄÀÏÀ» ¿±´Ï´Ù. ÇØ´ç ÆÄÀÏÀÌ ¾ø´Â °æ¿ì Net.Data´Â ÆÄÀÏÀ» ÀÛ¼ºÇÕ´Ï´Ù.

  • r+ - ÀÐ±â ¹× ¾²±â¸¦ À§ÇØ ±âÁ¸ÀÇ ÆÄÀÏÀ» ¿±´Ï´Ù.

  • w+ - ÀÐ±â ¹× ¾²±â¸¦ À§ÇØ ÆÄÀÏÀ» ÀÛ¼ºÇÕ´Ï´Ù. (°°Àº À̸§ÀÇ ÆÄÀÏÀÌ ÀÖ´Â °æ¿ì ±âÁ¸ÀÇ ÆÄÀÏÀº ¾ø¾îÁý´Ï´Ù. )

  • a+ - ÀÐ±â ¹× Ã·ºÎ¸¦ À§ÇØ Ã·ºÎ ¸ðµå·Î ÆÄÀÏÀ» ¿±´Ï´Ù. ÇØ´ç ÆÄÀÏÀÌ ¾ø´Â °æ¿ì Net.Data´Â ÆÄÀÏÀ» ÀÛ¼ºÇÕ´Ï´Ù.
Á¤¼ö Àç½Ãµµ IN ÆÄÀÏÀ» Áï½Ã ¿­ ¼ö ¾ø´Â °æ¿ì Àç½Ãµµ Ƚ¼ö. »ý·«½Ã, Àç½Ãµµ¸¦ ÇÏÁö ¾Ê½À´Ï´Ù.

¿¹

¿¹Á¦ 1:

%DEFINE {
  myFile = "c:/private/myfile"
  myMode = "r+"
%}
@DTWF_OPEN(myFile, myMode, "1000")

DTWF_READ


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)

°ª

Ç¥ 81. DTWF_READ ¸Å°³º¯¼ö
ÀÚ·á À¯Çü ¸Å°³º¯¼ö »ç¿ë ¼³¸í
¹®ÀÚ¿­ ÆÄÀϸí INOUT Å×ÀÌºí º¯¼ö·Î ·¹Äڵ带 ÀÐÀ» ÆÄÀϸí. ¼º°øÀûÀΠȣÃâ ¿Ï·á ÈÄ¿¡ ÀÌ ¸Å°³º¯¼ö´Â ¿ÏÀüÇÑ ÆÄÀϸíÀ» ¸®ÅÏÇÕ´Ï´Ù.
¹®ÀÚ¿­ transform IN ÆÄÀÏÀÇ Çü½ÄÀº ´ÙÀ½°ú °°½À´Ï´Ù.

  • ASCIITEXT - Ä÷³ °ªµé »çÀÌÀÇ °³Çà ¹®ÀÚ·Î Å×À̺íÀ» ÆÄÀÏ¿¡ ¾²°í ºÐ¸®¹®ÀÚ ¸Å°³º¯¼ö¸¦ ¹«½ÃÇÕ´Ï´Ù.

  • DELIMITED - ºÐ¸®¹®ÀÚ ¸Å°³º¯¼ö¿¡ ÁöÁ¤µÈ ºÐ¸®¹®ÀÚ·Î Å×À̺íÀ» ÆÄÀÏ¿¡ ¾¹´Ï´Ù.
¹®ÀÚ¿­ ºÐ¸®¹®ÀÚ 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","")

DTWF_REMOVE


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)

°ª

Ç¥ 82. DTW_REMOVE ¸Å°³º¯¼ö
ÀÚ·á À¯Çü ¸Å°³º¯¼ö »ç¿ë ¼³¸í
¹®ÀÚ¿­ ÆÄÀϸí INOUT »èÁ¦ÇÒ ÆÄÀϸí. ¼º°øÀûÀΠȣÃâ ¿Ï·á ÈÄ¿¡ ÀÌ ¸Å°³º¯¼ö´Â ¿ÏÀüÇÑ ÆÄÀϸíÀ» ¸®ÅÏÇÕ´Ï´Ù.
Á¤¼ö Àç½Ãµµ IN ÆÄÀÏÀ» Áï½Ã »èÁ¦ÇÒ ¼ö ¾ø´Â °æ¿ì Àç½Ãµµ Ƚ¼ö. »ý·«½Ã, Àç½Ãµµ¸¦ ÇÏÁö ¾Ê½À´Ï´Ù.

¿¹

¿¹Á¦ 1:

%DEFINE myFile = "c:/private/myfile"
@DTWF_REMOVE(myFile)

¿¹Á¦ 2:

%DEFINE {
  myFile = "c:/private/myfile"
  myWait = "2000"
%}
@DTWF_REMOVE(myFile, myWait)

DTWF_SEARCH


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)

°ª

Ç¥ 83. DTWF_SEARCH ¸Å°³º¯¼ö
ÀÚ·á À¯Çü ¸Å°³º¯¼ö »ç¿ë ¼³¸í
¹®ÀÚ¿­ ÆÄÀϸí INOUT Ž»öÇÒ ÆÄÀϸí. ¼º°øÀûÀΠȣÃâ ¿Ï·á ÈÄ¿¡ ÀÌ ¸Å°³º¯¼ö´Â ¿ÏÀüÇÑ ÆÄÀϸíÀ» ¸®ÅÏÇÕ´Ï´Ù.
¹®ÀÚ¿­ transform IN ÆÄÀÏ Çü½ÄÀº ´ÙÀ½°ú °°½À´Ï´Ù.

  • ASCIITEXT - Ä÷³ °ªµé »çÀÌÀÇ °³Çà ¹®ÀÚ·Î Å×À̺íÀ» ÆÄÀÏ¿¡ ¾²°í ºÐ¸®¹®ÀÚ ¸Å°³º¯¼ö¸¦ ¹«½ÃÇÕ´Ï´Ù.

  • DELIMITED - ºÐ¸®¹®ÀÚ ¸Å°³º¯¼ö¿¡ ÁöÁ¤µÈ ºÐ¸®¹®ÀÚ·Î Å×À̺íÀ» ÆÄÀÏ¿¡ ¾¹´Ï´Ù.
¹®ÀÚ¿­ ºÐ¸®¹®ÀÚ 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)

DTWF_UPDATE


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)

°ª

Ç¥ 84. DTWF_UPDATE ¸Å°³º¯¼ö
ÀÚ·á À¯Çü ¸Å°³º¯¼ö »ç¿ë ¼³¸í
¹®ÀÚ¿­ ÆÄÀϸí INOUT Å×ÀÌºí º¯¼ö·ÎºÎÅÍ ·¹Äڵ尡 °»½ÅµÇ´Â ÆÄÀϸí. ¼º°øÀûÀΠȣÃâ ¿Ï·á ÈÄ¿¡ ÀÌ ¸Å°³º¯¼ö´Â ¿ÏÀüÇÑ ÆÄÀϸíÀ» ¸®ÅÏÇÕ´Ï´Ù.
¹®ÀÚ¿­ transform IN ÆÄÀÏ Çü½ÄÀº ´ÙÀ½°ú °°½À´Ï´Ù.

  • ASCIITEXT - Ä÷³ °ªµé »çÀÌÀÇ °³Çà ¹®ÀÚ·Î Å×À̺íÀ» ÆÄÀÏ¿¡ ¾²°í ºÐ¸®¹®ÀÚ ¸Å°³º¯¼ö¸¦ ¹«½ÃÇÕ´Ï´Ù.

  • DELIMITED - ºÐ¸®¹®ÀÚ ¸Å°³º¯¼ö¿¡ ÁöÁ¤µÈ ºÐ¸®¹®ÀÚ·Î Å×À̺íÀ» ÆÄÀÏ¿¡ ¾¹´Ï´Ù.
¹®ÀÚ¿­ ºÐ¸®¹®ÀÚ 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)

DTWF_WRITE


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)

°ª

Ç¥ 85. DTWF_WRITE ¸Å°³º¯¼ö
ÀÚ·á À¯Çü ¸Å°³º¯¼ö »ç¿ë ¼³¸í
¹®ÀÚ¿­ ÆÄÀϸí INOUT Å×ÀÌºí º¯¼öÀÇ ·¹Äڵ带 ±â·ÏÇÒ ÆÄÀϸí. ¼º°øÀûÀΠȣÃâ ¿Ï·á ÈÄ¿¡ ÀÌ ¸Å°³º¯¼ö´Â ¿ÏÀüÇÑ ÆÄÀϸíÀ» ¸®ÅÏÇÕ´Ï´Ù.
¹®ÀÚ¿­ transform IN ÆÄÀÏ Çü½ÄÀº ´ÙÀ½°ú °°½À´Ï´Ù.

  • ASCIITEXT - Ä÷³ °ªµé »çÀÌÀÇ °³Çà ¹®ÀÚ·Î Å×À̺íÀ» ÆÄÀÏ¿¡ ¾²°í ºÐ¸®¹®ÀÚ ¸Å°³º¯¼ö¸¦ ¹«½ÃÇÕ´Ï´Ù.

  • DELIMITED - ºÐ¸®¹®ÀÚ ¸Å°³º¯¼ö¿¡ ÁöÁ¤µÈ ºÐ¸®¹®ÀÚ·Î Å×À̺íÀ» ÆÄÀÏ¿¡ ¾¹´Ï´Ù.
¹®ÀÚ¿­ ºÐ¸®¹®ÀÚ 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")


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