Experience Have done application programming as well as some installation and administration mostly with MySQL for web servers and site development and also with IMS and DB2 on legacy systems in the past.
Expert: Marty Landman Date: 9/13/2006 Subject: How to write procedure?
Question I need a script for the below raised question or can you give the concept for the below question.
-------------------------
Followup To
Question -
I have a situation where I need to fetch all records from temporary table to permanent table. The record has to move from temp table to permanent table. When we inserting the records in permanent table we use to check for duplicate records. If we found the duplicate records then we need to update the same record. If no duplicate the record has to insert.
Still in detail:
Around 20 columns, 3 columns is PK by checking the 3 columns we need to update rest of the columns in update option.
Answer This sounds like a merge application. It's a common problem in computer programming. Suggest begin by writing a simple process description or flowchart or pseudocode - however you like doing your planning stage. Then start implementing slowly, for instance just read the records one by one, printing each to the console for a sample input file and then build up step by step from there.
