In datastage while using the column import stage we may get the following error,
main_program: Syntax error: Error in “export” operator: Error in operator arg: In field “Opt”: Expected “;”, got: “.”, line 53
Error in “field_import” operator: Error in operator arg: In field “Opt”: Expected “;”, got: “.”, line 92
The main reason for this error is we should not have (.) dot or any other special characters in the column to import parameter. If you have it then it will not give any error notification when you are designing the job. but when run it then you will get the above error.
So please be cautious while using the column import stage and also dont forget to give select correct format in the output tab of the column import stage.