Manage Learn to apply best practices and optimize your operations.

Sql Lookup Using @Dbcommand(Odbc)

I recently had a problem when using @DBCommand(ODBC) to connect to an SQL Data-wharehouse. The problem was that I was trying to perform an @DBCommand(ODBC) lookup on a single table using multiple key lookups on multiple columns of the table. Normally with an @DBCommand you can add standard SQL Statements but I found that with this you have to have static lookup keys. My keys could change as the user changes the form. This is the Code I wrote to get around this problem. The first 2 lines are responsible for creating the correct SELECT statement based on the user choices and the 3rd line actually runs the SELECT statement.

Dig Deeper on Domino Resources

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.




  • iSeries tutorials's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...