Home » Infrastructure » Unix » Badrecord Check in korn shell script
Badrecord Check in korn shell script [message #246763] Thu, 21 June 2007 16:03
oraanu
Messages: 22
Registered: September 2005
Location: Boston
Junior Member
Hi,

I have to load data from Flatfile into our Database.
First I creating the temp External table from the flat file and then loading the data to the final table.I have written a shell to load the Data.After creating the temp External table I have to check the bad records in my shell script.If there is a bad record I have to Drop the temp External table and notify to the users.can anybody help me how to check whether that table has bad records or not in a shell script.

Please help me.

Thanks,
Anu
Previous Topic: scripts for monitoring UNIX space
Next Topic: delete old files
Goto Forum:
  


Current Time: Sun Dec 08 05:23:30 CST 2024