In order to preview a Query Object within the IDE make sure the database connection is set and there's no pending reorganization. In addition, please keep in mind the following considerations:
- Dameng displays sample data instead of the data from your Database.
-
If you are using Oracle, DB2 iSeries or SAP HANA, you must make sure to copy certain dependencies to the preview folder. Otherwise, the output window may display a message with the files to be copied and where to copy them to.
By default the Query Object supports querying a unique Database referenced by the default Data Stores. If you are using several Data Stores to connect to different database engines, it is not possible to reference attributes from different data stores in a query definition. There's a special case which is supported when several data stores references the same database engine instance.