SQL27984W - Some information has not been saved (import create mode)

[Justin]

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.

[w.l.fischer@googlemail.com]

Re: SQL27984W - Some information has not been saved (import createmode)

On Sep 19, 2:30 pm, Justin <kfw...@hotmail .comwrote:

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.