Hi Rüdiger,
> [Rüdiger Mähl wrote]
> Subject: quotation marks (WAS: empty strings in repmcli)
>
>
> I had some difficulties with empty strings in data that
> was to be processed by the repmcli (7.3.0.15) and now
> after upgrading to 7.3.0.18 the repmcli processes the
> data without complaining, but the fields now contain
> the last " (quotation marks) and null becomes a nice
> (but unwanted) string.
>
> [data snipped]
>
> Any suggestions?
>
> Rüdiger
>
I may only guess that your table
consists of one single column defined as char(X). There
is a known bug in repman that prevents it from removing
the last quotation marks from the data if it consists of
a single column. It will be solved with the next release.
You could workaround this using a statement that defines
an empty delimiter like this
dataload table <table name>
<col name> 1
infile <file name> ... delimiter ''
Prerequisite is to have the data without the delimiter.
I'm really sorry for this inconvenience.
Regards,
Steffen
