RE: CRTCSVF or how quickly one forgets

Whoops, mea culpa.  I replied to the wrong message. :)

Brian.

-----Original Message-----
From: Brian Piotrowski 
Sent: Wednesday, August 30, 2006 12:33 PM
To: Midrange Systems Technical Discussion
Subject: RE: CRTCSVF or how quickly one forgets

Thanks, Brian.

Say, you wouldn't happen to have a copy of your CL proggie that u can
share for doing an Option 21 / IPL routine, would you?  I have a script
that our original programs wrote - it runs ok, but it doesn't do an
Option 21 - instead, it's a series of SAVLIB commands.

I just haven't gotten around to rewriting it for Option 21.

Thanks!

Brian.

-----Original Message-----
From: Brian Dolinar [mailto:Brian.Dolinar@xxxxxxxxxxx] 
Sent: Wednesday, August 30, 2006 12:20 PM
To: midrange-l@xxxxxxxxxxxx
Subject: CRTCSVF or how quickly one forgets

==The Techy part ==
I was working a system and needed to download a bunch of db files into 
excel.  I could have done this a million different ways, but being lazy
(as 
most good admins/programmers are inherently), I wanted to automate
things.

Aha, I remembered, how about, CRTCSVF, the Create CSV format stream file

command developed by uzaemon? ( see 
http://homepage1.nifty.com/uzaemon/crtcsvf_usage.html )  I found it
online 
( here http://www.rpgiv.org/csv.htm ) and got it installed.

Grr, no dice, CCSID errors - iconv_open failed. EBCDIC CCSID - 65535 /
ASCII 
CCSID - 00437 - 3021 : The  value specified for the argument is not
correct.

Surely someone, somewhere, has had this issue before.  Google is your
friend 
(  http://www.google.com/search?hl=en&q=CRTCSVF+CCSID )

The answer was in the 5th search ( 
http://www.systeminetwork.com/isnetforums/showthread.php?t=25393 )
Change 
the DBFCCSID to 37 for the input file, STMFCCSID to 1252 for the output 
file.

==The Punchline==
And you know, the original poster of that solution was right.  It is a
great 
tool and it was helpful to share with the 400 community.  Next time I
see 
him, I will be sure to return the favor. :)

=====
Brian Dolinar | ACS Healthcare Solutions