crazystorm wrote:I wanna write a REXX script to invoke DB2 to run some query statements and return the results. Is it possible for REXX to do so? or this can only be implemented by calling COBOL/PLI programs? Can someone help on this and provide a REXX program sample? Thanks a lot!
Despite the limitation of search argument length that Mr. Scherrer points out, I suggest that you begin by searching for (or Googling on) DSNREXX
, IBM's Rexx/SQL interface. You may also inquire of your co-workers (if you can tolerate the risk of seeing the backs of their throats as their jaws drop in incomprehension) as to whether your shop indeed uses DSNREXX (mine doesn't; we have Open Software's RXTASQL interface, which we routinely use).
As I seldom if ever use the more widely-available DSNREXX -- and as you haven't offered me my usual billing rate -- I won't be writing code for you, although I'll answer questions to the best of my ability.
"You have sat too long for any good you have been doing lately ... Depart, I say; and let us have done with you. In the name of God, go!" -- what I say to a junior programmer at least once a day