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 + "");
}
