Hi,
I wrote a sql in DB2 and saving the data to sequential file.
Allow multiple instance is also NOT checked.
I am getting 2 copies of same record, i used distinct also in the query but the problem continues, if i use PK like or PK= in the query then i am getting unique records. Please help me understand why i am getting multiple records.
Hi Chulett,
I made the query pretty simple to check, direct select from a single table, if i run the query against the database directly i am getting unique records.