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

  • Favorite iSeries cheat sheets

    Here you'll find a collection of valuable cheat sheets gathered from across the iSeries/Search400.com community. These cheat ...

  • HTML cheat sheet

    This is a really cool cheat sheet if you're looking to learn more about HTML. You'll find just about everything you every wanted ...

  • Carol Woodbury: Security

    Carol Woodbury

SearchDataCenter

SearchContentManagement

Close