如何在DB2中的存储过程中创建表 [英] how to create table within stored procedure in DB2

问题描述

创建或替换

create or replace

PROCEDURE xyz_tbl_proc
as
BEGIN

 execute immediate '
            CREATE TABLE xyz
            (
             empname varchar(10)
             )';
             END;

i想在db2中编写存储过程来创建表。

一旦我运行这个表就没有被创建。请帮助。

i want to write a stored procedure in db2 to create table.
once i run this table is not getting created. please help.

推荐答案

create proc NewTable @TabName nvarchar(20),@Flag bit,@SID int,@Name varchar(20)
as
begin
if @Flag=1
begin
IF (EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = @TabName))
BEGIN
  print 'hi'
END
else
begin
    declare @str varchar(max)
    set @str='create table @TabName (Sid int,Name varchar(20))'
    select @str=replace(@str,'@TabName',@TabName)
    exec(@str)
    print 'Table not found'
END
end
end

我希望它运作良好并帮助你........： - ）

I hope it's working well and helping to you........:-)

这篇关于如何在DB2中的存储过程中创建表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！