Our company is currently evaluating Toad Data Point for use against Netezza (through ODBC driver) and we have recently come across an issue that may be a deal-breaker for us.
When executing a “Create or Replace Procedure,” the formatting is stripped (removes the line breaks) when it is saved to Netezza. It ends up appearing as a single line of code between the BEGIN and END… by comparison, when using Aginity (also through the same ODBC driver) it does NOT strip the formatting of the stored procedure.
Has anyone experienced this before? Any suggestions or setting tweaks I might try? Toad Data Point has so much to offer our team, but I honestly can’t imagine using it if we are unable to maintain the readability of complex stored procedures.
EDIT: Changed to Question