Use the RPG2SQL RPG samples LNTEST01 and LNTEST02 to get started adding to your Lotus Notes database.
For example: To call LNTEST01, use:
LNTEST01 DOMSERVER('RJS270') DOMDATABSE(AS400RP5.NSF) DOMUSER('Richard Schoen/RJS Software Systems Inc.') DOMPASS(TEST)
Note: The Notes User ID and Domain passed to the NotesSQL sample program must match the entry in the Authentication List Manager. If you pass an incorrect user ID and password to the LNTEXT command, RPG2SQL PC Component may give the following errors:
Connection request id 316 from 125.1.1.53
Received Open Connection: Driver={Lotus NotesSQL Driver (*.nsf)}; Server=RJS270; Database=AS400RP5.NSF; Uid=Richard Schoen/RJS Software Systems Inc.; Pwd=TEST; from 125.1.1.53(316)
Sending: 100 SQL
999 ERR-2147217843 [Lotus][ODBC Lotus Notes]Driver not capable
199 EOF
to 125.1.1.53
Received SQL Execute: insert into Archived_Document
(DocTitle,CreationDate,AdditionalText,SpoolFile,UserData,JobName,
SpoolNumber,UserID,FormType,SystemName,OutputQueue,OutputQueueLibrary,
UserField1,UserField2) VALUES('Test RPG2SQL Document','2004-12-01','This is
a test string','QSYSPRT','USRDTA1','JOBNAME1','1','USERID1','FORMTYPE1',
'S1011111','QPRINT','QGPL','User Field 1','User Field 2') from 125.1.1.53(316)
Sending: 100 SQL
999 ERR3704 Operation is not allowed when the object is closed.