|
View previous topic :: View next topic
|
| Author |
Message |
ozgurseyrek
New User
Joined: 22 Feb 2008
Posts: 70
Location: Turkey
|
|
|
|
Hi,
I want to run SQL in JCL and I want to Include column names in output file. Using SYSIBM.SYSCOLUMNS is a solution for that issue.
But my sql like that;
select Names, SUM(counters) as Totals
from TABLE1;
desired output;
Names Totals
John 12
Michael 24
Ozgur 30
....
Is it possible? |
|
| Back to top |
|
 |
PeterHolland
Global Moderator
Joined: 27 Oct 2009
Posts: 2481
Location: Netherlands, Amstelveen
|
|
|
|
| Whydont you try it? |
|
| Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008
Posts: 1020
Location: India
|
|
|
|
ozgurseyrek,
That is possible.
You can use DSNTEP4/DSNTEP2.
But, it wont be exactly like your desired output, it have table lines/borders and stuff like that.
Thanks,
Sushanth |
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
DSNTEPx sources are available in DSN___.SDSNSAMP
and can be modified according to the organization needs ( btdtgtts  ) |
|
| Back to top |
|
|
don.leahy
Active Member
Joined: 06 Jul 2010
Posts: 765
Location: Whitby, ON, Canada
|
|
|
|
| enrico-sorichetti wrote: |
DSNTEPx sources are available in DSN___.SDSNSAMP
and can be modified according to the organization needs ( btdtgtts ) |
If your shop has a PL/I compiler. My attempt to modify DSNTEPx came to a screeching halt when I discovered that they'd dropped the PL/I compiler to save money. "No one was using it"  |
|
| Back to top |
|
|
|
|
