Re: Question on CPYFRMSTMF

[Carel <coteijgeler@xxxxxxxxx>]

CPYFRMSTMF is used for flat files (no field definitions) or source PFs.

You should use CPYFRMIMPF instead.


Op 14-8-2021 om 15:48 schreef Howie, Bill:
> Hello all,
>
> I'm trying to use the CPYFRMSTMF command to copy some data from the IFS into an IBM I database file.  The data in the IFS is in a tab-delimited text file, created by simply saving a CSV file as a text file.  When I use the CPYFRMSTMF command I use the following keywords:  STMFCCSID(*PCASCII), ENDLINFMT(*CRLF), and TABEXPN(*NO).
>
> I have a field that is defined as a text field in the CSV file.  This field contains an alphanumeric vendor number.  It basically looks like this:  00123456.  The database file I'm copying it into has one large 1,076-character field for each row of data from the text file.  For some reason when the data is copied it drops the zeros off the front of the vendor number, so that it looks like this:  123456.  The vendor number file I need to read using the number has the zeros on the front, so I need them there.  What part of the CPYFRMSTMF command removes those zeros?  Would it be better to use CPYFRMIMPF instead?  Any info is as always appreciated.  Thanks!
>
> [Related image]<https://www.hc-companies.com/>Bill Howie
> Senior ERP Programmer/Analyst
> Direct: 330.487.3739 | Cell: 330.888.8085 | Toll Free: 800.225.7712
> 2450 Edison Blvd, Suite 3, Twinsburg OH 44087
> hc-companies.com<https://www.hc-companies.com/>
> Leader in Horticultural Containers
> [cid:image003.png@01D790F1.8528F150]<https://www.linkedin.com/company/the-hc-companies>   [cid:image004.png@01D790F1.8528F150] <https://www.facebook.com/HCCompanies/>    [cid:image005.png@01D790F1.8528F150] <https://www.instagram.com/hccompanies/>    [cid:image006.png@01D790F1.8528F150] <https://twitter.com/hc_companies>
>
> Disclaimer
>
> The information contained in this communication from the sender is confidential. It is intended solely for use by the recipient and others authorized to receive it. If you are not the recipient, you are hereby notified that any disclosure, copying, distribution or taking action in relation of the contents of this information is strictly prohibited and may be unlawful.
>
> This email has been scanned for viruses and malware, and may have been automatically archived by Mimecast Ltd, an innovator in Software as a Service (SaaS) for business. Providing a safer and more useful place for your human generated data. Specializing in; Security, archiving and compliance. To find out more visit the Mimecast website.