Currently No Direct Access to the AS400 only SQL Access allowed. For
security.
I would prefer the way you suggested I would not be asking if I could do
that. The Upper management want it that way.
Hope I can convince them otherwise.
Nathan Stanford
Senior Programmer/Analyst
[EMAIL PROTECTED]
> -----Original Message-----
> From: Dave Cahall [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, July 09, 2001 11:28 AM
> To: '[EMAIL PROTECTED]'
> Subject: RE: OpenQuery Inserting?
>
> Why wouldn't you do the insert directly into the TEST.XYZ.POLICY?
>
> Dave Cahall
> Vice President, Professional Services
> Digitaris Technologies, Inc.
> Office: 972.690.4131 ext 116
> Mobil: 214.914.9947
>
>
> -----Original Message-----
> From: Nathan Stanford [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 09, 2001 11:28 AM
> To: '[EMAIL PROTECTED]'
> Subject: OpenQuery Inserting?
>
>
> execute("SELECT * FROM OPENQUERY(TESTSERVER,"" SELECT * FROM
> TEST.XYZ.POLICY
> "") ")
>
> How can I do an insert? The above select works.
>
> Tried the below:
>
> execute("SELECT * FROM OPENQUERY(TESTSERVER,"" Insert into TEST.XYZ.POLICY
> (testcolumn) values (1) "")
> ")
>
>
> Thanks,
> Nathan Stanford
> Senior Programmer/Analyst
> [EMAIL PROTECTED]
>
>
>
> -------------------------------------------------------------------------
> This email server is running an evaluation copy of the MailShield anti-
> spam software. Please contact your email administrator if you have any
> questions about this message. MailShield product info: www.mailshield.com
>
> -----------------------------------------------
> To post, send email to [EMAIL PROTECTED]
> To subscribe / unsubscribe: http://www.dfwcfug.org
>
> -------------------------------------------------------------------------
> This email server is running an evaluation copy of the MailShield anti-
> spam software. Please contact your email administrator if you have any
> questions about this message. MailShield product info: www.mailshield.com
>
> -----------------------------------------------
> To post, send email to [EMAIL PROTECTED]
> To subscribe / unsubscribe: http://www.dfwcfug.org
-------------------------------------------------------------------------
This email server is running an evaluation copy of the MailShield anti-
spam software. Please contact your email administrator if you have any
questions about this message. MailShield product info: www.mailshield.com
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org
