We are writing a handheld application which will reside on a non-iSeries server. We want to access DB2 data from the handheld for data verification and then submit transactions to the DB2 database. What are the options for doing this in the iSeries world? I am an old RPG coder and I am finding it difficult to sort through the choices.
The handheld application will be written outside the iSeries box.
Hmmm... let's see --- "writing a handheld application" but "which will reside on a non-iSeries server".
Is it a handheld app or a server app? Or does it mean that the handheld will have its app loaded from a server? Just making sure...
What OS will be on the handheld? (Last time I did any handheld programming was almost 20 years ago. It was all done in Forth at that time.) Ideally, the appropriate iSeries Access ODBC driver can be loaded; but you might expect that the JDBC driver will be used and you'll code java to do the remote database operations. JDBC seems more reasonable. I have no idea how handhelds have advanced; nowadays, I suspect they're far beyond even the servers I was connecting to back then.
Technically, you _could_ obtain the LIPI documents from IBM and code sockets calls to the database host server yourself. I've written to some of the LIPIs and it takes practice to say the least.
Hmmm... depending on the handheld OS, I wonder if a VA-RPG app might not be a useful direction to look? There is even the possibility of generating java from a VA-RPG project. As a RPG programmer, that might be your ideal starting direction.
