I'd certainly prefer zOS/batch/DFSORT. Unload the table to FB disk, use
DF/SORT to insert x'05'(tab) or comma(CSV) where desired. I do this
quite often to create a flat file that will eventually go back to MS
excel/access. Millions of records? No big deal.
On 2/25/2015 4:47 PM, Rob Schramm wrote:
And it can be run in batch. Either off platform on z/OS.
Rob Schramm
Senior Systems Consultant
On Wed, Feb 25, 2015 at 5:46 PM, Rob Schramm <rob.schr...@gmail.com> wrote:
If it is something smaller (not millions of rows), connect via JDBC and
use SQL Workbench/j. It has plenty of options to pull the data into a CSV.
Rob Schramm
Senior Systems Consultant
On Tue, Feb 24, 2015 at 10:50 AM, Lizette Koehler <stars...@mindspring.com
wrote:
Try adding more volumes. The DB2 List thinks you need to double what you
are using with the JCL you posted.
Lizette
-----Original Message-----
From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU]
On Behalf Of Ron Thomas
Sent: Monday, February 23, 2015 7:44 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: Unload DB2 table in CSV format
Ok Thanks . I am getting the below message when i provided the DCB
Parameters
"FMNBA324 A data set, or volume full condition occurred while
attempting to
save this data set"
Thanks
Ron T
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
