To date when an sql statement is loaded to the bida_dw_sql_stmts table the comments in the sql statement are also loaded at that time.
However, with our new and improved ability to execute statements directly in Meta5 the comments must be removed. So we have added a processing directive called:
LOAD SQL STATEMENT COMMENTS.
This can be set to Yes or No and defaults to Yes.
So if you want to load an SQL Statement into the statements table and you want the comments removed?
You must specifically set this processing option “No”.
We hope you like this new feature!
Please note “PI= Product Improvement”.