Hi frnz,
I have requirement as follows..
There are two Modules say A and B...n both have few set of files..we have one script which read these files and load into database(vertica) table..while running script smtimes i encounter an error like one table is getting loaded from A module file also and module B file also..and due to this licking my script fails.
Now A & B run parellely so when A's file getting loaded into table it locks the table and B files fails to load..
so i want to add a piece of code where my script will wait till A file completley load into table and stop the file of B..n once A file loaded it will start loading B file into B..
Overall i need to Develop table update dependency tracking to avoid query failure due to table lock.
I knw its very confusing but if anyone can provide some input , i wud be very grateful..
Thanx