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.
SAP Knowledge Base Article - Preview