× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. August 2007

Re: can SQL Server files be stored in IFS

<snip>
I've been asked if MS SQL Server files can live in the IFS
(so the my RPGLE programs that currently write Excel format
data could write to the SQL server files in the IFS).
The SQL Server would access those files for it's programming.
And we are looking at RJS RPG2SQL product as well.
</snip>

Technically yes but it would be very slow compared to having the file on
a Windows Server.

Also, you would gain nothing. SQL Server databases are a single file
which only SQL Server can read. The only way to get to them is by
talking to SQL Server running on a Windows machine so you gaining
nothing by putting them on the IFS. You still have to go out to an
instance of sql server running on a Windows machine and then it would
have to do it's reads and writes through the IFS which would be slow.
You cannot write to SQL Server directly.

I think their has been discussion before on forum about accessing SQL
Server from RPG code.


As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow-Ups:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 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.