472,969 Members | 1,320 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,969 software developers and data experts.


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

SQL1247NApplications running in an XA transaction processing environment
must use the SYNCPOINT TWOPHASE connection setting.
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
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


Apr 26 '06 #1
2 1471
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

Apr 26 '06 #2
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??


Apr 28 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.