Ok now I guess its time to get more detailed into what I need.
I have a process that needs to load a tbl. During the process I update an audit table with a start date when i start and an end date when I finish. Because this is a database and because I am loading stage tables I need to make sure that I have the load done before I move on to the next set of data.
The logic in english is as follows:
If the audit table has a start date and a stop date populated then go to the next step.
So in Unix What I want to do is something like
start_date = db2 "select start_date from tbl where audit_job_name = "load" and audit_start_date = "predetermained in the first part of script"
end_date= "similar logic as above"
If start_date is not null and end_date is not null call :Next_Load_Function
else if start_date is null or end_date is null call:Failure_Function
end
I dont know if I am making myself clear. I am a DBA...not a script writer. All I know is the more comlicated the code the harder it is for me to understand
Let me know if i can clear up the muddy water...