private void Start(string tableName, string procName, string schema) { _sb.AppendLine("-- " + procName + " - table " + tableName); //depending on your UI you probably need one of these _sb.AppendLine("--#SET TERMINATOR ~"); _sb.AppendLine("--<ScriptOptions statementTerminator=\"~\"/>"); var sqlFormatProvider = new SqlFormatProvider(); var name = sqlFormatProvider.Escape(procName); _specificName = name; if (!string.IsNullOrEmpty(schema)) { name = sqlFormatProvider.Escape(schema) + "." + name; } //specific names have a maximum length of 18 (procedure names can be up to 128 chars) if (procName.Length > 18) { _specificName = sqlFormatProvider.Escape(procName.Substring(procName.Length - 18, 18)); } // CREATE OR REPLACE syntax is new in DB2 v9.7. For older versions, DROP first _sb.AppendLine("CREATE OR REPLACE PROCEDURE " + name + ""); }
private void Start(string tableName, string procName, string schema) { _sb.AppendLine("-- " + procName + " - table " + tableName); //depending on your UI you probably need one of these _sb.AppendLine("--#SET TERMINATOR ~"); _sb.AppendLine("--<ScriptOptions statementTerminator=\"~\"/>"); var sqlFormatProvider = new SqlFormatProvider(); var name = sqlFormatProvider.Escape(procName); _specificName = name; if (!string.IsNullOrEmpty(schema)) name = sqlFormatProvider.Escape(schema) + "." + name; //specific names have a maximum length of 18 (procedure names can be up to 128 chars) if (procName.Length > 18) _specificName = sqlFormatProvider.Escape(procName.Substring(procName.Length - 18, 18)); // CREATE OR REPLACE syntax is new in DB2 v9.7. For older versions, DROP first _sb.AppendLine("CREATE OR REPLACE PROCEDURE " + name + ""); }