0 How to Use This Book1 About Lotus Notes ODBC2 Installation & Configuration3 Using the Lotus Notes ODBC Driver4 Programming Information5 What's New in Release 26 Appendix A7 Appendix B
GlossaryODBCODBC (Open Database Connectivity) is an interface that allows applications to get to data in database management systems that use SQL. The interface allows a single application to connect to many different types of databases through a standard protocol. ODBC is implemented as a Driver Manager and multiple drivers. Each driver links the application to a specific database.################
Glossary
?ODBCDavid Martin
David Martin##########
Glossary
ODBCDavid Martin
David Martin##################################################
TitleLotus Notes ODBC DriverTitle Page
David Martin0 How to Use This BookLOTUS NOTES ODBC DRIVER\0 How to Use This Book
How ToLotus Notes ODBC DriverMapping Notes Names to SQL Names^
?Notes Names, SQL NamesCN=William DelaVega/OU=CAM/O=Lotus3 Using the Lotus Notes ODBC DriverLOTUS NOTES ODBC DRIVER\3 Using the Lotus Notes ODBC Driver
0 How to Use This Book1 About Lotus Notes ODBC2 Installation & Configuration3 Using the Lotus Notes ODBC Driver4 Programming Information5 What's New in Release 26 Appendix A7 Appendix B
CN=Michael Podanoffsky/OU=CAM/O=Lotus
CN=Michael Podanoffsky/OU=CAM/O=Lotus
CN=Michael Podanoffsky/OU=CAM/O=Lotus
SectionHow To
ChapterChapter Head
About This BookPreface
SectionHow To
ChapterChapter Head
About This BookPreface
Section
SectionAssign this topic to a category.
Book ModelLotus Notes ODBC Driver
About This BookPreface.
SubSection
SubSection^
SubSectionAssign this topic to a topic group.
0 How to Use This Book1 About Lotus Notes ODBC2 Installation & Configuration3 Using the Lotus Notes ODBC Driver4 Programming Information5 What's New in Release 26 Appendix A7 Appendix B
This book is for use with the Lotus Notes ODBC driver, version 2.01, and Microsoft Windows 3.1, Windows 95, Windows NT 3.5. You must be running Notes on a Windows workstation or a Windows server.
This book can be viewed online as a Notes database, and it can be printed.
Choose
Help - Using
for instructions on viewing, printing, and modifying this book.
A Notes book has three views:
Table of Contents
- Where each subcategory is a chapter and each document is a section. This view contains all the documents designed for online viewing.
Index -
Where each category is an index entry and each document is a section to which the index entry refers.
Print
- The same as the Table of Contents view, but includes additional documents: Title Page, Copyright Page, Contents, and Index.
To suit the needs of your site, you can edit the documents in this database. However, if you do edit the contents of this database, it must be strictly for the sole use of users within your organization. You cannot resell or otherwise distribute this documentation, modified or unmodified, to anyone outside your organization. Lotus assumes no responsibility for the technical accuracy of any modifications made to this documentation
or the operation of Lotus products in reliance on such modifications
Notes Support Lab
-&cYxV
PURSAF
Lotus Development Inc
0wmS(
PURSAF
Scott 31 OCT 94
PURSAF
O=Lotus
O=Lotus
PURSAFO
O=Lotus
OU=CAM/O=Lotus
PURSAFO
OU=CAM/O=Lotus
CN=William DelaVega/OU=CAM/O=Lotus
PURSAFO
_,l8
$Info
$Body
Wingdings
Using This Book
This book can be viewed online as a Notes database, printed, and modified for your site.
Viewing a Notes Book Online
To View Topics in Logical Order
Choose the
Table of Contents
view. This is the main view. You see the book title, chapter titles indented under the book title, and section titles indented under each chapter title. Each section comprises one document.
To View Topics Alphabeticallyd
Choose the
Index
view. e
You see a list of topics in alphabetical order, and a section title or titles indented under each topic. To find a topic fast, type the first few letters of the topic.
NOTE
A third c
Printing
view contains additional documents that are needed for a printed book, but not for online viewing. Instructions on printing books are described later in this document.
To Open a Document
Select it, then double-click it, or press
ENTERM
. A document has the following appearance:
ge Colors...
Reassigning Image Colors (%
& White
Dithered
ue Gray
At the top of each document are several buttons. When you click one, the appropriate action takes place.
Button
Action
SERSAF
Displays all topics in the database in alphabetical order (opens the Index view). The current document remains open; you return to it when you exit from the Index view.
Activates the
Full Text Search
bar which appears at the top of a document or view.
Prints the current document.
Takes you to the last window you left open. The current document is closed.
Takes you to the previous document. The current document is closed.
Takes you to the next database document. The current document is closed.
Two additional buttons precede the book and chapter names. Clicking either of these buttons opens the Table of Contents view and highlights the indicated book or chapter name. The current document remains open.
The next line is the name of the chapter (first document in a chapter) or a section in the chapter (other than the first document in the chapter).
To Use a Doclink
This symbol
Database 'Book Model', View 'Print'
is called a doclink (short for document link). Double-click it, or arrow to it and press
SPACEBAR
to go to another document relevant to the text next to the doclink. Close the document or select
BACKTRACK
to return to the document where you selected the doclink. The doclink in this paragraph goes to the "About This Book" document for this database.
Using Full Text Search
Choose
View - Show Search Bar
to use the Notes Full Text Search feature
NOTE
Before you can use Full Text Search, the database you want to search must have a
full text index -- a special copy of the text of a database that allows Notes to provide query results almost instantly.
If you're running Release 3 on your workstation, you can create full text indexes and use full text searching on
local
databases only if you're using Windows or PM.
Select or open the database and choose
File - Full Text
Search
- Information
to see if the database is indexed and whether the index is up to date. To create an index, choose
File - Full Text
Search
- Create!
. To update the index, choose
File - Full Text
Search
- Update
You can perform a full text search on a
shared
database (on a server) only if that server is running Release 3 and someone with Designer access to the database created an index.
See the Help document, "Indexing Databases for Full Text Search," or look up "Full Text Search" in the Help Index view.
With full text search, you can search for whole words, word stems, and phrases, as well as perform more complex queries using logical operators (Boolean searches), proximity, and other advanced features. You can search one database, or many databases. A single set of text search criteria is called a query.
Menu Commands Used to Perform Full Text Queries
Show Search Bar
appears on the View Menu when you have a database open. It displays the search bar, where you enter simple or complex queries.
Show Search Bar
is a toggle. When it's chosen, a check mark appears next to it in the view menu. If you're in a document when you choose
Show Search Bar
, your active window becomes the view in which you found the document.
Like the ruler, the search bar can stay at the top of the screen while you search for several things or refine a search, or while you do something else. When you're done searching, you can close the search bar (by toggling it back), but there's no need to.
Show Only Search Results
, also on the View Menu, is available only when the search bar is displayed. Choose
Show Only Search Results
to show
the documents that result from the query, hiding the other documents in the view.
Show Only Search Results
is a toggle. When it's chosen, a check mark appears next to it in the View Menu.$
When you perform a search
without`
choosing
Show Only Search Results
, all documents normally visible in the view are shown, with a check mark next to those selected by the query. You find these selected (checkmarked) documents just as you would any other time:
Press
to go to the next selected document,
SH+F3
to go to the previous selected document.
Press
to go to the next selected document,
SH+F3
to go to the previous selected document.
Scroll to find checkmarked (selected) documents.
View - Show Relevance
is available only when
Show Only Search Results
is chosen. It sorts the documents that satisfy the query by relative pertinence.
Show Relevance
is a toggle. When it's chosen, a check mark appears next to it.
Full Text Search Options
Choose
View - Show Search Bar
, type the word you want to find, and click the magnifying glass
To search within a document
you can also click the
button at the top of the document. This displays the current view and opens the search bar.
Showing query results
You decide how you want to see the result of a query. To see only those documents from the current view that satisfy the query (and hide the others), choose
View - Show Search Results
. To see the all the documents in the view with query results selected (checkmarked), turn off
Show Only Search Results
Refining Your Search
Wildcards
allow you to search for words using unspecified as well as specified letters.
Relevance ranking
sorts the documents that satisfy your query by how well they match. For example, documents with multiple "hits" are ranked higher than those with a single occurrence of the specified text. Also, a short document with a single occurrence of the specified text is ranked higher than a longer document with a single occurrence.
Hyphenated words
allows you to find words that may or may not have been hyphenated correctly. For example, "full-text," "full text," and "fulltext" all satisfy the query
full-text
Logical operators;
allow you to search for more than one word, and exclude specific words.
Printing a Notes Book/
To Print the Document You Are Currently In
Click the
Print
button or choose
File - Print
To Print a Chapter of the Book
Go to the Printing view. This view contains additional documents designed for a printed book: a title page, a copyright page, a Table of Contents with page numbers, and an Index with page numbers.
In the Printing view, select the documents that make up the chapter. Choose
File - Page Setup
; specify the header, footer, width, height, and other properties as desired. Choose
File - Print
. For normal chapters, change
Page Break
Extra Line
, then click
. For About This Book and Index, leave
Page Break
as is and click
To Reflect the Pagination in the Table of Contents and Index Documents
The page numbers in the Table of Contents and Index documents are based on the following page size: width 7.062; height 9 inches. If you use a different page size, and use the Table of Contents and Index documents, you should first print the chapters, then modify the page numbers in the Table of Contents and Index documents before printing them.
Suggested Headers and Footers
The suggested headers and footers for a book are as follows:
About This Book
- None.
Chapters
- Header: ?
BookName
ChapterName
. Footer:
Index
- Header: E
BookName
|Index
. Footer:
|Index-&P|
Creating or Modifying a Notes Book
Structure of a Book Database
A book database has three views: Table of Contents, Index, and Printing; and eight forms: Title, Copyright, Contents, About This Book, Index, Chapter, Appendix, and Section. The About This Book form is for a description of the book contents. The Chapter and Appendix forms are for the first document in a chapter or appendix. The Section form is for the remaining documents in a chapter or appendix. The other forms are for the Printing view.
The Table of Contents and Printing views reflect the general structure of the book:
Book Name
0 About This Book
Title document
Printing view only
Copyright document
Printing view only
Contents document
Printing view only
About This Book document
1 Chapter Name
Chapter document
Section document
as necessary
Section document
as necessary
2 Chapter Name
Chapter document
Section document
as necessary
Section document
as necessary
additional chapters as necessary
appendices as necessary
A Appendix Name
Appendix document
Section document
as necessary
Section document
as necessary
Index
Index document
Printing view only
numbering and lettering as shown is recommended to keep the parts of the book in correct order.
To Unhide the Forms on the Compose Menu
A book database hides its forms so readers do not see them on the
Compose
menu. You must unhide the forms you want to use to compose documents. When you finish, you should hide the forms again.
Choose
Design - Forms
. Select the name of a form and click
. When the
form opens, choose M
Design - Form Attributes
. To unhide the form, select `
Include in Compose Menu
and click
;WeekDays $Progr
Choose
File - Close Window
to close the form. Perform the above procedure for each form that you need.
To hide a form, use the above procedure, but
deselec@
Include in Compose Menu!
To Set Up the Book Parts
Choose (
Design - Fields
. Select SubSection and click
. When the Shared Field Definition box opens, click
Format
. Type in the names of the book parts at the chapter level, as shown below.
Display
lors (%d%%)
Then click
, and
again.
Choose
Design - Fields
again and this time select Section and click
. When the Shared Field Definition box opens, click
Format
. Type in the name of the book, as shown below:
&Cascad
&Tile
&Arrange
You may want more than one name for this category. Your database may include multiple books or may be divided into parts. For a small database that represents one book, a single name is recommended.
To Create a Document
Choose
Compose@
and the appropriate document form. The following form is for a Section document.
Define or apply
h styles
Modify
h Attributes
olors (%d%%)
Press
ENTER
on the first field and select the name of the book. Press F
ENTER
on the second field and select the appropriate chapter.
On the Section form, type the section name into the third box. On the Chapter or Appendix form, type the chapter or appendix name. For other forms, you do not fill in this field.
On the Section form, be sure to enter the order of the document within the chapter. If you want the document name indented in the Table of Contents view, change the value of
Indent?
from 0 to 1.
Type in the index entries that apply to this document, one entry per line.
Finally, enter the body of the document.
To Use the Notes Book Styles
The following styles are defined. (The paragraph styling is defined under
Text - Define Style
. The font styling must be adjusted manually.) The left margin for headers and text (unless otherwise specified) is 1".
ChapterHead (this is the SubSection field in Chapter and Appendix forms)
Helv18 bold upper/lower magenta
Spacing single, single, double
Keep with next
AHead (this is the SubSection field in Section forms)
Helv14 bold upper/lower magenta
Spacing 1 1/2, single, single
Keep with next
BHead
Helv12 bold upper/lower magenta
Spacing 1 1/2, 1 1/2, single
Keep with next
CHead
Helv10 bold upper/lower magenta
Spacing single, 1 1/2, single
Keep with next
Para
Helv10
ParaLead
Helv10
Keep with next
Display
Helv9
Margins 1.25, 1.25
Keys - bold upper
User - plain, upper/lower
System - bold, upper/lower
Bullet
Helv10
Margins 1.25, 1.1
Tab 0.15
First line - Cour6 bold asterisk (
), then tab
List
Helv10
Margins 1.25, 1.0
Tab 0.25
First line - integer in sequence Helv10 bold, then period, then tab
Note
Helv10
Margins 1.75, 1.0
Tab 0.75
First line - the word
NOTE
CAUTION
, or
in Helv9 bold, then tab
DocLinkHead
Helv10 bold upper/lower magenta
Margins 1, 1
Keep with next
Tab 5.0
The words "Contents of This Chapter"
DocLink
Helv10
Margins 1.25, 1.25
Keep Lines Together
Tab 5.0
No blank line between DocLinkHead and DocLink
The section title, tab, and a doclink to the section
IndPara
Margins 1.25, 1.25
IndDisplay
Margins 1.25, 1.25
IndBullet
Margins 1.5, 1.375
Use dash instead of asterisk
IndList
Margins 1.5, 1.25
Figures
Helv9
Title, if used, Helv9 bold - two spaces below, aligned on left with figure
If numbered, precede title with
Figure n-n.
Tables
Helv9
Heads: bold, centered, double-width line on bottom, single otherwise
Text: plain, left, single-width lines
Margins 1.25, 1.25 unless full width of page is need
Title, if used, Helv9 bold - space and a half above, aligned on left with table
If numbered, precede title with
Table n-n.
If text does not need to wrap, make columns just wide enough.
Check your tables carefully after printing. You may have to adjust column width. They do not print with the same wraps as on the screen.
To Create a Table of Contents Document
Print the book chapter by chapter in the desired size.
Copy an existing Table of Contents document and retain a few lines so you can follow the format. The format specifications are as follows. For chapter titles: left margin at 1", tabs at 2" and 5.75"; chapter title in bold. For other titles: left margin at 2"; tab at 5.75"; title in plain text.
Go to the Table of Contents view. Choose
File - Export
. Type in a file name and select Tabular Text in the bottom box. Click
. This procedure exports the view to a file.
Go to the end of the Table of Contents document. Choose
File - Import
. Select the file containing the Table of Contents view, select ASCII Text in the bottom box, and click
Now format the imported text and delete the template text. Add the page numbers by referring to the printed document.
To Create an Index Document
Print the Table of Contents document.
Copy an existing Index document and retain a few lines so that you can follow the format. The format specifications are as follows: left margin at 2"; first line at 1"; tab at 2"; letter in bold, entries and page numbers in plain text.
Go to the Index view. Choose
File - Export
. Type in a file name and select Tabular Text in the bottom box. Click
. This procedure exports the view to a file.
Go to the end of the Index document. Choose
File - Import
. Select the file containing the Table of Contents view, select ASCII Text in the bottom box, and click
Now format the imported text and delete the template text.
At this point, the document still contains document names indented under the topics instead of page numbers following the topic. You must replace the document names with the appropriate page numbers - use the Table of Contents document as a guide. Choose
Edit - Find & Replace
for each entry in the Table of Contents.
ACTIVE
READNOTEACTIVE
EDITNOTEACTIVE
NEWNOTE
KEYBOARD
EDITNOTEKEYBOARD
NEWNOTE
HELP HELP-KEYBOARD
(DESIGNING A VIEW)
ACTIVE
PERUSE
KEYBOARD
PERUSE
ACTIVE
KEYBOARD
HELP HELP-KEYBOARD
532013
2502299
321001
12872020
1802552
3411010
3711000
13093345
61011
10852030
542553
402011
3012022
4512303
401003
13202033
2912033
2912011
3012550
6501013
12562023
5662032
4191992
3652302
102551
3152273
2231949
5902557
931007
12661016
10581007
12662037
1802026
531997
12027
12601999
7292028
12281
322038
3601976
250 1011976
250 100
2702008
4932293
71 FORM2293
71 MACRO2293
VIEW1946
11964
13602558
7702018
4801974
13602559
6311936
679990
4609991
1390980
1415721
1416979
DBNAME
MODIFIED
TOMORROW
ISDOCBEINGRECALCULATED
CONTAINS
DBLOOKUP
PROMPT
TEXTTONUMBER
MIDDLEBACK
SUBSET
ISTEXT
MAILDBNAME
SELECT
ISCATEGORY
ISMEMBER
KEYWORDS
ELEMENTS
MIDDLE
ISNEWDOC
MINUTE
ISTIME
DBCOLUMN
LEFTBACK
MEMBER
MODULO
SECOND
ISDOCBEINGLOADED
TEXTTOTIME
BEGINS
AUTHOR
MAILSEND
ISEXPANDABLE
USERNAME
REPEAT
ISNUMBER
LENGTH
ADJUST
ISDOCBEINGMAILED
LAUNCH
USERPRIVILEGES
DOCDESCENDANTS
DOCLEVEL
PROPERCASE
PASSWORD
CREATED
FAILURE
RIGHT
WEEKDAY
ISERROR
ROUND
UNAVAILABLE
ISAVAILABLE
SUCCESS
MATCHES
DBTITLE
INTEGER
COMMAND
TODAY
ATTACHMENTS
DOCNUMBER
RIGHTBACK
REPLACE
ATTACHMENTNAMES
VIEWTITLE
DOCSIBLINGS
EXPLODE
ISDOCBEINGSAVED
MONTH
RESPONSES
YESTERDAY
ISRESPONSEDOC
NEWLINE
DOCLENGTH
DBMANAGER
ENVIRONMENT
ATTACHMENTLENGTHS
IMPLODE
UPPERCASE
DOCPARENTNUMBER
LOWERCASE
ERROR
ISUNAVAILABLE
DOCCHILDREN
FALSE
SOUNDEX
ISNOTMEMBER
POWER
13198
PRESERVE_EXISTING_LINE_BREAKS_IN
133161
23592
ONLY_ANSI_CGM_METAFILES_MAY_BE_I
13321
13422
13324
13428
13429
* LOTUS NOTES
HELP Context-sensitivity Document
*8/14 noon
* All lines beginning with an asterisk are comment lines
* Lotus, 1-2-3, Lotus Agenda, Symphony, and Lotus Notes are registered
* trademarks of Lotus Development Corporation4
* IF YOU ARE NEW TO THIS DOCUMENT, READ THE FOLLOWING
* COMMENTS.
* Do not mix major context (EDIT, DESK, VIEW, DIALOG, MESSAGE)
* or F1 and Help menu commands will return an error
* Order: EDIT, VIEW, DESK, DIALOG, MESSAGE
* Begin Modes and Contexts
*EDIT KEYBOARD READNOTE
* Invoked via Help Keyboard menu option
EDIT KEYBOARD EDITNOTE 3
Database 'Notes R3 BETA Help', View 'All']
* Invoked via Help Keyboard menu option
EDIT KEYBOARD NEWNOTE
Database 'R3 BETA Help', View 'a. Table of Contents|TOC'
* Same as EDIT KEYBOARD EDITNOTE
EDIT ACTIVE READNOTE
Database 'Notes R3 BETA Help', View 'All'8
* While reading a document
*EDIT ACTIVE EDITFORM
* While editing a form
EDIT ACTIVE EDITNOTE
Database 'Notes R3 BETA Help', View 'All'O
* While editing an existing document
EDIT ACTIVE NEWNOTE
Database 'Notes R3 BETA Help', View 'All'
* While creating a new document
*the following provide menu Help while editing
*EDIT MENU FILE
*EDIT MENU EDIT
*EDIT MENU VIEW
* View objects dependent upon application views and privileges
* Make help generic
*EDIT MENU MAIL
*EDIT MENU COMPOSE
* Compose objects dependent upon application forms and privileges
* Make help generic
*EDIT MENU TEXT
*EDIT MENU TOOLS
*EDIT MENU DESIGN
*EDIT MENU HELP
*EDIT MENU WINDOW
EDIT MENU HELP Help-Keyboard O
Database 'Notes R3 BETA Help', View 'All'
*EDIT MENU SYSTEM
*the following provide menu help while in a view
*VIEW MENU FILE
*VIEW MENU EDIT
*VIEW MENU VIEW
*VIEW MENU MAIL
*VIEW MENU COMPOSE
* Text commands unavailable in a view
*VIEW MENU TOOLS
*VIEW MENU DESIGN]
*VIEW MENU WINDOW]
*VIEW MENU HELP
DESIGN MENU (designing a view)
Database 'Notes R3 BETA Help', View 'All'
*VIEW MENU DESIGN
*VIEW MENU HELPT
*VIEW MENU HELP Help-Keyboard
*VIEW MENU SYSTEM
VIEW ACTIVE Peruse
Database 'Notes R3 BETA Help', View 'All'
*view summary level
*VIEW ACTIVE EDIT
*editing a view
VIEW KEYBOARD PERUSE
Database 'Notes R3 BETA Help', View 'All'
* While at the view level
DESK ACTIVE ]
Database 'Notes R3 BETA Help', View 'All']
*for the desktop (aka the Notes workspace)
DESK KEYBOARD
Database 'Notes R3 BETA Help', View 'a. Table of Contents|TOC'
*for the desktop
*DESK MENU System
* System menu
*DESK MENU FILE
*DESK MENU EDIT
*DESK MENU VIEW
*DESK MENU MAIL]
*Compose & Text commands unavailable at desktop
*DESK MENU TOOLS
*DESK MENU DESIGN
*DESK MENU WINDOW
*DESK MENU HELP
DESK MENU HELP Help-Keyboard
Database 'Notes R3 BETA Help', View 'All']
* DIALOG BOXES
* Also have unique field IDs, which are ignored for this release of Help
*NOTE - "can't get key" or "no key" usually means dialog uses File Open
*NOTE 6/30/92 - where blank (no other comment), intentionally skipped
*NOTE 6/30/92 - where "admin needed" -- I can't get these dlogs
DIALOG 1975 270
Database 'Notes R3 BETA Help', View 'All'
*Add Encryption Key
*DIALOG *Agenda Import Settings
*DIALOG *Agenda Export STF Settings
*DIALOG admin needed *Batch New User
DIALOG
978 1470
Database 'Notes R3 BETA Help', View 'All'
*Button Formula
DIALOG 2008 493
Database 'Notes R3 BETA Help', View 'All'
*Categorize
DIALOG 992 1380
Database 'Notes R3 BETA Help', View 'All']
*Change Links
DIALOG 2016 223
Database 'Notes R3 BETA Help', View 'All'(
*Change User Name
DIALOG 1009 1260
Database 'Notes R3 BETA Help', View 'All'
*Check Spelling
DIALOG 1963 631
Database 'Notes R3 BETA Help', View 'All'
*Choose Dictionary]
DIALOG 1962 631
Database 'Notes R3 BETA Help', View 'All'
*Choose Translation Table
*DIALOG can't get key
*Choose User ID to ExamineW
*DIALOG can't get key
*Choose User ID to Merge into Current ID
*DIALOG can't get key
*Choose User ID to Switch toW
*DIALOG can't get key
*Clear Password (Lotus Notes)
DIALOG 2047 371
Database 'Notes R3 BETA Help', View 'All']
*Color Setup
DIALOG 2031 53
Database 'Notes R3 BETA Help', View 'All'"
*Copy Database(
*DIALOG admin needed ]
*Create Certifier ID
DIALOG 1947 770
Database 'Notes R3 BETA Help', View 'All'
*Create Index
*DIALOG admin needed 4
*Create Organization Certifier ID
*DIALOG admin needed
*Create Organizational Unit Certifier ID
DIALOG 2013 250
Database 'Notes R3 BETA Help', View 'All'
*Currently Held Certificates
DIALOG 2040 93
Database 'Notes R3 BETA Help', View 'All'
*Database Information
DIALOG 2042 315
Database 'Notes R3 BETA Help', View 'All'
*Database Access Control
DIALOG 998 1340
Database 'Notes R3 BETA Help', View 'All'
*Define Style
DIALOG 2303 40
Database 'Notes R3 BETA Help', View 'All'
*Design Column Definition
*DIALOG 2293 71 FIELD *Design Fields (doesn't appear in ALL view)
DIALOG 2293 71 FORM
Database 'Notes R3 BETA Help', View 'All'
*Design Forms
DIALOG 2293 71 MACRO 4
Database 'Notes R3 BETA Help', View 'All'
*Design Macros
DIALOG 2299 32
Database 'Notes R3 BETA Help', View 'All'
*Design Selection Formula
DIALOG 1999 729
Database 'Notes R3 BETA Help', View 'All'
*Design Synopsis
DIALOG 2293 VIEW
Database 'Notes R3 BETA Help', View 'All'
*Design Views
DIALOG 2286 497
Database 'Notes R3 BETA Help', View 'All'
*Document Info
DIALOG 1008 1
Database 'Notes R3 BETA Help', View 'All'0
*Edit Encryption Keys
DIALOG 725 679
Database 'Notes R3 BETA Help', View 'All'
*Edit Header/Footer
*DIALOG can't get key
*Edit Insert Attachment
DIALOG 401 337
Database 'Notes R3 BETA Help', View 'All'
*Edit SmartIcons
DIALOG 999 1313
Database 'Notes R3 BETA Help', View 'All'
*Edit Table Delete Row/Column
DIALOG 1001 1287
Database 'Notes R3 BETA Help', View 'All'
*Edit Table Format Table
DIALOG 1007 1266
Database 'Notes R3 BETA Help', View 'All |(All)'
*Edit Table Insert
DIALOG 1000 1309
Database 'Notes R3 BETA Help', View 'All'
*Edit Table Insert Row/Column
*DIALOG can't get key
*Enter Safe Copy ID
*DIALOG
*Exchange Database
*DIALOG no key *Export
*DIALOG *Export Warning
*DIALOG *Export/Import File Info (Macintosh only)
DIALOG 1016 1058
Database 'Notes R3 BETA Help', View 'All'7
*Field Definition
DIALOG 3345 6
Database 'Notes R3 BETA Help', View 'All'4
*File Database Delete
DIALOG 1949 590
Database 'Notes R3 BETA Help', View 'All'
*File Print
DIALOG 724 4609
Database 'Notes R3 BETA Help', View 'All'
*Find & Replace
DIALOG 726 634
Database 'Notes R3 BETA Help', View 'All'
*Font
DIALOG 1011 1085
Database 'Notes R3 BETA Help', View 'All'
*Form Attributes
DIALOG 2281 32 M
Database 'Notes R3 BETA Help', View 'All'G
*Form Formula
DIALOG 1946 1
Database 'Notes R3 BETA Help', View 'All'
*Full Text Index Options
*DIALOG
*Full Text Index Operations
DIALOG 2018 480
Database 'Notes R3 BETA Help', View 'All'E
*Hang Up
*DIALOG can't get key
*Icon Size (Windows and PM only)
DIALOG 2011 301
Database 'Notes R3 BETA Help', View 'All'
*ID Password
*DIALOG no key *ImportR
DIALOG 2045 650
Database 'Notes R3 BETA Help', View 'All'
*Imported Graphics Metafile Font PreferencesD
DIALOG 991 1390
Database 'Notes R3 BETA Help', View 'All'
*Insert ObjectB
DIALOG 985 1415
Database 'Notes R3 BETA Help', View 'All'
*Insert New Object Display Format
DIALOG 1007 1266
Database 'Notes R3 BETA Help', View 'All'
*Insert TablesD
DIALOG 2038 360
Database 'Notes R3 BETA Help', View 'All'
*International SetupE
DIALOG 990 1395
Database 'Notes R3 BETA Help', View 'All'
*Links
DIALOG 2020 180
Database 'Notes R3 BETA Help', View 'All'S
*Location Setup
DIALOG 1964 1360
Database 'Notes R3 BETA Help', View 'All'
*Mail Certificate Request
*DIALOG
*Mail Address
DIALOG 1976 250 101
Database 'Notes R3 BETA Help', View 'All'
*Mail Encryption KeyH
DIALOG 1974 1360
Database 'Notes R3 BETA Help', View 'All'
*Mail Public Key
DIALOG 1013 1256
Database 'Notes R3 BETA Help', View 'All'
*Mail Save
DIALOG 2005 1
Database 'Notes R3 BETA Help', View 'All'
*Mail Send
DIALOG 2037 180
Database 'Notes R3 BETA Help', View 'All'
*Mail Setup
DIALOG 2022 451
Database 'Notes R3 BETA Help', View 'All'A
*Network PortsO
DIALOG 2303 40 O
Database 'Notes R3 BETA Help', View 'All'
*New Column
DIALOG 2030 54
Database 'Notes R3 BETA Help', View 'All'
*New Database
DIALOG 986 1416
Database 'Notes R3 BETA Help', View 'All'
*New Field
*DIALOG *New Server
*DIALOG *New User
DIALOG 2023 566
Database 'Notes R3 BETA Help', View 'All'
*Notes setup
DIALOG 2026 53
Database 'Notes R3 BETA Help', View 'All'
*Open Database
DIALOG 2027 520
Database 'Notes R3 BETA Help', View 'All'
*Page Setup
DIALOG 1997 1
Database 'Notes R3 BETA Help', View 'All'E
*Page Setup Paper SourceD
DIALOG 1003 1320
Database 'Notes R3 BETA Help', View 'All'
*Paste Special
DIALOG 980 1460
Database 'Notes R3 BETA Help', View 'All'
*PopUp
*DIALOG *Print Form Override
DIALOG 721 672
Database 'Notes R3 BETA Help', View 'All'
*Print Setup
DIALOG 2273 541
Database 'Notes R3 BETA Help', View 'All'2
*Query Builder
*DIALOG *Query Options
*DIALOG *Refresh Design
*DIALOG *Remote Console Connect
*DIALOG *Replace Design
*DIALOG no key
*Save SmartIcons Set4
DIALOG 2033 291
Database 'Notes R3 BETA Help', View 'All'
*Scan Unread Preferred Databases
DIALOG 2032 419
Database 'Notes R3 BETA Help', View 'All'
*Scan Unread Preferred Setup
DIALOG 2033 291
Database 'Notes R3 BETA Help', View 'All'
*Scan Unread Selected Databases
DIALOG 2296 470
Database 'Notes R3 BETA Help', View 'All'E
*Select Documents
*DIALOG *Set Names
DIALOG 2011 301
Database 'Notes R3 BETA Help', View 'All'
*Set Password
*DIALOG no key 1
*SmartIcons
DIALOG 1936 800
Database 'Notes R3 BETA Help', View 'All'
*SmartIcons Formula
*DIALOG admin needed *Specify Certifier
DIALOG 2557
Database 'Notes R3 BETA Help', View 'All'
*Structured Text Export
DIALOG 2558
Database 'Notes R3 BETA Help', View 'All'
*Structured Text Import
DIALOG 2553
Database 'Notes R3 BETA Help', View 'All'3
*Tabular Export SettingsA
DIALOG 2552
Database 'Notes R3 BETA Help', View 'All'
*Tabular Import Settings
DIALOG 2559
Database 'Notes R3 BETA Help', View 'All'
*Text File Export
DIALOG 2559
Database 'Notes R3 BETA Help', View 'All'
*Text File Import
DIALOG 979 1053
Database 'Notes R3 BETA Help', View 'All'2
*Text Paragraph
*DIALOG
*Tools Call
*DIALOG *Use Field
DIALOG 1992 365
Database 'Notes R3 BETA Help', View 'All'8
*User Activity
DIALOG 1976 250 100
Database 'Notes R3 BETA Help', View 'All']
*User ID Encryption Keys
DIALOG 2012 1
Database 'Notes R3 BETA Help', View 'All'
*User ID Information
DIALOG 2046 341
Database 'Notes R3 BETA Help', View 'All'
*User Setup
DIALOG 2302 10
Database 'Notes R3 BETA Help', View 'All'
*View Attributes
DIALOG 1010 1171
Database 'Notes R3 BETA Help', View 'All'
*Window Title
DIALOG 2551
Database 'Notes R3 BETA Help', View 'All'
*Worksheet Export Settings
DIALOG 2550
Database 'Notes R3 BETA Help', View 'All'
*Worksheet Import Settings]
DIALOG 2028 518
Database 'Notes R3 BETA Help', View 'All'
*Workspace Page Name(
*The following dialog boxes share context DIALOG 2559. Users will receive a general explanation and links to the specific activity.]
*Import contexts - dialog box titles:
*Text File Import - shares dialog 2559
* @Functions
@FUNCTIONS ABS
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS ADJUST
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS ALL
Database 'Notes R3 BETA Help', View 'All']
@FUNCTIONS ATTACHMENTLENGTHS ]
Database 'Notes R3 BETA Help', View 'All'W
@FUNCTIONS ATTACHMENTNAMES
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS ATTACHMENTS ]
Database 'Notes R3 BETA Help', View 'All']
@FUNCTIONS AUTHOR
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS BEGINS
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS CHAR
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS COMMAND
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS CONTAINS
Database 'Notes R3 BETA Help', View 'All']
@FUNCTIONS CREATED
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS DATE
Database 'Notes R3 BETA Help', View 'All']
@FUNCTIONS DAY
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS DBCOLUMN
Database 'Notes R3 BETA Help', View 'All']
@FUNCTIONS DBLOOKUP
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS DBMANAGER
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS DBNAME
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS DBTITLE
Database 'Notes R3 BETA Help', View 'All']
*@FUNCTIONS DEFAULT 101
@FUNCTIONS DOCCHILDREN ]
Database 'Notes R3 BETA Help', View 'All']
@FUNCTIONS DOCDESCENDANTS
Database 'Notes R3 BETA Help', View 'All'W
@FUNCTIONS DOCLENGTH (
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS DOCLEVEL
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS DOCNUMBER
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS DOCPARENTNUMBER X
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS DOCSIBLINGS
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS ELEMENTS
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS ENDS
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS ENVIRONMENT 101
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS ERROR
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS EXP
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS EXPLODE
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS FAILURE
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS FALSE
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS HOUR
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS IF
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS IMPLODE
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS INTEGER
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS ISAVAILABLE
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS ISCATEGORY
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS ISDOCBEINGLOADED
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS ISDOCBEINGMAILED
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS ISDOCBEINGRECALCULATED
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS ISDOCBEINGSAVED
Database 'Notes R3 BETA Help', View 'All'C
@FUNCTIONS ISERROR
Database 'Notes R3 BETA Help', View 'All'K
@FUNCTIONS ISEXPANDABLE
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS ISMEMBER
Database 'Notes R3 BETA Help', View 'All'Y
@FUNCTIONS ISNEWDOC
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS ISNOTMEMBER
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS ISNUMBER
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS ISRESPONSEDOC
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS ISTEXT
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS ISTIME
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS ISUNAVAILABLE P
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS KEYWORDS
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS LAUNCH
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS LEFT
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS LEFTBACK
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS LENGTH
Database 'Notes R3 BETA Help', View 'All'E
@FUNCTIONS LN
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS LOG
Database 'Notes R3 BETA Help', View 'All'S
@FUNCTIONS LOWERCASE
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS MAILDBNAME
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS MAILSEND
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS MATCHES
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS MAX
Database 'Notes R3 BETA Help', View 'All'A
@FUNCTIONS MEMBER
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS MIDDLE
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS MIDDLEBACK
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS MIN
Database 'Notes R3 BETA Help', View 'All'T
@FUNCTIONS MINUTE
Database 'Notes R3 BETA Help', View 'All'D
@FUNCTIONS MODIFIED
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS MODULO
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS MONTH
Database 'Notes R3 BETA Help', View 'All'H
@FUNCTIONS NEWLINE
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS NO
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS NOW T
Database 'Notes R3 BETA Help', View 'All'E
@FUNCTIONS PASSWORD
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS POWER
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS PROMPT
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS PROPERCASE
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS REPEAT
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS REPLACE
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS RESPONSES
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS RIGHT
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS RIGHTBACK
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS ROUND
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS SECOND
Database 'Notes R3 BETA Help', View 'All'2
@FUNCTIONS SELECT
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS SOUNDEX
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS
SUBSET
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS
SUCCESS
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS
TEXT
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS O
TEXTTONUMBER
Database 'Notes R3 BETA Help', View 'All'A
@FUNCTIONS
TEXTTOTIME E
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS
TIME
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS
TODAY
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS
TOMORROW
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS
TRIM
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS
TRUE D
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS UNAVAILABLE 1
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS UPPERCASE
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS USERNAME
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS USERPRIVILEGES
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS V2IF
Database 'Notes R3 BETA Help', View 'All'8
@FUNCTIONS VIEWTITLE
Database 'Notes R3 BETA Help', View 'All'1
@FUNCTIONS WEEKDAY
Database 'Notes R3 BETA Help', View 'All'2
@FUNCTIONS WORD
Database 'Notes R3 BETA Help', View 'All'6
@FUNCTIONS YEAR
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS YES
Database 'Notes R3 BETA Help', View 'All'
@FUNCTIONS YESTERDAY 0
Database 'Notes R3 BETA Help', View 'All'D
* Message keys begin
MESSAGE 3142
Database 'Notes R3 BETA Help', View 'All'
* A category is selected; please select a document to respond to
MESSAGE 3143
Database 'Notes R3 BETA Help', View 'All'N
* A category is selected; please select a document WITHIN the category
MESSAGE 3089
Database 'Notes R3 BETA Help', View 'All'
* A field by this name already exists....
MESSAGE 3369
Database 'Notes R3 BETA Help', View 'All'
* A replica for the specified database cannot be found. Do you want...
MESSAGE 1068 3
Database 'Notes R3 BETA Help', View 'All'
* Access control list must contain at lease one Manager2
MESSAGE 1291 9
Database 'Notes R3 BETA Help', View 'All'
* An operator or semicolon expected
MESSAGE 3119 3
Database 'Notes R3 BETA Help', View 'All'
* Another copy of this document was saved while you were editing it.
MESSAGE 3423 ]
Database 'Notes R3 BETA Help', View 'All'(
* At least one document must be selected in order to run ...
MESSAGE 1029
Database 'Notes R3 BETA Help', View 'All'
* Cannot convert text to number]
*MESSAGE
* Cannot locate form: <Form Name>
MESSAGE 258
Database 'Notes R3 BETA Help', View 'All'
* Cannot write or create file
MESSAGE 5929
Database 'Notes R3 BETA Help', View 'All'
* Cannot write or create ID file
MESSAGE 13429 2
Database 'Notes R3 BETA Help', View 'All'
* Changes to this document will not be saved due to Read-Only privileges.
MESSAGE 13428 6
Database 'Notes R3 BETA Help', View 'All'
* Changes to this document will not be saved in Read-Only mode. Do you want to edit the document?]
MESSAGE 6402
Database 'Notes R3 BETA Help', View 'All']
* Could not open the ID file
MESSAGE 3373
Database 'Notes R3 BETA Help', View 'All'
* Created OK - Initialization will occur next replication
MESSAGE 3343
Database 'Notes R3 BETA Help', View 'All'
* Database already added to your workspace. To find it,...(
MESSAGE 3364 ]
Database 'Notes R3 BETA Help', View 'All']
* Database is not initialized yet(
MESSAGE 3535 ]
Database 'Notes R3 BETA Help', View 'All']
* Database not found. Do you want to search for it...
MESSAGE 3446
Database 'Notes R3 BETA Help', View 'All'Y
* Delete the n marked documents permanently from the database?
MESSAGE 3134 ]
Database 'Notes R3 BETA Help', View 'All'W
* Destination file already exists; overwrite it?
MESSAGE 13324 6
Database 'Notes R3 BETA Help', View 'All']
* Do you want to save this form?
MESSAGE 3211
Database 'Notes R3 BETA Help', View 'All'
* Do you want to save this new document?
MESSAGE 13321 6
Database 'Notes R3 BETA Help', View 'All'
* Do you want to save this new form?
MESSAGE 3100 ]
Database 'Notes R3 BETA Help', View 'All']
* Do you want to save your changes?
MESSAGE 3533
Database 'Notes R3 BETA Help', View 'All'
* Do you want to upgrade (redesign) your mail file?W
MESSAGE 3163 ]
Database 'Notes R3 BETA Help', View 'All'(
* Document contains an unrecognize
d feature (possibly from another version of the product)
*MESSAGE * Domain name <name> not found in any Name & Address Book
MESSAGE 3468
Database 'Notes R3 BETA Help', View 'All'
* Each ID requires a software license. Have you...
MESSAGE 1045 ]
Database 'Notes R3 BETA Help', View 'All'W
* Encoded Data Checksum Mismatch - Attachment may be corrupted
MESSAGE 1303
Database 'Notes R3 BETA Help', View 'All']
* End of formula reached before end of quoted string or date/time]
MESSAGE 3303
Database 'Notes R3 BETA Help', View 'All'
* Error accessing Dictionary File]
MESSAGE 3306
Database 'Notes R3 BETA Help', View 'All'
* Error accessing user dictionary file
MESSAGE 3233 ]
Database 'Notes R3 BETA Help', View 'All']
* Error creating tempory file]
MESSAGE 1072
Database 'Notes R3 BETA Help', View 'All'
* Error opening Character Set Translation File
MESSAGE 3303 1
Database 'Notes R3 BETA Help', View 'All'
* Error opening Dictionary file(
MESSAGE 2834 2
Database 'Notes R3 BETA Help', View 'All'
* Error reading configuration data
MESSAGE 264
Database 'Notes R3 BETA Help', View 'All'
* File cannot be created
MESSAGE 259 X
Database 'Notes R3 BETA Help', View 'All']
* File does not exist]
MESSAGE 591
Database 'Notes R3 BETA Help', View 'All'
* File object is truncated - file may have been damaged
MESSAGE 1290
Database 'Notes R3 BETA Help', View 'All'
* Formula incomplete
MESSAGE 1347
Database 'Notes R3 BETA Help', View 'All'
* Formula or value requires too much memory
MESSAGE 3595
Database 'Notes R3 BETA Help', View 'All'
* Groups cannot be nested more than n levels deep when mailing
MESSAGE 3199
Database 'Notes R3 BETA Help', View 'All'
* Help database cannot be located
MESSAGE 3198
Database 'Notes R3 BETA Help', View 'All'
* Help document cannot be located
MESSAGE 3197
Database 'Notes R3 BETA Help', View 'All'
* Help view cannot be located
MESSAGE 5930
Database 'Notes R3 BETA Help', View 'All'
* ID file cannot be created|
MESSAGE 6424 W
Database 'Notes R3 BETA Help', View 'All']
* If you change the user's name, you will lose all the certificates...
MESSAGE 6418 (
Database 'Notes R3 BETA Help', View 'All'
* If you change your name, you will lose all of your certificates...
MESSAGE 1340
Database 'Notes R3 BETA Help', View 'All'
* Incorrect data type variationW
MESSAGE 1054 ]
Database 'Notes R3 BETA Help', View 'All'(
* Index (link) has been corrupted - will be rebuilt automatically when database is closedX
MESSAGE 1049
Database 'Notes R3 BETA Help', View 'All'
* Index (pool) has been corrupted - will be rebuilt automatically when database is closed]
MESSAGE 3115
Database 'Notes R3 BETA Help', View 'All']
* Input validation problem - context dependent
MESSAGE 263 ]
Database 'Notes R3 BETA Help', View 'All'W
* Insufficient memory]
MESSAGE 1047
Database 'Notes R3 BETA Help', View 'All']
* Insufficient memory (P)]
MESSAGE 2561 :
Database 'Notes R3 BETA Help', View 'All'
* Insufficient network or adapter resources. Consult Network documentation to increase the maximum number of sessions.
MESSAGE 2566
Database 'Notes R3 BETA Help', View 'All'
* Internal network software problem (or hardware malfunction)
MESSAGE 283
Database 'Notes R3 BETA Help', View 'All'
* Invalid character in file name
MESSAGE 1044
Database 'Notes R3 BETA Help', View 'All'S
* Invalid encoded data - Attachment may be corrupted
MESSAGE 529
Database 'Notes R3 BETA Help', View 'All'
* Invalid formula format
MESSAGE 5931 #
Database 'Notes R3 BETA Help', View 'All'
* Invalid ID file]
MESSAGE 1282 (
Database 'Notes R3 BETA Help', View 'All'
* Invalid operator
MESSAGE 1283
Database 'Notes R3 BETA Help', View 'All']
* Invalid type of argument
* MESSAGE
* Main formula must be last]
MESSAGE 3341 (
Database 'Notes R3 BETA Help', View 'All'
* Mark n selected documents for deletion?X
MESSAGE 777
Database 'Notes R3 BETA Help', View 'All'e
* Name & Address Book (NAMES.NSF) does not contain a required view
MESSAGE 2575 o
Database 'Notes R3 BETA Help', View 'All'
* NETBIOS not loaded or not running
MESSAGE 2565
Database 'Notes R3 BETA Help', View 'All'
* Network adapter not installed or not functioning
MESSAGE 2571
Database 'Notes R3 BETA Help', View 'All'
* Network name already in use on this system
MESSAGE 2642 ]
Database 'Notes R3 BETA Help', View 'All']
* Network not started]
MESSAGE 2567 V
Database 'Notes R3 BETA Help', View 'All'
* Network operation did not complete in a reasonable amount of time...
MESSAGE 3141
Database 'Notes R3 BETA Help', View 'All'I
* No document is selected; Please select a document to respond to8
MESSAGE 3194
Database 'Notes R3 BETA Help', View 'All'
* No formula specified for a computed field
MESSAGE 3424
Database 'Notes R3 BETA Help', View 'All'8
* No formula was specified in the macro
MESSAGE 1301
Database 'Notes R3 BETA Help', View 'All'
* No main expression in formula
MESSAGE 3592
Database 'Notes R3 BETA Help', View 'All'
* No Name & Address Book database found
MESSAGE 3591 S
Database 'Notes R3 BETA Help', View 'All'
* No names found to send mail to
MESSAGE 2819 E
Database 'Notes R3 BETA Help', View 'All'R
* No printer currently selected
MESSAGE 3590
Database 'Notes R3 BETA Help', View 'All'
* No SendTo field in documentA
MESSAGE 648
Database 'Notes R3 BETA Help', View 'All'
* Notes Version 1 database (.NSF) has grown larger than 40MB. Use File Database Copy to recreate your file as a Notes Version 2 database (.NSF) capable of 100MB.
MESSAGE 649 1
Database 'Notes R3 BETA Help', View 'All'
* Notes Version 1 workspace file (DESKTOP.DSK) has grown larger than 1MB;
MESSAGE Only_ANSI_CGM_metafiles_may_be_I
Database 'Notes R3 BETA Help', View 'All'
* Only ANSI CGM metafiles may be imported
MESSAGE 1298
Database 'Notes R3 BETA Help', View 'All'
* Only ENVIRONMENT, DEFAULT, or FIELD can be used as a modifier to :=
MESSAGE 133161
Database 'Notes R3 BETA Help', View 'All'
* Only text can be pasted into this field
MESSAGE 1302
Database 'Notes R3 BETA Help', View 'All'
* Passing args to a non-function
MESSAGE 3136
Database 'Notes R3 BETA Help', View 'All'
* Permanently delete 1 file attachment from the database?
MESSAGE 3344 T
Database 'Notes R3 BETA Help', View 'All'B
* Permanently delete <database_name>?
MESSAGE 3214
Database 'Notes R3 BETA Help', View 'All'
* Permanently delete the specified area from the document
MESSAGE 3166 L
Database 'Notes R3 BETA Help', View 'All'E
* Please install Roman or Modern fonts on your systemI
*MESSAGE * Preparing to receive Newmail notifications
MESSAGE Preserve_existing_line_breaks_in T
Database 'Notes R3 BETA Help', View 'All'
* Preserve existing line breaks in text?
MESSAGE 2562
Database 'Notes R3 BETA Help', View 'All'
* Remote system no longer responding
MESSAGE 2570
Database 'Notes R3 BETA Help', View 'All'
* Remote system not responding
MESSAGE 3414 T
Database 'Notes R3 BETA Help', View 'All'
* Removing the database will delete your <number> private view(s)...
MESSAGE 5639
Database 'Notes R3 BETA Help', View 'All'
* Replication history is corrupted
* MESSAGE Server <server> is not responding, or...
MESSAGE 3383
Database 'Notes R3 BETA Help', View 'All'
* Some preferences will not take effect until next time...
MESSAGE 1058
Database 'Notes R3 BETA Help', View 'All'
* The access control list is full. If you need to add users,...
MESSAGE 3335
Database 'Notes R3 BETA Help', View 'All'
* The active view cannot be deleted
MESSAGE 6419
Database 'Notes R3 BETA Help', View 'All'
* The certificate(s) have not been issued to you and cannot be merged into your ID file. They have been issued to: <user name>
MESSAGE 3388
Database 'Notes R3 BETA Help', View 'All'
* The database was substantially changed...
MESSAGE 3175
Database 'Notes R3 BETA Help', View 'All'
* The doclink database cannot be located
MESSAGE 327
Database 'Notes R3 BETA Help', View 'All'
* The executable program library cannot be found
MESSAGE 321
Database 'Notes R3 BETA Help', View 'All'
* The file NOTES.INI cannot be found on the search path
MESSAGE 3528
Database 'Notes R3 BETA Help', View 'All'
* The first categorized column in this view...
MESSAGE 5927
Database 'Notes R3 BETA Help', View 'All'
* The ID file is a safe copy and cannot be used for that purpose
MESSAGE 3184
Database 'Notes R3 BETA Help', View 'All'
* The linked document cannot be found
MESSAGE 5646
Database 'Notes R3 BETA Help', View 'All'
* The server does not have a replica of the selected database(s)
MESSAGE 6421
Database 'Notes R3 BETA Help', View 'All'S
* The specified ID file has been corrupted, or is not an ID file
MESSAGE 3102
Database 'Notes R3 BETA Help', View 'All'
* This field cannot be split into multiple paragraphs
MESSAGE 2023
Database 'Notes R3 BETA Help', View 'All'0
* To complete the setup of Notes on this computer ...3
MESSAGE 1348 E
Database 'Notes R3 BETA Help', View 'All'
* Too many concurrent formula evaluations; please retry.
MESSAGE 13422 2
Database 'Notes R3 BETA Help', View 'All'3
* Too many documents open using complex forms. Please close one fo your documents and retry.0
MESSAGE 1845
Database 'Notes R3 BETA Help', View 'All'
* Too many windows - You must close one to continue
MESSAGE 1036
Database 'Notes R3 BETA Help', View 'All'4
* Unable to interpret Time or Date
MESSAGE 1307 H
Database 'Notes R3 BETA Help', View 'All'
* Unknown @function
MESSAGE 3203
Database 'Notes R3 BETA Help', View 'All'
* Unrecognized characters found after number
MESSAGE 5909
Database 'Notes R3 BETA Help', View 'All'
* User ID has been corrupted
MESSAGE 5908
Database 'Notes R3 BETA Help', View 'All'
* User ID version is not supported
MESSAGE 1309 4
Database 'Notes R3 BETA Help', View 'All'
* Variable already defined.
MESSAGE 604
Database 'Notes R3 BETA Help', View 'All'
* You and the signer of this document have no ID Certificates in common...
MESSAGE 587
Database 'Notes R3 BETA Help', View 'All'
* You are not authorized to access the database5
MESSAGE 588
Database 'Notes R3 BETA Help', View 'All'
* You are not authorized to delete the database6
MESSAGE 582 U
Database 'Notes R3 BETA Help', View 'All'4
* You are not authorized to perform that operation
MESSAGE 2831
Database 'Notes R3 BETA Help', View 'All'1
* You can only change selected text. There is no text selected.
MESSAGE 3597 N
Database 'Notes R3 BETA Help', View 'All'
* You do not have a mail file specified. Use ...
MESSAGE 3596 3
Database 'Notes R3 BETA Help', View 'All'
* You do not have a mail server specified. Use...
MESSAGE 3598
Database 'Notes R3 BETA Help', View 'All'
* You must first add your mail file <server name> <mail file> on...
MESSAGE 3113
Database 'Notes R3 BETA Help', View 'All'
* You must first specify a valid name for this form using Design Form Attributes
MESSAGE 3387
Database 'Notes R3 BETA Help', View 'All'2
* Your database privileges were changed ...
MESSAGE 6423
Database 'Notes R3 BETA Help', View 'All'
* Your ID file has been corrupted, or is not an ID file2
MESSAGE 6405
Database 'Notes R3 BETA Help', View 'All'
* Your ID file has not been certified to access the server
*MESSAGE * Your ID has not been certified to use this server
MESSAGE 1071
Database 'Notes R3 BETA Help', View 'All'
* Your name is listed to access this database, but with a different ID
MESSAGE 1296 1
Database 'Notes R3 BETA Help', View 'All'
* := can only appear at the beginning of an expression
MESSAGE 1297
Database 'Notes R3 BETA Help', View 'All'
* := must be immediately preceded by a field or variable name
MESSAGE 3588
Database 'Notes R3 BETA Help', View 'All'
* <Name> not found in any Name & Address Book
MESSAGE 1285
Database 'Notes R3 BETA Help', View 'All'
* @Function or operator expected or @function does not require an...
MESSAGE 1335 ]
Database 'Notes R3 BETA Help', View 'All'W
* @Repeat() yielded string too large
Times New Roman
New Section
Topic
DocLink
DocLinkHead
ChapterHead
BHead
AHead
CHead
ParaLead
Display
Bullet
IndPara
IndDisplay
IndBullet
IndList
Indexx
Print...
BacktrackT
Prev<=
=>Nxti
Section
Section
SectionAssign this topic to a category.
UNIX Release Notes
Categories
SubSection
SubSection^
SubSectionAssign this topic to a topic group.
Product DescriptionInstallation ProcedurePlatform Value Added FeaturesKnown Problems
Title of Section
TopicEnter the title for the section.
Doc
Doc_NumberType order of document within chapter.
Indent?
Indent
Index entries
Index_EntriesList of index entries (separate entries with a carriage return)
Categories =
Section
SubSection"
Categories^
Categories
BodyWrite the body of the document here.
(hidden)
DocAuthor
Times New Roman
Chapter
Chapter
ChapNo"
Topic
DocLinkHead
ChapterHead
Ahead
BHead
CHead
ParaLead
Display
Bullet
IndPara
IndDisplay
IndBullet
IndList
DocLink
Index-
Print...
Backtrack
Prev<=
=>Nxt
Section
Section
SectionAssign this topic to a category.
UNIX Release Notes
Categories
SubSection
SubSection^
SubSectionAssign this topic to a topic group.
Product DescriptionInstallation ProcedurePlatform Value Added FeaturesKnown Problems
Chapter
ChapNoEnter chapter number.
Title of Chapter
TopicAssign a title for this chapter.
Doc
Doc_Number
Indent?
Indent
Index entries
Index_EntriesList of index entries (separate entries with a carriage return)
Categories
Section
SubSection"
Categories^
Categories
BodyWrite the body of the document here.
(hidden)
DocAuthor
Times New Roman
Title Page
Topic
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
BHead
Ahead
ChapterHead
DocLink
Index
Print...
Backtrack
Prev<=
=>Nxt
Section
Section
SectionAssign this topic to a category.
UNIX Release Notes
Categories
SubSection
SubSection^
SubSectionAssign this topic to a topic group.
Product DescriptionInstallation ProcedurePlatform Value Added FeaturesKnown Problems
Title Page
TopicTypically you do not change this field.
Doc
Doc_Number
Indent?
Indent
Index entries
Index_EntriesList of index entries (separate entries with a carriage return)
Categories
Section
SubSection"
Categories^
Categories
BodyWrite the body of the document here.
(hidden)
DocAuthor
Times New Roman
Copyright Page
Topic
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
BHead
Ahead
ChapterHead
DocLink
Index
Print...
Backtrack
Prev<=
=>Nxt
Section
Section
SectionAssign this topic to a category.
UNIX Release Notes
Categories
SubSection
SubSection^
SubSectionAssign this topic to a topic group.
Product DescriptionInstallation ProcedurePlatform Value Added FeaturesKnown Problems
Copyright Page
TopicTypically you do not change this field.
Doc
Doc_Number
Indent?
Indent
No|NYes|Yo
Index entries
Index_EntriesList of index entries (separate entries with a carriage return)
Categories
Section
SubSection"
Categories^
Categories
BodyWrite the body of the document here.
(hidden)
DocAuthor
Times New Roman
Table of Contents
Topic
DocLink
ChapterHead
Ahead
BHead
CHead
ParaLead
Display
Bullet
IndPara
IndDisplay
IndBullet
IndList
Index
Print...
Backtrack
Prev<=
=>Nxt
Section
Section
SectionAssign this topic to a category.
UNIX Release Notesy
Categories
SubSection
SubSection^
SubSectionAssign this topic to a topic group.
Product DescriptionInstallation ProcedurePlatform Value Added FeaturesKnown Problemsn
Table of Contents
TopicTypically you do not change this field.
Doc
Doc_Number
Indent?
Indent
Index entries
Index_Entries
Categories
Section
SubSection"
Categories^
Categories
BodyWrite the body of the document here.
(hidden)
DocAuthor
Times New Roman
Index
Topic
DocLink
ChapterHead
Ahead
BHead
CHead
ParaLead
Display
Bullet
IndPara
IndDisplay
IndBullet
IndList
Index
Print...
Backtrack
Prev<=
=>Nxt
Section
Section
SectionAssign this topic to a category.
UNIX Release Notes
Categories
SubSection
SubSection^
SubSectionAssign this topic to a topic group.
Product DescriptionInstallation ProcedurePlatform Value Added FeaturesKnown Problems
Index
TopicTypically you do not change this field.
Doc
Doc_Number
Indent?
Indent
Index entries
Index_EntriesList of index entries (separate entries with a carriage return)
Categories
Section
SubSection"
Categories^
Categories
BodyWrite the body of the document here.
(hidden)
DocAuthor`
Times New Roman
Appendix
Appendix
Letter"
Topic
DocLinkHead
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
BHead
Ahead
ChapterHead
DocLink
Index
Print...
Backtrack
Prev<=
=>Nxt
Section
Section
SectionAssign this topic to a category.
UNIX Release Notes
Categories
SubSection
SubSection^
SubSectionAssign this topic to a topic group.
Product DescriptionInstallation ProcedurePlatform Value Added FeaturesKnown Problems
Appendix
LetterEnter chapter number.
Title of Appendix
TopicAssign a title for this appendix.
Doc
Doc_Number
Indent?
Indent
Index entries
Index_EntriesList of index entries (separate entries with a carriage return)
Categories
Section
SubSection"
Categories^
Categories
BodyWrite the body of the document here.
(hidden)
DocAuthor
Indent
Topic
Topic
CategoriesDoc_Number$10$Conflict$REF$C1$
How To
Section
Chapter
Chapter Head
Appendix
Title
Copyright
Contents
Preface
About This Book
Index
hidden
CategoriesDoc_Number$10
View Name
Column Name
DROP TABLE
Title Page
CREATE INDEX
ALTER TABLE"
Copyright Page
Programming"
Error Messages
Conventions
CREATE TABLE
FOR UPDATE
HAVING
Index Name
WHERE
Table Name
INSERT
ORDER BY
New Features
Data Types!
What Is ODBC?
Example
CREATE VIEW
DROP INDEX
SELECT
GROUP BY
DROP VIEW
FROM
New...
Properties... Action...
Action
Action Bar
(Untitled)8This value cannot be larger than 22.75 inches(57.785cm).JCommas are not allowed as numeric value separators, please use ';' instead$Unable to interpret specified number
Unable to create action bar.
Categori_ze
_Edit Document
Send Docu_ment
_Forward
_Move To Folder...
_Remove From Folder
Indent
Topic
Topic
CategoriesDoc_Number$10$Conflict$REF$C1$
How To
Section
Chapter
Chapter Head
Appendix
Title
Copyright
Contents
Preface
About This Book
Index
hidden
Print
ming Information$TITLE's
FOLDER_DIRECTORY_OBJECT
LOTUS NOTES ODBC DRIVER
3 SQL Statements
3 Using the Lotus Notes ODBC Driver
0 How to Use This Book
5 What's New in Release 2
2 Installation & Configuration
1 About Lotus Notes ODBC
4 Programming
LOTUS NOTES ODBC DRIVER\5 What's New in Release 2
What's New in Release 2
LOTUS NOTES ODBC DRIVER\5 What's New in Release 2
LOTUS NOTES ODBC DRIVER\4 Programming
LOTUS NOTES ODBC DRIVER\4 Programming
Driver Capabilities: SQLGetInfo Return Values
LOTUS NOTES ODBC DRIVER\4 Programming
ODBC API Functions
%I}Fmm
LOTUS NOTES ODBC DRIVER\3 Using the Lotus Notes ODBC Driver
Exceptions to ODBC SQL Grammar
LOTUS NOTES ODBC DRIVER\3 Using the Lotus Notes ODBC Driver
333333
Using the Universal Relation Table
LOTUS NOTES ODBC DRIVER\3 Using the Lotus Notes ODBC Driver
Using the Lotus Notes ODBC Driver
LOTUS NOTES ODBC DRIVER\3 Using the Lotus Notes ODBC Driver
Connecting to a Lotus Notes Data Source
9Q[fP
LOTUS NOTES ODBC DRIVER\3 Using the Lotus Notes ODBC Driver
Mapping SQL Tables, Views, and Indexes To and From Notes
LOTUS NOTES ODBC DRIVER\3 Using the Lotus Notes ODBC Driver
ffffff
LOTUS NOTES ODBC DRIVER\3 Using the Lotus Notes ODBC Driver
Using Tables Derived From Notes Forms and Views
LOTUS NOTES ODBC DRIVER\3 Using the Lotus Notes ODBC Driver
ffffff
View Column Definitions
LOTUS NOTES ODBC DRIVER\3 Using the Lotus Notes ODBC Driver
The Universal Relation Table
LOTUS NOTES ODBC DRIVER\3 Using the Lotus Notes ODBC Driver
Using Notes Views as Indexes
LOTUS NOTES ODBC DRIVER\3 Using the Lotus Notes ODBC Driver
LOTUS NOTES ODBC DRIVER\3 Using the Lotus Notes ODBC Driver
Summary of Supported SQL Grammar
LOTUS NOTES ODBC DRIVER\3 Using the Lotus Notes ODBC Driver
Under the copyright laws, neither the documentation nor the software may be copied, photocopied, reproduced, translated, or reduced to any electronic medium or machine-readable form, in whole or in part, except in the manner described in the documentation.
Copyright 1993 - 1995 Lotus Development Corporation
55 Cambridge Parkway
Cambridge, MA 02142w
All rights reserved. Printed in the United States.
Lotus and Lotus Notes are registered trademarks of Lotus Development Corporation, a subsidiary of International Business Machines Corp.
Microsoft is a registered trademark and Windows is a trademark of Microsoft Corporation.
Copyright 1994, 1995 Casahl Technology, Inc. All Rights Reserved.
Casahl is a registered trademark of Casahl Technology, Inc.
IndList
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
You might need to modify a data source configuration, perhaps because you have moved a database. You can also delete data sources
Database 'Lotus Notes ODBC Driver Document', View 'Table of Contents'
, and add new ones
Database 'Lotus Notes ODBC Driver Document', View 'Table of Contents'
BHead
To modify a Lotus Notes data source:
1. In the Main group in the Program Manager window, double-click the Control Panel icon.
2. In the Control Panel window, double-click the ODBC icon.
The Data Sources dialog box appears.
3. Select the data source in the Data Sources (Drivers) list box.a
4. Choose Setup.
5. In the Lotus Notes ODBC Setup dialog box
Lotus Notes ODBC Driver Doc
, modify the information about the data source.n
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
The following table lists the C language #defines for the fInfoType argument and the
corresponding values returned by SQLGetInfo.
SQLGetInfo values returned by the ODBC Driver Manager are not listed here.
In this table, "No" means that the driver returns "N", "Yes" means that the driver returns "Y" and "None" means that the driver returns the null string.
fInfoType
Value (#define)
Lotus Notes Driver Return Values
SQL_ACCESSIBLE_PROCEDURES
SQL_ACCESSIBLE_TABLES
SQL_ACTIVE_CONNECTIONS
0 = No Limit
SQL_ACTIVE_STATEMENTS
0 = No Limit
SQL_ALTER_TABLE
SQL_AT_ADD_COLUMN
SQL_BOOKMARK_PERSISTENCE
SQL_BP_SCROLLr
SQL_BP_UPDATE
SQL_COLUMN_ALIAS
SQL_CONCAT_NULL_BEHAVIOR
SQL_CB_NULL
SQL_CONVERT_BIGINT
SQL_CONVERT_BINARY
SQL_CONVERT_BITe
SQL_CONVERT_CHAR
0x000381FF = u
SQL_CVT_CHAR |
SQL_CVT_NUMERIC |
SQL_CVT_DECIMAL |
SQL_CVT_INTEGER |
SQL_CVT_SMALLINT |
SQL_CVT_FLOAT |
SQL_CVT_REAL |
SQL_CVT_DOUBLE |
SQL_CVT_VARCHAR |
SQL_CVT_DATE | o
SQL_CVT_TIME | a
SQL_CVT_TIMESTAMPr
SQL_CONVERT_DATE
0x00028101 = a
SQL_CVT_CHAR | u
SQL_CVT_VARCHAR |
SQL_CVT_DATE | k
SQL_CVT_TIMESTAMP#
SQL_CONVERT_DECIMAL
SQL_CONVERT_DOUBLE
SQL_CONVERT_FLOAT
SQL_CONVERT_INTEGER
SQL_CONVERT_NUMERIC
SQL_CONVERT_REAL
SQL_CONVERT_SMALLINT
0x000001FF =
SQL_CVT_CHAR |
SQL_CVT_NUMERIC |
SQL_CVT_DECIMAL |
SQL_CVT_INTEGER |
SQL_CVT_SMALLINT|
SQL_CVT_FLOAT |
SQL_CVT_REAL |
SQL_CVT_DOUBLE |
SQL_CVT_VARCHAR
SQL_CONVERT_FUNCTIONS
SQL_FN_CVT_CONVERT
SQL_CONVERT_LONGVARBINARY
SQL_CONVERT_LONGVARCHARm
SQL_CONVERT_TIME
0x00030101 =
SQL_CVT_CHAR |
SQL_CVT_VARCHAR |
SQL_CVT_TIME |
SQL_CVT_TIMESTAMP
SQL_CONVERT_TIMESTAMP
0x00038101 =
SQL_CVT_CHAR | m
SQL_CVT_VARCHAR |
SQL_CVT_DATE |
SQL_CVT_TIME |
SQL_CVT_TIMESTAMPm
SQL_CONVERT_TINYINT
SQL_CONVERT_VARBINARYb
SQL_CONVERT_VARCHAR9
0x000381FF = $
SQL_CVT_CHAR |
SQL_CVT_NUMERIC |
SQL_CVT_DECIMAL |
SQL_CVT_INTEGER |
SQL_CVT_SMALLINT | ,
SQL_CVT_FLOAT |
SQL_CVT_REAL |
SQL_CVT_DOUBLE |
SQL_CVT_VARCHAR |
SQL_CVT_DATE |
SQL_CVT_TIME |
SQL_CVT_TIMESTAMP
SQL_CORRELATION_NAME
SQL_CN_ANY
SQL_CURSOR_COMMIT_BEHAVIOR
SQL_CB_PRESERVE
SQL_CURSOR_ROLLBACK_BEHAVIOR
SQL_CB_DELETE
SQL_DATA_SOURCE_NAME
(Data source name from connection.)
SQL_DATA_SOURCE_READ_ONLY
(If the database is local, this is the read-only setting of the database file. If the database is on a server, this indicates whether the user has write access.)
SQL_DATABASE_NAME
(Database name from connection.)
SQL_DBMS_NAME
"Lotus Notes"
SQL_DBMS_VER
"Lotus Notes Version 4"
SQL_DEFAULT_TXN_ISOLATION
SQL_DRIVER_NAME
"NOTESSQL.DLL"
SQL_DRIVER_ODBC_VER
"02.00",
SQL_DRIVER_VER
"2.00.2001" (Returns the version of the installed driver.)
SQL_EXPRESSIONS_IN_ORDERBY
SQL_FETCH_DIRECTION
0x000000C1 =
SQL_FD_FETCH_NEXT |
SQL_FD_FETCH_RESUME |
SQL_FD_FETCH_BOOKMARK
SQL_FILE_USAGE
SQL_FILE_QUALIFIER
SQL_GETDATA_EXTENSIONS
0x00000007 = E
SQL_GD_ANY_COLUMN |
SQL_GD_ANY_ORDER |
SQL_GD_BLOCK
SQL_GROUP_BY
SQL_GB_GROUP_BY_EQUALS_SELECT
SQL_IDENTIFIER_CASE
SQL_IC_SENSITIVE = Names are case sensitive and are stored in mixed case.A
SQL_IDENTIFIER_QUOTE_CHAR
""" (Double quote)
SQL_KEYWORDS
"SERVER,RICHTEXT,TEXT,
SQL_BIGINT,SQL_BINARY,SQL_BIT,
SQL_CHAR,
SQL_DATE,SQL_DECIMAL,
SQL_DOUBLE,SQL_FLOAT,
SQL_INTEGER,SQL_LONGVARBINARY,
SQL_LONGVARCHAR,SQL_NUMERIC,
SQL_REAL,SQL_SMALLINT,SQL_TIME,
SQL_TIMESTAMP,SQL_TINYINT,
SQL_VARBINARY,SQL_VARCHAR"
SQL_LIKE_ESCAPE_CLAUSE
SQL_LOCK_TYPES
SQL_LCK_NO_CHANGE,
SQL_MAX_BINARY_LITERAL_LEN
SQL_MAX_CHAR_LITERAL_LEN
SQL_MAX_COLUMN_NAME_LENe
SQL_MAX_COLUMNS_IN_GROUP_BY
SQL_MAX_COLUMNS_IN_INDEX
SQL_MAX_COLUMNS_IN_ORDER_BYE
SQL_MAX_COLUMNS_IN_SELECT
SQL_MAX_COLUMNS_IN_TABLE
SQL_MAX_CURSOR_NAME_LEN
SQL_MAX_INDEX_SIZE
SQL_MAX_OWNER_NAME_LEN
SQL_MAX_PROCEDURE_NAME_LEN
SQL_MAX_QUALIFIER_NAME_LEN
SQL_MAX_ROW_SIZE
65535
SQL_MAX_ROW_SIZE_INCLUDES_LONG
SQL_MAX_STATEMENT_LEN
(Default is 1024, actual value is from data source.)
The Lotus Notes ODBC driver supports all ODBC API functions with the following exceptions:
IndBullet
SQLColumnPrivileges
SQLTablePrivileges
SQLForeignKeys
SQLPrimaryKeys
SQLProcedureColumns
SQLProcedures
These functions are not implemented in the driver because there is not support for them in Notes.
The following describes how particular functions are implemented in the Lotus Notes ODBC driver, where the implementation differs from the ODBC specification.
BHead
SQLCancel
The SQLCancel function (without the SQLSetStmtOption ASYNC_ENABLE option) is useful for interrupting an SQLPutData function when the return of a long data field requires additional SQLPutData functions.
SQLColumns
If a column in a view does not refer directly to a field, the Lotus Notes ODBC driver names the column in the result set starting with the character "$" followed by a number, for example "$2".
A call to SQLColumns returns only the first 32 characters of the remarks field. The remarks field
corresponds to the Help Description for a field set in the form using the Field Definition dialog
SQLGetConnectOption
SQLSetConnectOption
These functions accept all valid options.
The only option that affects the state of the driver is:
SQL_QUIET_MODE
For SQLSetConnectOption, these options return SQL_SUCCESS if given the argument value shown, and SQLGetConnectOption always returns these values:
SQL_ACCESS_MODE = SQL_MODE_READ_WRITE only
SQL_AUTOCOMMIT = 1 only
These options return SQLSTATE S1C00 (Driver not capable) if given valid input, or S1009 (Invalid argument) in case of invalid input:
SQL_CURRENT_QUALIFIER
SQL_LOGIN_TIMEOUT
SQL_PACKET_SIZE
SQL_TRANSLATE_DLL
SQL_TRANSLATE_OPTION
SQL_TXN_ISOLATION
SQLGetStmtOption
SQLSetStmtOption
These functions accept all valid options. In some cases, SQLSetStmtOption does not accept all possible values:
SQL_BIND_TYPE
SQL_CONCURRENCY = SQL_CONCUR_LOCK or SQL_CONCUR_READ_ONLY only
SQL_CURSOR_TYPE = SQL_CURSOR_FORWARD_ONLY or SQL_CURSOR_STATIC only
SQL_MAX_LENGTH
SQL_MAX_ROWS
SQL_NOSCAN = SQL_NOSCAN_OFF
SQL_RETRIEVE_DATE
SQL_ROWSET_SIZE
These options return SQLSTATE S1C00:
SQL_ASYNC_ENABLE
SQL_KEYSET_SIZE
SQL_SIMULATE_CURSOR
SQL_QUERY_TIMEOUT
SQLSetParam
SQLSetScrollOptions
These functions are supported only for backwards compatibility with ODBC 1.0 applications.
SQLTables
The following table types may be returned:
TABLE
VIEW
ALIAS
UNIVERSAL
Every Notes database includes a table that has the same name as the database. This is referred to as the Universal Relation table. The Universal Relation table contains all fields in all forms in the Notes database. Tables created with the Notes driver are more similar to SQL views than to traditional relational database tables.
SQLTransact
SQLTransact is supported in a limited way. Since Notes does not provide any transaction
mechanism, SQL_COMMIT is supported but SQL_ROLLBACK returns an error.
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
BHead
To delete a Lotus Notes data source
1. In the Main group in the Program Manager window, double-click the Control Panel icon.
2. In the Control Panel window, double-click the ODBC icon.]
The Data Sources dialog box appears.
IndList
3. Select the data source in the Data Sources (Drivers) list box.E
4. Choose Delete, and then choose Yes to confirm the deletion.
bullet1
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
Lotus Notes ODBC Driver Reference
describes how to install, configure, and use the Lotus Notes ODBC driver to open, query, and modify Lotus Notes databases.
BHead
Organization
bullet1
Chapter 1
About the Lotus Notes ODBC Driver
introduces the Lotus Notes ODBC Driver.
Chapter 2
Installation and Configuration.
Chapter 3
Using the Lotus Notes ODBC Driver
describes how to use the Lotus Notes ODBC driver.
Chapter 4x
Programming
provides programming information for application programmers using the Open Database Connectivity (ODBC) application programming interface (API).
Chapter 5
What's New in Release 2
describes new features in this release.
Conventions Used in This Book
Lotus Notes ODBC Driver Reference
uses the following conventions:
introduces additional technical information about a command or procedure.
Wingdings
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
To query Notes data, you must have:
Bullet
The Lotus Notes ODBC driver.
Lotus Notes Workstation software, release 4 or later.
The ODBC Driver Manager (ODBC.DLL) version 2.0 or later.
A computer running either
Bullet
- Microsoft Windows 3.1 or later, or
- Microsoft Windows 95, or
- Microsoft Windows NT 3.5 or later, or
- IBM's OS/2 Warp
Lotus Notes Workstation software must be installed. Notes database files can reside on a server. You do not need to have local copies of these files, but must have at least reader access to them through Notes.
To add, modify, or delete drivers or data sources, you must have the ODBC Control Panel option or the ODBC Administrator program installed on your computer.
For more information about Notes databases, refer to your Lotus Notes documentation.
BHead
AHead
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
AHead
Installing the Lotus Notes ODBC Driver
1. Double-click the Control Panel icon in the Main Group of the Program Manager window.
The Control Panel window appears.
2. Double-click the ODBC icon.
The ODBC Data Sources dialog box appears.
3. Choose Drivers.
The Drivers dialog box appears.
4. Choose Add.
The Add Drivers dialog box appears.
5. Enter the name of the drive and directory containing the Notes driver in the text box and choose OK; or choose Browse to select a drive and directory name.
The Install Drivers dialog box appears.
6. In the Available ODBC Drivers list box, select Lotus Notes.
7. Choose OK.
The Notes driver is installed.
BHead
To delete the Lotus Notes ODBC driver
1. Double-click the Control Panel icon in the Main group of the Program Manager window.
2. Double-click the ODBC icon.
The Data Sources dialog box appears.
3. Choose Drivers.
The Drivers dialog box appears.
4. In the Installed ODBC Drivers list box, select Lotus Notes.
5. Choose Delete.
A message asks you to confirm that you want to remove the driver and all the data sources that use the driver.
6. Choose Yes.
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
The Lotus Notes ODBC driver allows you to open and query a Notes database through the Open Database Connectivity
) interface
Database 'Lotus Notes ODBC Driver Doc', View 'Table of Contents'
The application/driver hierarchy is (file names are for Windows 3.1):
Application
ODBC Driver Manager
(ODBC.DLL)
Lotus Notes ODBC Driver
(NOTESSQL.DLL)
(NSQLODBC.DLL)*
Lotus Notes Workstation Software**
Lotus Notes Server or Local .NSF file
*The Lotus Notes ODBC driver consists of two DLLs. NOTESSQL.DLL is called by the ODBC Driver Manager and this is the DLL whose name appears in ODBC.INI. NSQLODBC.DLL is called by NOTESSQL.DLL.
** The Lotus Notes ODBC driver communicates exclusively with the Lotus Notes workstation software. Lotus Notes handles all network traffic and security.
Mu9I_
The following ODBC SQL grammar is supported.
BHead
Supported Statements
ALTER TABLE
CREATE INDEX
CREATE TABLE
CREATE VIEW
DELETE searched
DELETE positioned
DROP INDEX
DROP TABLE
DROP VIEW
INSERT
SELECT
WHERE
FOR UPDATE o
GROUP BY
HAVING
ORDER BY e
UPDATE searched
UPDATE positioned
Supported Expressions, Functions, and Operatorse
Numeric Operatorst
Predicate Operatorsu
Column Functions
indbullet1
IndList
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
Before you can connect to a Notes database with the Lotus Notes ODBC driver, you must add a
A Lotus Notes Data Source specifies the Notes server and Notes database you want to open.
data source
for it. You can change or delete a data source at any time. You can use as many data sources as you like with a particular driver, provided no two data sources have the same name.
BHead
To add a Lotus Notes data source:
1. In the Main group in the Program Manager window, double-click the Control Panel icon.
2. In the Control Panel window, double-click the ODBC icon.
The ODBC Data Sources dialog box appears.
3. Choose Add.
The Add Data Source dialog box appears.
4. Select Lotus Notes from the Installed ODBC Drivers list box.
5. Choose OK.
6. In the Lotus Notes ODBC Setup dialog box
, enter information to set up the data source.
subhead
subpara
BHead
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
1. Enter a name that identifies the data source in the Data Source Name text box. For example, add the name "Employee" to identify the ODBC connection to an employee database.
2. (Optional) Enter a description of the data source in the Description text box. For example, add the description "Hire date, salary history, and current review of all employees" to describe the contents of the employee database.
3. Enter the name of the Notes server that contains the Notes database you want to open in the Server text box. Leave the text box blank if the Notes database is on a local disk.
4. Enter the path and name of the .NSF file you want to open in the Database text box. For example,
IndList
C:\PERSONNEL\EMPLOYEE.NSF
for a file on a local disk, or
PERSONNEL\EMPLOYEE.NSF
for a database on a Lotus Notes server.
BHead
NotesSQL Options Setup
You can modify any of the following optional parameters. The values for these parameters affect run-time memory allocation:
Max Length of Text Fields
This parameter specifies
the maximum number of bytes the Lotus Notes ODBC driver allows in a string. This includes the limit on the number of characters returned from a Notes text field, as well as the limit on the length of a string to be inserted into a Notes document.
The maximum value allowed is
10,240 (10K).
The default value is 254. If the database will be used exclusively or primarily with 1-2-3, then
a value of 511 is recommended. This is the maximum length of a string in a cell in 1-2-3.
Max Number of Tables
This parameter specifies the
maximum number of tables in a single query.
The maximum value allowed is
The default value is 20.
Max Number of Subqueries
This parameter specifies the
maximum number of nested subqueries in an SQL statement.
The maximum value allowed is
The default value is 20.
Keep Temporary Indexes Until SQLDisconnect
This option controls the saving of temporary indexes. Select the option to save temporary indexes until SQLDisconnect. Leave the option unselected to delete indexes at the end of each SELECT result.
Return Notes Implicit Fields
This option controls whether certain Notes fields are provided through SQLStatistics & SQLSpecialColumns. Turn it off for maximum interoperability. Turn it on for backward compatibility with NotesSQL 2.0 or earlier. The default is off.
Max Length of Rich Text Fields
This parameter is the same as Max
Length of Text Fields, but for rich text fields.
The maximum value allowed is 10,240 (10K).
The default value is 512. If the database will be used exclusively or primarily with 1-2-3, then
a value of 511 is recommended. This is the maximum length of a string in a cell in 1-2-3.
Note:
Notes databases have long text fields called Rich Text fields. The Body field of a Notes document is often a Rich Text field. If you want to retrieve all the data in such a field, be sure that the maximum string length you specify is large enough.
SQL Statement Length
This parameter specifies the maximum length of an SQL statement passed to SQLPrepare or SQLExecDirect.
The maximum value allowed is 32,767 (32K).
The default value is 4,024.
Thread Timeout
All calls are serialized so they proceed one after the other. This parameter specifies the number of seconds one thread should wait for another thread to finish.
The maximum value allowed is 99,999.
The default is 60.
A value of 0 means wait forever.
BHead
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
You can use the Lotus Notes ODBC driver with any application that supports ODBC drivers for external data access. To connect to the Notes database, you select the data source
Database 'Lotus Notes ODBC Driver Doc', View 'Table of Contents'
you defined using the Setup dialog box
Database 'Lotus Notes ODBC Driver Doc', View 'Table of Contents'
If your Notes ID is password-protected, Notes prompts for a password when you first connect to a remote database using the Lotus Notes ODBC driver. This information is not database-specific, and is retained for the length of the session, so you will not need to enter it more than once if you connect to more than one database.
Lotus Notes never prompts for a User ID. Your Notes User ID is part of your workstation installation.
BHead
Connection Strings
The following keywords are supported for the SQLDriverConnect call:
Keyword
Description
The name of the data source.
Database
The name of the Notes database, with a path if necessary.
Server
The name of the Notes server where the database is located.
If the database is on the local workstation
leave the field blank.
For example, to connect to the Personnel data source in the directory PERSONNEL on
ODBC (Open Database Connectivity) is an interface that allows applications to retrieve and manipulate data in database management systems using SQL. The interface allows a single application to connect to many different types of databases through a standard protocol. ODBC is implemented as a Driver Manager and multiple drivers. Each driver links the application to a specific type of database.
The major components of ODBC are the Microsoft ODBC driver manager and the underlying driver files. Each ODBC driver is a Windows dynamic link library for accessing a specific type of database. ODBC Drivers use a driver manager to handle connection, and an administration tool to configure ODBC data sources. An ODBC data source may be a local directory or file, or a combination of a DBMS, a remote host operating system, and a network.
5Courier New
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
The Lotus Notes ODBC driver supports most SQL statements and clauses in the ODBC Minimum and Core grammar. The following table describes exceptions:
Grammar
Limitation
WHERE clause and TIMESTAMP fields
Timestamp fields need to be fully padded when used in Where clauses if the time component is not used. If time is not used, the following format is required
'1995-12-31 00:00:00'
ALTER TABLE
The following keywords are not supported:
NOT NULL
CREATE INDEX
The UNIQUE keyword is not supported
CREATE TABLE
The following keywords are not supported:
NOT NULL
UNIQUE
PRIMARY KEY
REFERENCES
No table constraint definition
PARAMETER RESTRICTIONS
Parameters are supported in INSERT, DELETE, and SELECT SQL statements. They
cannot
be used with CREATE TABLE, CREATE VIEW and other statements that manipulate the structure of tables and views.
RESTRICT and CASCADE
Dependencies are only recognized if they were originally created using the driver. DROP TABLE CASCADE will only remove dependent Views created using the driver. DROP TABLE RESTRICT will only prevent the removal of a table if a dependent View was created using the driver.
GRANT and REVOKE
Not supported. All access control is handled implicitly by Notes.
Wingdings
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
Error messages come from three areas:
Driver Manager
(ODBC.DLL)
Lotus Notes ODBC Driver
Lotus Notes Workstation
The Driver Manager detects incorrect sequences of ODBC API calls and invalid parameter values.
The Lotus Notes ODBC driver (NotesSQL) detects errors when parsing and validating SQL commands.
The Lotus Notes Workstation detects errors when executing database operations.
Error messages have the following format:
IndPara
[vendor][ODBC-component][data source]
message-text
The prefixes in square brackets ([ ]) identify the location of the error.
The following table shows the format of error messages returned by the Driver Manager, Lotus Notes ODBC driver, and Lotus Notes Workstation:
Error message
Error location
[Microsoft][ODBC DLL]
message-text
Driver Manager (ODBC.DLL)
[Casahl/Lotus][ODBC Lotus Notes]
message-text
Lotus Notes ODBC Driver (NOTESSQL.DLL)
[Casahl/Lotus][ODBC Lotus Notes][Lotus Notes Server]Notes API error:
message-text
Lotus Notes Workstation
or Serveru
BHead
Errors reported by the Lotus Notes ODBC driver or the Driver Manager
The driver returns an error message and the appropriate SQLSTATE when an error is detected in the Lotus Notes ODBC driver or the Driver Manager.
When the error is detected in the Driver Manager, the Notes driver, or the SQL engine layer, the name of a data source is not included in the error message.
Errors reported by the Lotus Notes Workstation
When an error is reported by the Lotus Notes Workstation, the NotesSQL driver returns SQLSTATE S1000 and the error message returned by the Notes Workstation.
Wingdings
AHead
IndPara
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
The ALTER TABLE statement adds one or more columns to a table.
Database 'Lotus Notes ODBC Driver Doc', View 'Table of Contents'
is one of the following:
CHAR(n) or CHARACTER(n) where 1 <= n <= 254
DECIMAL(p, s) where p (precision) is 1 <= p <= 15 and s (scale) is 0 <= s <= p
NUMERIC(p, s) (same as DECIMAL)
SMALLINT
INTEGERf
FLOATe
DOUBLE PRECISION
VARCHAR(n) or CHARACTER VARYING(n) (same as CHAR)
TIME
TIMESTAMPH
Restrictions
NULL and NOT NULL are not supported.d
ALTER TABLE DROP is not supported.r
VARCHAR will produce a fixed length CHAR fields, instead of a large text field.
Wingdings
AHead
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
AHead
The CREATE INDEX statement defines an index for a table.
Syntax
Display
CREATE INDEX
<index name>
<base table name>
<column name> [
] [ , <column name> [
] ] ...
AHead
Example
CREATE INDEX
CUSTNDXC
CUSTOMER i
LASTNAME ASC
BHead
Arguments
<index name>
is the name of the index to create.
<base
table name
is the name of the table to be indexed.
column name
is the name of a column to include in the index. The entire list of column specifications is enclosed in parentheses and items are separated by commas. The column may not be of type VARCHAR.t
ASC or DESC specifies the order of the index, either ascending (ASC) or descending (DESC). If not specified, the index is built in ascending order.
Note
This operation creates a new view in the Notes database.
Restrictions
No unique index.
Wingdings
AHead
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
AHead
The CREATE TABLE statement defines a new table in the current database.
Syntax
Display
CREATE TABLE
<base table name>
<column name> <datatype>
DEFAULT
<default value> ] }
[ , ... ]
AHead
Example
CREATE TABLEs
STAFF
(STAFF_NO
LASTNAME
(15),
FIRSTNAME
(10),
HIREDATE
LOCATION
(15),
SUPERVISOR
SALARY
FLOAT
COMMISSION
FLOAT
BHead
Arguments
<base table name>
is the name of the table to create.
column name
is the name of a column.
<datatype>
Database 'Lotus Notes ODBC Driver Doc', View 'Table of Contents'
is one of the following:
IndList
CHAR(n) or CHARACTER(n) where 1 <= n <= 254
DECIMAL(p, s) where p (precision) is 1 <= p <= 15 and s (scale) is 0 <= s <= p
NUMERIC(p, s) (same as DECIMAL)
SMALLINT
INTEGER
REAL
FLOAT
DOUBLE PRECISION
VARCHAR(n) or CHARACTER VARYING(n) (same as CHAR)
DATE
TIMEl
TIMESTAMPF
IndPara
The field size specified for CHAR and VARCHAR fields is required by the syntax but ignored by Notes when creating the field.
Restrictions
NULL default value is not supported.
Column and table constraint definitions are not supported.
VARCHAR will produce a fixed length CHAR fields, instead of a large text field.
Wingdings
AHead
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
AHead
The CREATE VIEW statement defines a new view in the current database.
Syntax
Display
CREATE VIEW
<view name>
<column list>
<query specification>
AHead
Example
CREATE VIEW
NYCUST
COMPANY,ADDRESS
SELECT COMPANY,ADDRESS FROM CUSTOMER WHERE STATE = 'NY'
BHead
Arguments
<view name>
is the name of a new view.
<column list> is a comma-delimited list of
column names
Wingdings
AHead
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
AHead
The positioned DELETE statement deletes the last row fetched (the current row).
Syntax
Display
DELETE FROMn
<table name>
WHERE CURRENT OF
<cursor name>
AHead
Examplee
DELETE FROM
INVENTORY
WHERE CURRENT OF
SQL_CUR_0
BHead
Arguments
<table name>
is the name of the table where you want to delete data.
<cursor name> is the name of the cursor pointing to the row to be deleted.
Wingdings
AHead
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
AHead
The DELETE searched statement deletes specified rows from a table.
Syntax
Display
DELETE FROM
<table name> [
WHERE
<where clause> ]
AHead
Example
DELETE FROM
NYCUST
WHERE
COMPANY = 'Interior Designs'
BHead
Arguments
<table name>
is the name of the table where you want to delete data.
<where clause> specifies the rows to delete. If no WHERE clause is specified then all rows in the table are deleted.
Wingdings
AHead
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
AHead
The DROP INDEX statement deletes an index from the current database.
Syntax
Display
DROP INDEX
<index name>
AHead
Example
DROP INDEX
CUSTNDX
BHead
Arguments
<index name>
is the name of the index to delete.
This operation deletes a Notes view.
Restrictions:
Wingdings
AHead
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
AHead
The DROP TABLE statement deletes a table from the current database.
Note:
The DROP TABLE statement does not delete data from the database.
Database 'Lotus Notes ODBC Driver Document', View 'Table of Contents'
Syntax c
Display
DROP TABLE
<base table name> [
CASCADE
RESTRICT
Example
DROP TABLE D
NEWCUST
BHead
Arguments
<base table name>
is the name of the table to delete.
This operation deletes a Notes form and does not delete the documents created with that form. When Notes tries to display one of these documents, Notes will display an error message because it cannot find the form needed to display the document.
Wingdings
AHead
BHead
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
AHead
The DROP VIEW statement deletes a view from the current database.
BHead
Syntax
Display
DROP VIEW
<view name>
AHead
Example
DROP VIEW
NYCUST
BHead
Arguments
<view name>
is the name of the view to delete.
Restrictions:
Dependent objects and documents are not dropped.n
AHead
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
AHead
The FOR UPDATE clause allows the specification of a list of column names
BHead
Syntax
Display
<FOR UPDATE clause> is
FOR UPDATE OF
<column list>`
AHead
Example
Select
FROM
INVENTORY
WHERE
LOCATION='New York'T
FOR UPDATE OF
ON_HAND
Wingdings
BHead
AHead
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
The FROM clause specifies the table names or views that are the source tables for a
query.
BHead
Syntax
Display
<FROM clause> is
{<table reference> [ <alias> ] } [ , ... ]
AHead
Example
SELECT
FROM
CUSTOMER
BHead
Arguments
<table reference> is the name of a table
or a view
<alias> is an alias for the table name or view name. The alias is defined only for this query.
AHead
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
The GROUP BY clause groups the data from source tables by one or more columns
and produces a single summary row for each column name
specified.
BHead
Syntax
Display
<GROUP BY clause> is
GROUP BY
column
list>
AHead
Example
SELECT
LOCATION, AVG(UNITCOST)
FROM
INVENTORY
GROUP BY
LOCATION
This list cannot include derived columns. All columns in the GROUP BY must also appear in the
SELECT
clause.
AHead
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
The HAVING clause specifies a search condition for a group.
BHead
Syntax
Display
<HAVING clause> is
HAVING
<search condition>
AHead
Example
SELECT
LOCATION, AVG(UNITCOST)
FROM
INVENTORY
GROUP BY
LOCATION
HAVING
AVG(UNITCOST) > 600
The search condition must include a Column function.
Lotus Notes ODBC Driver Doc
Wingdings
AHead
AHead
BHead
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
The INSERT statement adds a row to a table. Values can be specified explicitly or derived from a query. The value assigned to a column must be compatible with the column's datatype. If no value is specified, a default is assigned if available.
is the name of the table into which to insert data.
<column list> is an optional list of the columns to update. If you do not specify a column list, then values are assigned to columns in the order in which they appear in the definition of the table. You must separate column names
with commas and enclose the entire list in parentheses.
<value list> You must separate values with commas and enclose the entire list in parentheses. Each value must be one of the following
IndList
A quoted string constant (use single quotes)
A numeric constant
A dynamic parameter
NULL
IndBullet
The INSERT statement must contain either a VALUES clause or a SELECT clause.
When the Notes driver inserts a new record into a table, it evaluates three formulas in the form design for every field (Notes does the same thing when you compose a document):
Default Value
Input Translation
Input Validation
The field definition can include any of these formulas or none of them. These formulas are evaluated in the following order:
1. The Default Value formula (if it exists) is evaluated to supply a value when the INSERT
statement contains no data for the field.
2. The Input Translation formula is evaluated.
The Input Translation formula could change the value of the inserted data.
3. The Input Validation formula is evaluated.
If the Input Validation formula returns FALSE then the insert of that row fails.
When an INSERT statement involves multiple records, and one or more of the insertions fails an input validation check, the return code from SQLExecute or SQLExecDirect is
SQL_SUCCESS_WITH_INFO. This tells the user what failed and allows valid insertions to
continue.
AHead
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
The ORDER BY clause specifies how to sort the records retrieved based on a query.
BHead
Syntax
Display
<ORDER BY clause> is G
ORDER BY
{ { <
column name
| <integer> } [ e
[ , ...])
AHead
Example
SELECT
LOCATION, AVG(UNITCOST)
FROM
INVENTORY
GROUP BY
LOCATION
ORDER BY
LOCATION DESC
Wingdings
BHead
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
The SELECT statement selects rows and columns from tables either for display or as input to other SQL statements.
BHead
Syntax
Display
SELECT
DISTINCT
] <fullselect> [ <
ORDER BY clause
> | <
FOR UPDATE
clause> ]
BHead
Arguments
<fullselect> is:
IndList
<SELECT clause>
FROM clause
[ <
WHERE clause
[ <
GROUP BY clauseB
[ <
HAVING clauseB
<SELECT clause> is {
| <expression list> }
<expression list> is a list of column names and other expressions whose values will appear in the result table (result set).
Wingdings
BHead
AHead
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
The positioned Update statement updates the last row fetched.
BHead
Syntax
Display
UPDATE
<table name>
{ <column name>
<value expression> } [ , ... ]
WHERE
CURRENT OF
<cursor name>
AHead
Example
UPDATE
INVENTORY
SET
QTY = 100.00
WHERE CURRENT OF
SQL_CUR_0
BHead
Arguments
<table name>
is the name of the table to update.
column name
is the name of a column in the table.
<value expression> is the new value for the column. This must be either a value expression or a dynamic parameter.
<cursor name> is the name of the cursor pointing to the row to update.
Wingdings
AHead
BHead
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
The UPDATE searched statement updates values in selected rows of a table. v
BHead
Syntax
Display
UPDATE
<table name>
{ <column name>
<expression> } [ , ... ]
[ <where clause> ]
AHead
Examples
Bullet
UPDATE
INVENTORY
UNITCOST=UNITCOST * 1.2
UPDATE
STAFF
SET
COMMISSION = (COMMISSION * 1.25)
WHERE
HIREDATE < '1982-07-05'
BHead
Arguments
<table name>
is the name of the table to update.
column name
is the name of a column in the table.
<expression> is an expression which evaluates to a new value for the column.
<where clause> (see
SELECT
) identifies which rows will be updated. If no WHERE clause is supplied, all rows are updated.
Wingdings
AHead
BHead
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
AHead
The WHERE clause specifies the conditions that records must meet for retrieval.
BHead
Syntax
Display
<WHERE clause> is
WHERE
<search condition>
AHead
Examples
Bullet
SELECT
FROM
CUSTOMER
WHERE
CITY='New York'
2.SELECT
PART_NO, DESCRIPT, ON_HAND, LOCATION, UNITCOST
FROM
INVENTORY
WHERE
ON_HAND > 50
3.SELECT
PART_NO, DESCRIPT, LOCATION, ON_HAND, UNITCOST
FROM
INVENTORY
WHERE
LOCATION = 'Los Angeles'
LOCATION = 'New York'
AND Z
ON_HAND < 20
AND
UNITCOST < 1000
BHead
Arguments
<search condition> is <boolean term> [
<search condition> ]
<boolean term> is <boolean factor> [
<boolean term> ]
<boolean factor> is [ x
] <boolean primary>
<boolean primary> is <predicate> |
<search condition>H
<predicate> is one of the following:u
IndList
<between predicate> is:
<expression> [
BETWEEN
<expression>
<expression>
<comparison predicate> is:
expression
comparison operator
> <expression>
<exists predicate> is:
EXISTS
( <subquery>)
<in predicate> is:
[
{ <subquery> | <value list> }
<like predicate> is:
column name
search pattern
<quantified comparison predicate> is:
<expression> <comparison operator> {
subquery
<all condition> is:
<expression> <comparison operator> [
( <subquery> )
<IN comparison with subquery>is:
<expression> [
( <subquery> )
<join condition> is:
<column
expression
> <comparison operator> <column expression>
These column expressions are generally qualified by table name or alias. Column expressions can not include asterisks ( * ).
The Lotus Notes ODBC driver supports the following numeric operators in expressions.
Operator
Meaning
Addition
Subtraction
Multiplication
Division
The Lotus Notes ODBC driver supports the following predicate operators.
Operator
Meaning
Less Than
Greater Than
Less Than or Equal
Greater Than or Equal
Equal
Not Equal
BETWEEN
Specifies a range of values between a lower and upper boundary.
Specifies a member of a set of specified values or a member of a subquery.
Use for matching a pattern. Wildcard characters in LIKE predicate:
Use an underscore ( _ ) to represent a single character.
Use a percent symbol ( % ) to represent any number of characters.
Use a backslash ( \ ) as the escape character.
Use the NOT operator with another operator to specify a search condition that is false. For example: NOT IN, NOT LIKE, or NOT BETWEEN.
Use to compare a value to each value returned by a subquery. Can be prefaced by =, <>, >, >=, <, <=, =.
=ANY is equivalent to IN.
<>ANY is equivalent to NOT IN.
SOME is an alternate keyword for ANY.
Use to compare a value to each value returned by a subquery. Can be prefaced by =, <>, >, >=, <, <=
EXISTS
"True" if a subquery returned at least one record.
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
Column functions can also be part of a SELECT clause. A column function takes an entire column of data as its argument and produces a single data item that summarizes the column. For example: the AVG column function takes a column of data and computes its average.
The argument to a column function can be a field name or an expression. The Lotus Notes ODBC driver supports the following Column functions.
Function
Description
Returns the average of the values in a numeric field or expression. For example, AVG(SALES) returns the average of all values in the column "SALES".
COUNT
Returns the number of values in any field expression.
Returns the highest value in any field expression. For example, MAX(SALES) returns the highest sales field value.
Returns the lowest value in any field expression. For example, MIN(SALES) returns the lowest sales field value.
Returns the total of values in numeric field expression. For example, SUM(SALES) returns the sum of all sales field values.
Wingdings
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
The following table shows how Lotus Notes data types are mapped to ODBC SQL data types. In addition to the SQL data types Notes supports two additional data types:
List Fields
IndBullet
Rich Text Fields
ODBC SQL Data Type
Lotus Notes Data Type
SQL_CHAR
SQL_VARCHAR
SQL_LONGVARCHAR
SQL_DECIMAL
Number, Fixed format
SQL_NUMERIC
Number, Fixed format
SQL_SMALLINT
Number, Fixed format
SQL_INTEGER
Number, General format
SQL_REAL
Number, General format
SQL_FLOAT
Number, General format
SQL_DOUBLE
Number, General format
SQL_DATE
SQL_TIME
SQL_TIMESTAMP
Note
SQLGetTypeInfo returns ODBC SQL data types. All conversions in Appendix D of the
Microsoft ODBC SDK Programmer's Reference
are supported for the ODBC SQL data types listed earlier in this topic.
SQL_TIMESTAMP fields do not support fractions of a second.
SQL_VARCHAR or SQL_LONGVARCHAR data types
cannot
be used to create rich text fields. They create Text fields.
BHead
Notes to SQL data type mapping:A
Lotus Notes data type
ODBC SQL data type
Number, Fixed format
Number, Percent format
SQL_DECIMAL
Number, General format
Number, Scientific format
SQL_FLOAT
Depending on format this can be SQL_TIME, SQL_DATE, or SQL_TIMESTAMP
SQL_VARCHAR
Keyword
SQL_VARCHAR
Multi-value list
SQL_VARCHAR
Rich text field
Text portion only, as SQL_LONGVARCHAR
Section
Not supported
Conversion from Rich Text to SQL_LONGVARCHAR adds line breaks.
Numeric values greater than 10 to the 99th power are not supported. Note, some products that use ODBC drivers have limitations on the exponent and precision size of real numbers. Please check the limits of the product you are using for additional limit information.
The Lotus Notes ODBC driver does not check the keyword list for Keyword fields. It is possible to insert values not on the keyword list when the "allow values not in list" box is not checked.r
The Lotus Notes ODBC driver does not support Notes Section security. User of the Lotus Notes ODBC driver can read and modify fields anywhere on a form.
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
The Lotus Notes driver supports multiple values in fields. The Lotus Notes driver contains information about which fields can have multiple values, and the underlying data type for these values.
The Lotus Notes driver does not support list fields in DDL statements (CREATE TABLE, ALTER TABLE, CREATE INDEX, CREATE VIEW).
Use the following notation in DML statements (SELECT, INSERT, UPDATE searched, UPDATE positioned, DELETE Searched, DELETE positioned) to specify a list of values:
'string;string;string'
Text Fields
The Lotus Notes driver returns all the data in multi-valued fields composed of text as a single string, with items separated by semicolons. For example:
'a;b;c'
Note:
An extra semicolon can appear in the result if: data was entered in Notes, and any character other than a semicolon was used as the list separator, and the list contains an item which includes a semicolon.
The Lotus Notes driver accepts a semicolon-delimited list of strings for insertion in a multi-valued field of type Text. For example:
'a;b;c'
This value creates a list in the Notes document if the field allows multiple values. If the field does not allow multiple values, the value appears in Notes as a single string. Data retrieved through the Lotus Notes driver produces the same result in either case.
Numeric and Date Fields
The Lotus Notes driver returns only the first value in the list when the multi-valued fields are numeric or date fields.
Currently the Lotus Notes driver accepts only a single numeric or date value for insertion in a multi-valued field of type Numeric or Date.
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
The Lotus Notes ODBC driver returns only the text part(s) of a Notes Rich Text field. The Lotus Notes ODBC driver cannot create a Rich Text field.
The driver supports only the LIKE operator in a WHERE clause for testing Rich Text fields. The driver does not support any other tests on Rich Text fields.
Additional restrictions on Rich Text fields:
If a Rich Text field in Notes has embedded bitmaps or large attachments, text following the bitmap may not be returned by NotesSQL.
If a Rich Text field contains only blank lines, NotesSQL will not return data from that field.
String constants in a LIKE statement are restricted to a maximum of 254 characters, including any embedded carriage returns.
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
A table name can be up to 64 characters long. Table names can consist of letters, digits, underscores ( _ ), dollar signs ( $ ), and spaces. If a table name contains a space or is the same as a SQL reserved word, then the name must be enclosed in double-quotes.
When creating a table, remember that table names must be unique within a database. Don't use the name of an existing table or view.
If a Notes database contains both a view and a form with the same name, NotesSQL will see the form but not the view.
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
A column name can be up to 32 characters long. Column names can consist of letters, digits, underscores ( _ ), and dollar signs ( $ ). Column names connot contain spaces or conflict with a SQL reserved word.
When creating or altering a table, remember that column names must be unique within a table. Don't use the name of another column in the table.
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
An index name can be up to 32 characters long. Index names can consist of letters, digits, underscores ( _ ), dollar signs ( $ ), and spaces. If an index name contains a space or is the same as a SQL reserved word, then the name must be enclosed in double-quotes.
When creating an index, remember that index names and view names must be unique within a database. Don't use the name of an existing index or view.
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
A view name can be up to 32 characters long. View names can consist of letters, digits, underscores ( _ ), dollar signs ( $ ), and spaces. If a view name contains a space or is the same as a SQL reserved word, then the name must be enclosed in double-quotes.
When creating a view, remember that index names and view names must be unique within a database. Don't use the name of an existing index or view.
If a Notes database contains both a view and a form with the same name, NotesSQL will see the form but not the view.
DocLink
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
BHead
Ahead
ChapterHead
DocLinkHead
This chapter introduces the Lotus Notes ODBC Driver.
Contents of this chapter:
What is ODBC?
Database 'Lotus Notes ODBC Driver Doc', View 'Table of Contents'
What is the Lotus Notes ODBC Driver?e
Database 'Lotus Notes ODBC Driver Doc', View 'Table of Contents'
This chapter describes how to install the Lotus Notes ODBC driver, create ODBC data sources, and connect to the data source.
Contents of this chapter:a
Installing the Lotus Notes ODBC Driver
Database 'Lotus Notes ODBC Driver Doc', View 'Table of Contents'
Lotus Notes ODBC Setup Dialog Boxt
Database 'Lotus Notes ODBC Driver Doc', View 'Table of Contents'
Adding a Lotus Notes Data Source
Database 'Lotus Notes ODBC Driver Doc', View 'Table of Contents'
Modifying A Data Source
Database 'Lotus Notes ODBC Driver Doc', View 'Table of Contents'
Deleting a Data Sourcef
Database 'Lotus Notes ODBC Driver Doc', View 'Table of Contents'
Hardware and Software Requirements
Database 'Lotus Notes ODBC Driver Doc', View 'Table of Contents'
9Q[fP
This chapter describes how to use the Lotus Notes ODBC driver.
Contents of this chapter:u
Connecting to a Lotus Notes Data Source
Database 'Lotus Notes ODBC Driver Doc', View 'Table of Contents'
Mapping SQL Tables, Views, and Indexes To and From Notes
Database 'Lotus Notes ODBC Driver Document', View 'Table of Contents'
The Universal Relation Table \
Database 'Lotus Notes ODBC Driver Document', View 'Table of Contents'
IndPara
Using the Universal Relation Table
Database 'Lotus Notes ODBC Driver Document', View 'Table of Contents'
Using Tables Derived From Notes Forms and Views
Database 'Lotus Notes ODBC Driver Document', View 'Table of Contents'
Using Notes Views as Indexes
Database 'Lotus Notes ODBC Driver Document', View 'Table of Contents'
Summary of Supported SQL Grammar I
Database 'Lotus Notes ODBC Driver Doc', View 'Table of Contents'
Exceptions to ODBC SQL Grammar
Database 'Lotus Notes ODBC Driver Doc', View 'Table of Contents'
Error Messages
Database 'Lotus Notes ODBC Driver Doc', View 'Table of Contents'
View Column Definitions
Database 'Lotus Notes ODBC Driver Document', View 'Table of Contents'
Data Types
Database 'Lotus Notes ODBC Driver Doc', View 'Table of Contents'
%I}Fmm
The following topics provide additional programming information on the Lotus Notes ODBC driver. These topics are intended for application programmers who are using the Open Database Connectivity (ODBC) application programming interface (API).r
Contents of this chapter:m
Driver Capabilities: SQLGetinfo Return Values
Database 'Lotus Notes ODBC Driver Doc', View 'Table of Contents'
ODBC API Functions
Database 'Lotus Notes ODBC Driver Doc', View 'Table of Contents'
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
BHead
Mapping SQL Tables, Views, and Indexes to and from Notes
The following table describes how SQL components map to Notes components:
SQL Component
Notes Component
Comments
Table
The Lotus Notes ODBC driver recognizes both Notes forms and views as tables.
Database 'Lotus Notes ODBC Driver Document', View 'Table of Contents'
However, a Notes database contains only one real table, referred to as the Universal Relation.
Database 'Lotus Notes ODBC Driver Document', View 'Table of Contents'
This table has the same name as the database.
Column
Form Field
View Column
When creating a table or view, it is best to avoid the use of column names that are
ODBC or SQL
Reserved words are listed in Appendix C of the Microsoft ODBC Programmers Reference.
reserved words
or that contain characters other than alphabetic, numeric, dollar sign ($), or underscores. However, if you enclose the column name in
For example, to use the reserved word DATE type "DATE".
double quotation marks
(" ") any character and any name is permitted.
Index
An SQL Index corresponds to a Notes view where all sorted columns refer directly to fields in a
single
form, and which selects documents from only that form.
An SQL View maps to a Notes view that selects documents from
form.
When you create a view using SQL, a view is created in Notes that selects from one form. Except for private views, all Notes views are reported as SQL views.
IndBullet
When a Notes data base has both a Form and a View of the same name, the NotesSQL driver cannot distinguish between them in SQL statements. In that case, Views with the same names as Forms cannot be accessed
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
The Lotus Notes ODBC driver recognizes both Notes forms and views as tables. In addition to forms and views, the Notes database contains a table that has the same name as the database. This table is called the Universal Relation. The Universal Relation contains all fields defined in all forms in the Notes database. The Universal Relation is the only true table in a Notes database. As a result, SQL tables created with the Lotus Notes ODBC driver behave more like SQL views than like traditional relational database tables.
For example, with the Lotus Notes ODBC driver, you can create a Notes form with the CREATE TABLE statement. However, the DROP TABLE statement deletes the Notes form, but does not delete any data from the database. Using DROP TABLE with the Lotus Notes ODBC driver is like deleting an SQL view. The data remains in the database. You can view the data through other forms or views that use the same field names, or by referencing the Universal Relation table. t
Using the Lotus Notes ODBC driver, if you create a new table with the same name as a previously deleted table, and use some of the field names from the deleted table, you could find data in the table before you insert any data. This is because the table is actually a view of existing data in the Universal Relation table. Documents (records) in the Notes database contain the name of the form used to create them. The Lotus Notes ODBC driver uses the form name stored in the document to identify the document when selecting from a form.
Wingdings
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
The Lotus Notes ODBC driver recognizes both Notes forms and views as tables. In addition, the driver recognizes the Universal Relation as a table. However, Notes forms and views have very different properties that affect the performance of data access and display with the Lotus Notes ODBC driver.t
Views in Notes databases list documents in a specific order. Avoid selecting from a table based on a Notes view and then specifying a different sort order. When you specify a different sort order on an existing view Notes creates a temporary table on your workstation and resorts the documents. The creation of a large temporary table and sorting the documents in a that table will take a long time.l
To display information from a view in a different sort order, use a table based on a Notes form and create an index on the form using the order you want, or create a new view either in Notes or through ODBC.
Example
Tables derived from Notes forms are not necessarily indexed for fast access. When selecting data from a table based on a Notes form, the Lotus Notes ODBC driver will look for a view that acts as an index on that table. If such a view is present, access to the table will be fast. If no such view is present, access to the table may be very slow. In particular, if the table is small with respect to the database, it will take a long time for the driver to locate all the records in the table. This is because Notes must search the entire database and check every record to see if it belongs to the table.
Wingdings
The Notes Name and Address Book is a good database to use as an example to compare the
use of forms or views in a database. The Name and Address Book database includes
A form called Person
A view called People with a sort key on LastName
The following statement is the most efficient way to find people in the Name and Address Book
sorted by LastName:
IndPara
SELECT LastName
FROM People
ORDER BY LastName
People is a Notes view. This query is efficient because the Lotus Notes ODBC driver can use
the index already associated with the view People that lists LastName in the right order.
Now assume you want to list people sorted by their mailing addresses. You could use the
following statement:
SELECT LastName, Mail_Address
FROM People
ORDER BY Mail_Address
Since the view People is not sorted on Mail_Address, the Lotus Notes ODBC driver uses the People index, generates a temporary database, and creates a temporary index on Mail_Address. This results in slower performance.
A more efficient way to achieve the same result is to issue the following statement:t
SELECT LastName, Mail_Address
FROM Person
ORDER BY Mail_Address
Person is a Notes form. If there is no index on Mail_Address, the Lotus Notes ODBC driver generates a temporary index on Mail_Address but does not need to generate a temporary database. This statement is faster than the previous statement, which used ORDER BY on a view-based table. This statement can be executed even faster if the user creates an index using the CREATE INDEX statement in the Lotus Notes ODBC driver or creates an index through Notes view creation.
Text providing defintion
DocLink
ChapterHead
Ahead
BHead
CHead
ParaLead
Display
Bullet
IndPara
IndDisplay
IndBullet
IndList
Lotus Notes ODBC Driver Referenceb
Release 2.0
Wingdings
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
The Lotus Notes ODBC driver will use an existing Notes view as an index if it meets the following criteria:
The view selection formula in the Notes view design is SELECT Form = "name", or SELECT @All
SELECT Form = "name" is faster than SELECT @All, unless all documents in the database were created using the same form.
Each column in the view is defined as a simple reference to a field in that form (no formulas)i
At least one column in the view is sorted
Wingdings
The same field name can be used in more than one form with different data types in a Notes database. Therefore, you must use explicit field names in a SELECT clause that references the Universal Relation table. In particular, you cannot use SELECT *. You can only perform text operations on fields in the Universal Relation table because the data type for all fields is Character.
The Universal Relation table can participate in a self-join, but cannot participate in any other kind of join.
The Universal Relation table supports only SELECT and CREATE VIEW statements. You
cannot perform an INSERT, DELETE, or UPDATE statement in a Universal Relation table.
You cannot delete the Universal Relation table with the DROP TABLE statement.
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
AHead
Conventions
The following table lists the conventions used to describe the syntax for SQL statements.
Convention
DescriptionO
<argument>
Information that the user or application must provide.
CREATE
Syntax that must be entered exactly as shown, including function names.
Optional items or, if in bold text, brackets that must be included in the syntax. Square brackets also delimit syntax elements.
Seperates mutually exclusive choices in a list of syntax elements.
Delimits a list of mutually exclusive choices in a syntax line.
Indicates that the preceding grammar element may be repeated several times.
[ , ... ]
Indicates that the preceding grammar element may be repeated in a comma-delimited list.
user input
In examples, indicates information that the user must provide.
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
If a column in a view does not refer directly to a field, the Lotus Notes ODBC driver will create a name for that column in the result set. The name will start with the character $ followed by a number, for example $2.
If a view column definition or a Computed for Display field in a form contains one of the @functions listed below, the Lotus Notes ODBC driver will return no results for that column. These columns are not reported by SQLColumns. These columns will display data when viewed from Notes, but this data is not available through an SQL query.
@DeleteDocument
@DeleteFields
@DocChildren
@DocLevel
@DocNumber
@DocParentNumber
@DocSiblings
@Error
@IsCategory
@IsExpandable
@Unavailable
Expressions passed in SQL statements must be either valid SQL expressions or valid Notes expressions. Otherwise, the results may be unpredictable.
DocLink
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
BHead
Ahead
ChapterHead
DocLinkHead
This chapter describes new features in Lotus Notes ODBC Driver release 2.
Wingdings
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
These features are new in release 2 of NotesSQL.
IndBullet
ODBC 2.0 support
As far as possible, under the limitations of the Notes engine, the driver supports all ODBC 2.0 functions and SQL grammar. Restrictions include: no transactions, no table constraints, no primary keys.
Fewer SQL grammar restrictions
UNION, DISTINCT, and NULL support
Unique index reporting
Notes NoteID is reported as a unique index on every table.
Recursive views
Date, time, datetime escape syntax
Scalar functions
Cost-based query optimization
Use Notes full-text index
Search Notes Rich Text Fields using LIKE
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
Notes is more flexible about names than SQL. When naming a form or view Notes allows many special characters and sequences of characters that are outside of the standard SQL syntax.
Here are two examples of special characters used in Notes view names.
It is not uncommon to number views like so:
1. Products
2. Suppliers
in order for them to show up in a certain order in the Create menu.
If a developer wants hierarchical view names they use the backward slash in this manner:
Products\By Name
Products\By Age
These common Notes names are outside of the name space of SQL. The standard SQL syntax does not allow the use of periods, spaces, and forward slashes in unquoted identifier names.
Mapping
Because of this difference in syntax support, NotesSQL maps the backslash, back quote, brackets, dash, double quote, exclamation point, & period (
'\', '`', '[', ']', '"', '!', & '.'
) to an underscore (
) in form and view names.
Caveat
Due to the character mapping, SQL aliases that are the same as the view or form name are not allowed. For example
SELECT * FROM MainqViewqAll MainqViewqAll
will not be accepted. It will return the error message "Alias name needed". Even though you probably wouldn't type in this SQL (after all what is the point of having an alias that is the same as the original name), certain applications (notably Crystal Reports) generate them. The workaround to this is to modify the alias name.
CN=Paul Geffen/OU=CAM/O=Lotus
04/22/96 10:04:32 AM Michael Podanoffsky/CAM/Lotus deleted Paul Geffen
04/22/96 10:04:27 AM Michael Podanoffsky/CAM/Lotus updated Michael Podanoffsky
04/22/96 10:04:20 AM Michael Podanoffsky/CAM/Lotus added Michael Podanoffsky
(.txt)