I need to call an iseries remote procedure to generate the file that I need to import in DTS.
Here is the deal:
The AS400 team has created a remote procedure that can be called by a url.
If I type the url in a browser it runs a rpg program that exports data to my server. Then all I have to do is import the file.
The problem I am having is in how to call the remote procedure from DTS.
I need to either call the url from DTS or call the remote procedure directly from DTS.
Any help is appreciated.
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs).
Being someone who is always looking for alternatives to "work your data", I came across this …
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.