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