Re: Comment Lines in dbload
In article <1994Apr13.163008.26197@anasazi.com>, sandberg@anasazi.com (Mike Sandberg) writes:
|> Someone just asked me if we can have comment lines in a dbload file.
|>
|> Can we ?
|>
|> Thanks in advance.
|>
|> Michael
|> --
|> Michael Sandberg | voice 602.331.2834
|> First Data Resources/Phoenix | fax 602.331.2828
|> 7500 N. Dreamy Draw Drive, Suite 200 | email sandberg@anasazi.com
|> Phoenix, Arizona 85020 | prodigy xctb45a@prodigy.com
|> "The only thing we have to fear is fear itself" - Franklin D. Roosevelt
Yes you can.
The comment lines must be in braces as in the following excerpt from a dbload command file that I generated (from a COBOL FD using awk).
FILE "./CARCLN.DAT" (
l_order_key 1 - 20, { Bytes = 20 }
l_fo_no 1 - 13, { Bytes = 0 [ COPY ] }
l_line_item 14 - 20, { Bytes = 0 [ COPY ] }
l_supplier 21 - 23, { Bytes = 3 }
l_class 24 - 26, { Bytes = 3 }
l_prod_grp 27 - 29, { Bytes = 3 }
l_apc_cd 30 - 33, { Bytes = 4 }
....
--
Mark J. Twomey, |
Motorola B.V. | m___
Swords, | @=" )~~ Pig Out !
County Dublin, | W W
Ireland, |
Europe. email at mjt@email.mot.com +----------------------------------