select agency_id from #Request.prefix_db_lookup#.Agency where status='active' ORDER BY agency_id

The current directory is:#cfftp.returnvalue#

", "ALL")> SELECT * FROM #Request.prefix_db_agency#.Invoices Where Internal_control_number='#Internal_control_number#' UPDATE IGNORE #Request.prefix_db_agency#.Invoices SET claim_status ='Accepted', User_defined_Status ='Processing' , claim_received_date = CURDATE() ,Record_Modified_By = '#Session.EmployeeId#' ,Record_Modified_Date = #now()# WHERE Internal_control_number ='#Internal_control_number#' AND Internal_control_number !=0 UPDATE IGNORE #Request.prefix_db_agency#.Invoices SET claim_status ='Rejected', Error_description = '#Errordescription#', User_defined_Status ='Needs fix' , claim_rejected_date = CURDATE() ,Record_Modified_By = '#Session.EmployeeId#' ,Record_Modified_Date = #now()# WHERE Internal_control_number ='#Internal_control_number#' AND Internal_control_number !=0 UPDATE IGNORE #Request.prefix_db_agency#.Invoices SET claim_status ='Accepted', User_defined_Status ='Processing' , claim_received_date = CURDATE() ,Record_Modified_By = '#Session.EmployeeId#' ,Record_Modified_Date = #now()# WHERE Internal_control_number ='#Internal_control_number#' AND Internal_control_number !=0 UPDATE IGNORE #Request.prefix_db_agency#.Invoices SET claim_status ='Rejected', Error_description = '#Errordescription#', User_defined_Status ='Needs fix' , claim_rejected_date = CURDATE() ,Record_Modified_By = '#Session.EmployeeId#' ,Record_Modified_Date = #now()# WHERE Internal_control_number ='#Internal_control_number#' AND Internal_control_number !=0

Internal Control Number	Error	Date	Status
#Internal_Control_number#	#Errordescription#		#Rejected_date#	#status# Accepted	#DateFormat(Now(),"YYYY-MM-DD")#	#status# Rejected