Data Integration
We are in the beginning stages of integrating data between a PC based inventory system and the iSeries. Specifically we will be downloading and uploading data between the two systems automatically. We have had success using ODBC. We also need to be able to call an RPG program from the PC based system. I'm sure there are many solutions. 1) Is ODBC still a standard way of integrating/connecting? If not, what is the best way? 2) Can we call the iSeries RPG program from inside MS SQL server? and, 3) Do we have to use Java? Thanks for any input!
Software/Hardware used:
Software/Hardware used:
ASKED:
November 30, 2005 2:39 PM
UPDATED:
November 30, 2005 3:03 PM
RELATED QUESTIONS
- Product Review - UniPaaS, RAD Tool, Unique development paradigm
- get an i-Series *LIBL in a .NET program
- Journaling-does it reflect a record change when iSeries file has been updated outside of this environment?
- how to limit data access on AS400 through ODBC, client access or Sequel viewpoint product
- DDM file access headaches
Answer Wiki:
You can turn the RPG program into a stored procedure:
Here's a typical SQL statement to do the link:
CREATE PROCEDURE &CURRENTLIB/pr_utlfiledownloadACH(
IN v_fileDir VARCHAR(200),
IN v_fileName VARCHAR(50))
LANGUAGE C
NOT DETERMINISTIC
MODIFIES SQL DATA
EXTERNAL NAME &CURRENTLIB/S_PUFDLACH
PARAMETER STYLE GENERAL WITH NULLS;
You will probably need less code than shown above.
When you call the procedure, use the SQL CALL statement. In the above example, I'd use:
CALL pr_utlfiledownloadACH('first arg','second arg');
--
Sheldon Linker
Linker Systems, Inc.
800-315-1174
www.linkersystems.com
sol@linker.com
+1-949-552-1904
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
