David MartinCN=Paul Geffen/OU=CAM/O=LotusCN=Michael Stewart/OU=CAM/O=Lotus
#####################################
Glossary
ODBCDavid Martin
David Martin####################################################
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.################
How ToLotus NotesSQLFrequently Asked Questions (FAQ)
CN=Michael Stewart/OU=CAM/O=Lotus3 Using NotesSQLLOTUS NOTESSQL\3 Using NotesSQL
0 How to Use This Book1 About Lotus NotesSQL2 Installation & Configuration3 Using NotesSQL4 Programming Information5 What's New in Release 2.025 Appendix A: SQL Statements7 Appendix B
0 How to Use This Book1 About Lotus NotesSQL2 Installation & Configuration3 Using NotesSQL4 Programming Information5 What's New in Release 2.025 Appendix A: SQL Statements7 Appendix B
CN=Michael Stewart/OU=CAM/O=Lotus
CN=Michael Podanoffsky/OU=CAM/O=Lotus
CN=Michael Podanoffsky/OU=CAM/O=Lotus
CN=Michael Podanoffsky/OU=CAM/O=Lotus
CN=William DelaVega/OU=CAM/O=Lotus
ChapterChapter Head
SectionHow To
About This BookPreface.
ChapterChapter Head
SectionHow To
About This BookPreface
ChapterChapter Head
SectionHow To
About This BookPreface
0 How to Use This Book1 About Lotus NotesSQL2 Installation & Configuration3 Using NotesSQL4 Programming Information5 What's New in Release 2.025 Appendix A: SQL Statements7 Appendix B
* 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
03/06/98 02:28:33 PM Michael Stewart/CAM/Lotus added OtherDomainServers
03/06/98 02:28:25 PM Michael Stewart/CAM/Lotus updated LocalDomainServers
03/06/98 02:28:17 PM Michael Stewart/CAM/Lotus added LocalDomainServers
03/06/98 02:27:45 PM Michael Stewart/CAM/Lotus deleted William DelaVega/CAM/Lotus
03/06/98 02:27:45 PM Michael Stewart/CAM/Lotus deleted Shu Chen/CAM/Lotus
03/06/98 02:27:44 PM Michael Stewart/CAM/Lotus deleted Mike Boyle/CAM/Lotus
03/06/98 02:27:44 PM Michael Stewart/CAM/Lotus deleted Michael Stewart/CAM/Lotus
03/06/98 02:27:43 PM Michael Stewart/CAM/Lotus deleted Jack Allen/CAM/Lotus
03/06/98 02:27:43 PM Michael Stewart/CAM/Lotus deleted Dmitry Khazanovich/CAM/Lotus
03/06/98 02:27:42 PM Michael Stewart/CAM/Lotus deleted Bernadette Kelly/CAM/Lotus
03/06/98 02:27:42 PM Michael Stewart/CAM/Lotus deleted Avshalom Neer/CAM/Lotus
02/05/98 03:19:20 PM zathras/CAM/Notes updated Mike Boyle/CAM/Lotus
02/05/98 03:19:15 PM zathras/CAM/Notes added Mike Boyle/CAM/Lotus
01/20/98 10:12:27 AM zathras/CAM/Notes updated Shu Chen/CAM/Lotus
01/20/98 10:10:10 AM zathras/CAM/Notes updated Shu Chen/CAM/Lotus
01/20/98 10:10:01 AM zathras/CAM/Notes added Shu Chen/CAM/Lotus
01/20/98 10:09:35 AM zathras/CAM/Notes deleted William Chan/CAM/Lotus
10/23/97 03:21:05 PM William DelaVega/CAM/Lotus updated Michael Stewart/CAM/Lotus
10/23/97 03:21:01 PM William DelaVega/CAM/Lotus updated Jack Allen/CAM/Lotus
10/23/97 03:20:36 PM William DelaVega/CAM/Lotus updated Jack Allen/CAM/Lotus
-Default-
/LOUli
LocalDomainServers
OtherDomainServers
CN=Dmitry Khazanovich/OU=CAM/O=Lotus
Times New Roman
Title Page
Topic
Title
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
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
BodyWrite the body of the document here.
(hidden)
DocAuthor
O=Lotus Notes
O=Lotus Notes
PURSAFO
|.:#U
O=Lotus Notes
CN=Lotus Notes Template Development/O=Lotus Notes
PURSAFO
Fde!f^^
}|L$%l
$Author
$TITLE
$INFO
$WINDOWTITLE
$$ScriptName
Doc_Number
Indent
$BODY
&Arial
DocLink
ChapterHead
Ahead
BHead
CHead
ParaLead
Display
Bullet
IndPara
IndDisplay
IndBullet
IndList
Copyright
Revision history
Original Original file produced for Lotus NotesSQL 2.0.
First revision Incorporates information on Lotus NotesSQL 2.01.
Second revision Incorporates information on Lotus NotesSQL 2.02.
Third revision Incorporates information on Lotus NotesSQL 2.03.
Fourth revision Incorporates information on Lotus NotesSQL 2.04.
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, without the prior written consent of Lotus Development Corporation, except in the manner described in the software agreement.
Copyright 1996 - 1998
Lotus Development Corporation
55 Cambridge Parkway
Cambridge, MA 02142
All rights reserved. Published in the United States.
Domino, NotesSQL, and Notes are trademarks and Lotus and Lotus Notes are registered trademarks of Lotus Development Corporation. IBM and OS/2 are registered trademarks of International Business Machines Corporation.
Microsoft, Windows,
Windows NT, and Visual Basic
are registered trademarks and ODBC is a trademark of Microsoft Corporation.
Crystal Reports is a trademark of Crystal, a Seagate Software Company.
Other product and company names mentioned herein may be the trademarks or registered trademarks of their respective owners.
Copyright 1994, 1995 Casahl Technology, Inc. All Rights Reserved.
Casahl is a registered trademark of Casahl Technology, Inc.
LOTUS DEVELOPMENT CORPORATION LICENSOR(S) MAKES NO WARRANTIES, EXPRESS OR IMPLIED, INCLUDING WITHOUT LIMITATION THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE, REGARDING THE SOFTWARE. LOTUS DEVELOPMENT CORPORATION'S LICENSOR(S) DOES NOT WARRANT, GUARANTEE OR MAKE ANY REPRESENTATIONS REGARDING THE USE OR THE RESULTS OF THE USE OF THE SOFTWARE IN TERMS OF ITS CORRECTNESS, ACCURACY, RELIABILITY, CURRENTNESS OR OTHERWISE. THE ENTIRE RISK AS TO THE RESULTS AND PERFORMANCE OF THE SOFTWARE IS ASSUMED BY YOU. THE EXCLUSION OF IMPLIED WARRANTIES IS NOT PERMITTED BY SOME JURISDICTIONS. THE ABOVE EXCLUSION MAY NOT APPLY TO YOU.
IN NO EVENT WILL LOTUS DEVELOPMENT CORPORATION'S LICENSOR(S), AND THEIR DIRECTORS, OFFICERS, EMPLOYEES OR AGENTS (COLLECTIVELY LOTUS DEVELOPMENT CORPORATION'S LICENSOR(S)) BE LIABLE TO YOU FOR ANY CONSEQUENTIAL, INCIDENTAL OR INDIRECT DAMAGES (INCLUDING DAMAGES FOR LOSS OF BUSINESS PROFITS, BUSINESS INTERRUPTION, LOSS OF BUSINESS INFORMATION, AND THE LIKE) ARISING OUT OF THE USE OF OR INABILITY TO USE THE SOFTWARE EVEN IF LOTUS DEVELOPMENT CORPORATION'S LICENSOR(S) HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. BECAUSE SOME JURISDICTIONS DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES, THE ABOVE LIMITATIONS MAY NOT APPLY TO YOU.
O=Lotus Notes
O=Lotus Notes
PURSAFO
|.:#U
O=Lotus Notes
CN=Lotus Notes Template Development/O=Lotus Notes
PURSAFO
Fde!f^^
$INFO
$BODY
subhead
subpara
BHead
BHead
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
This is a list of the parameters of a Lotus Notes Data Source with a description of each. There are many parameters, but most have reasonable defaults. We suggest you try using the defaults first. The three dialog box fields that must be filled in are marked with an asterisk.
Fields that ask for numeric values check your input. If you specify a value above the allowed maximum, the maximum value is substituted. If you specify a value below the allowed minimum, the minimum value is substituted. If you specify an invalid value, such as a letter, the default value is substituted.
Data Source Name *
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.
Description
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.
Server *
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.
Database *
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.
Whether the data is local or on a server, the path is relative to the Notes data directory on that machine. If the Notes data directory is D:\NOTES\DATA\, PERSONNEL\EMPLOYEE.NSF points to D:\NOTES\DATA\PERSONNEL\EMPLOYEE.NSF.
Max Length of Text Fields
This parameter specifies
the maximum number of bytes NotesSQL allows in a string. This limits the number of characters returned from a Notes text field and the length of a string to be inserted into a Notes text field.
The maximum value allowed is
15,360. The minimum value allowed is 2.
The default value is 254. If the database will be used exclusively or primarily with Lotus 1-2-3
, we recommend a value of 511. This is the maximum length of a string in a cell in Lotus 1-2-3.
Max Number of Tables
This parameter specifies the
maximum number of tables in a single query.
The maximum value allowed is
100. The minimum value allowed is 1.
The default value is 20.
Max Number of Subqueries
This parameter specifies the
maximum number of nested subqueries in a SQL statement.
The maximum value allowed is
100. The minimum value allowed is 1.
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.
The option is unselected by default.
Return Notes Implicit Fields
This option controls whether certain Notes fields are provided through SQLStatistics and SQLSpecialColumns. Turn it off for maximum interoperability. Turn it on for backward compatibility with NotesSQL 2.0 or earlier.
The option is unselected by default.
Map Special Characters
This option controls whether certain characters are mapped to the underscore character ( _ ). For details, see
The maximum value allowed is 15,360. The minimum value allowed is 2.
The default value is 512. If the database will be used exclusively or primarily with Lotus 1-2-3, we recommend a value of 511. This is the maximum length of a string in a cell in Lotus 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 minimum value allowed is 2.
The default value is 4,096 (4K).
Thread Timeout
(available on 32-bit Windows platforms only)
All calls are serialized so that 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 minimum value allowed is 0. A value of 0 means wait forever.
The default value is 60.
99. Th
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
<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.
See related topics
NotesSQL 2.03 Reference
NotesSQL 2.03 Reference
SQL Typographical Conventions
NotesSQL 2.03 Reference
NotesSQL 2.03 Reference
Column, Index, Table, and View Names
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
NotesSQL recognizes Notes forms and views as tables. In addition to forms and views, every 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 by NotesSQL behave more like SQL views than like traditional relational database tables.
For example, with NotesSQL, 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 NotesSQL is like deleting a SQL view, in that the data remains in the database. You can view the data through other views that use the same field names, or by referencing the Universal Relation table.
Continuing this example, 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. NotesSQL uses the form name stored in the document to identify the document when selecting from a form.
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 NotesSQL 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_DELETE
SQL_BP_SCROLL
SQL_BP_UPDATE
SQL_COLUMN_ALIAS
SQL_CONCAT_NULL_BEHAVIOR
SQL_CB_NON_NULL
SQL_CONVERT_BIGINT
SQL_CONVERT_BINARY
SQL_CONVERT_BIT
SQL_CONVERT_CHAR
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_CONVERT_DATE
0x00028101 =
SQL_CVT_CHAR |
SQL_CVT_VARCHAR |
SQL_CVT_DATE |
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_LONGVARCHAR
SQL_CONVERT_TIME
0x00030101 =
SQL_CVT_CHAR |
SQL_CVT_VARCHAR |
SQL_CVT_TIME |
SQL_CVT_TIMESTAMP
SQL_CONVERT_TIMESTAMP
0x00038101 =
SQL_CVT_CHAR |
SQL_CVT_VARCHAR |
SQL_CVT_DATE |
SQL_CVT_TIME |
SQL_CVT_TIMESTAMP
SQL_CONVERT_TINYINT
SQL_CONVERT_VARBINARY
SQL_CONVERT_VARCHAR
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
(Name of driver dll, depends on platform.)
SQL_DRIVER_ODBC_VER
"02.00"
SQL_DRIVER_VER
"2.04.0201" (Returns the version of the installed driver.)
The DROP INDEX statement removes 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 remove.
This operation removes a Notes view.
See related topics
NotesSQL 2.03 Reference
NotesSQL 2.03 Reference
SQL Typographical Conventions
NotesSQL 2.03 Reference
NotesSQL 2.03 Reference
Column, Index, Table, and View Names
Wingdings
AHead
BHead
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.
See related topics
NotesSQL 2.03 Reference
NotesSQL 2.03 Reference
SQL Typographical Conventions
NotesSQL 2.03 Reference
NotesSQL 2.03 Reference
Column, Index, Table, and View Names
NotesSQL 2.03 Reference
NotesSQL 2.03 Reference
CN=zathras/OU=CAM/O=Notes
Data Types
indbullet1
IndList
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
Before you can connect to a Notes database with NotesSQL, you must add a
A Lotus Notes Data Source specifies the Domino/Notes server and Notes database you want to open.
Notes Product Development
)I^-.
PURSAF
O=Lotus
O=Lotus
PURSAFO
O=Lotus
OU=CAM/O=Lotus
PURSAFO
OU=CAM/O=Lotus
CN=Michael Stewart/OU=CAM/O=Lotus
A]yvinNj
PURSAFO
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. Start the ODBC Administrator.
2. Choose Add.
3. In the Add Data Source dialog box, select Lotus Notes from the Installed ODBC Drivers list box.
4. Choose OK.
This brings up the NotesSQL Configuration dialog box. For help with this dialog box, see "
Notes Product Development
)I^-.
PURSAF
O=Lotus
O=Lotus
PURSAFO
O=Lotus
OU=CAM/O=Lotus
PURSAFO
OU=CAM/O=Lotus
CN=Michael Stewart/OU=CAM/O=Lotus
A]yvinNj
PURSAFO
Configuring a Lotus Notes Data Source
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 clause
[ <
HAVING clause
[ <UNION clause> ]
<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).
See related topics
NotesSQL 2.03 Reference
NotesSQL 2.03 Reference
SQL Typographical Conventions
NotesSQL 2.03 Reference
NotesSQL 2.03 Reference
Column Functions
NotesSQL 2.03 Reference
NotesSQL 2.03 Reference
CN=zathras/OU=CAM/O=Notes
Data Types
Mu9I_
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
The following ODBC SQL grammar is supported:
BHead
Supported Statements
Notes Product Development
)I^-.
PURSAF
O=Lotus
O=Lotus
PURSAFO
O=Lotus
OU=CAM/O=Lotus
PURSAFO
OU=CAM/O=Lotus
CN=Michael Stewart/OU=CAM/O=Lotus
A]yvinNj
PURSAFO
ALTER TABLE
Notes Product Development
)I^-.
PURSAF
O=Lotus
O=Lotus
PURSAFO
O=Lotus
OU=CAM/O=Lotus
PURSAFO
OU=CAM/O=Lotus
CN=Michael Stewart/OU=CAM/O=Lotus
A]yvinNj
PURSAFO
CREATE INDEX
Notes Product Development
)I^-.
PURSAF
O=Lotus
O=Lotus
PURSAFO
O=Lotus
OU=CAM/O=Lotus
PURSAFO
OU=CAM/O=Lotus
CN=Michael Stewart/OU=CAM/O=Lotus
A]yvinNj
PURSAFO
g5J^F
CREATE TABLE
Notes Product Development
)I^-.
PURSAF
O=Lotus
O=Lotus
PURSAFO
O=Lotus
OU=CAM/O=Lotus
PURSAFO
OU=CAM/O=Lotus
CN=Michael Stewart/OU=CAM/O=Lotus
A]yvinNj
PURSAFO
CREATE VIEW
Notes Product Development
)I^-.
PURSAF
O=Lotus
O=Lotus
PURSAFO
O=Lotus
OU=CAM/O=Lotus
PURSAFO
OU=CAM/O=Lotus
CN=Michael Stewart/OU=CAM/O=Lotus
A]yvinNj
PURSAFO
49]GL
/Q[8Q
DELETE Searched
Notes Product Development
)I^-.
PURSAF
O=Lotus
O=Lotus
PURSAFO
O=Lotus
OU=CAM/O=Lotus
PURSAFO
OU=CAM/O=Lotus
CN=Michael Stewart/OU=CAM/O=Lotus
A]yvinNj
PURSAFO
DELETE Positioned
Notes Product Development
)I^-.
PURSAF
O=Lotus
O=Lotus
PURSAFO
O=Lotus
OU=CAM/O=Lotus
PURSAFO
OU=CAM/O=Lotus
CN=Michael Stewart/OU=CAM/O=Lotus
A]yvinNj
PURSAFO
DROP INDEX
Notes Product Development
)I^-.
PURSAF
O=Lotus
O=Lotus
PURSAFO
O=Lotus
OU=CAM/O=Lotus
PURSAFO
OU=CAM/O=Lotus
CN=Michael Stewart/OU=CAM/O=Lotus
A]yvinNj
PURSAFO
DROP TABLE
Notes Product Development
)I^-.
PURSAF
O=Lotus
O=Lotus
PURSAFO
O=Lotus
OU=CAM/O=Lotus
PURSAFO
OU=CAM/O=Lotus
CN=Michael Stewart/OU=CAM/O=Lotus
A]yvinNj
PURSAFO
DROP VIEW
Notes Product Development
)I^-.
PURSAF
O=Lotus
O=Lotus
PURSAFO
O=Lotus
OU=CAM/O=Lotus
PURSAFO
OU=CAM/O=Lotus
CN=Michael Stewart/OU=CAM/O=Lotus
A]yvinNj
PURSAFO
INSERT
Notes Product Development
)I^-.
PURSAF
O=Lotus
O=Lotus
PURSAFO
O=Lotus
OU=CAM/O=Lotus
PURSAFO
OU=CAM/O=Lotus
CN=Michael Stewart/OU=CAM/O=Lotus
A]yvinNj
PURSAFO
D*s)3
SELECT
Notes Product Development
)I^-.
PURSAF
O=Lotus
O=Lotus
PURSAFO
O=Lotus
OU=CAM/O=Lotus
PURSAFO
OU=CAM/O=Lotus
CN=Michael Stewart/OU=CAM/O=Lotus
A]yvinNj
PURSAFO
F{Wop
c|i$A
FOR UPDATE
Notes Product Development
)I^-.
PURSAF
O=Lotus
O=Lotus
PURSAFO
O=Lotus
OU=CAM/O=Lotus
PURSAFO
OU=CAM/O=Lotus
CN=Michael Stewart/OU=CAM/O=Lotus
A]yvinNj
PURSAFO
0DZPl
Notes Product Development
)I^-.
PURSAF
O=Lotus
O=Lotus
PURSAFO
O=Lotus
OU=CAM/O=Lotus
PURSAFO
OU=CAM/O=Lotus
CN=Michael Stewart/OU=CAM/O=Lotus
A]yvinNj
PURSAFO
\r^T*
GROUP BY
Notes Product Development
)I^-.
PURSAF
O=Lotus
O=Lotus
PURSAFO
O=Lotus
OU=CAM/O=Lotus
PURSAFO
OU=CAM/O=Lotus
CN=Michael Stewart/OU=CAM/O=Lotus
A]yvinNj
PURSAFO
HAVING
Notes Product Development
)I^-.
PURSAF
O=Lotus
O=Lotus
PURSAFO
O=Lotus
OU=CAM/O=Lotus
PURSAFO
OU=CAM/O=Lotus
CN=Michael Stewart/OU=CAM/O=Lotus
A]yvinNj
PURSAFO
d ?7ht
ORDER BY
NotesSQL 2.03 Reference
Notes Product Development
)I^-.
PURSAF
O=Lotus
O=Lotus
PURSAFO
O=Lotus
OU=CAM/O=Lotus
PURSAFO
OU=CAM/O=Lotus
CN=Michael Stewart/OU=CAM/O=Lotus
A]yvinNj
PURSAFO
NotesSQL 2.03 Reference
UNION
Notes Product Development
)I^-.
PURSAF
O=Lotus
O=Lotus
PURSAFO
O=Lotus
OU=CAM/O=Lotus
PURSAFO
OU=CAM/O=Lotus
CN=Michael Stewart/OU=CAM/O=Lotus
A]yvinNj
PURSAFO
UPDATE Searched
Notes Product Development
)I^-.
PURSAF
O=Lotus
O=Lotus
PURSAFO
O=Lotus
OU=CAM/O=Lotus
PURSAFO
OU=CAM/O=Lotus
CN=Michael Stewart/OU=CAM/O=Lotus
A]yvinNj
PURSAFO
UPDATE Positioned
Link
WHERE
Supported Expressions, Functions, and Operators
Notes Product Development
)I^-.
PURSAF
O=Lotus
O=Lotus
PURSAFO
O=Lotus
OU=CAM/O=Lotus
PURSAFO
OU=CAM/O=Lotus
CN=Michael Stewart/OU=CAM/O=Lotus
A]yvinNj
PURSAFO
vs~q
Numeric Operators
Link
Notes Product Development
)I^-.
PURSAF
O=Lotus
O=Lotus
PURSAFO
O=Lotus
OU=CAM/O=Lotus
PURSAFO
OU=CAM/O=Lotus
CN=Michael Stewart/OU=CAM/O=Lotus
A]yvinNj
PURSAFO
Predicate Operators
Notes Product Development
)I^-.
PURSAF
O=Lotus
O=Lotus
PURSAFO
O=Lotus
OU=CAM/O=Lotus
PURSAFO
OU=CAM/O=Lotus
CN=Michael Stewart/OU=CAM/O=Lotus
A]yvinNj
PURSAFO
Column Functions
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
{<table reference> [ <alias> ] } [ , ... ]
AHead
Example
SELECT
FROM
CUSTOMER
BHead
Arguments
<table reference> is the name of a table
or view
<alias> is an alias for the table name or view name. The alias is defined only for this query.
See related topics
NotesSQL 2.03 Reference
NotesSQL 2.03 Reference
SQL Typographical Conventions
NotesSQL 2.03 Reference
NotesSQL 2.03 Reference
Column, Index, Table, and View Names
Wingdings
IndPara
AHead
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.
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
FLOAT
DOUBLE PRECISION
VARCHAR(n) or CHARACTER VARYING(n) (same as CHAR)
TIME
TIMESTAMP
The field sizes specified for CHAR, DECIMAL, NUMERIC, and VARCHAR fields are optional. If you specify a size for one of these fields, Notes ignores it when creating the field.
Restrictions
NULL and NOT NULL are not supported.
ALTER TABLE DROP is not supported.
VARCHAR will produce a fixed length CHAR field, instead of a large text field.
See related topics
NotesSQL 2.03 Reference
NotesSQL 2.03 Reference
SQL Typographical Conventions
NotesSQL 2.03 Reference
NotesSQL 2.03 Reference
Column, Index, Table, and View Names
NotesSQL 2.03 Reference
NotesSQL 2.03 Reference
Data Types
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
See related topics
NotesSQL 2.03 Reference
NotesSQL 2.03 Reference
SQL Typographical Conventions
NotesSQL 2.03 Reference
NotesSQL 2.03 Reference
Column, Index, Table, and View Names
Wingdings
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
NotesSQL recognizes 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 NotesSQL.
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 re-sorts the documents. Creating a large temporary table and sorting the documents in that table will take a long time.
Temporary table creation requires you to have read/write access to the database. If you have read-only access, you cannot perform an operation like SELECT with ORDER BY or GROUP BY unless there is an existing view you can use to support the operation.
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.
Tables derived from Notes forms are not necessarily indexed for fast access. When selecting data from a table based on a Notes form, NotesSQL looks 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.
See examples
Example: Using SQL Tables Derived from Notes Forms and Views
5Courier New
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
NotesSQL supports most SQL statements and clauses in the ODBC Minimum and Core grammar. The following table describes exceptions:
Grammar
Exception
NULLs
There is no explicit NULL in Notes. NotesSQL uses NULLs to provide access to the Notes function @IsAvailable. See "NULLs" below for details.
ORDER BY clause
NotesSQL supports ordering by expressions that aren't in the project list. This is not standard SQL but many applications use it.
WHERE clause and TIMESTAMP fields
Timestamp fields need to be fully padded when used in WHERE clauses if the time component is not used. That is, 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 (DDL). Arrays of parameters are not supported.
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.
BHead
NULLS
NotesSQL uses NULLs to provide access to the Notes function @IsAvailable. For example, suppose you are comparing a field to NULL, as in:
SELECT * FROM Employee WHERE Name IS NULL
NotesSQL checks @IsAvailable("Name"). If @IsAvailable("Name") is TRUE, the WHERE clause is FALSE. Otherwise, the WHERE clause is TRUE.
Continuing the parallel, updating or inserting NULLs through NotesSQL removes fields from documents. So for example, the following will create a document with no Name field:
INSERT INTO Employee (EmpNo, Name) VALUES (10, NULL)
Likewise, the following will remove the Name field from a document:
UPDATE Employee SET Name=NULL WHERE EmpNo=10
Wingdings
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
NotesSQL 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 either 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. Note that views created with SELECT @All are not described as indexes through SQLStatistics. They are used by NotesSQL to improve performance.
Each sorted column in the view is defined as a simple reference to a field in that form (no formulas).
At least one column in the view is sorted.
An easy way to see this information at a glance in Notes is to select File - Database - Design Synopsis. In the dialog box, choose Views, then click OK. Notes generates a detailed synopsis document that includes all the above information and more.
Unique Indexes
In Notes there is a view property labeled "Unique keys in index (for ODBC access)." When this setting is checked, NotesSQL describes the sorted columns of the view as the keys of a unique index. This happens through the ODBC call SQLStatistics. Having these indexes allows several third-party applications to issue updates against NotesSQL.
Use some care with this feature. Checking the box doesn't make the view a unique index in the relational database sense. Specifically, it doesn't prevent duplicate records. It only puts the first document with a particular sorted value into the view. Therefore, if you are using this feature, updates may affect more than one record and ORDER BYs may generate small result sets.
Here are some guidelines to follow to avoid these problems:
Only use the checkbox for one view that selects from each form that will be updated.
Choose a view with sorted columns that are each one field (not a formula or expression).
Choose a view with sorted columns that together uniquely identify a record.
Wingdings
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
You must have read/write access to a database to use its Universal Relation. Without read/write access, you cannot perform any operation (including SELECTs) on the Universal Relation.
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. In particular, you cannot use SELECT *. You can only perform text operations on fields in the Universal Relation because the data type for all fields is character.
The Universal Relation can participate in a self-join but cannot participate in any other kind of join.
NotesSQL supports the SELECT statement on the Universal Relation. NotesSQL does not support this on a read-only .NSF file.
NotesSQL supports the
CREATE VIEW statement on the Universal Relation.
NotesSQL does not support
INSERT, DELETE, UPDATE, DROP TABLE, or DROP VIEW statements on the Universal Relation.
NotesSQL uses the type "UNIVERSAL" to differentiate the Universal Relation in the result set of SQLTables.
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
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 clause must also appear in the
SELECT
clause.
See related topics
NotesSQL 2.03 Reference
NotesSQL 2.03 Reference
SQL Typographical Conventions
NotesSQL 2.03 Reference
NotesSQL 2.03 Reference
Column, Index, Table, and View Names
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
Description
<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.
Separates 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.
SALES
Names of fields in Notes databases.
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, NotesSQL creates a name for that column in the result set. The name is 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, NotesSQL returns no results for that column. These columns are not reported by SQLColumns. These columns display data when viewed from Notes, but this data is not available through a 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 are unpredictable.
BHead
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
You can use NotesSQL with any application that supports ODBC drivers for external data access. To connect to the Notes database, you select the data source
you defined using the Setup dialog box
If your Notes user ID is password-protected, Notes prompts for a password when you first connect to a remote database using NotesSQL. 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 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
Error messages come from three areas: the ODBC Driver Manager, NotesSQL, or Notes.
The Driver Manager detects incorrect sequences of ODBC API calls and invalid parameter values.
NotesSQL detects errors when parsing and validating SQL commands.
Notes 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 ODBC Driver Manager, NotesSQL, and Notes:
Error message
Error location
32-bit Windows:
[Microsoft][ODBC Driver Manager]
message-text
16-bit Windows:
[Microsoft][ODBC.DLL]
message-text
OS/2:
[Visigenic][ODBC Driver Manager]
message-text
ODBC Driver Manager
[Lotus][ODBC Lotus Notes]
message-text
NotesSQL
[Lotus][ODBC Lotus Notes][Lotus Notes Server]Notes API error:
message-text
Lotus Notes or Domino
BHead
Errors reported by NotesSQL
The driver returns an error message and the appropriate SQLSTATE when an error is detected in NotesSQL. The name of a data source is not included in the error message.
Errors reported by Notes
When an error is reported by Notes, NotesSQL returns SQLSTATE S1000 and the error message returned by Notes.
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
NotesSQL is the Lotus Notes ODBC driver. It allows you to open and query a Notes database (a .NSF file) through the
NotesSQL 2.03 Reference
NotesSQL 2.03 Reference
Open Database Connectivity (
) interface
Here is the application/driver hierarchy (using 32-bit Windows file names):
Application
ODBC Driver Manager
(ODBC32.DLL)
NotesSQL
(NSQL32.DLL)
(NSQLV32.DLL)*
Lotus Notes Workstation Software**
Lotus Notes Server or Local .NSF file
*On 32-bit Windows, NotesSQL consists of 3 DLLs. NSQL32.DLL is called by ODBC32.DLL, the ODBC Driver Manager. NSQL32.DLL is the DLL whose name appears in ODBC.INI. NSQLV32.DLL is called by NSQL32.DLL.
** NotesSQL communicates exclusively with the Lotus Notes workstation software. Lotus Notes handles all network traffic and security.
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
Column functions can 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. NotesSQL 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 "SALES" column.
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 all values in a numeric field expression. For example, SUM(SALES) returns the sum of all SALES field values.
Wingdings
BHead
AHead
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
<search condition>
AHead
Examples
Bullet
SELECT
FROM
CUSTOMER
WHERE
CITY='New York'
SELECT
PART_NO, DESCRIPT, ON_HAND, LOCATION, UNITCOST
FROM
INVENTORY
WHERE
ON_HAND > 50
SELECT
PART_NO, DESCRIPT, LOCATION, ON_HAND, UNITCOST
FROM
INVENTORY
WHERE
LOCATION = 'Los Angeles'
LOCATION = 'New York'
AND
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 [
] <boolean primary>
<boolean primary> is <predicate> |
<search condition>
<predicate> is one of the following:
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 a table name or alias. Column expressions cannot include asterisks ( * ).
See related topics
NotesSQL 2.03 Reference
NotesSQL 2.03 Reference
SQL Typographical Conventions
NotesSQL 2.03 Reference
NotesSQL 2.03 Reference
Column, Index, Table, and View Names
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> [
] [ ,
... ]
AHead
Example
CREATE INDEX
CUSTNDX
CUSTOMER
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.
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.
See related topics
NotesSQL 2.03 Reference
NotesSQL 2.03 Reference
SQL Typographical Conventions
NotesSQL 2.03 Reference
NotesSQL 2.03 Reference
Column, Index, Table, and View Names
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
NotesSQL supports the following numeric operators in expressions:
Operator
Meaning
Addition
Subtraction
Multiplication
Division
Wingdings
AHead
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
AHead
The DROP TABLE statement removes a table from the current database.
Syntax
Display
DROP TABLE
<base table name> [
CASCADE
RESTRICT
Example
DROP TABLE
NEWCUST
BHead
Arguments
<base table name>
is the name of the table to remove.
CASCADE removes any dependent objects. RESTRICT fails if there are dependent objects.
This operation removes a Notes form. It does not remove the documents created with that form. When Notes tries to display one of these documents, Notes displays an error message because it cannot find the form needed to display the document.
See related topics
NotesSQL 2.03 Reference
NotesSQL 2.03 Reference
SQL Typographical Conventions
NotesSQL 2.03 Reference
NotesSQL 2.03 Reference
NotesSQL 2.03 Reference
NotesSQL 2.03 Reference
Column, Index, Table, and View Names
Database 'Lotus Notes ODBC Driver Document', View 'Table of Contents'
Database 'Lotus Notes ODBC Driver Document', View 'Table of Contents'
The Universal Relation
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 not part of the standard SQL syntax.
Bullet
It is not uncommon to number views so they will appear
in a certain order in the Create menu:
1. Products
2. Suppliers
If developers want hierarchical view names, they use the backslash:
Products\By Name
Products\By Age
These common Notes naming conventions are not allowed by standard SQL syntax, which does not allow the use of periods, spaces, and forward slashes in unquoted identifier names.
Mapping
Because of this difference in syntax support, NotesSQL optionally maps certain characters to the underscore character ( _ ). This mapping is configurable for each Data Source. The default is to map the names. We recommend using the default unless it causes a form or view to be inaccessible. This can happen when two similar names (for example, "Employees$" and "Employees_") are mapped to the same name.
If you choose to map names, NotesSQL maps forms, views and their aliases, form fields, and view columns. The characters mapped are:
Lotus Notes Designer or Lotus Notes Workstation must be installed. A full user license is required; desktop and mail IDs are not supported. 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.
For more information about Notes databases, refer to your Lotus Notes documentation.
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
NotesSQL supports multiple values in fields. NotesSQL contains information about which fields can have multiple values and the underlying data type for these values.
NotesSQL does not support multi-valued (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'
(See below for more information about the correct separator character to use.)
Text Fields
NotesSQL returns all the data in multi-valued fields composed of text as a single string. Data items are separated by the display separator character (the character defined in Notes as the one to use to separate multiple values when displaying them). For example:
'a;b;c'
Note:
An extra semicolon can appear in the result if the data was entered in Notes, any character other than a semicolon was used as the display separator character, and the list contains an item that includes a semicolon.
NotesSQL accepts a list of strings for insertion in a multi-valued field of type Text. You must separate the strings with the display separator character defined for that field. For example, if a comma is the display separator character for a field, you must specify a string like:
'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 NotesSQL produces the same result in either case.
Numeric and Date Fields
NotesSQL returns only the first value in the list when the multi-valued fields are numeric or date fields.
Currently, NotesSQL accepts only a single numeric or date value for insertion in a multi-valued field of type Numeric or Date.
Wingdings
AHead
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
AHead
The positioned DELETE statement removes the last row fetched (the current row).
Syntax
Display
DELETE FROM
<table name>
WHERE CURRENT OF
<cursor name>
AHead
Example
DELETE FROM
INVENTORY
WHERE CURRENT OF
SQL_CUR_0
BHead
Arguments
<table name>
is the name of the table where you want to remove data.
<cursor name> is the name of the cursor pointing to the row to be removed.
See related topics
NotesSQL 2.03 Reference
NotesSQL 2.03 Reference
SQL Typographical Conventions
NotesSQL 2.03 Reference
NotesSQL 2.03 Reference
NotesSQL 2.03 Reference
NotesSQL 2.03 Reference
Column, Index, Table, and View Names
bullet1
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
Lotus
NotesSQL(TM
Reference
describes how to install, configure, and use Notes
SQL, the Lotus Notes
ODBC driver, to open, query, and modify Lotus Notes
databases.
BHead
Organization
bullet1
Chapter 1
About NotesSQL
introduces NotesSQL.
Chapter 2
Installation and Configuration.
Chapter 3
Using NotesSQL
describes how to use NotesSQL.
Chapter 4
Programming
provides programming information for application programmers using the Open Database Connectivity (ODBC) application programming interface (API).
Appendix A
SQL Statements
Conventions Used in This Book
Lotus NotesSQL Reference
uses the following conventions:
SQL code is in Courier 10 point. SQL keywords are in upper case. For example:
SELECT * FROM MainqViewqAll MainqViewqAll
Introduces additional technical information about a command or procedure.
%I}Fmm
DocLink
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
BHead
Ahead
ChapterHead
DocLinkHead
The following topics provide additional programming information on NotesSQL. These topics are intended for application programmers who are using the ODBC application programming interface (API).
Contents of this chapter:
Notes Product Development
)I^-.
PURSAF
O=Lotus
O=Lotus
PURSAFO
O=Lotus
OU=CAM/O=Lotus
PURSAFO
OU=CAM/O=Lotus
CN=Michael Stewart/OU=CAM/O=Lotus
A]yvinNj
PURSAFO
Database 'Lotus Notes ODBC Driver Doc', View 'Table of Contents'
Driver Capabilities: SQLGetinfo Return Values
Notes Product Development
)I^-.
PURSAF
O=Lotus
O=Lotus
PURSAFO
O=Lotus
OU=CAM/O=Lotus
PURSAFO
OU=CAM/O=Lotus
CN=Michael Stewart/OU=CAM/O=Lotus
A]yvinNj
PURSAFO
Database 'Lotus Notes ODBC Driver Doc', View 'Table of Contents'
ODBC API Functions
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.
BHead
To modify a Lotus Notes data source:
1. Start the ODBC Administrator.
2. Select the data source in the Data Sources (Drivers) list box.
3. Choose Setup.
4. In the Lotus Notes ODBC Setup dialog box
, modify the information about the data source, as described in "
NotesSQL 2.03 Reference
NotesSQL 2.03 Reference
Configuring a Lotus Notes Data Source
See related topics
NotesSQL 2.03 Reference
NotesSQL 2.03 Reference
Adding a Lotus Notes Data Source
NotesSQL 2.03 Reference
NotesSQL 2.03 Reference
Configuring a Lotus Notes Data Source
NotesSQL 2.03 Reference
NotesSQL 2.03 Reference
Deleting a Lotus Notes Data Source
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
The UNION clause combines SELECT statements.
BHead
Syntax
Display
select-statement
UNION
select-statement
AHead
Example
SELECT
F.LOCATION, I.PART, AVG(I.UNITCOST)
FROM
INVENTORY I, FACTORIES F
WHERE
F.LOCATION = I.
LOCATION
UNION SELECT
I.LOCATION, I.PART, 0
FROM
INVENTORY I
WHERE NOT EXISTS
(SELECT
LOCATION
FROM
FACTORIES
WHERE
LOCATION
= I.LOCATION
GROUP BY
LOCATION
ORDER BY
LOCATION DESC
See related topics
NotesSQL 2.03 Reference
NotesSQL 2.03 Reference
SQL Typographical Conventions
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
These are tips for using NotesSQL with other applications:
Access supports table names of 64 characters. The ODBC specification supports 128. We've found that Access doesn't display the list of tables when a table has a name longer than 63 characters. This prevents connecting to a whole database even if the table you want has a smaller name.
Access doesn't support indexes on text fields longer than 254. For a DSN with 254 (the default) as the text field length, Access can use views with sorted text fields as indexes. If you change the setting in the configuration dialog to 255, Access will not be able to use the text field as a key in an index. It will display the following error message:
"Invalid field "..." in index or relation"
Also, updates of text fields will not work with the text field length set higher than 254 characters.
This issue does not apply to rich text fields.
In Crystal Reports(TM), after choosing a table, you are prompted to "Please select an alias name to refer to this file." The alias name entered should start with an alphabetic character. The default alias name is the same as the table name. If this starts with a non-alphabetic character, Crystal Reports gives an "Invalid Character" error.
In Visual Basic
and other applications, for a table to be updatable there must be a unique index on it. For details, see "
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". You probably wouldn't type this SQL, since there is no point in having an alias that is the same as the original name. However certain applications, notably Crystal Reports, generate SQL like this. The workaround for this is to modify the alias name.
Bullet
These are known limitations or problems with NotesSQL:
A text field length of more than 254 is not recommended. It is available so that you can read long Notes text fields. Notes text fields are mapped to the ODBC data type VARCHAR. The ODBC specification for the maximum string length of a VARCHAR field is 254. Some applications won't work with longer fields. You may experience problems even if the data is shorter than 254 characters.
Scalar functions are supported if there is underlying Notes support. Consequently, these scalar functions are not supported:
String: ASCII, INSERT, LOCATE, REPLACE
Numeric: TRUNCATE
System: IFNULL
NotesSQL was developed to the ODBC 2.0 specification. ODBC 3.0 Driver Manager vendors have tried to be backward-compatible with ODBC 2.0 drivers, but several features are not available. Here are the two we know about:
SQLDriverConnect does not accept the FILEDSN and SAVEFILE attribute-keywords, so File DSNs are not functional.
Several APIs were added in 3.0. None of these is supported.
There may be problems using categorized views. They don't map to the relational data model.
You can't use a form or view with a double quote (
) in the name.
View selection formulas marked as "easy" (as opposed to "formula") in the radio button on the view design may be hiding some detail. Look in the design synopsis to see the full view selection formula.
NotesSQL can update Authors and Readers fields in existing documents. However, if you insert a new document with a Readers or Authors field, NotesSQL actually creates a Text field (with field flags type Summary) for that Readers or Authors field.
NotesSQL does not support multithreading
on OS/2, 16-bit Windows, or the Macintosh
due to limitations in the underlying thread support.
On Win32 platfor
DocLink
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
BHead
Ahead
ChapterHead
DocLinkHead
This chapter introduces Lotus NotesSQL.
Contents of this chapter:
Database 'Lotus Notes ODBC Driver Doc', View 'Table of Contents'
Database 'Lotus Notes ODBC Driver Doc', View 'Table of Contents'
What is ODBC?
Database 'Lotus Notes ODBC Driver Doc', View 'Table of Contents'
Database 'Lotus Notes ODBC Driver Doc', View 'Table of Contents'
What is NotesSQL?
Database 'NotesSQL 2.03 Reference', View 'Table of Contents'
CN=zathras/OU=CAM/O=Notes
Database 'NotesSQL 2.03 Reference', View 'Table of Contents'
CN=zathras/OU=CAM/O=Notes
New Features in This Release
Wingdings
IndBullet
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
NotesSQL 2.04 provides the following enhancements and bug fixes:
On Microsoft Windows 95 and Windows NT (Intel and Alpha) platforms only, new thread handling design allows interaction with thread sharing Internet application and reporting tools. Fixes known problems
using NotesSQL with Microsoft Internet Information Server (IIS), Cognos Impromptu, and Intersolv SequeLink products.
Additional testing procedures on 32-bit Windows platforms to ensure functionality with leading Internet application software. Specifically tested were: Lotus BeanMachine Release 1.1, IBM Visual Age for Java (Enterprise) Version 1.0, NetObjects Fusion Version 2.0.2, Microsoft Active Server Pages and Internet Database Connector (IDC) on IIS 4.0, Microsoft Visual InterDev 1.0, and Microsoft FrontPage 98. Make sure you have the latest versions or patches of Lotus BeanMachine and Visual Age for Java. (For BeanMachine, you need patch 1.1.4.) You can download these from www.lotus.com/beanmachine and www.software.ibm.com/ad/vajava/fixes.htm.
We relaxed a restriction that forced an outer join clause to be the first item in the FROM clause of a SELECT statement. The outer join clause can now be anywhere in the FROM clause.
NotesSQL now properly evaluates a CR/LF in a text field in a WHERE clause of a SELECT statement.
DocLink
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
BHead
Ahead
ChapterHead
DocLinkHead
This chapter describes how to install NotesSQL, create ODBC data sources, and connect to the data source.
Contents of this chapter:
Database 'NotesSQL 2.03 Reference', View 'Print'
CN=zathras/OU=CAM/O=Notes
Database 'NotesSQL 2.03 Reference', View 'Print'
CN=zathras/OU=CAM/O=Notes
Hardware and Software Requirements
Database 'Lotus Notes ODBC Driver Doc', View 'Table of Contents'
Database 'Lotus Notes ODBC Driver Doc', View 'Table of Contents'
Installing NotesSQL
Database 'Lotus Notes ODBC Driver Doc', View 'Table of Contents'
Database 'Lotus Notes ODBC Driver Doc', View 'Table of Contents'
Configuring a Lotus Notes Data Source
Database 'Lotus Notes ODBC Driver Doc', View 'Table of Contents'
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'
Database 'Lotus Notes ODBC Driver Doc', View 'Table of Contents'
Modifying a Lotus Notes Data Source
Database 'Lotus Notes ODBC Driver Doc', View 'Table of Contents'
Database 'Lotus Notes ODBC Driver Doc', View 'Table of Contents'
Deleting a Lotus Notes Data Source
Database 'NotesSQL 2.03 Reference', View 'Print'
CN=zathras/OU=CAM/O=Notes
Wingdings
AHead
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
AHead
The searched DELETE statement removes 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 remove data.
<where clause> specifies the rows to remove. If no WHERE clause is specified, all rows in the table are removed.
See related topics
NotesSQL 2.03 Reference
NotesSQL 2.03 Reference
SQL Typographical Conventions
NotesSQL 2.03 Reference
NotesSQL 2.03 Reference
Column, Index, Table, and View Names
NotesSQL 2.03 Reference
NotesSQL 2.03 Reference
WHERE
Wingdings
AHead
BHead
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
AHead
The DROP VIEW statement removes 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 remove.
Restrictions:
Dependent objects and documents are not removed.
See related topics
NotesSQL 2.03 Reference
NotesSQL 2.03 Reference
SQL Typographical Conventions
NotesSQL 2.03 Reference
NotesSQL 2.03 Reference
Column, Index, Table, and View Names
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
BHead
Ahead
ChapterHead
DocLink
Lotus NotesSQL Reference
Release 2.04
BHead
AHead
BHead
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
AHead
All 32-bit Windows platforms (Windows 95 or NT for Intel or Alpha)
1. Run SETUP.EXE and follow the prompts that appear.
Note:
During installation, a dialog box asks you if you want to install ODBC 3.0 components or cancel the installation. Click OK to continue.
2. At the end of the installation process, the ODBC Data Source Administrator dialog box appears so you can add Lotus Notes Data Sources. If you are upgrading from a previous 2.x version of NotesSQL, note that you do not have to make any changes to your Data Sources. All your previously added Data Sources will work with this release.
3. For ease of access, move this documentation database to your Notes data directory.
16-bit Windows
1. Run SETUP.EXE, which loads Microsoft ODBC Setup, and follow the prompts.
2. When the Install Drivers dialog box appears, select the NotesSQL driver and click OK. (You do not need to modify any information in the Advanced dialog box.)
3. At the end of the installation process, the ODBC Data Source Administrator dialog box appears so you can add Lotus Notes Data Sources. If you are upgrading from a previous 2.x version of NotesSQL, note that you do not have to make any changes to your Data Sources. All your previously added Data Sources will work with this release.
4. For ease of access, move this documentation database to your Notes data directory.
1. At the command prompt, set the ODBC_PATH environment variable to the directory where you want to install the driver. For example:
set ODBC_PATH=C:\ODBC
(You do not need to do this if you have already installed the Visigenic ODBC Driver Manager.)
2. At the command prompt, run SETUP.EXE.
3. When prompted for the installation directory, use the default directory (the directory specified by the ODBC_PATH environment variable).
4. When the Install Drivers dialog box appears, select the NotesSQL driver and click OK. (You do not need to modify any information in the Advanced dialog box.)
5. At the end of the installation process, the ODBC Data Source Administrator dialog box appears so you can add Lotus Notes Data Sources. If you are upgrading from a previous 2.x version of NotesSQL, note that you do not have to make any changes to your Data Sources. All your previously added Data Sources will work with this release.
6. For ease of access, move this documentation database to your Notes data directory.
7. Reboot the system.
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
BHead
Naming Rules
A column, index, or view name can be up to 32 characters long. A table name can be up to 64 characters long.
Index, view, and table names can consist of letters, digits, underscores ( _ ), dollar signs ( $ ), and spaces. If an index, view, or table name contains a space or is the same as a SQL reserved word, it must be enclosed in double quotes.
Column names can consist of letters, digits, underscores ( _ ), and dollar signs ( $ ). Column names connot contain spaces or conflict with a SQL reserved word.
Creating Columns, Indexes, Tables, and Views
When creating an index or 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.
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.
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.
Name Visibility
If a Notes database contains both a view and a form with the same name, NotesSQL will see the form but not the view.
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 data type. 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, 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 (as Notes does 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). This formula is evaluated to supply a value when the INSERT statement contains no data for the field.
2. The Input Translation formula.
The Input Translation formula could change the value of the inserted data.
3. The Input Validation formula.
If the Input Validation formula returns FALSE, the insertion of that row fails. If you are inserting a single record and the insertion fails, SQLExecute and SQLExecDirect return SQL_ERROR. If you are inserting 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. If all the insertions fail, SQLExecute and SQLExecDirect return SQL_ERROR.
See related topics
NotesSQL 2.03 Reference
NotesSQL 2.03 Reference
SQL Typographical Conventions
NotesSQL 2.03 Reference
NotesSQL 2.03 Reference
Column, Index, Table, and View Names
NotesSQL 2.03 Reference
NotesSQL 2.03 Reference
WHERE
NotesSQL 2.03 Reference
NotesSQL 2.03 Reference
CN=zathras/OU=CAM/O=Notes
Data Types
Wingdings
AHead
IndPara
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
NotesSQL 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 no support for them in Notes.
The following describes how particular functions are implemented in NotesSQL, 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, NotesSQL names the column in the result set. The name is the character "$" followed by a number (for example, "$2").
A call to SQLColumns fills the optional REMARKS column. The contents of the REMARKS column depends on the type of the field. For Notes form fields, the help description is in the REMARKS column. For Notes view columns, the column title is in the REMARKS column. For fields from Notes aliases, the "base" form or view name is in the REMARKS column. The length of the REMARKS column is 128 characters.
Note that SQLColumns filters out columns that have no relation. You cannot create or select a column if it is not part of a relation in SQL.
SQLGetConnectOption
SQLSetConnectOption
These functions accept all valid options.
The options that affect the state of the driver are:
SQL_ACCESS_MODE
SQL_QUIET_MODE
For SQLSetConnectOption, SQL_AUTOCOMMIT returns SQL_SUCCESS if given the argument 1, and SQLGetConnectOption always returns 1.
The following 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
The following 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
SYNONYM
UNIVERSAL
Every Notes database includes a table that has the same name as the database. This is referred to as the Universal Relation table. It 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.
See related topics
Notes Product Development
)I^-.
PURSAF
O=Lotus
O=Lotus
PURSAFO
O=Lotus
OU=CAM/O=Lotus
PURSAFO
OU=CAM/O=Lotus
CN=Michael Stewart/OU=CAM/O=Lotus
A]yvinNj
PURSAFO
i[h7}
NotesSQL 2.03 Reference
The Universal Relation
BHead
IndBullet
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
The following table describes how SQL components map to Notes components:
SQL Component
Notes Component
Comments
Table
Universal Relation
SQL Tables map to either Notes forms or Notes views
However, a Notes database contains only one real table, referred to as the Universal Relation.
This table has the same name as the database.
Column
Form Field
View Column
When creating a NotesSQL 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 letters, numbers, or underscores.
Index
A SQL Index maps to a Notes view in which all sorted columns refer directly to fields in a
single
form, and which selects documents from only that form.
A SQL View maps to a Notes view that selects documents from
form, in which all columns are calculable from the 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.
When a Notes database has both a form and a view with the same name, NotesSQL cannot distinguish between them in SQL statements and the view cannot be accessed
See related topics
NotesSQL 2.03 Reference
NotesSQL 2.03 Reference
Using SQL Tables Derived from Notes Forms and Views
NotesSQL 2.03 Reference
NotesSQL 2.03 Reference
The Universal Relation
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
NotesSQL returns only the text part(s) of a Notes rich text field. NotesSQL 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 tich 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.
You cannot insert a string longer than 15,360 bytes into a rich text field.
IndList
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
BHead
To delete a Lotus Notes data source:
1. Start the ODBC Administrator.
2. Select the data source in the Data Sources (Drivers) list box.
3. Choose Delete.
4. Choose Yes to confirm the deletion.
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
NotesSQL 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 =, <>, >, >=, <, <=, or =.
=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 =, <>, >, >=, <, or <=.
EXISTS
"True" if a subquery returned at least one record.
Wingdings
BHead
AHead
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
The searched UPDATE statement updates values in selected rows of a table.
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 that evaluates to a new value for the column.
<where clause>
identifies the rows to update. If no WHERE clause is supplied, all rows are updated.
See related topics
NotesSQL 2.03 Reference
NotesSQL 2.03 Reference
SQL Typographical Conventions
NotesSQL 2.03 Reference
NotesSQL 2.03 Reference
Column, Index, Table, and View Names
NotesSQL 2.03 Reference
NotesSQL 2.03 Reference
WHERE
NotesSQL 2.03 Reference
NotesSQL 2.03 Reference
CN=zathras/OU=CAM/O=Notes
Data Types
9Q[fP
DocLink
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
BHead
Ahead
ChapterHead
DocLinkHead
This chapter describes how to use NotesSQL.
Contents of this chapter:
Database 'Lotus Notes ODBC Driver Doc', View 'Table of Contents'
Database 'Lotus Notes ODBC Driver Doc', View 'Table of Contents'
Connecting to a Lotus Notes Data Source
Database 'Lotus Notes ODBC Driver Document', View 'Table of Contents'
Database 'Lotus Notes ODBC Driver Document', View 'Table of Contents'
Mapping SQL Tables, Views, and Indexes to and from Notes
Database 'NotesSQL 2.03 Reference', View 'Print'
CN=zathras/OU=CAM/O=Notes
Database 'NotesSQL 2.03 Reference', View 'Print'
CN=zathras/OU=CAM/O=Notes
Mapping Notes Names to SQL Names
Database 'Lotus Notes ODBC Driver Document', View 'Table of Contents'
Database 'Lotus Notes ODBC Driver Document', View 'Table of Contents'
The Universal Relation
IndPara
Database 'Lotus Notes ODBC Driver Document', View 'Table of Contents'
Database 'Lotus Notes ODBC Driver Document', View 'Table of Contents'
Using the Universal Relation
Database 'Lotus Notes ODBC Driver Document', View 'Table of Contents'
Database 'Lotus Notes ODBC Driver Document', View 'Table of Contents'
Using SQL Tables Derived from Notes Forms and Views
Database 'NotesSQL 2.03 Reference', View 'Print'
CN=zathras/OU=CAM/O=Notes
Database 'NotesSQL 2.03 Reference', View 'Print'
CN=zathras/OU=CAM/O=Notes
Example: Using SQL Tables Derived from Notes Forms and Views
Database 'Lotus Notes ODBC Driver Document', View 'Table of Contents'
Database 'Lotus Notes ODBC Driver Document', View 'Table of Contents'
Using Notes Views as Indexes
Database 'Lotus Notes ODBC Driver Doc', View 'Table of Contents'
Database 'Lotus Notes ODBC Driver Doc', View 'Table of Contents'
Error Messages
Database 'Lotus Notes ODBC Driver Document', View 'Table of Contents'
Database 'Lotus Notes ODBC Driver Document', View 'Table of Contents'
View Column Definitions
Database 'Lotus Notes ODBC Driver Doc', View 'Table of Contents'
Database 'Lotus Notes ODBC Driver Doc', View 'Table of Contents'
Data Types
NotesSQL 2.03 Reference
NotesSQL 2.03 Reference
Tips for Third-Party Applications and Caveats
Wingdings
Mu9I_
Bullet
Bullet
AHead
IndList
BHead
DocLink
ChapterHead
Ahead
BHead
CHead
ParaLead
Display
Bullet
IndPara
IndDisplay
IndBullet
IndList
DocLinkHead
This appendix describes SQL statements, clauses, and conventions supported by NotesSQL.
Contents of this chapter:
Notes Product Development
)I^-.
PURSAF
O=Lotus
O=Lotus
PURSAFO
O=Lotus
OU=CAM/O=Lotus
PURSAFO
OU=CAM/O=Lotus
CN=Michael Stewart/OU=CAM/O=Lotus
A]yvinNj
PURSAFO
NotesSQL 2.03 Reference
Summary of Supported ODBC SQL Grammar
Notes Product Development
)I^-.
PURSAF
O=Lotus
O=Lotus
PURSAFO
O=Lotus
OU=CAM/O=Lotus
PURSAFO
OU=CAM/O=Lotus
CN=Michael Stewart/OU=CAM/O=Lotus
A]yvinNj
PURSAFO
NotesSQL 2.03 Reference
Exceptions to ODBC SQL Grammar
Notes Product Development
)I^-.
PURSAF
O=Lotus
O=Lotus
PURSAFO
O=Lotus
OU=CAM/O=Lotus
PURSAFO
OU=CAM/O=Lotus
CN=Michael Stewart/OU=CAM/O=Lotus
A]yvinNj
PURSAFO
NotesSQL 2.03 Reference
SQL Typographical Conventions
Notes Product Development
)I^-.
PURSAF
O=Lotus
O=Lotus
PURSAFO
O=Lotus
OU=CAM/O=Lotus
PURSAFO
OU=CAM/O=Lotus
CN=Michael Stewart/OU=CAM/O=Lotus
A]yvinNj
PURSAFO
NotesSQL 2.03 Reference
Column, Index, Table, and View Names
Notes Product Development
)I^-.
PURSAF
O=Lotus
O=Lotus
PURSAFO
O=Lotus
OU=CAM/O=Lotus
PURSAFO
OU=CAM/O=Lotus
CN=Michael Stewart/OU=CAM/O=Lotus
A]yvinNj
PURSAFO
NotesSQL 2.03 Reference
Multi-Valued Fields (List Fields)
Numeric Operators
NotesSQL 2.03 Reference
NotesSQL 2.03 Reference
Rich Text Fields
ALTER TABLE
CREATE INDEX
CREATE TABLE
CREATE VIEW
DELETE Searched
DELETE Positioned
DROP INDEX
DROP TABLE
DROP VIEW
INSERT
SELECT
Column Functions
FOR UPDATE
GROUP BY
HAVING
ORDER BY
NotesSQL 2.03 Reference
NotesSQL 2.03 Reference
UNION
UPDATE Searched
UPDATE Positioned
Link
WHERE
Link
Predicate Operators
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
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 ODBC driver manager and the underlying drivers. Each ODBC driver is a dynamic link library for accessing a specific type of database. ODBC uses the driver manager to handle finding and connecting to a driver 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.
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 TABLE
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>
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
TIME
TIMESTAMP
IndPara
The field sizes specified for CHAR, DECIMAL, NUMERIC, and VARCHAR fields are optional.
If you specify a size for one of these fields, Notes ignores it 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 field, instead of a large text field.
See related topics
NotesSQL 2.03 Reference
NotesSQL 2.03 Reference
SQL Typographical Conventions
NotesSQL 2.03 Reference
NotesSQL 2.03 Reference
Data Types
NotesSQL 2.03 Reference
NotesSQL 2.03 Reference
Column, Index, Table, and View Names
Wingdings
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
The Notes Personal Address Book (NAMES.NSF) is a good database to use as an example to compare the use of forms or views in a database. The Personal 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 Personal Address Book sorted by LastName:
IndPara
SELECT LastName
FROM People
ORDER BY LastName
People is a Notes view. This query is efficient because NotesSQL can use the index already associated with the People view 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 People view is not sorted on Mail_Address, NotesSQL uses the People index, generates a temporary table, 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:
SELECT LastName, Mail_Address
FROM Person
ORDER BY Mail_Address
Person is a Notes form. If there is no index on Mail_Address, NotesSQL generates a temporary index on Mail_Address but does not need to generate a temporary table. 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 in Notes or by using the CREATE INDEX statement in NotesSQL.
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
{ { <
column name
| <integer> } [
[ , ... ]
AHead
Example
SELECT
LOCATION, AVG(UNITCOST)
FROM
INVENTORY
GROUP BY
LOCATION
ORDER BY
LOCATION DESC
See related topics
NotesSQL 2.03 Reference
NotesSQL 2.03 Reference
SQL Typographical Conventions
NotesSQL 2.03 Reference
NotesSQL 2.03 Reference
Column, Index, Table, and View Names
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
Using SQL Tables Derived from Notes Forms and Views
Using Notes Views as Indexes
333333
Using the Universal Relation
Connecting to a Lotus Notes Data Source
9Q[fP
ffffff
Mapping Notes Names to SQL Names
Mapping SQL Tables, Views, and Indexes to and from Notes
Example: Using SQL Tables Derived from Notes Forms and Views
333333
View Column Definitions
Tips for Third-Party Applications and Caveats
tions and Caveats
UPDATE Positioned
LOTUS NOTESSQL\2 Installation and Configuration
333333
rators
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Mapp
The Universal Relation
Using SQL Tables Derived from Notes Forms and Views
Using Notes Views as Indexes
333333
Using the Universal Relation
Connecting to a Lotus Notes Data Source
9Q[fP
ffffff
Mapping Notes Names to SQL Names
Mapping SQL Tables, Views, and Indexes to and from Notes
Example: Using SQL Tables Derived from Notes Forms and Views
333333
View Column Definitions
Tips for Third-Party Applications and Caveats
UPDATE Positioned
LOTUS NOTESSQL\2 Installation and Configuration
333333
rators
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Mapping Notes Names to SQL Names
LOTUS NOTESSQL\2 Installation and Configuration
ffffff
Hardware and Software Requirements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Multi-Valued Fields (List Fields)
LOTUS NOTESSQL\5 Appendix A: SQL Statements
DELETE Positioned
LOTUS NOTESSQL\0 How to Use This Book
How to Use This Book
LOTUS NOTESSQL\2 Installation and Configuration
333333
Modifying a Lotus Notes Data Source
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Tips for Third-Party Applications and Caveats
LOTUS NOTESSQL\1 About Lotus NotesSQL
About Lotus NotesSQL
LOTUS NOTESSQL\2 Installation and Configuration
Installation and Configuration
LOTUS NOTESSQL\5 Appendix A: SQL Statements
DELETE Searched
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\2 Installation and Configuration
Installing NotesSQL
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Column, Index, Table, and View Names
LOTUS NOTESSQL\1 About Lotus NotesSQL
New Features in This Release
LOTUS NOTESSQL\5 Appendix A: SQL Statements
ODBC API Functions
Mapping SQL Tables, Views, and Indexes to and from Notes
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Rich Text Fields
LOTUS NOTESSQL\2 Installation and Configuration
Deleting a Lotus Notes Data Source
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Predicate Operators
LOTUS NOTESSQL\5 Appendix A: SQL Statements
UPDATE Searched
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\1 About Lotus NotesSQL
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Example: Using SQL Tables Derived from Notes Forms and Views
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Mapping SQL Tables, Views, and Indexes to and from Notes
ffffff
View Column Definitions
LOTUS NOTESSQL\1 About Lotus NotesSQL
333333
What is NotesSQL?
LOTUS NOTESSQL\1 About Lotus NotesSQL
About Lotus NotesSQL
LOTUS NOTESSQL\1 About Lotus NotesSQL
New Features in This Release
LOTUS NOTESSQL\1 About Lotus NotesSQL
The Universal Relation
Using SQL Tables Derived from Notes Forms and Views
Using Notes Views as Indexes
333333
Using the Universal Relation
Connecting to a Lotus Notes Data Source
9Q[fP
ffffff
Mapping Notes Names to SQL Names
Mapping SQL Tables, Views, and Indexes to and from Notes
Example: Using SQL Tables Derived from Notes Forms and Views
333333
View Column Definitions
Tips for Third-Party Applications and Caveats
Frequently Asked Questions (FAQ)
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Mapp
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Summary of Supported ODBC SQL Grammar
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Using SQL Tables Derived from Notes Forms and Views
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Exceptions to ODBC SQL Grammar
Using Notes Views as Indexes
333333
Using the Universal Relation
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
SQL Typographical Conventions
Connecting to a Lotus Notes Data Source
ffffff
LOTUS NOTESSQL\1 About Lotus NotesSQL
333333
What is NotesSQL?
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Column Functions
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Numeric Operators
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Mapping Notes Names to SQL Names
LOTUS NOTESSQL\2 Installation and Configuration
ffffff
Hardware and Software Requirements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Multi-Valued Fields (List Fields)
LOTUS NOTESSQL\5 Appendix A: SQL Statements
DELETE Positioned
LOTUS NOTESSQL\0 How to Use This Book
How to Use This Book
LOTUS NOTESSQL\2 Installation and Configuration
333333
Modifying a Lotus Notes Data Source
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\1 About Lotus NotesSQL
About Lotus NotesSQL
LOTUS NOTESSQL\2 Installation and Configuration
Installation and Configuration
LOTUS NOTESSQL\5 Appendix A: SQL Statements
DELETE Searched
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\2 Installation and Configuration
Installing NotesSQL
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Column, Index, Table, and View Names
LOTUS NOTESSQL\1 About Lotus NotesSQL
New Features in This Release
LOTUS NOTESSQL\5 Appendix A: SQL Statements
ODBC API Functions
Mapping SQL Tables, Views, and Indexes to and from Notes
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Rich Text Fields
LOTUS NOTESSQL\2 Installation and Configuration
Deleting a Lotus Notes Data Source
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Predicate Operators
LOTUS NOTESSQL\5 Appendix A: SQL Statements
UPDATE Searched
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\1 About Lotus NotesSQL
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Example: Using SQL Tables Derived from Notes Forms and Views
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
FOR UPDATE
333333
View Column Definitions
Tips for Third-Party Applications and Caveats
cations and Caveats
ons and Caveats
LOTUS NOTESSQL\1 About Lotus NotesSQL
New
LOTUS NOTESSQL\2 Installation and Configuration
Configuring a Lotus Notes Data Source
LOTUS NOTESSQL\5 Appendix A: SQL Statements
The Universal Relation
Driver Capabilities: SQLGetInfo Return Values
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
UPDATE Positioned
LOTUS NOTESSQL\2 Installation and Configuration
333333
Adding a Lotus Notes Data Source
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Summary of Supported ODBC SQL Grammar
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Using SQL Tables Derived from Notes Forms and Views
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Exceptions to ODBC SQL Grammar
Using Notes Views as Indexes
333333
Using the Universal Relation
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
SQL Typographical Conventions
Connecting to a Lotus Notes Data Source
ffffff
LOTUS NOTESSQL\1 About Lotus NotesSQL
333333
What is NotesSQL?
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Column Functions
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Numeric Operators
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Mapping Notes Names to SQL Names
LOTUS NOTESSQL\2 Installation and Configuration
ffffff
Hardware and Software Requirements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Multi-Valued Fields (List Fields)
LOTUS NOTESSQL\5 Appendix A: SQL Statements
DELETE Positioned
LOTUS NOTESSQL\0 How to Use This Book
How to Use This Book
LOTUS NOTESSQL\2 Installation and Configuration
333333
Modifying a Lotus Notes Data Source
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\1 About Lotus NotesSQL
About Lotus NotesSQL
LOTUS NOTESSQL\2 Installation and Configuration
Installation and Configuration
LOTUS NOTESSQL\5 Appendix A: SQL Statements
DELETE Searched
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\2 Installation and Configuration
Installing NotesSQL
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Column, Index, Table, and View Names
LOTUS NOTESSQL\1 About Lotus NotesSQL
New Features in This Release
LOTUS NOTESSQL\5 Appendix A: SQL Statements
ODBC API Functions
Mapping SQL Tables, Views, and Indexes to and from Notes
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Rich Text Fields
LOTUS NOTESSQL\2 Installation and Configuration
Deleting a Lotus Notes Data Source
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Predicate Operators
LOTUS NOTESSQL\5 Appendix A: SQL Statements
UPDATE Searched
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\1 About Lotus NotesSQL
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Example: Using SQL Tables Derived from Notes Forms and Views
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
FOR UPDATE
333333
View Column Definitions
Tips for Third-Party Applications and Caveats
Frequently Asked Questions (FAQ)
Mapping SQL Tables, Views, and Indexes to and from Notes
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Rich Text Fields
Installing NotesSQL
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Column, Index, Table, and View Names
LOTUS NOTESSQL\1 About Lotus NotesSQL
333333
What is NotesSQL?
LOTUS NOTESSQL\1 About Lotus NotesSQL
About Lotus NotesSQL
LOTUS NOTESSQL\1 About Lotus NotesSQL
New Features in This Release
Indent
Topic
Topic
CategoriesDoc_Number$10$Conflict$REF$C1$
How To
Section
Chapter
Chapter Head
Appendix
Preface
About This Book
CategoriesDoc_Number$10
HAVING!
LOTUS NOTESSQL\3 Using NotesSQL
LOTUS NOTESSQL\4 Programming
DROP INDEX
SELECT
FROM
ALTER TABLE
CREATE VIEW"
GROUP BY"
Error Messages
WHERE
CREATE INDEX
DROP TABLE
Programming
UNION
Data Types
DROP VIEW
INSERT"
Using NotesSQL"
SQL Statements!
What is ODBC?
CREATE TABLE"
ORDER BY
How To
Section
Chapter
Chapter Head
Appendix
Preface
About This Book
CategoriesDoc_Number$10
CategoriesDoc_Number$10Select, then press ENTER or double-click to open a category or documentb
Indent
Topic
Topic
InternationalPrefix
LongDistancePrefix
MailFileName
RenameGroup
InLocalTime
InGMT
ReloadIfModified
OpenCalendar
SetMasterAddressBook
EditFindInPreview
SetPasswordFields
IsNetworkAdmin
DeleteResource
DeleteNTUser
DeleteResourceApproved
Specific
AddResource
CalendarGoTo
DeleteFileApproved
FindFreeTimeDialog
RemoveFromCluster
EditProfile
CalendarFormat
AddToCluster
UrlList
RefreshHideFormulas
Reload
DeleteStats
ViewShowOnlyUnread
NavigateToBacklink
NoOKCancel
AutoHorzFit
AutoVertFit
ViewMoveName
ViewRenamePerson
YESNOCANCEL
ChooseFolders
DeleteGroup
DeleteUser
AllInRange
Rule3
Rule2
Rule1
NoUpdate
Update
ShowHidePreviewPane
NavigatorProperties
TextCycleSpacing
TextOutdent
TextBullet
TextNumbers
StyleCycleKey
TextPermanentPen
GoUpLevel
ShowHideParentPreview
ShowHideLinkPreview
InsertSubform
CreateRectangularHotspot
CreateRectangle
CreatePolygon
CreatePolyline
CreateEllipse
CreateTextbox
ShowProperties
TextSpacingSingle
SectionProperties
SectionExpand
SectionCollapse
SectionRemY
Driver Capabilities: SQLGetInfo Return Values
ODBC API Functions
%I}Fmm
LOTUS NOTESSQL\2 Installation and Configuration
Configuring a Lotus Notes Data Source
LOTUS NOTESSQL\2 Installation and Configuration
333333
Adding a Lotus Notes Data Source
LOTUS NOTESSQL\2 Installation and Configuration
ffffff
Hardware and Software Requirements
LOTUS NOTESSQL\2 Installation and Configuration
333333
Modifying a Lotus Notes Data Source
LOTUS NOTESSQL\2 Installation and Configuration
Installation and Configuration
LOTUS NOTESSQL\2 Installation and Configuration
Installing NotesSQL
LOTUS NOTESSQL\2 Installation and Configuration
Deleting a Lotus Notes Data Source
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
UPDATE Positioned
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Summary of Supported ODBC SQL Grammar
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Exceptions to ODBC SQL Grammar
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
SQL Typographical Conventions
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Column Functions
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Numeric Operators
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Mu9I_
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Multi-Valued Fields (List Fields)
LOTUS NOTESSQL\5 Appendix A: SQL Statements
DELETE Positioned
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
DELETE Searched
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Column, Index, Table, and View Names
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Rich Text Fields
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Predicate Operators
LOTUS NOTESSQL\5 Appendix A: SQL Statements
UPDATE Searched
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
FOR UPDATE
LOTUS NOTESSQL\5 Appendix A: SQL Statements
DELETE Positioned
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
DELETE Searched
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Column, Index, Table, and View Names
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Rich Text Fields
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Predicate Operators
LOTUS NOTESSQL\5 Appendix A: SQL Statements
UPDATE Searched
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
FOR UPDATE
LOTUS NOTESSQL\5 Appendix A: SQL Statements
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
Copyright Page
HAVING!
LOTUS NOTESSQL\3 Using NotesSQL
LOTUS NOTESSQL\4 Programming
DROP INDEX
SELECT
FROM
ALTER TABLE
CREATE VIEW"
GROUP BY"
Error Messages
WHERE
CREATE INDEX
DROP TABLE
Programming
UNION
Data Types
DROP VIEW
Title Page
INSERT"
Using NotesSQL"
SQL Statements!
What is ODBC?
CREATE TABLE"
ORDER BY
Write monthly status reports and communicate regularly with project team and UA manager; identify any issues in a timely fashion.
Monitor and contribute to Notes databases relevant to Notes, your projects, and UA. In particular, continue to be an active participant in the UA Web team and UA group's general discussion databases.
Value and consider the different points of view of Notes team members and respect each person's contribution to the overall team effort.
Actively work together with other UA team members in Notes and Lotus to share information, leverage work, expertise, and ideas; contribute your expertise to other departments within Notes, and within Lotus, time permitting.
Create, maintain, and improve good working relationships with other groups that are dependent on you or you depend on; specifically Iris, QE, Development, Support, Product Management, and Marketing.
Encourage and foster team work and openly communicate issues that effect the group and work toward their resolution.
Follow through with issues from customer feedback in a timely manner, and communicate relevant issues to other team members.
Innovate whenever possible with a focus on reducing page count, minimizing redundancy, lessening lead-times, and improving information access and usability.
Demonstrate awareness that market share and profitability are essential business goals by working to increase Domino/Notes and related product market |
LOTUS NOTESSQL
LOTUS NOTESSQL\0 How to Use This Book
LOTUS NOTESSQL\0 How to Use This Book
How to Use This Book
LOTUS NOTESSQL\0 How to Use This Book
LOTUS NOTESSQL\0 How to Use This Book
LOTUS NOTESSQL\2 Installation and Configuration
Configuring a Lotus Notes Data Source
LOTUS NOTESSQL\5 Appendix A: SQL Statements
The Universal Relation
Driver Capabilities: SQLGetInfo Return Values
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
UPDATE Positioned
LOTUS NOTESSQL\2 Installation and Configuration
333333
Adding a Lotus Notes Data Source
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Summary of Supported ODBC SQL Grammar
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Using SQL Tables Derived from Notes Forms and Views
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Exceptions to ODBC SQL Grammar
Using Notes Views as Indexes
333333
Using the Universal Relation
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
SQL Typographical Conventions
Connecting to a Lotus Notes Data Source
ffffff
LOTUS NOTESSQL\1 About Lotus NotesSQL
333333
What is NotesSQL?
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Column Functions
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Numeric Operators
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Mapping Notes Names to SQL Names
LOTUS NOTESSQL\2 Installation and Configuration
ffffff
Hardware and Software Requirements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Multi-Valued Fields (List Fields)
LOTUS NOTESSQL\5 Appendix A: SQL Statements
DELETE Positioned
LOTUS NOTESSQL\0 How to Use This Book
How to Use This Book
LOTUS NOTESSQL\2 Installation and Configuration
333333
Modifying a Lotus Notes Data Source
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Tips for Third-Party Applications and Caveats
LOTUS NOTESSQL\1 About Lotus NotesSQL
About Lotus NotesSQL
LOTUS NOTESSQL\2 Installation and Configuration
Installation and Configuration
LOTUS NOTESSQL\5 Appendix A: SQL Statements
DELETE Searched
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\0 How to Use This Book
LOTUS NOTESSQL\2 Installation and Configuration
Installing NotesSQL
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Column, Index, Table, and View Names
LOTUS NOTESSQL\1 About Lotus NotesSQL
New Features in This Release
LOTUS NOTESSQL\5 Appendix A: SQL Statements
ODBC API Functions
Mapping SQL Tables, Views, and Indexes to and from Notes
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Rich Text Fields
LOTUS NOTESSQL\2 Installation and Configuration
Deleting a Lotus Notes Data Source
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Predicate Operators
LOTUS NOTESSQL\5 Appendix A: SQL Statements
UPDATE Searched
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\1 About Lotus NotesSQL
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Example: Using SQL Tables Derived from Notes Forms and Views
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
FOR UPDATE
333333
View Column Definitions
Column Definitions
umn Definitions
0 How to Use This Book
2 Installation and Configuration
5 Appendix A: SQL Statements
3 Using NotesSQL
4 Programming
1 About Lotus NotesSQL
LOTUS NOTESSQL\0 How to Use This Book
LOTUS NOTESSQL\2 Installation and Configuration
Configuring a Lotus Notes Data Source
LOTUS NOTESSQL\5 Appendix A: SQL Statements
The Universal Relation
Driver Capabilities: SQLGetInfo Return Values
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
UPDATE Positioned
LOTUS NOTESSQL\2 Installation and Configuration
333333
Adding a Lotus Notes Data Source
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Summary of Supported ODBC SQL Grammar
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Using SQL Tables Derived from Notes Forms and Views
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Exceptions to ODBC SQL Grammar
Using Notes Views as Indexes
333333
Using the Universal Relation
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
SQL Typographical Conventions
Connecting to a Lotus Notes Data Source
ffffff
LOTUS NOTESSQL\1 About Lotus NotesSQL
333333
What is NotesSQL?
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Column Functions
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Numeric Operators
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Mapping Notes Names to SQL Names
LOTUS NOTESSQL\2 Installation and Configuration
ffffff
Hardware and Software Requirements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Multi-Valued Fields (List Fields)
LOTUS NOTESSQL\5 Appendix A: SQL Statements
DELETE Positioned
LOTUS NOTESSQL\0 How to Use This Book
How to Use This Book
LOTUS NOTESSQL\2 Installation and Configuration
333333
Modifying a Lotus Notes Data Source
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\1 About Lotus NotesSQL
About Lotus NotesSQL
LOTUS NOTESSQL\2 Installation and Configuration
Installation and Configuration
LOTUS NOTESSQL\5 Appendix A: SQL Statements
DELETE Searched
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\0 How to Use This Book
LOTUS NOTESSQL\2 Installation and Configuration
Installing NotesSQL
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Column, Index, Table, and View Names
LOTUS NOTESSQL\1 About Lotus NotesSQL
New Features in This Release
LOTUS NOTESSQL\5 Appendix A: SQL Statements
ODBC API Functions
Mapping SQL Tables, Views, and Indexes to and from Notes
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Rich Text Fields
LOTUS NOTESSQL\2 Installation and Configuration
Deleting a Lotus Notes Data Source
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Predicate Operators
LOTUS NOTESSQL\5 Appendix A: SQL Statements
UPDATE Searched
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\1 About Lotus NotesSQL
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Example: Using SQL Tables Derived from Notes Forms and Views
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
FOR UPDATE
333333
View Column Definitions
333333
View Column Definitions
lease
LOTUS NOTESSQL\5 Appendix A: SQL Statements
ODBC API Functions
Mapping SQL Tables, Views, and Indexes to and from Notes
NotesSQL
Driver Capabilities: SQLGetInfo Return Values
ODBC API Functions
%I}Fmm
LOTUS NOTESSQL\1 About Lotus NotesSQL
333333
What is NotesSQL?
LOTUS NOTESSQL\1 About Lotus NotesSQL
About Lotus NotesSQL
LOTUS NOTESSQL\1 About Lotus NotesSQL
New Features in This Release
LOTUS NOTESSQL\1 About Lotus NotesSQL
The Universal Relation
Using SQL Tables Derived from Notes Forms and Views
Using Notes Views as Indexes
333333
Using the Universal Relation
Connecting to a Lotus Notes Data Source
9Q[fP
ffffff
Mapping Notes Names to SQL Names
Mapping SQL Tables, Views, and Indexes to and from Notes
Example: Using SQL Tables Derived from Notes Forms and Views
333333
View Column Definitions
Tips for Third-Party Applications and Caveats
Frequently Asked Questions (FAQ)
LOTUS NOTESSQL\5 Appendix A: SQL Statements
dix A: SQL Statements
Mapping Notes Names to SQL Names
QL\5 Appendix A: SQL Statements
Multi-Valued Fields (List Fields)
LOTUS NOTESSQL\5k
How to Use This Book
LOTUS NOTESSQL\2 Install
Frequently Asked Questions (FAQ)$
Using SQL Tables Derived from Notes Forms and Views
Using Notes Views as Indexes
333333
Using the Universal Relation
Connecting to a Lotus Notes Data Source
9Q[fP
ffffff
Mapping Notes Names to SQL Names
Mapping SQL Tables, Views, and Indexes to and from Notes
Example: Using SQL Tables Derived from Notes Forms and Views
333333
View Column Definitions
Tips for Third-Party Applications and Caveats
Frequently Asked Questions (FAQ)
LOTUS NOTESSQL\5 Appendix A: SQL Statements
dix A: SQL Statements
Mapping Notes Names to SQL Names
QL\5 Appendix A: SQL Statements
Multi-Valued Fields (List Fields)
LOTUS NOTESSQL\5k
How to Use This Book
LOTUS NOTESSQL\2 Installation and Configuration
333333
Modifying a Lotus Notes Data Source
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Tips for Third-Party Applications and Caveats
LOTUS NOTESSQL\1 About Lotus NotesSQL
About Lotus NotesSQL
LOTUS NOTESSQL\2 Installation and Configuration
Installation and Configuration
LOTUS NOTESSQL\5 Appendix A: SQL Statements
DELETE Searched
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\0 How to Use This Book
LOTUS NOTESSQL\2 Installation and Configuration
Installing NotesSQL
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Column, Index, Table, and View Names
LOTUS NOTESSQL\1 About Lotus NotesSQL
New Features in This Release
LOTUS NOTESSQL\5 Appendix A: SQL Statements
ODBC API Functions
Mapping SQL Tables, Views, and Indexes to and from Notes
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Rich Text Fields
LOTUS NOTESSQL\2 Installation and Configuration
Deleting a Lotus Notes Data Source
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Predicate Operators
LOTUS NOTESSQL\5 Appendix A: SQL Statements
UPDATE Searched
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\1 About Lotus NotesSQL
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Example: Using SQL Tables Derived from Notes Forms and Views
LOTUS NOTESSQL\5 Appendix A: SQL Statements
perators
LOTUS NOTESSQL\5 Appendix A: SQL Statements
UPDATE Searched
LOTUS NOTESSQL\2 Installation and Configuration
Configuring a Lotus Notes Data Source
LOTUS NOTESSQL\2 Installation and Configuration
333333
Adding a Lotus Notes Data Source
LOTUS NOTESSQL\2 Installation and Configuration
ffffff
Hardware and Software Requirements
LOTUS NOTESSQL\2 Installation and Configuration
333333
Modifying a Lotus Notes Data Source
LOTUS NOTESSQL\2 Installation and Configuration
Installation and Configuration
LOTUS NOTESSQL\2 Installation and Configuration
Installing NotesSQL
LOTUS NOTESSQL\2 Installation and Configuration
Deleting a Lotus Notes Data Source
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
UPDATE Positioned
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Summary of Supported ODBC SQL Grammar
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Exceptions to ODBC SQL Grammar
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
SQL Typographical Conventions
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Column Functions
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Numeric Operators
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Mu9I_
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Multi-Valued Fields (List Fields)
LOTUS NOTESSQL\5 Appendix A: SQL Statements
DELETE Positioned
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
DELETE Searched
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Column, Index, Table, and View Names
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Rich Text Fields
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Predicate Operators
LOTUS NOTESSQL\5 Appendix A: SQL Statements
UPDATE Searched
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
FOR UPDATE
Modifying a Lotus Notes Data Source
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Tips for Third-Party Applications and Caveats
LOTUS NOTESSQL\1 About Lotus NotesSQL
About Lotus NotesSQL
LOTUS NOTESSQL\2 Installation and Configuration
Installation and Configuration
LOTUS NOTESSQL\5 Appendix A: SQL Statements
DELETE Searched
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\0 How to Use This Book
LOTUS NOTESSQL\2 Installation and Configuration
Installing NotesSQL
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Column, Index, Table, and View Names
LOTUS NOTESSQL\1 About Lotus NotesSQL
New Features in This Release
LOTUS NOTESSQL\5 Appendix A: SQL Statements
ODBC API Functions
Mapping SQL Tables, Views, and Indexes to and from Notes
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Rich Text Fields
LOTUS NOTESSQL\2 Installation and Configuration
Deleting a Lotus Notes Data Source
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Predicate Operators
LOTUS NOTESSQL\5 Appendix A: SQL Statements
UPDATE Searched
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\1 About Lotus NotesSQL
LOTUS NOTESSQL\5 Appendix A: SQL Statements
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
Frequently Asked Questions
Can I share ODBC handles between threads?
Yes, on Win32 platforms. The restriction that an application can't share ODBC handles between threads has been removed in NotesSQL 2.04. This enhancement removed problems we've seen in using NotesSQL with Microsoft Internet Information Server (IIS) and the Internet Database Connector (IDC) component, Impromptu from Cognos, and SequeLink from Intersolv.
Can I use NotesSQL with the JDBC-ODBC bridge?
Yes. However, if you want to create a Java applet that uses the JDBC-ODBC bridge and NotesSQL to access Notes data, remember that the bridge is not 100% Pure Java, and is therefore by definition not secure. NotesSQL itself relies on Notes to ensure the security of the Notes data you access. It is the responsibility of the applet creator to make the program a trusted applet in the context of the browser in which it runs.
What Java tools can I use to connect to NotesSQL using
the JDBC-ODBC bridge?
The Lotus BeanMachine, which includes a part on the palette that lets you access ODBC data sources, and Visual Age for Java e-business using the Data Access Builder tool. You'll need NotesSQL 2.04 and the most recent software or patches for each product. (For BeanMachine, it's patch 1.1.4.) You can download the software you need from www.lotus.com/beanmachine and www.software.ibm.com/ad/vajava/fixes.htm.
Can I use NotesSQL with NetObjects Fusion?
Yes. NetObjects Fusion
,s data publishing capabilities allow you to import data from any ODBC driver.
Can I access NotesSQL using Active Server Pages?
Yes. You need NotesSQL 2.04 and IIS 4.0 using ActiveX Data Objects (ADO).
Can I use FrontPage 98 to generate Active Server Pages (ASP) accessing NotesSQL 2.04?
Where can I get NotesSQL 2.04?
You can get the latest version of NotesSQL from the Lotus Web site (
http://www.lotus.com
On the home page, click Products in the left-hand frame. Then scroll down in the frame and click NotesSQL. From the NotesSQL page, download the NotesSQL self-extracting executable to a temporary installation directory. Run the executable, and then run the setup.exe it contains.
Which versions of Notes can NotesSQL 2.04 access?
Notes 4.0 and above.
Can I produce a report that joins Notes data and data from my relational database?
This depends on your reporting tool. If it supports heterogeneous joins, sure.
Can I update Notes databases via NotesSQL 2.04?
Yes. Some applications could be unable to issue updates in certain circumstances, but we are currently unaware of any such problems.
What security is in place when I use NotesSQL 2.04 to access Notes?
The same security that is in place with any Notes C API application. This is why we don't support sending a user name and password through the API; doing so would breach Notes security. To run an application unattended without ever receiving a password prompt, you must use a non-password-protected ID.
Note: You can remove password protection from your ID by clearing it (File - Tools - User ID - Clear Password), unless your Domino administrator required a password to be used when your ID was created. In this case, you won't be able to clear it.
Can I use NotesSQL with a File DSN?
File DSNs (or File Data Sources) are not part of ODBC 2.0 and NotesSQL does not support them. NotesSQL does support System DSNs and User DSNs on 32-bit Windows platforms. The difference between the data sources lies in where the connect information is stored. For a File DSN, the information goes in a text file with a "DSN" extension. Information for the other two data sources is stored in your registry. We will support File DSNs in a future release.
Some applications (notably Access and Visual InterDev) default to creating a File DSN when you are creating a new ODBC Data Source. They display the ODBC Administrator with the File DSN tab in front. Generally, you can just switch to the User DSN or System DSN tab without a problem.
This book is for use with NotesSQL, the Lotus Notes ODBC driver, release 2.04. NotesSQL runs on Microsoft Windows, Windows 95, Windows NT, Apple Macintosh PowerPC, and OS/2. You must be running Notes on a workstation.
This book can be viewed online as a Notes database, and it can be printed.
Choose
Help - Using This Database
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
Copyright
Revision history
Original Original file produced for Lotus NotesSQL 2.0.
First revision Incorporates information on Lotus NotesSQL 2.01.
Second revision Incorporates information on Lotus NotesSQL 2.02.
Third revision Incorporates information on Lotus NotesSQL 2.03.
Fourth revision Incorporates information on Lotus NotesSQL 2.04.
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, without the prior written consent of Lotus Development Corporation, except in the manner described in the software agreement.
Copyright 1996 - 1998
Lotus Development Corporation
55 Cambridge Parkway
Cambridge, MA 02142
All rights reserved. Published in the United States.
Domino, NotesSQL, and Notes are trademarks and Lotus and Lotus Notes are registered trademarks of Lotus Development Corporation. IBM and OS/2 are registered trademarks of International Business Machines Corporation.
Microsoft, Windows,
Windows NT, and Visual Basic
are registered trademarks and ODBC is a trademark of Microsoft Corporation.
Crystal Reports is a trademark of Crystal, a Seagate Software Company.
Other product and company names mentioned herein may be the trademarks or registered trademarks of their respective owners.
Copyright 1994, 1995 Casahl Technology, Inc. All Rights Reserved.
Casahl is a registered trademark of Casahl Technology, Inc.
LOTUS DEVELOPMENT CORPORATION LICENSOR(S) MAKES NO WARRANTIES, EXPRESS OR IMPLIED, INCLUDING WITHOUT LIMITATION THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE, REGARDING THE SOFTWARE. LOTUS DEVELOPMENT CORPORATION'S LICENSOR(S) DOES NOT WARRANT, GUARANTEE OR MAKE ANY REPRESENTATIONS REGARDING THE USE OR THE RESULTS OF THE USE OF THE SOFTWARE IN TERMS OF ITS CORRECTNESS, ACCURACY, RELIABILITY, CURRENTNESS OR OTHERWISE. THE ENTIRE RISK AS TO THE RESULTS AND PERFORMANCE OF THE SOFTWARE IS ASSUMED BY YOU. THE EXCLUSION OF IMPLIED WARRANTIES IS NOT PERMITTED BY SOME JURISDICTIONS. THE ABOVE EXCLUSION MAY NOT APPLY TO YOU.
IN NO EVENT WILL LOTUS DEVELOPMENT CORPORATION'S LICENSOR(S), AND THEIR DIRECTORS, OFFICERS, EMPLOYEES OR AGENTS (COLLECTIVELY LOTUS DEVELOPMENT CORPORATION'S LICENSOR(S)) BE LIABLE TO YOU FOR ANY CONSEQUENTIAL, INCIDENTAL OR INDIRECT DAMAGES (INCLUDING DAMAGES FOR LOSS OF BUSINESS PROFITS, BUSINESS INTERRUPTION, LOSS OF BUSINESS INFORMATION, AND THE LIKE) ARISING OUT OF THE USE OF OR INABILITY TO USE THE SOFTWARE EVEN IF LOTUS DEVELOPMENT CORPORATION'S LICENSOR(S) HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. BECAUSE SOME JURISDICTIONS DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES, THE ABOVE LIMITATIONS MAY NOT APPLY TO YOU.
O=Lotus Notes
O=Lotus Notes
PURSAFO
|.:#U
O=Lotus Notes
CN=Lotus Notes Template Development/O=Lotus Notes
PURSAFO
Fde!f^^
h}R6js
$INFO
$BODY
PURSAFO
Wingdings
IndList
IndBullet
IndDisplay
IndPara
Bullet
Display
ParaLead
CHead
AHead
BHead
ChapterHead
DocLinkHead
DocLink
ODBC SQL to Notes data type mapping:
IndBullet
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
In addition to the SQL data types, Notes supports two additional data types:
Notes Product Development
)I^-.
PURSAF
O=Lotus
O=Lotus
PURSAFO
O=Lotus
OU=CAM/O=Lotus
PURSAFO
OU=CAM/O=Lotus
CN=Michael Stewart/OU=CAM/O=Lotus
A]yvinNj
PURSAFO
NotesSQL 2.03 Reference
Multi-Valued
Fields (List Fields)
Rich Text Fields
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 above.
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:
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
Note
Numeric values greater than 10 to the 99th power are not supported. 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.
Note
NotesSQL 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.
Note
NotesSQL does not support Notes Section security. Users of NotesSQL can read and modify fields anywhere on a form.
Note
You cannot insert a string longer than 15,360 bytes into a rich text field.
LOTUS NOTESSQL\0 How to Use This Book
LOTUS NOTESSQL\2 Installation and Configuration
Configuring a Lotus Notes Data Source
LOTUS NOTESSQL\5 Appendix A: SQL Statements
The Universal Relation
Driver Capabilities: SQLGetInfo Return Values
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
UPDATE Positioned
LOTUS NOTESSQL\2 Installation and Configuration
333333
Adding a Lotus Notes Data Source
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Summary of Supported ODBC SQL Grammar
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Using SQL Tables Derived from Notes Forms and Views
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Exceptions to ODBC SQL Grammar
Using Notes Views as Indexes
333333
Using the Universal Relation
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
SQL Typographical Conventions
Connecting to a Lotus Notes Data Source
ffffff
LOTUS NOTESSQL\1 About Lotus NotesSQL
333333
What is NotesSQL?
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Column Functions
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Numeric Operators
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Mapping Notes Names to SQL Names
LOTUS NOTESSQL\2 Installation and Configuration
ffffff
Hardware and Software Requirements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Multi-Valued Fields (List Fields)
LOTUS NOTESSQL\5 Appendix A: SQL Statements
DELETE Positioned
LOTUS NOTESSQL\0 How to Use This Book
How to Use This Book
LOTUS NOTESSQL\2 Installation and Configuration
333333
Modifying a Lotus Notes Data Source
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\1 About Lotus NotesSQL
About Lotus NotesSQL
LOTUS NOTESSQL\2 Installation and Configuration
Installation and Configuration
LOTUS NOTESSQL\5 Appendix A: SQL Statements
DELETE Searched
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\0 How to Use This Book
LOTUS NOTESSQL\2 Installation and Configuration
Installing NotesSQL
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Column, Index, Table, and View Names
LOTUS NOTESSQL\1 About Lotus NotesSQL
New Features in This Release
LOTUS NOTESSQL\5 Appendix A: SQL Statements
ODBC API Functions
Mapping SQL Tables, Views, and Indexes to and from Notes
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Rich Text Fields
LOTUS NOTESSQL\2 Installation and Configuration
Deleting a Lotus Notes Data Source
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Predicate Operators
LOTUS NOTESSQL\5 Appendix A: SQL Statements
UPDATE Searched
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\1 About Lotus NotesSQL
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Example: Using SQL Tables Derived from Notes Forms and Views
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
FOR UPDATE
333333
View Column Definitions
Tips for Third-Party Applications and Caveats
lease
LOTUS NOTESSQL\5 Appen
LOTUS NOTESSQL\2 Installation and Configuration
Configuring a Lotus Notes Data Source
LOTUS NOTESSQL\5 Appendix A: SQL Statements
The Universal Relation
Driver Capabilities: SQLGetInfo Return Values
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
UPDATE Positioned
LOTUS NOTESSQL\2 Installation and Configuration
333333
Adding a Lotus Notes Data Source
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Summary of Supported ODBC SQL Grammar
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Using SQL Tables Derived from Notes Forms and Views
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Exceptions to ODBC SQL Grammar
Using Notes Views as Indexes
333333
Using the Universal Relation
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
SQL Typographical Conventions
Connecting to a Lotus Notes Data Source
ffffff
LOTUS NOTESSQL\1 About Lotus NotesSQL
333333
What is NotesSQL?
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Column Functions
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Numeric Operators
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Mapping Notes Names to SQL Names
LOTUS NOTESSQL\2 Installation and Configuration
ffffff
Hardware and Software Requirements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Multi-Valued Fields (List Fields)
LOTUS NOTESSQL\5 Appendix A: SQL Statements
DELETE Positioned
LOTUS NOTESSQL\0 How to Use This Book
How to Use This Book
LOTUS NOTESSQL\2 Installation and Configuration
333333
Modifying a Lotus Notes Data Source
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\1 About Lotus NotesSQL
About Lotus NotesSQL
LOTUS NOTESSQL\2 Installation and Configuration
Installation and Configuration
LOTUS NOTESSQL\5 Appendix A: SQL Statements
DELETE Searched
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\2 Installation and Configuration
Installing NotesSQL
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Column, Index, Table, and View Names
LOTUS NOTESSQL\1 About Lotus NotesSQL
New Features in This Release
LOTUS NOTESSQL\5 Appendix A: SQL Statements
ODBC API Functions
Mapping SQL Tables, Views, and Indexes to and from Notes
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Rich Text Fields
LOTUS NOTESSQL\2 Installation and Configuration
Deleting a Lotus Notes Data Source
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Predicate Operators
LOTUS NOTESSQL\5 Appendix A: SQL Statements
UPDATE Searched
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\1 About Lotus NotesSQL
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Example: Using SQL Tables Derived from Notes Forms and Views
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
FOR UPDATE
333333
View Column Definitions
Tips for Third-Party Applications and Caveats
LOTUS NOTESSQL\1 About Lotus NotesSQL
New
LOTUS NOTESSQL\0 How to Use This Book
LOTUS NOTESSQL\2 Installation and Configuration
Configuring a Lotus Notes Data Source
LOTUS NOTESSQL\5 Appendix A: SQL Statements
The Universal Relation
Driver Capabilities: SQLGetInfo Return Values
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
UPDATE Positioned
LOTUS NOTESSQL\2 Installation and Configuration
333333
Adding a Lotus Notes Data Source
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Summary of Supported ODBC SQL Grammar
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Using SQL Tables Derived from Notes Forms and Views
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Exceptions to ODBC SQL Grammar
Using Notes Views as Indexes
333333
Using the Universal Relation
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
SQL Typographical Conventions
Connecting to a Lotus Notes Data Source
ffffff
LOTUS NOTESSQL\1 About Lotus NotesSQL
333333
What is NotesSQL?
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Column Functions
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Numeric Operators
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Mapping Notes Names to SQL Names
LOTUS NOTESSQL\2 Installation and Configuration
ffffff
Hardware and Software Requirements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Multi-Valued Fields (List Fields)
LOTUS NOTESSQL\5 Appendix A: SQL Statements
DELETE Positioned
LOTUS NOTESSQL\0 How to Use This Book
How to Use This Book
LOTUS NOTESSQL\2 Installation and Configuration
333333
Modifying a Lotus Notes Data Source
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\1 About Lotus NotesSQL
About Lotus NotesSQL
LOTUS NOTESSQL\2 Installation and Configuration
Installation and Configuration
LOTUS NOTESSQL\5 Appendix A: SQL Statements
DELETE Searched
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\0 How to Use This Book
LOTUS NOTESSQL\2 Installation and Configuration
Installing NotesSQL
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Column, Index, Table, and View Names
LOTUS NOTESSQL\1 About Lotus NotesSQL
New Features in This Release
LOTUS NOTESSQL\5 Appendix A: SQL Statements
ODBC API Functions
Mapping SQL Tables, Views, and Indexes to and from Notes
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Rich Text Fields
LOTUS NOTESSQL\2 Installation and Configuration
Deleting a Lotus Notes Data Source
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Predicate Operators
LOTUS NOTESSQL\5 Appendix A: SQL Statements
UPDATE Searched
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\1 About Lotus NotesSQL
LOTUS NOTESSQL\5 Appendix A: SQL Statements
Example: Using SQL Tables Derived from Notes Forms and Views
LOTUS NOTESSQL\5 Appendix A: SQL Statements
LOTUS NOTESSQL\5 Appendix A: SQL Statements
FOR UPDATE
333333
View Column Definitions
Tips for Third-Party Applications and Caveats
Frequently Asked Questions (FAQ)
Frequently Asked Questions (FAQ)
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
(.txt)