PI SQL Client

Showing 20

TransposeArchiveEX feature on RTQP

No description provided

Guest about 2 years ago in AVEVA™ PI System Access (PSA) / PI SQL Client 1 No status

Get AF Server Name and AF Database Name in PI SQL DAS (RTQP)

As a PI Applications Developer, I need to be able to retrieve the name of the current AF Server and Current AF Database in the PI SQL DAS (RTQP). This information was available in PI OLEDB Enterprise’s [System].[Connection].[ConnectionProperty] an...

Guest about 2 years ago in AVEVA™ PI System Access (PSA) / PI SQL Client 0 No status

2 VOTE

Access AFTables with RTQP

Add possibility to read AFTables using RTQP Engine

Carlo Pedroli almost 2 years ago in AVEVA™ PI System Access (PSA) / PI SQL Client 0 No status

1 VOTE

PI SQL Commander's Template-Specific Data Model Wizard should include a search/filter to make locating templates in the template selection step easier.

PI SQL Commander's Template-Specific Data Model Wizard should include a search/filter to make locating templates in the template selection step easier. Currently for AF databases with many templates, a user has to use a scroll bar in order to find...

Bethany Jewett about 1 year ago in AVEVA™ PI System Access (PSA) / PI SQL Client 0 No status

2 VOTE

Add support for local variables in PI SQL (RTQP)

The current version of PI DAS (RTQP Engine) does not support local variables. It causes rather clumsy constructs in some instances.

Guest about 2 years ago in AVEVA™ PI System Access (PSA) / PI SQL Client 0 No status

1 VOTE

PI SQL Client to support all types of ResultSets

Currently the PI SQL Client JDBC only supports reading the resultset in a forward manner (ResultSet.TYPE_FORWARD_ONLY). We would like to have the feature to support all types of Result sets like ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.TYPE_SC...

Diwakar Hariharan over 1 year ago in AVEVA™ PI System Access (PSA) / PI SQL Client 0 No status

1 VOTE

Table-Valued Function

Currently it is not possible to define filter definitions for Table-Value functions.With DataLink I'm able to define to build an average for a process value by using a defined filter method. e.g. calculating an average current of an engine while t...

Christian Benitz almost 2 years ago in AVEVA™ PI System Access (PSA) / PI SQL Client 0 No status

1 VOTE

Add support for unit conversion

Please add a "Canonical UOM Per UOM" or "UOM Per Canonical UOM" column (not necessarily with those exact names) to the UnitOfMeasure table. This column would contain the conversion factor needed to convert between the UOM and the canonical UOM, si...

Kenneth Barber about 2 years ago in AVEVA™ PI System Access (PSA) / PI SQL Client 0 No status

1 VOTE

Add RTQP PI SQL support for parameter type cast

PI DAS (RTQP Engine) 2018 SP3 Patch 1 lacks support for type casting input parameters of a table valued function. For example. this simple example fails to create a table valued function: CREATE FUNCTION [MOMS].[fact].[getInstrumentOperationalDat...

Guest about 2 years ago in AVEVA™ PI System Access (PSA) / PI SQL Client 0 No status

1 VOTE

Add RTQP PI SQL support for default value of function parameter

The current version of PI DAS (RTQP Engine) does not support the definition of default values for table-valued function parameters. This is a rather bleak omission, in my view. For example, the following will fail to create the table-valued functi...

Guest about 2 years ago in AVEVA™ PI System Access (PSA) / PI SQL Client 0 No status

Please enter your email address

FILTER BY CATEGORY