Informatica handling multiple result sets from Stored Procedure

Get new comments by email
You can cancel email alerts at anytime.
Comments (3)

MyPrecious in Des Moines, Iowa

82 months ago

Hello,

This is regarding Informatica handling result sets returned from stored procedure. I am developing a cobol-db2 stored procedure which will return a single result set or two result sets based on the request code. This SP would be invoked by an Informatica process to retrieve rows.

Can Informatica handle result set(s)? (For your information I have ZERO knowledge on informatica).

Thanks!

- Was this comment helpful? Yes / No Reply - Report abuse

priya in Hackensack, New Jersey

80 months ago

MyPrecious in Des Moines, Iowa said: Hello,

This is regarding Informatica handling result sets returned from stored procedure. I am developing a cobol-db2 stored procedure which will return a single result set or two result sets based on the request code. This SP would be invoked by an Informatica process to retrieve rows.

Can Informatica handle result set(s)? (For your information I have ZERO knowledge on informatica).

Thanks!

I dont know about DB2 but yes you can use Stored Procedure in Informatica
There is s SP Tx to do this

- Was this comment helpful? Yes / No Reply - Report abuse

babuswift in Madras, India

56 months ago

hai i babu, i am searching job on informatica, bo ,

i 2009 fesher on mca

- Was this comment helpful? Yes / No Reply - Report abuse

» Sign in or create an account to comment on this topic.