|
Conversions > General Options ? Convert CCSID 65535
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,https://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Farch
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&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&sdata=lJbyVQE4EdiUfC%2F4HxRcctgwikv7AL9gst1aRKyvkP
g%
3D&reserved=0 or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
ive.midrange.com%2Frpg400-l&data=05%7C01%7Celehti%40quiktrip.com%7
C478c7137780a45bdd61508da4893f883%7Cbe902cb3a2b74bfd86442264fe46c43d%7
C0%7C0%7C637902097613364203%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMD
AiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&s
data=eajkRpkz77qDFOMYb4WfReU3hEor1c5iwjMNWRGwmLY%3D&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&data=05%7C01%7Celehti%40quiktrip.com%7C134803
30
50ca4167be0508da48928967%7Cbe902cb3a2b74bfd86442264fe46c43d%7C0%7C0%
7C
637902091464518906%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQI
jo
iV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=Q%
2B
5N%2BzoDSJDjeAgqpa%2BP7jVCFXcwsT9dzsegEfsnfSg%3D&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&data=05%7C01%7Celeh
ti%40quiktrip.com%7C478c7137780a45bdd61508da4893f883%7Cbe902cb3a2b74bf
d86442264fe46c43d%7C0%7C0%7C637902097613364203%7CUnknown%7CTWFpbGZsb3d
8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C
3000%7C%7C%7C&sdata=m6danhOFgavcpqVsKbo0ZoiIQar3KdOhiquGt3WJFok%3D
&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&data=05%7C01%7Celehti%40quiktrip.com%7
C478c7137780a45bdd61508da4893f883%7Cbe902cb3a2b74bfd86442264fe46c43d%7
C0%7C0%7C637902097613364203%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMD
AiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&s
data=eajkRpkz77qDFOMYb4WfReU3hEor1c5iwjMNWRGwmLY%3D&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&data=05%7C01%7Celehti%40quiktrip.com%7C478c7137
780a45bdd61508da4893f883%7Cbe902cb3a2b74bfd86442264fe46c43d%7C0%7C0%7C
637902097613364203%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjo
iV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=nBr4
x4dooetzlDdlCoiNYutOfk0YbLT0R0kxWW9xqJo%3D&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&data=05%7C01%7Celeh
ti%40quiktrip.com%7C478c7137780a45bdd61508da4893f883%7Cbe902cb3a2b74bf
d86442264fe46c43d%7C0%7C0%7C637902097613364203%7CUnknown%7CTWFpbGZsb3d
8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C
3000%7C%7C%7C&sdata=m6danhOFgavcpqVsKbo0ZoiIQar3KdOhiquGt3WJFok%3D
&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&data=05%7C01%7Celehti%40quiktrip.com%7C478c7137780a45bdd61508da4893f883%7Cbe902cb3a2b74bfd86442264fe46c43d%7C0%7C0%7C637902097613364203%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=eajkRpkz77qDFOMYb4WfReU3hEor1c5iwjMNWRGwmLY%3D&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&data=05%7C01%7Celehti%40quiktrip.com%7C478c7137
780a45bdd61508da4893f883%7Cbe902cb3a2b74bfd86442264fe46c43d%7C0%7C0%7C
637902097613364203%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjo
iV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=nBr4
x4dooetzlDdlCoiNYutOfk0YbLT0R0kxWW9xqJo%3D&reserved=0
As an Amazon Associate we earn from qualifying purchases.
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.