On 2020-04-16 17:56, Sri h Kolusu wrote:
It would be nice if this could execute before SYMNAMES is read, so
the SELECT handler could create symbols for all of the columns in
the result set.
If your intention is to create DFSORT symbols from DB2 table definition
then there are a couple of ways to get it done. Let me know if you are
interested in that and we can discuss that offline.
Why offline? What's so secret about it?
1) Use the standard Db2 tools to generate a PL/I %INCLUDE member for your table
2) Download RAP00110 and ESYMSORT from the URL in the signature below
3) Put them into an EXEC library concatenated to SYSEXEC (or use ALTLIB)
4) VIEW the generated PL/I %INCLUDE member, give the command "ESYMSORT ?" and
follow the instructions displayed.
5) Optional, but very much appreciated: Give me some feedback.
Robert
--
Robert AH Prins
robert.ah.prins(a)gmail.com
The hitchhiking grandfather - https://prino.neocities.org/indez.html
Some REXX code for use on z/OS - https://prino.neocities.org/zOS/zOS-Tools.html
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO IBM-MAIN
