help on store procedure of db2# Database - 数据库
l*o
1 楼
we can implement sp on sysbase in java with this way.
stmt.execute(sqlstmt).
//execute next statement
"create procedure MMSP( @id " + "int" + ", @ordinal integer
)" + NEWLINE +
"as begin" + NEWLINE +
// List the clones of this field and remove this field
from the list
"exec MB_MDListClones @id" + NEWLINE +
// Propagate ordinal info for links
"update MB_MDDefinition set ordinal = @ordinal " +
"where fieldId in (select fieldId from " +
MB_CLONE_TEMP_TABLE_NAME + " where id
stmt.execute(sqlstmt).
//execute next statement
"create procedure MMSP( @id " + "int" + ", @ordinal integer
)" + NEWLINE +
"as begin" + NEWLINE +
// List the clones of this field and remove this field
from the list
"exec MB_MDListClones @id" + NEWLINE +
// Propagate ordinal info for links
"update MB_MDDefinition set ordinal = @ordinal " +
"where fieldId in (select fieldId from " +
MB_CLONE_TEMP_TABLE_NAME + " where id