× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



See icons 'Start Transfer', 'Stop Transfer', 'Properties'. Open 'Properties' > Conversions.

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

[WARNING]: External Email

where can i chec these properties i don't have separate i series navigator to download i just have a session and that button 'Data transfer from IBM i ' i could not find these properties there- Download properties
Conversions > General Options ? Convert CCSID 65535


Thanks


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

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%2Fli
st
s.midrange.com%2Fmailman%2Flistinfo%2Frpg400-l&amp;data=05%7C01%7Cel
eh
ti%40quiktrip.com%7C1348033050ca4167be0508da48928967%7Cbe902cb3a2b74
bf
d86442264fe46c43d%7C0%7C0%7C637902091464518906%7CUnknown%7CTWFpbGZsb
3d
8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%
7C
3000%7C%7C%7C&amp;sdata=lJbyVQE4EdiUfC%2F4HxRcctgwikv7AL9gst1aRKyvkP
g%
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%2Farch
ive.midrange.com%2Frpg400-l&amp;data=05%7C01%7Celehti%40quiktrip.com%7
C478c7137780a45bdd61508da4893f883%7Cbe902cb3a2b74bfd86442264fe46c43d%7
C0%7C0%7C637902097613364203%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMD
AiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&amp;s
data=eajkRpkz77qDFOMYb4WfReU3hEor1c5iwjMNWRGwmLY%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%2Fam
az
on.midrange.com%2F&amp;data=05%7C01%7Celehti%40quiktrip.com%7C134803
30
50ca4167be0508da48928967%7Cbe902cb3a2b74bfd86442264fe46c43d%7C0%7C0%
7C
637902091464518906%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQI
jo
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%2Flist
s.midrange.com%2Fmailman%2Flistinfo%2Frpg400-l&amp;data=05%7C01%7Celeh
ti%40quiktrip.com%7C478c7137780a45bdd61508da4893f883%7Cbe902cb3a2b74bf
d86442264fe46c43d%7C0%7C0%7C637902097613364203%7CUnknown%7CTWFpbGZsb3d
8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C
3000%7C%7C%7C&amp;sdata=m6danhOFgavcpqVsKbo0ZoiIQar3KdOhiquGt3WJFok%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%2Farch
ive.midrange.com%2Frpg400-l&amp;data=05%7C01%7Celehti%40quiktrip.com%7
C478c7137780a45bdd61508da4893f883%7Cbe902cb3a2b74bfd86442264fe46c43d%7
C0%7C0%7C637902097613364203%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMD
AiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&amp;s
data=eajkRpkz77qDFOMYb4WfReU3hEor1c5iwjMNWRGwmLY%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%7C478c7137
780a45bdd61508da4893f883%7Cbe902cb3a2b74bfd86442264fe46c43d%7C0%7C0%7C
637902097613364203%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjo
iV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&amp;sdata=nBr4
x4dooetzlDdlCoiNYutOfk0YbLT0R0kxWW9xqJo%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%2Flist
s.midrange.com%2Fmailman%2Flistinfo%2Frpg400-l&amp;data=05%7C01%7Celeh
ti%40quiktrip.com%7C478c7137780a45bdd61508da4893f883%7Cbe902cb3a2b74bf
d86442264fe46c43d%7C0%7C0%7C637902097613364203%7CUnknown%7CTWFpbGZsb3d
8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C
3000%7C%7C%7C&amp;sdata=m6danhOFgavcpqVsKbo0ZoiIQar3KdOhiquGt3WJFok%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%7C478c7137780a45bdd61508da4893f883%7Cbe902cb3a2b74bfd86442264fe46c43d%7C0%7C0%7C637902097613364203%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&amp;sdata=eajkRpkz77qDFOMYb4WfReU3hEor1c5iwjMNWRGwmLY%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%7C478c7137
780a45bdd61508da4893f883%7Cbe902cb3a2b74bfd86442264fe46c43d%7C0%7C0%7C
637902097613364203%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjo
iV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&amp;sdata=nBr4
x4dooetzlDdlCoiNYutOfk0YbLT0R0kxWW9xqJo%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%7C478c7137780a45bdd61508da4893f883%7Cbe902cb3a2b74bfd86442264fe46c43d%7C0%7C0%7C637902097613364203%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&amp;sdata=m6danhOFgavcpqVsKbo0ZoiIQar3KdOhiquGt3WJFok%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%7C478c7137780a45bdd61508da4893f883%7Cbe902cb3a2b74bfd86442264fe46c43d%7C0%7C0%7C637902097613364203%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&amp;sdata=eajkRpkz77qDFOMYb4WfReU3hEor1c5iwjMNWRGwmLY%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%7C478c7137780a45bdd61508da4893f883%7Cbe902cb3a2b74bfd86442264fe46c43d%7C0%7C0%7C637902097613364203%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&amp;sdata=nBr4x4dooetzlDdlCoiNYutOfk0YbLT0R0kxWW9xqJo%3D&amp;reserved=0

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.