Data Exchange Using Queries
Use
Business Suite applications can use PCo to send queries to external data sources, for example, to read or change values of data source tags. The PCo agent instance, which is connected to the external data source, receives the query and interprets the statements it contains. PCo provides three types of query:
-
Tag query
These queries that refer to tags.
-
Database query
These queries are SQL queries that refer to database content. The SQL dialect used corresponds to the connected data source.
-
Text query
These queries are text-type queries with text-type content that you can define freely.
The results of the queries support certain data types, see: SQL Data Types