How to create Structure at data base level using a program

[Former Member]

Hi all,

I need to create a structure at data base level with some fields.

But the thing is i need to achieve using this a program.

Please help me out at the earliest.

Thanks&Regards

[Former Member]

Thanks

[former_member222860]

Hi,

EXEC SQL.

  CREATE TABLE MARA_TEMP AS SELECT * FROM MARA WHERE 1 = 2

ENDEXEC.

This will create Structure : MARA_TEMP at the database level.

Thanks\

Mahesh

[Former Member]

Thanks