Re: Delimiters again
Posted in 1992
Paul Roberts — — source: Informix-list mailing list archive (1991-1998)
In article <8755@emory.mathcs.emory.edu> zellich@STL-07SIMA.ARMY.MIL (Rich Zellich) writes:
>How about the UNLOAD command?
>
>unload to [flatfilename]>select [whatever] from [wherever];
>
>UNLOAD writes out a dbload-format file, by default using "|" as the delimiter.
>All you need to do is prepend the "unload to filename" on the front of your
>select.
>
By the way, you can specify any charcter as the delimiter; "|" is just
the default character. flatfilename needs to go in quotes:
unload to "my_file" select [blah] from [blah_blah]
>I have no idea if UNLOAD is available for SE or Turbo; we're using Online here.
>
Yes, it works just the same on SE & Turbo.
Paul