I get this error SQL 1247 when trying to load data into tables from
DataStage.
I have attached the error description below but am unable to understand.
Any suggestions highly appreciated.

SQL1247
SQL1247NApplications running in an XA transaction processing environment
must use the SYNCPOINT TWOPHASE connection setting.
Explanation:
The application was precompiled with the option SYNCPOINT ONEPHASE or
SYNCPOINT NONE, or the SYNCPOINT connection setting was changed to one of
these values using the SET CLIENT API. These settings are invalid for
applications which cause transaction processing syncpoint commands (for
example CICS SYNCPOINT) to be executed. Note that SYNCPOINT ONEPHASE is
the default precompiler option.

User response:
Possible actions:

Re-precompile the application using the precompiler option SYNCPOINT
TWOPHASE.
Modify the program such that the SET CLIENT API is called to set the
connection option to SYNCPOINT TWOPHASE prior to any other processing.
sqlcode: -1247

sqlstate: 51025

Cheers,
San.