I’ve spent the last few hours trying to connect to DB2 on an AS/400 V5R1 with limited success. I can get a list of tables (or files at least), but they’re not the ones I’ve been working with using other middleware (CF etc). I’m not sure how to specify the correct schema in the connection string. I’ve tried this (and many other variations):
jdbc:as400://:;locationName=<database_name>;collectionID=<schema_name>;
but it gives the same list of tables whatever I try. Has anyone succeeded in using Servoy with DB2? How do you go about specifying the desired Schema?