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 ]
Well, now I can't figure out how to call the SP I just created.  I want to
call it from SQL Server's Query Analyzer, like this:
CALL ABQSYS/SP_DATA_AREA_READ ('TRANSDEV', 'TRLCNTL')
maybe, but that doesn't work.  Exec doesn't work either.

-----Original Message-----
From: Joe Pluta [mailto:joepluta@PlutaBrothers.com]
Sent: Friday, September 14, 2001 10:41 AM
To: midrange-l@midrange.com
Subject: RE: Checking an AS/400 DTAARA from SQL Server


Stored procedures are the best answer.  I was thrown by your statement:

"only physical and logical files can be queried"

I thought that perhaps this was some sort of design constraint ("Thou Shalt
Not Use Stored Procedures").  I should have asked in more detail.  Sorry.

Joe


> -----Original Message-----
> From: Brad McDaniel
>
> 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,

_______________________________________________
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.