Steven,
Sorry I don't know this for UniData, but I posting just in case it may use similar techniques to those under UniVerse. On UniVerse you can use the CALL statement (that's CALL as in SQL CALL not a BASIC CALL) CALL subroutine(Args) MyCmd.Text = 'CALL MySub(1)' (NOTE : This is considered by ADO to be an SQL command, not a stored procedure). This returns either: A) any printed output as a single column named 'PRINTED OUTPUT', or B) you can execute native uvSQL commands using SQLExecDirect and capture the result into a system variable named @HSTMT. This then passes the results back as an ADO RowSet. Regards, Brian -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 26 April 2004 23:36 To: [EMAIL PROTECTED] Subject: Calling UniData subroutines via OLEDB Hello We're struggling through the IBM documentation to figure out how to call a subroutine on UniData via OLEDB. (The OLDB.pdf) I'm hoping some one can point us in the direction of some additional documentation or code examples. I've begun searching in the archives, but only limited success so far. thanks in advance for any info. Steven Covey Senior Business Analyst JIA, Inc. (Jenkon) [EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users ________________________________________________________________________ This email was checked by MessageLabs SkyScan before entering Microgen. ________________________________________________________________________ This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
