In PowerBuilder in embedded SQL all references to SYS.DUMMY are converted to DBO.DUMMY. This is made because in PowerBuilder you can't use select statement without FROM clause, for example “SELECT 1”, although this is supported in MSSQL Server. In order to make this query work properly you need to create DBO.DUMMY table in SQL Server.

For example:

 CREATE TABLE DBO.DUMMY 
 (
 col1 int
 )
 GO

Also you need to insert only one row into this table.

For example:

 INSERT INTO DBO.DUMMY (col1) VALUES (1)
 GO