top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Autocommit behavior for DB2 stored proc called from informatica powercenter

0 votes
396 views

I have a stored procedure being called from an informatica mapping. There are no manual commits inside the procedure and the procedure is created with 'COMMIT ON RETURN NO'

I can see the updates done inside the procedure being committed. I think this could be because of the auto commit setting in the Informatica Server. (And I assume the 'commit after end of file' option in the task properties does not apply to stored proc calls)

If this is the case,assuming I do not want to commit anything even if procedure completes without errors, where do I find the autocommit setting (BD2 Driver configuration/Informatica configuration) and change it?

posted Oct 31, 2014 by Sunil

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

The default setting is present in the workflow session settings under properties tab

enter image description here

answer Nov 3, 2014 by Shweta Singh
Similar Questions
+1 vote
Can I set a Parameter based on the output of a Stored Procedure in Informatica PowerCenter?

In Informatica's PowerCenter, is it possible to set a parameter's value based on the output of a stored procedure? The parameter I want to set is a parameter I defined in a flat-file data object.

+1 vote
Import data from db2 using informatica power Center without powerexchange

How to Import data from db2 table using informatica power Center without powerexchange.

0 votes
while loading data from Teradata to Oracle using informatica powercenter, we are facing special character issue

Teradata : JANUVIA - 50MG – TABLET - 1 BLISTER - 28 TABLET (28.TA) ORacle: JANUVIA - 50MG ? TABLET - 1 BLISTER - 28 TABLET (28.TA)

We are using code page 'ms windows latin 1 (ansi) superset of latin1' for source connection i.e. Teradata.

We are using code page UTF 8 for target

0 votes
Export details of workflow from Informatica Powercenter Monitor

I am new to informatica. Whenever we run any workflow its details are shown in the monitor. Everyday I need to prepare an excel report of those details manually.

I want to automate this process.

For this job I wanted to know in which file details of the workflow run are stored which are displyed by Informatica monitor. So that I can build a program which will read that file interprete the values and will create an Excel report automatically avoiding my Manual work.

Modification - By details of Workflow I mean...

The number of records which were provided as input to interface.
The number of records which were successfully processed and sent to target table.
The number of records which were rejected during the process.
The number of records which went into Exception table.
+1 vote
how to call DB2 functions in Informatica ETL?

How to call DB2 functions in Informatica ETL?

Only used views in ETL before, have no idea how to do so for the functions, anyone got any idea?

...