Hi all,

Can anyone please guide/help me on writing a store procedure. This is the first time I am writing a store procedure in db2.

They have provided me with a CSV file that has all the values and I have to use this values for using in each iterations listed below.

The application team has provided me with a logic that iterates through each loop and the result set of the first loop should be used in the second loop and so on 5 loops.

And for each Iteration I have to remove the duplicate values or do not add the duplicate values while iteration for each resul set.

They are asking me to use the vectors.

Any help is highly appreciated.

Thanks a lot......

DB2 Version: 8.1.1

OSLEVEL : AIX 5.3

Did you have a look at the DB2 manuals already? It contains a lot of examples on stored procedures and how to write them.

p.s: 8.1.1 is out of service.

Thanks Stolze for ur reply..

No, I did not check the DB2 Manuals. can you please guide me for the manuals where I can find them?

Thanks Again..

start here

DB2 Universal Database

Thanks Satya..