Can you please share the workaround to export and import as DDL?
Currently we are using Teiid Designer 9.2, but where also we are facing DDL Stored procedure import issue, Store Procedure SQL Transformation is empty when we import the DDL back to Teiid Designer 9.2
For TEIIDDES-2729 Bad export of carriage return in SQL transformation
Workaround is to do remove all carriage returns in middle of SQL query
For TEIIDDES-2741 Concatenation operator || incompatible with import SQL
Workaround is to use Teiid function CONCAT instead of || operator.