begin
let string(int) sql_file = first_without_error(vector_select(CONFIG_REC.dbc_property,
[record property_name "sql_file", property_value ""],
{property_name})[0].property_value,"");
let is_reconciliation_snapshot = first_defined(CONFIG_REC.enable_reconciliation_snapshot,"") == "Y";
result::if(is_full_cdc or (is_delta_cdc and is_reconciliation_snapshot))
"file.simple_read"
else if (is_file and disable_multifile and not string_index(filename_pattern, ".xl"))
"file.simple_read"
else begin force_error("No channel code specified!"); result::"";end
;end
class to handle scenerio
begin let string(int) sql_file = first_without_error(vector_select(CONFIG_REC.dbc_property, [record property_name "sql_file", property_value ""], {property_name})[0].property_value,"");
let is_reconciliation_snapshot = first_defined(CONFIG_REC.enable_reconciliation_snapshot,"") == "Y"; result::if(is_full_cdc or (is_delta_cdc and is_reconciliation_snapshot)) "file.simple_read" else if (is_file and disable_multifile and not string_index(filename_pattern, ".xl")) "file.simple_read" else begin force_error("No channel code specified!"); result::"";end ;end