Subject detect char in external table
Author Nick Upson
I'm currently importing a load of data via external tables, using a dbproc
to perform the actual conversion to the internal table(s) for each.
Unfortunately the data file has a load of null characters at
the end. I want to do something like "select ... from externaltable where
field <> ch" but I can't work out how to express the value for ch.

cat -v shows the character as ^@, my editor (pfe) shows it \x00

Get your FREE download of MSN Explorer at