SAP Note 22340 - inf201 when DB6IREORG or DB6TREORG is accessed

Symptom:

Client export with tp terminates with a database error:

inf201 "A syntax error has occurred."

The affected table is DB6IREORG or DB6TREORG.

Cause and prerequisites

Tables DB6IREORG and DB6TREORG contain a field called 'DATETIME'. Under Informix, this field is reserved for the name of a data type and therefore causes the above SQL error when accessed.

Solution

Corrected in SAP Release 3.0C.

Until then:
Tables DB6IREORG and DB6TREORG are not relevant for SAP under Informix.
Therefore, you can delete them from the command file that was generated by RSCLIEXP.

Procedure:

Start 'dbaccess' as user 'informix' and call the following SQL command (replace with the name of the command file generated by RSCLIEXP):

delete from e071 where trkorr = ''
and obj_name in ('DB6IREORG', 'DB6TREORG');

You can then restart the tp export.

To avoid this error you can enter the tables DB6IREORG and DB6TREORG into an exception table to exclude them from the next RSCLIEXP client export.

You can maintain the exception table as follows:

• Run the report RSCCEXPT with the following program parameters (Transaction SE38):
  Table DB6IREORG and/or DB6TREORG
  Function U (= Update)

• You can check whether the tables have been entered correctly in the exception table by running the report RSCCEXPT once more with the parameters TAB = "*" and function = "L". The list displayed should contain entries for DB6IREORG and DB6TREORG.

Additional key words

DB6IREORG, DB6TREORG, client export, tp, inf201