Do I need to define the column in file format section of mload which I am planning to load as hard coded value coming from parameter file. In attached code report_suit_id should be passed from parameter file as &val4 but I am getting syntax error saying that "Syntax error: expected something between '(' and the end of the request.". If I hardcode the report_suit_id as '1', its working fine. Please let me know how can I pass this value from parameter file. I need to perform case when based on value coming from parameter file for this field.
Please provide the table DDL (at least the column datatypes) and the param.txt file.