Altering a Table within a PowerBuilder Script

[connoq]

is it possible to use ALTER TABLE (to add columns to a table) from within a PowerBuilder Script? Anyone have the syntax?

 

[shiongss]

Hi,

String s_str
s_str = "alter table table_name add name varchar(20)"

EXECUTE IMMEDIATE :s_sql USING SQLCA;

Hope this help.

 

[connoq]

shiongss, Thank you! Your tip was very helpful. It bothers me that we were unable to find this information through the PowerBuilder help. When you search for ALTER you get nothing. Not knowing that the EXECUTE IMMEDIATE was available, we would have never figured this out. Can you recommend any books or online documentation that is comprehensive (i.e, in this case when looking up ALTER TABLE having it tell you that you can only utilize ALTER TABLE through EXECUTE IMMEDIATE)? Thanks again.

 

[shiongss]

Hi,

That statement i was not learn from book, it's from my work experience.

The help file in PB do have a help regarding of EXECUTE IMMEDIATE.