1. RAFAEL RODRIGUEZ
  2. PowerBuilder
  3. Monday, 10 July 2023 03:21 AM UTC

How can I run dynamic sql commands in runtime: 1) Like insert or update to a database without a DW 2) alter a table, drop or add a column 

 

RAFAEL RODRIGUEZ Accepted Answer Pending Moderation
  1. Monday, 10 July 2023 15:51 PM UTC
  2. PowerBuilder
  3. # 1

Thank you Roland, I prove this right now

Comment
There are no comments made yet.
Roland Smith Accepted Answer Pending Moderation
  1. Monday, 10 July 2023 03:32 AM UTC
  2. PowerBuilder
  3. # 2

String ls_sqlsyntax

ls_sqlsyntax = "INSERT INTO ..."

EXECUTE IMMEDIATE :ls_sqlsyntax USING SQLCA;

 

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.