SQL1247

[shsandeep]

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.

[Kiran Nair]

Hi,
Just to get context of this error. What kind of API in DataStage are
you using to do the same ?
Are you using the any transaction managers for the same ?
I am not sure if DATASTAGE it self has a transaction manager. If so you
can try
set client connect 2 syncpoint twophase

[shsandeep]

One thing I forgot to mention was that this error comes up only when trying
to load tables that have 168 columns.
Any clue what is going on??

Cheers,
San.