RE: Checking an AS/400 DTAARA from SQL Server

[Brad McDaniel <BMCDANIEL@xxxxxxxxx>]

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--
[ Picked text/plain from multipart/alternative ]
Aha...I get it.  I think I missed the stored procedure line.  We have tons
of stored procs already that access AS/400 files and objects from the
windows platform.  Thanks,
Brad

-----Original Message-----
From: Scott Mildenberger [mailto:Smildenber@Washcorp.com]
Sent: Friday, September 14, 2001 8:19 AM
To: 'midrange-l@midrange.com'
Subject: RE: Checking an AS/400 DTAARA from SQL Server


Brad,

I think Tom's suggestion below about using a stored procedure would work
better.  Then it is only retrieving the value when requesting and you don't
need the CL program running continuously.

Scott Mildenberger

> -----Original Message-----
> From: Brad McDaniel [mailto:BMCDANIEL@ABSBC.ORG]
> Sent: Friday, September 14, 2001 6:45 AM
> To: 'midrange-l@midrange.com'
> Subject: RE: Checking an AS/400 DTAARA from SQL Server
>
>
> This message is in MIME format. Since your mail reader does
> not understand
> this format, some or all of this message may not be legible.
> --
> [ Picked text/plain from multipart/alternative ]
> I think you may have answered my question with my same question.  My
> question was how do I check the value of a non-database
> object (in this
> case, a non-database object (dtaara) on a linked AS/400) in
> SQL Server.  In
> the meantime, I just created the following CL to run in a
> continuous loop,
> which creates a file that changes every thirty seconds which
> can be queried
> from SQL Server.
> If anyone knows of a better way, let me know.
> Thanks,
> Brad
> that? On the AS/400, your best bet is maybe a stored procedure.
>
> Tom Liotta
>
> --
> Tom Liotta
_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.