Using SQL statements in DataWindows

Requirements

  • If you specify the table owner in the Specify Update Properties window in PowerBuilder, please make sure the "Enclose table and column names in quote" option is not selected in PowerServer Toolkit during the deployment or errors will occur.

  • If you specify the argument name in Specify Retrieval Arguments window in PowerBuilder, use ASCII characters.

  • Do not use FOR UPDATE non-cursor statement in the SQL statement for DataWindows.