Symptom
- You are using SAP Data Intelligence and having a format issue with Flowagent SQL Executor Gen2 operator.
- The character '[' in the SQL statement is converted to '-'.
For example, the original right SQL should be:
copy into IM_SHARE_DB.IM_SHARE_SCHEMA.EMPLOYEE_TABLE from @stage file_format = (type = csv field_optionally_enclosed_by='"')
pattern = '.*salesdocument_[0-9]+_[0-9]+[.]csv.*'
But in Flowagent SQL Executor you got the 'pattern' parameter as below:
pattern = '.*salesdocument_-9+_-9+\.csv.*'
Read more...
Environment
- SAP Data Intelligence Cloud Edition
- SAP Data Intelligence onPrem Edition
Product
SAP Data Intelligence 3.0
Keywords
Flowagent SQL Executor, pattern, [ , KBA , CA-DI , Data Intelligence , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.