Re: Accessing the UniversalServer from Perl

On Mon, 6 Oct 1997, Gerd Kamp wrote: > we're using the web data blade and its embedded SQL to serve our regular > webpages. That works (fairly) well. But in order to add some existing games > to our site, we need to access the universal server from within regular perl > scripts (we would like to store the users of the game in the database). > > Our consultants said that the only possibility to access the universal > server from perl scripts is to call dbaccess with the appropriate > parameters. Is that right or is there any other (better) possibility to > access the db from perl? DBI and DBD::Informix can access IUS, but they're only guaranteed to work with the pre-IUS data types (because I simply haven't yet made time to sort out the new features). Since you're using the Web datablade, DBD::Informix as supplied out of the box probably won't work for you. On the other hand, it should not be very difficult to extend it to handle the LVARCHAR data type, and then use LVARCHAR to retrieve any IUS-only data type or user-defined data type. I'd love someone to volunteer for this work, but otherwise, you're going to have to wait until I find the time. Yours, Jonathan Leffler (johnl@informix.com) #include <witticism.h>