Just this week, I had to correct a routine for a customer of mine that
outputs
a line of character data in CSV format. The routine had some errors and
flaws. I would like to tell you what I did and discuss some of the
properties of the CSV format.
First: the routine gets as input a number (numbe
P.S. I looked up "Turing-complete." Now I have a headache.
On 2/26/2015 11:51 AM, Paul Gilmartin wrote:
On Thu, 26 Feb 2015 08:20:49 -0800, Sri h Kolusu wrote:
Tony suggested the use of Tab (X'05') as delimiter which will avoid the
problem of data already have the common delimiter comma.
Paul, my original inspiration for suggesting the "Swiss Army Knife" came
from a project some years ago where I was tasked with cleaning up a DB2
table where support from the database team was not possible for
political reasons. Being hardly the expert (I never learned DB1!) I
posted the questi
On Thu, 26 Feb 2015 08:20:49 -0800, Sri h Kolusu wrote:
>
>Tony suggested the use of Tab (X'05') as delimiter which will avoid the
>problem of data already have the common delimiter comma.
>
I stand by my assertion that lacking a priori knowledge that a character
can not occur in the data the task
000433f07816-dmarc-requ...@listserv.ua.edu>
> To: IBM-MAIN@LISTSERV.UA.EDU
> Date: 02/25/2015 07:11 PM
> Subject: Re: Unload DB2 table in CSV format
> Sent by: IBM Mainframe Discussion List
>
> On Wed, 25 Feb 2015 17:42:16 -0600, Tony's Outlook via Mozilla wrote:
&
With my tool, you can choose the delimiter by parameter
(some like semicolon instead of comma, because in some
European countries the comma is used instead of decimal point
to separate the decimal fraction - tab is possible too, of course),
and char fields are enclosed into quotes (or apostrophes)
On Wed, 25 Feb 2015 17:42:16 -0600, Tony's Outlook via Mozilla wrote:
>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.
I posted it on the DB2 list some days ago, and if you don't mind,
I post it here, too, because it's the same topic.
I am selling a product running with DB2 and Oracle DBs,
that generates CSV files from SQL results. It runs on almost
every platform (mainframe, Unix, Windows). CSV is one of many
o
rame 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 v
5 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 cond
> 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
>>
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
> s
I believe the DB2 Unload utility will also allow you to create an extract in a
delimited form. Seems like there were some idiosyncrasies with it, but I don't
recall the details at the moment. But you might start here:
http://www-01.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/com.ibm.db2z10.doc
M-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
>
> "FMNBA32
This is not a question, I presume?
Kees.
-Original Message-
From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf
Of Ron Thomas
Sent: 23 February, 2015 15:44
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: Unload DB2 table in CSV format
Ok Thanks . I am getting the
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 / a
Ron Thomas wrote:
>//FMNOUT DD DSN=USMKT.SL2P.KUSMDW01.CUSSTO.F2B23.UNL1,
>// UNIT=CART,VOL=(,RETAIN,,30),LABEL=01,
>// DISP=(NEW,CATLG,CATLG)
>FMNBA318 Output data set FMNOUT /USMKT.SL2P.KUSMDW01.CUSSTO.F2B23.UNL1 OPEN
>failed ABEND code 013-34 . FMNDB801 Export funct
You might also want to post this on the DB2 List.
If you have not joined, you can do so at IDUG.ORG
Lizette
> -Original Message-
> From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU]
> On Behalf Of Ron Thomas
> Sent: Monday, February 23, 2015 6:55 AM
> To: IBM-MAIN@LIS
From the list of well-know errorcodes:
013-34: invalid blocksize.
You should specify DCB info on the //FMNOUT dataset.
Kees.
-Original Message-
From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf
Of Ron Thomas
Sent: 23 February, 2015 14:55
To: IBM-MAIN@LISTSE
19 matches
Mail list logo
