Manage Learn to apply best practices and optimize your operations.

Sampling Of Sql Statements That Can Be Used With Notes

Problem:
What SQL commands can be used with Notes?
Solution:
Notes 3.x

Notes 3.x supports only the SELECT SQL command. Sample SELECT statements are
listed
below. The SQL command can be used in Notes 3.x via @DbCommand formulas.

Sample SELECT Statements:

SELECT ALL FROM table

SELECT FROM table WHERE search-condition

SELECT FROM table GROUP BY columnid, columnid

SELECT FROM table HAVING

SELECT FROM table ORDER BY columnid DESCENDING

Notes 4.x

Notes 4.x supports the SELECT command (as listed above) as well as additional
SQL commands
such as those listed below. In Notes 4.x, SQL statements can be used in
@DbCommand formulas
and in LotusScript code (using the LotusScript Data Object).

Sample SQL Statements:

INSERT INTO tablename (columnid, columnid) VALUES (value, value)

UPDATE tablename SET columnid = value WHERE search-condition

ALTER TABLE tablename {ADD columnid datatype}

CREATE INDEX indexname ON tablename (columnid ASC, columnid DESC)

CREATE TABLE tablename (columnid datatype)

CREATE VIEW viewname (columnid, columnid) AS SELECT ...

DELETE FROM table

DELETE FROM table WHERE column = value

DROP INDEX indexname

DROP TABLE tablename

DROP VIEW viewname

Dig Deeper on Domino Resources - Part 4

SearchWindowsServer

Search400

  • iSeries tutorials

    Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...

SearchDataCenter

SearchContentManagement

Close