Run into problems with SOU’s bookstore feed twice now. SOU places a file in /san/flat/sou/souprd/fin/invfeed. The file has a name *bookinve.dat and contains 3 record types. The shell FZRBKST gets run from job submission. It splits the file into 3 files, one for each record type and loads 3 temp tables (fwbinvh,fwrinvc, and fwrinva) . Next it picks up some vendor and fopal info, geneates a doc code and inserts into Banner tables to get picked up by fgbtrni.
The program removes all lis files and logs when it starts making tracking down an error situation tough because a user has a tendency to try and run again when they get an error. The shell makes it to archiving the original data file and usually fails somewhere in the 3 sqlldr loads. So when they try and run it again, the 1st logs are deleted and it fails right away because there is no data file.
I check the 3 temp tables and look at the load logs if they’re there. If it failed during a load, you can delete the temp tables, have the user fix the offending record in the datafile, reload the datafile, and have the user run it again
