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 - 1483 days ago
Last viewed on: 29 May 2017 (2742 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 21 days 22 hours 25 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)