Steven,
I am curious as to why you just don't use a remote view to update your file up on the 400 (make the fields in the remote view updatable). If you are using SQL pass-through to get the record in the first place then the file must be natively described already, right? Why don't you just use ODBC (remote view or pass-through) to send an update command back to the server?
The only way I could think to accomplish what you are trying to do is to have the RPG program poll for the existence of the particular file name that you are transfering up, and then when it has read it in, have the program delete it. I am not sure if this approach is acceptable in your situation or not.
I am assuming that you are developing this app in either a WIN9x or WINNT environment right? Back in the DOS days, I used to have a system that actually POKED (an old BASIC technique) bytes to the emulation card (which was already logged into a session) and started an RPG program on a system36 that way. Very unorthadox, but hey, it worked! Unfortunately, this idea won't work in a networked environment.
The only other idea I could give you is to use a third-party tool. Are you familiar with Rumba software? Rumba is a CA competitor, and they have a windows utility (which I believe is also command line executable) to send CL commands to the AS/400. Unfortunately, I think you would have to use the Rumba suite entirely and give up Client Access. (I personally despise Client Access)
Well, hope that helped a little bit.
Good luck!
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only