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