import and exporting problems...

[Craig Longman]

i am having some trouble understanding the import, export and load
commands. i have some data that includes a bunch of text that often
contains newlines in it.

how do i do this? i have tried simply exporting a table that already
has a row or two that have LFs in them, but the import and load command
will both fail on that exact file just exported? kind of makes it hard
to figure out what to do. i have tried escaping it with backslashes,
converting to \0x0a and \x0a, none of which seemed to make an iota of
difference.

also, one of the places i'm exporting from ( sybase ) seems to insist on
using the single char as a text delimiter. the docs for load say i can
specify a character delimiter with the 'CHARDEL option', but i can find
no reference to how to specify that option to the load command. does it
have to go into a special file that is used as a template?

thanks,

CraigL->Thx();

[Mike Wang]

Hi Craig,

You may try the option 'delprioritychar', such as
load from ??? of del modified by delprioritychar ....

Good luck,
Mike Wang

"Craig Longman" <cra...@begeek.com> wrote in message
news:39F53AE0...@begeek.com...