RE: [External] Regarding downloading data from IBM i series

Junk data? Is your CCSID conversion set as needed? Download properties > Conversions > General Options ? Convert CCSID 65535

-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of jerry ven
Sent: Tuesday, June 7, 2022 9:32 AM
To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: [External] Regarding downloading data from IBM i series

[WARNING]: External Email

I tried these different options but getting junk data in excel file also getting error 'CWBTF0009 - The Data in this Field Is Too Long for the
OS/400 Field'

Thanks

On Tue, 7 Jun 2022 at 19:59, Lehti, Eric <elehti@xxxxxxxxxxxx> wrote:

Jerry,
Those options are available so you can get the results you want for
the excel format you choose.

-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
jerry ven
Sent: Tuesday, June 7, 2022 9:20 AM
To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: [External] Regarding downloading data from IBM i series

[WARNING]: External Email

Hi,

When trying to download a spool file's data which is in a flat file
(copied spool file into a flat file) in IBM i to local desktop in a
excel file format then which specific settings under file details
like BIFF3(MS
Excel3 - 8) should be selected to download this spool file in a good
excel format to local desktop?

also under PC file description file how hould it be saved 1 enhanced
or 2) standard


--
This is the RPG programming on IBM i (RPG400-L) mailing list To post a
message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit:
https://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Flist
s.midrange.com%2Fmailman%2Flistinfo%2Frpg400-l&amp;data=05%7C01%7Celeh
ti%40quiktrip.com%7C1348033050ca4167be0508da48928967%7Cbe902cb3a2b74bf
d86442264fe46c43d%7C0%7C0%7C637902091464518906%7CUnknown%7CTWFpbGZsb3d
8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C
3000%7C%7C%7C&amp;sdata=lJbyVQE4EdiUfC%2F4HxRcctgwikv7AL9gst1aRKyvkPg%
3D&amp;reserved=0 or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Farchive.midrange.com%2Frpg400-l&amp;data=05%7C01%7Celehti%40quiktrip.com%7C1348033050ca4167be0508da48928967%7Cbe902cb3a2b74bfd86442264fe46c43d%7C0%7C0%7C637902091464518906%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&amp;sdata=f8cHIqyIndhfJNJXLLEiVPprgBLiEGzdleJaagbAqlE%3D&amp;reserved=0.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
related questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link:
https://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Famaz
on.midrange.com%2F&amp;data=05%7C01%7Celehti%40quiktrip.com%7C13480330
50ca4167be0508da48928967%7Cbe902cb3a2b74bfd86442264fe46c43d%7C0%7C0%7C
637902091464518906%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjo
iV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&amp;sdata=Q%2B
5N%2BzoDSJDjeAgqpa%2BP7jVCFXcwsT9dzsegEfsnfSg%3D&amp;reserved=0

--
This is the RPG programming on IBM i (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: https://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.midrange.com%2Fmailman%2Flistinfo%2Frpg400-l&amp;data=05%7C01%7Celehti%40quiktrip.com%7C1348033050ca4167be0508da48928967%7Cbe902cb3a2b74bfd86442264fe46c43d%7C0%7C0%7C637902091464518906%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&amp;sdata=lJbyVQE4EdiUfC%2F4HxRcctgwikv7AL9gst1aRKyvkPg%3D&amp;reserved=0
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at https://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Farchive.midrange.com%2Frpg400-l&amp;data=05%7C01%7Celehti%40quiktrip.com%7C1348033050ca4167be0508da48928967%7Cbe902cb3a2b74bfd86442264fe46c43d%7C0%7C0%7C637902091464518906%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&amp;sdata=f8cHIqyIndhfJNJXLLEiVPprgBLiEGzdleJaagbAqlE%3D&amp;reserved=0.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: https://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Famazon.midrange.com%2F&amp;data=05%7C01%7Celehti%40quiktrip.com%7C1348033050ca4167be0508da48928967%7Cbe902cb3a2b74bfd86442264fe46c43d%7C0%7C0%7C637902091464518906%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&amp;sdata=Q%2B5N%2BzoDSJDjeAgqpa%2BP7jVCFXcwsT9dzsegEfsnfSg%3D&amp;reserved=0