Skip navigation
Log in to follow, share, and participate in this community.

Recent Activity

BarryHu
In Lesson 3, Understand the basics of RTQP Engine schema, there is a step "Add GetSummaries...". When execute the code I got the attached error. May someone explain why it happens? Thanks. Also insert image does not seem to be working. When I choose the file and click Insert, nothing happens....
norman_soriano
Click to view contentHi,   could anyone help me to find out what is the problem on my pi sql client? I cant able to create new schema. it is disabled on my sql commander.    Thank you in advance!!  
Basavakumar_Jigalur
Hello Team,   I am starter to the PI SQL topics. I understood that we need enter all the details via connection string for PI OLEDB provider before we connect to PI DA and get data. But I am not clear, where to enter those scripts. Regarding UDL file, I understood how to create it and what all to fill in, but not sure how would that be utilized.… (Show more)
kduffy
Click to view contentCross Apply is seen in the query compendium and example queries in a number of locations within PI SQL Client and PI OLEDB Enterprise, but since it's not a widely used operator, many people are confused by its usage.   While a JOIN appends columns from a second table onto existing rows from the first table, a CROSS APPLY applies a function to…
kduffy
Click to view contentOverview: Functions are powerful database objects in SQL allowing users to pass input parameters and receive a calculated output of some kind. There are many Scalar-Valued Functions (such as COUNT(), or Microsoft's t-SQL function GETDATE()), but for functions that output a table, there are two options: Table-Valued Function Function Table  …
kduffy
Click to view contentThis document contains the answers to the Exercise: PI SQL Client (OLEDB) and RTQP Configuration . The screenshots in this document are of either PI SQL Commander's Data Link Properties dialogue box or the PI SQL Client Admin Guide .   Note: Each of these connection strings use the [Location] parameter to store the [AF Server name] and the [Data…