|
midrange.com
can u send me an example of the code? thx, sandy
tazadog@hotmail.com
>From: DaveBednarcik@WesternUnion.com
>Reply-To: DOMINO400@midrange.com
>To: DOMINO400@midrange.com
>Subject: Re: DB2 LSX
>Date: Fri, 6 Jul 2001 11:44:54 -0400
>
>
>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
>+---
_________________________________________________________________________
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
+---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 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.
