Update SQLCMD and SQL JDBC plugin to enhance error handling

By the end of the DB deployment, our process demands a list of all such files that failed during execution. As with the current palettes ? RunSQLCmd and SQL JDBC, it is not possible to get the output of each file on some location, we are trying to pull a list of all failed scripts from the UDeploy logs. But we are facing some challenge ? The output in UDeploy log is such that the name of the failed script is not appearing next to this line: ?Failed to execute?. Instead, the entire script code that got failed gets written next to ?Failed to execute?. In such a case it is challenging for us to pull a list of files that failed.

This can probably be achieved through shell scripting, but we are trying to make use of as many palettes as possible other than shell scripting palette. Can you please suggest on this and check to see if the Udeploy log format for JDBC plugin could be changed so that we can get the failed file name right next to this line- ?Failed to execute?.

[sql] Executing resource: C:\ibm-ucd\XXX\var\work\DDL_DB_Deployment_Testing2\FirstScript.sql
[sql] Executing resource: C:\ibm-ucd\xxxxxxx\var\work\DDL_DB_Deployment_Testing2\SecondScript.sql
[sql] Executing resource: C:\ibm-ucd\xxxxx\var\work\DDL_DB_Deployment_Testing2\ThirdScript.sql
[sql] 1 of 3 SQL statements executed successfully
[sql] Failed to execute: use BondDeploy update bond_deplmj,hjkoy_log set project='Rock' where [db_name] ='DBREF001'
[sql] com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ','.
[sql] Failed to execute: use BondDeploy update bond_deploy_log set project='Diamond' where [db_name] ='DBCAM001' dhfhyjuty select * from bond_deploy_log
[sql] com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'dhfhyjuty'.