By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,558 Members | 1,068 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,558 IT Pros & Developers. It's quick & easy.

SQL1247

P: n/a
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.

Apr 26 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

Apr 26 '06 #2

P: n/a
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.

Apr 28 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.