l**o
发帖数: 3 | 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 | l**o
发帖数: 3 | 2 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 |
|
