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 - 4004 days ago
Last viewed on: 23 Apr 2024 (5272 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
www.cozTools.com/qryfile
Comment on: How to Create Varying Length STMF with CPYTOIMPF
Posted: 10 years 11 months 18 days 13 hours 9 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)