I've hit a wall and I'm hoping someone can help me with a simple
About 10 months ago our data warehouse group asked us to remove
packed fields from a file they receive from an outside vendor. At
the time I did something simple that replaced the packed fields with
blanks. I'm pretty sure I didn't write a program. Unfortunately I
don't have any notes on what I did and now they are asking to make it
a permanent process. I think it involved creating a file as ASCII
and copying data but I can't find a combination that works. I have
googled ASCII conversions on the iSeries as well as tried various
CRTPF, CPYFRMSTMF, CPYFTMIMPF, and SQL variations over the past day
and a half.
Does anyone have a way to do this short of writing a program or an
SQL update statement? There is an anomaly in the records that
precludes just updating fixed positions in the record. I may have to
do that anyway but I would prefer not to.
Rick Chevalier <<Chevalier, Rick.vcf>>