Hi,
i need to get value say empActiveNumber from SQL db,after retriving this record again i have to loop through the DB2 DB to check for the particular empactive number and get the details from db2.
For this whether can i use getrows method of recordset,does the size matters for that???..instead of retriving value from SQL and with that value i am again loopin the DB2.
please gimme suggestion how to proceed with that.

For this,

  You retrieve the empActiveNumber from SQLDB and store in a string variable seperated by commas.

Next stage,
  Issue another SQL statement using SQL IN operator to retrieve the details from the DB2 DB.

If you use for loop, there is a lot of burden on the database. If you retrieve values from the SQL DB are more, you must open the recordset that many no of times(with DB2 DB).

Hi rajani,
After retriving records from SQL dB i need to check for each record that gives differen values...

hello,
  i didnt get you. I thought that you have one-to-many/1-1 relationship b/w SQLDB and DB2 DB. What do you mean by check different values?

DB2 may have multiple records for sing active number so i cant use in operater
IN operater is like "or",It will retrive for all the values given values in the IN

Then,

  You can proceed with For...Loop
But, it will be slow if the SQL DB retrieves more numbers.

In the first post you said that you want to retrieve further info from DB2 DB from the values retrieving thru SQL DB. I thought that you def'ly have records in the DB2 DB and you want all the records corresponding to SQL DB values. Then using IN operator is best.
Eventhough its like OR but it satisfies your condition know.
You give ORDER BY clause.

after checking the DB2 with IN operator,i need to retrive the checked records from db2 and send mail for this again i have to go for loop....