SAP Knowledge Base Article - Preview

3241726 - Flowagent SQL Executor Gen2 SQL format issue with '[' - SAP DI

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.