@Dblookup (ODBC)

HCL Domino Domino Forum
1

i would like to use @dblookup(ODBC) to access values from AS/400. I already created a data source and I also have a username and password that connects to the AS/400.

What is the formula of @dblookup (ODBC) if i want to access a table that is inside a directory/library? below is the details:

datasoure=MA

username=user

password=pword

table=employee/department where employee is the direcorty/library and the department is the table;

column=empno

key column=lname

key= the value of a the field lastname (inpute field.

thanks in advance

2

Subject: @Dblookup (ODBC)

Try using “employee.department” as table name. I did not tested this in @dblookup myself.

3

Subject: @Dblookup (ODBC)

The designer help has a proper explanation and an example to use OBBC in @DBLookup.

4

Subject: RE: @Dblookup (ODBC)

i already tried the designer help but the problem is the table i am accessing is under a directory, and not on the root directory…

how can i access the sid table using @dblookup (ODBC)?