Scott, The AS/400 DB probably has the same ODBC issues as UV regarding mapping of non-relational/non-table data. Hence, I've found the use of stored procedures can be a useful bridge for such issues which UV is the target to be updated.
I don't know if AS/400 supports such a thing as call stored procedures from remote ODBC clients. I've successfully used that technique at the UV end to call a UV/BASIC subroutine to do the "dirty" work of retrieving and updating/locking data - from non-UV environments via UniObjects or UCI. Just note that if you are going to use BCI on a UNIX host, you need to purchase a third-party ODBC Driver Manager and link it to UniVerse prior to use. There a postings in the U2 mailing archives about doing it (as well as the UV documentation). Regards, David -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Thursday, 2 July 2009 11:04 AM To: U2 Users List Subject: Re: [U2] Updating AS400 Data from Universe Thanks much Craig, I'll give that a look. ----- Original Message ----- From: "Craig Bennett" <[email protected]> To: "U2 Users List" <[email protected]> Sent: Wednesday, July 1, 2009 6:42:46 PM GMT -06:00 US/Canada Central Subject: Re: [U2] Updating AS400 Data from Universe Hi Scott, have you considered an ODBC link and using BCI (the UV calling interface to ODBC)? A quick google suggests that ODBC interfaces are available for AS400. regards, Craig ************** IMPORTANT MESSAGE ***************************** This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ************************************************************** _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
