We have an RDBMS interface in place that is working correctly.
A simple SQL selection in the Exdesc retrieves a value from Oracle.
Now I wanted to create a selection where I update tags using concatenated values for the tag namens.
SELECT T as timestamp,
CONCAT(FIELD1,'') || '.' || CONCAT(FIELD2,'') as alias,
V as value
WHERE DAT IS NULL ORDER BY alias, timestamp
This SQL was saves as test.sql in de SQL folder (and that was listed in ICU RDBMS SQL Files Directory)
A test of the SQL statement in Toad4Oracle showed something like:
My goal: to create a tag with the name NAME.SUB1 that will update with the timestamp and values.
When I create the tag using the point builder I set:
The name to: NAME.SUB1
The Point Source to the point source of the RDBMS interface
Point Type to Float32
Exdesc to: /ALIAS=alias
Location1: 1 (scann class defined)
Instrument Tag: test.sql
The error message that I receive:
>> Point - NAME.SUB1 : Bad bind column iPosition 4!
>> Point - NAME.SUB1 : tag refused
The logging shows the SQL query from the test.sql file so it gets the correct query.
What am I doing incorrect?
(could the concatenation cause any problems or am I doing something else incorrectly??)