Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a senario where i load data once a day from several databases via ODBC connections.(connectionstrings).
My problem is that this is a automated load process and sometimes when i have a problem with one connection the load stop to display connection error. What i would like is that if a ODBC connection is not successfull the load must carry on with the next connection of the following databases and skip the database that has a connection problem.
I was thinking in the line of :
IF connection1 success // HOW CAN I TEST CONNECTION WITHOUT HALTING ALL THE LOADS.
THEN
LOAD database1
END
IF connection2 success
THEN
LOAD database2
END
Help would be appreciated.
Regards
Louw
Hi
Please refer
connection1;
let vError = ScriptErrorCount;
connection2;
Trace "Connection2 Successful";
else
Trace "Connection1 Successful";
End if
let vError =null();
Thank you Mayil , Balraj and Kush. All these post helped me.
best regards
Louw