Transaction_id , SMALLINT
Amount , Decimal(11,2)
Every 4 hrs I get the file with following structure .
Amount (Decimal 10,2)
Transaction_id is a sequence number .
The job to load the table will run every 6 times in a day.
When the job is run second time and onwards , I have to fetch the maximum Transaction_id from a table , need to add 1 to it and assign it to the first record of the file and then increment it for each record .
File Structure for load is similar to the table structure .
Can anyone help me with this ?
Additional information ...if required ..please let me know .