#-------------------------------------------------------------------------------
# Run a non-CLP DB2 system command and write the output to a file.
#
RUN_OTHER_COMMAND()
{
 set "$DEBUG_SWITCH"
 OUTPUT_FILE="$1"
 MAX_RETURN_CODE="$2"
 COMPRESS_OPTION="$3"
 COMMAND="$4"
 PARAMETERS="$5"
 INIT_OUTPUT_FILE "$OUTPUT_FILE" "$DEBUG_SWITCH"  

 print "\nCommand ran:"               >> "$OUTPUT_FILE" 
 print "  ${COMMAND} ${PARAMETERS}\n" >> "$OUTPUT_FILE"
 "$COMMAND" ${PARAMETERS}             >> "$OUTPUT_FILE"
 RETURN_CODE="$?"
 if [[ "$RETURN_CODE" -gt "$MAX_RETURN_CODE" ]]; then
    ERROR_MESSAGE "Problem running command: \"${COMMAND} ${PARAMETERS}\", return code: \"${RETURN_CODE}\",\n        View: \"${OUTPUT_FILE}\" for further details" $DEBUG_SWITCH
 else
    case "$COMPRESS_OPTION" in
       compress|COMPRESS)
         ZIP_IT "$OUTPUT_FILE" "$DEBUG_SWITCH"  
         ;;
       *)
         print "Output saved to: \"${OUTPUT_FILE}\""
         ;;
    esac
 fi
}
