Dear friends,
Hi !!
I wanted to send the data extract file to some folder. I am having PRO iv 5.5 and oracle. I have to execute the SQL query from Pro IV and export the result set in to text file. I know how to execute the Sql query or stored procedure from Pro 4 to Oracle. I wanted the best practice in pro 4 to execute stored procedure and export the data to file.
Please help me.
Click the link below to see the new game I'm developing!
3 replies to this topic
#4
Joseph Bove
-
- Members
-
- 756 posts
ProIV Guru
- Gender:Male
- Location:Ramsey, United States
Posted 22 December 2004 - 02:27 PM
Ajay,
What we've done is to use shell command (#STAT = SYSTEM('dosql sqlscript')) to execute stored procedures. Although this solution works, I am somewhat concerned about the lack of elegance involved with it.
Ultimately, I would like to be able to execute any sql command from within ProIV.
hth,
Joseph
What we've done is to use shell command (#STAT = SYSTEM('dosql sqlscript')) to execute stored procedures. Although this solution works, I am somewhat concerned about the lack of elegance involved with it.
Ultimately, I would like to be able to execute any sql command from within ProIV.
hth,
Joseph
Reply to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users
Click the link below to see the new game I'm developing!
