I don’t know that this will count as an “answer” as much as a knudge in the right direction. A few months back I worked at a company that had an IBM AS/400 … err… iSeries (sorry) and I was able to automate quite a bit in Client Access.
There is a record macro function that records keystrokes and creates a “Macro” that is essentially a wrapper around a VBScript file. With a little VBScript Knowledge you can automate just about anything. (We had a export of data from SQL we automated data entry for once because the “programmers” were to busy to do it.)
A google search of <i><b>ibm client access macro vbscript</b></i> yeilds an interesting site as the first one… <a href=”http://www.mcpressonline.com/scripting/beef-up-client-access-macros-with-vbscript.html”>here</a>
Basically, the file startes out like this:
<i>[PCOMM SCRIPT HEADER]
DESCRIPTION=Midrange Computing Client Access VBScript demo
[PCOMM SCRIPT SOURCE]</i>
After the last line you add your vbscript. Specifically, take a look at the “Using Objects” section of this article it tells you about the objects available that will probably give you what you want to do.
I hope this helps! If not, post more and I’ll see what I can find to help further.