From: Justin on

When running an export:

export to css.ixf of ixf select css_id, service, client_id, site_id,
css_label, css_abbr, sos_flag, city, state, 'N', 'N' from
userid.css_defn

It returns an error: SQL27984W Some information has not been saved to
the PC/IXF file during Export. This file will not be supported in
Import CREATE mode. Reason code="7".

Reason code 7 states: 7 Action strings other than 'SELECT * FROM
<TABLE-NAME>' are not supported.

Is this related to the data? Because we have run this statement in
the past without this error.


From: w.l.fischer on
On Sep 19, 2:30 pm, Justin <kfw...(a)hotmail.com> wrote:
> When running an export:
>
> export to css.ixf of ixf select css_id, service, client_id, site_id,
> css_label, css_abbr, sos_flag, city,          state, 'N', 'N' from
> userid.css_defn
>
> It returns an error:  SQL27984W Some information has not been saved to
> the PC/IXF file during Export. This file will not be supported in
> Import CREATE mode. Reason code="7".
>
> Reason code 7 states:  7 Action strings other than 'SELECT * FROM
> <TABLE-NAME>' are not supported.
>
> Is this related to the data?  Because we have run this statement in
> the past without this error.

I believe it is related to re-creating the table with import from ...
replace_create. In that case, you wouldn't have to worry, as you're
only interested in the data.