Midrange News for the IBM i Community


Posted by: Jacquie Pantoja
How to Create Varying Length STMF with CPYTOIMPF
has no ratings.
Published: 07 May 2013
Revised: 07 May 2013 - 1599 days ago
Last viewed on: 21 Sep 2017 (2952 views) 

Using IBM i? Need to create Excel, CSV, HTML, JSON, PDF, SPOOL reports? Learn more about the fastest and least expensive tool for the job: SQL iQuery.

How to Create Varying Length STMF with CPYTOIMPF Published by: Jacquie Pantoja on 07 May 2013 view comments(1)


I take variable lenght files and write them to a fixed length file, then I cpytoimpf.  i need for the streamfile to be variable lenghts not the fixed length.  how do i accomplish that?


I take variable lenght files and write them to a fixed length file, then I cpytoimpf.  i need for the streamfile to be variable lenghts not the fixed length.  how do i accomplish that?

Return to midrangenews.com home page.
Sort Ascend | Descend

COMMENTS

(Sign in to Post a Comment)
Posted by: bobcozzi
Site Admin ****
Chicagoland
Comment on: How to Create Varying Length STMF with CPYTOIMPF
Posted: 4 years 4 months 17 days 20 hours 39 minutes ago

Hi Jacquie,

First, this section is for complete articles not Q & A. So kindly repost in the "Submit New Topic" area. 

There is a trim parameter on the CPYTOIMPF just be sure to include the RMVBLANK(*TRAILING) or *EOR and set the RCDDLM to RCDDLM(*CRLF)