taylor5pak
Programmer
Hello, is it possible to do a database lookup within an awk script to verify a value exist and then if so insert values from the record being read into the database?
Ex. I have a huge file and in it contains an invoice data, first I want to see if the invoice already exists in the database, if it does I am going to write these records out to a file, If not I am going to write these records out to another file.. I am going to then process all records that were not in the database and at this point I would like to make another call to the database and insert...
Ex. I have a huge file and in it contains an invoice data, first I want to see if the invoice already exists in the database, if it does I am going to write these records out to a file, If not I am going to write these records out to another file.. I am going to then process all records that were not in the database and at this point I would like to make another call to the database and insert...