started through the doc. still cant find a good answer. Appreciate if someone post the answer for the requirement
The method is:
CALL RXSUBCOM("ADD", environment, handler)
and you will then send DB2 commands by coding:
ADDRESS environment "query"
is pretty much an arbitrary string, although you should
use a meaningful name, like "DB2" or "SQL".handler
can be one of a number of interfaces. IBM supplies DSNREXX; the queries are static SQL, very much like those coded in a compiled-language program. Open Software Technologies supplies RXTASQL (part of their REXXTOOLS package) the queries are dynamic SQL, like those executed through DSNTEPx, SPUFI, or QMF. There may be others. Ask your senpai
, DBA, or other site support personnel which if any of these are installed in your shop.
"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