I did get the Insert Method to work.


Dave Bednarcik
Email: DaveBednarcik@WesternUnion.com
Work #: (201)263-5186
Fax # : (201)263-5455


                                                                                
                
                    "S Wenig"                                                   
                
                    <tazadog@hotmail.c        To:     DOMINO400@midrange.com    
                
                    om>                       cc:                               
                
                    Sent by:                  Fax to:                           
                
                    owner-domino400@mi        Subject:     Re: DB2 LSX          
                
                    drange.com                                                  
                
                                                                                
                
                                                                                
                
                    06/22/01 02:10 PM                                           
                
                    Please respond to                                           
                
                    DOMINO400                                                   
                
                                                                                
                
                                                                                
                




i've successfully used LSX to retrieve data from an as400 (from Domino on
an
NT), and to call an as400 program passing parms, but i've never been able
to
get the "insert" to work...

sandy


>From: DaveBednarcik@WesternUnion.com
>Reply-To: DOMINO400@midrange.com
>To: DOMINO400@midrange.com
>Subject: Re: DB2 LSX
>Date: Fri, 22 Jun 2001 11:06:04 -0400
>
>
>It would be Uselsx "*LSXDB2". (DB2 Connection).
>
>Also a few questions:
>
>1.   Why do you not autocommit?
>2.   Is the QIWS/QCUSTCDT a library and file from your AS/400 system?  If
>so, why are you quering a AS/400 file?
>3.   Why do I need a qry & SQL Parameters?  I have a field(s) whose values
>I have stored in my scripted agent and want to update a file on the AS/400
>file.
>
>Thanks,
>
>Dave Bednarcik
>Email: DaveBednarcik@WesternUnion.com
>Work #: (201)263-5186
>Fax # : (201)263-5455
>
>
>
>                     "Walter Scanlan"
>                     <wscanlan@us.ibm.c        To:
>DOMINO400@midrange.com
>                     om>                       cc:
>                     Sent by:                  Fax to:
>                     owner-domino400@mi        Subject:     Re: DB2 LSX
>                     drange.com
>
>
>                     06/22/01 09:49 AM
>                     Please respond to
>                     DOMINO400
>
>
>
>
>
>
>
>Dave,
>      You didn't say if you wanted LSXLC or LSXODBC.
>
>This is the sample I recommend to verify the connection if available.
>
>Event Options:
>   Option Public
>   Uselsx "*lsxodbc"
>Sub Initialize
>      Dim con As New ODBCConnection
>      Dim qry As New ODBCQuery
>      Dim res As New ODBCResultSet
>
>      con.autocommit=False
>      If (con.connectto("remotesystem","user","password")) Then
>           qry.sql ="select * from QIWS/QCUSTCDT"
>           Set res.Query = qry
>           Res.Execute
>           Call Res.FirstRow
>           Res.Close(Db_Close)
>           Call con.disconnect
>      End If
>End Sub
>
>Walter Scanlan
>Advisory Software Engineer
>Domino for AS/400 Team Leader
>Internet wscanlan@us.ibm.com
>
>
>
>                     DaveBednarcik@Wester
>
>                     nUnion.com                 To:
>DOMINO400@midrange.com
>                     Sent by:                   cc:
>
>                     owner-domino400@midr       Subject:     DB2 LSX
>
>                     ange.com
>
>
>
>                     06/21/2001 04:54 PM
>
>                     Please respond to
>
>                     DOMINO400
>
>
>
>
>
>
>I am trying to write to a DB2 file on the AS/400 using Lotus Script (DB2
>LSX classes) but I am having no results.  Does anyone have any examples
>that I could look at?
>
>Thanks,
>
>Dave Bednarcik
>Email: DaveBednarcik@WesternUnion.com
>Work #: (201)263-5186
>Fax # : (201)263-5455
>
>+---
>| This is the Domino/400 Mailing List!
>| To submit a new message, send your mail to DOMINO400@midrange.com.
>| To subscribe to this list send email to DOMINO400-SUB@midrange.com.
>| To unsubscribe from this list send email to
DOMINO400-UNSUB@midrange.com.
>| Questions should be directed to the list owner/operator:
meechamw@ptd.net
>+---
>
>
>
>
>+---
>| This is the Domino/400 Mailing List!
>| To submit a new message, send your mail to DOMINO400@midrange.com.
>| To subscribe to this list send email to DOMINO400-SUB@midrange.com.
>| To unsubscribe from this list send email to
DOMINO400-UNSUB@midrange.com.
>| Questions should be directed to the list owner/operator:
meechamw@ptd.net
>+---
>
>
>
>
>+---
>| This is the Domino/400 Mailing List!
>| To submit a new message, send your mail to DOMINO400@midrange.com.
>| To subscribe to this list send email to DOMINO400-SUB@midrange.com.
>| To unsubscribe from this list send email to
DOMINO400-UNSUB@midrange.com.
>| Questions should be directed to the list owner/operator:
meechamw@ptd.net
>+---

_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

+---
| This is the Domino/400 Mailing List!
| To submit a new message, send your mail to DOMINO400@midrange.com.
| To subscribe to this list send email to DOMINO400-SUB@midrange.com.
| To unsubscribe from this list send email to DOMINO400-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: meechamw@ptd.net
+---




+---
| This is the Domino/400 Mailing List!
| To submit a new message, send your mail to DOMINO400@midrange.com.
| To subscribe to this list send email to DOMINO400-SUB@midrange.com.
| To unsubscribe from this list send email to DOMINO400-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: meechamw@ptd.net
+---

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2021 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.