SQL statements
- Last UpdatedSep 29, 2022
- 1 minute read
- PI System
- PI OLEDB Enterprise 2019
- Developer
The basic structure in SQL is the statement. Each statement begins with a unique keyword. SQL statements consist of clauses which begin with a keyword. SQL syntax is not case sensitive.
A statement has no explicit limit in terms of string length, however implicit limits may apply to configuration details such as process space, hardware, OS configuration. In practice, only auto-generated statements exceed a size of 100,000 characters and OSIsoft recommends that you implement special scalability testing for such applications.