Is there a declaration of "check" variable in your script? : I have a job similar to the following that needs to retrieve a process date : from a database table by calling a user-defined statement. If there was an : error while retrieving the date, the returned string will be equal to : "ERROR". : After the user-defined statement has executed and returned the string : representing the process date (or "ERROR" string), I receive an : "Invalid Datatype" error while processing the : "IsEqual" line in the job. : Do you have any ideas on what is causing this? : Thanks. : --Job-- : Dim process_date, String : Dim error_message, String, "ERROR" : // Retrieve the current process date : retrieve_process_date( process_date ) : IsEqual( process_date, error_message, check ) : IfThen( check, ERROR_DATE ) : (Code omitted...) : -------------------------- : --User-Defined Statement-- : (Code omitted...) : DatabaseGet( 1, 1, process_date_time ) : Format( process_date_time, "mm-dd-yyyy", process_date ) : GoTo( done ) : ERROR: Set process_date, "ERROR" : DONE: DatabaseDisconnect : Return process_date : -------------------------
|