Help T-SQL Server developer lost trying to implement some simple
cursor logic!

I need to create a "table object (variable)" OR "TEMP variable" OR
"create and drop a table in a procedure" in DB2 to eliminate duplicate
records from my  query.

In the procedure I simply want to insert unique rows into this
temporary table ... using a cursor to insert distinct rows by using
the (FETCH FIRST 1 ROW ONLY) and (ORDER BY) clauses; into my result
set. I know this can be done with a group by but the code gets too
messy(and the qery becomes inefficient) (also a temp table would make
sense ince the result set is less than a 100 rows out of millions of
records), and the data keeps changing so I'm not certain what the
distinct field is.

Can anyone help with code or pseud-code or link to a good tutorial. I
cannot find simple db2 cursor examples or examples on how to create
temporary tables or global variables. Please help!

My code in T-SQL would look like:

**************************************************************************
create procedure returnUniqueMasterRecords
as

insert into #distinct_Data
select * from  dbo.Master_SRC_With_Dups where Master_Id in
(select Master_Id  from dbo.Master_SRC_With_Dups
group by Master_Id
having count(*) =1)

declare @Var_ID varchar(30)

DECLARE MasterDup_cursor CURSOR FOR
select distinct Master_Id from  dbo.Master_SRC_With_Dups where
Master_Id in
(select Master_Id from dbo.Master_SRC_With_Dups
group by Master_Id
having count(*) >1)
order by Master_Id desc

OPEN MasterDup_cursor

FETCH NEXT FROM MasterDup_cursor
INTO @Var_ID

WHILE @@FETCH_STATUS = 0
BEGIN

insert into #distinct_Data
select top 1 * from dbo.Master_SRC_With_Dups where Master_Id =
@Var_ID
order by distinctive_Field desc

FETCH NEXT FROM MasterDup_cursor INTO @Var_ID

END

CLOSE Tower_cursor
DEALLOCATE Tower_cursor

select * from #distinct_Data
return 0

**************************************************************************

I queried the database version in the event that this makes a
difference:

SERVEICE_LEVEL    FIXPACK_NUM
DB2 v8.1.1.112           12

SELECT service_level, fixpack_num FROM TABLE
(sysproc.env_get_inst_info())
as INSTANCEINFO