|
What I find interesting (other than the disclosure of several private
email accounts - hopefully masked for this email) is that it starts out as
gibberish but then becomes readable. Otherwise I wonder if it might be as
simple as looking at the outbound CCSID. Starting at V5R3 and above IBM
really started getting weird on CCSID - especially with that command.
I personally would find the command easier to read without the prompt
screen - especially with the line adjustments that this list does.
Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com
"Mark Allen" <scprideandms@xxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
10/03/2008 08:57 AM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
To
"Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
cc
Subject
CPYTOIMPF isssue
I've tried this a number of different ways but I keep getting the same
issue, what the heck am I missing
When the below command runs I can look at the file thru WRKLNK and it
looks
OK (screen shot after command)
Copy To Import File
(CPYTOIMPF)
Type choices, press
Enter.
From
file:
File . . . . . . . . . . . . . > LIVEEDUHDR
Name
Library . . . . . . . . . . *LIBL Name, *LIBL,
*CURLIB
Member . . . . . . . . . . . . *FIRST Name, *FIRST,
*ALL
To data base
file:
File . . . . . . . . . . . . .
Name
Library . . . . . . . . . . *LIBL Name, *LIBL,
*CURLIB
Member . . . . . . . . . . . . *FIRST Name, *FIRST, *FROMMBR,
*ALL
To stream file . . . . . . . . . >
'/QNTC/CINVMVISTA02/Scripts/myunion.csv'
Replace or add records . . . . . > *REPLACE *ADD,
*REPLACE
From CCSID . . . . . . . . . . . *FILE 1-65533,
*FILE
To CCSID . . . . . . . . . . . . *FILE 1-65533,
*FILE
Stream file code page . . . . . *STMF 1-32767, *STMF,
*PCASCII...
Record delimiter . . . . . . . . > *CRLF Character value,
*EOR...
Record format of import file . . *DLM *DLM,
*FIXED
More...
F3=Exit F4=Prompt F5=Refresh F12=Cancel F13=How to use this
display
F24=More
keys
Copy To Import File
(CPYTOIMPF)
Type choices, press
Enter.
String delimiter . . . . . . . . > *NONE Character value,
*DBLQUOTE...
String escape character . . . . *STRDLM Character value,
*STRDLM...
Remove blanks . . . . . . . . . > *TRAILING *NONE, *LEADING,
*TRAILING...
Field delimiter . . . . . . . . ',' Character value,
*TAB
Null field indicator . . . . . . *NO *NO,
*YES
Decimal point . . . . . . . . . *PERIOD *PERIOD,
*COMMA
Date format . . . . . . . . . . *ISO *ISO, *USA, *EUR, *JIS,
*YYMD
Time format . . . . . . . . . . *ISO *ISO, *USA, *EUR,
*JIS
Bottom
F3=Exit F4=Prompt F5=Refresh F12=Cancel F13=How to use this
display
F24=More keys
Browse :
/QNTC/CINVMVISTA02/Scripts/myunion.csv
Record : 1 of 1 by 18 Column : 1
229 by 131
Control
:
....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8....+....9....+....0....+....1....+....2....+....3.
************Beginning of
Data**************
Action,Type,Name,DisplayName,EmailAddress,FirstName,LastName,....etc etc
all
looks fine
Then I do the following command to copy/add the data as below the data
gets
all "mucked" up....screen shot below command
Copy To Import File
(CPYTOIMPF)
Type choices, press
Enter.
From
file:
File . . . . . . . . . . . . . > LIVEEDUTRP
Name
Library . . . . . . . . . . *LIBL Name, *LIBL,
*CURLIB
Member . . . . . . . . . . . . *FIRST Name, *FIRST,
*ALL
To data base
file:
File . . . . . . . . . . . . .
Name
Library . . . . . . . . . . *LIBL Name, *LIBL,
*CURLIB
Member . . . . . . . . . . . . *FIRST Name, *FIRST, *FROMMBR,
*ALL
To stream file . . . . . . . . . >
'/QNTC/CINVMVISTA02/Scripts/myunion.csv'
Replace or add records . . . . . > *ADD *ADD,
*REPLACE
From CCSID . . . . . . . . . . . *FILE 1-65533,
*FILE
To CCSID . . . . . . . . . . . . *FILE 1-65533,
*FILE
Stream file code page . . . . . *STMF 1-32767, *STMF,
*PCASCII...
Record delimiter . . . . . . . . > *CRLF Character value,
*EOR...
Record format of import file . . *DLM *DLM,
*FIXED
More...
F3=Exit F4=Prompt F5=Refresh F12=Cancel F13=How to use this
display
F24=More
keys
Copy To Import File
(CPYTOIMPF)
Type choices, press
Enter.
String delimiter . . . . . . . . > *NONE Character value,
*DBLQUOTE...
String escape character . . . . *STRDLM Character value,
*STRDLM...
Remove blanks . . . . . . . . . > *TRAILING *NONE, *LEADING,
*TRAILING...
Field delimiter . . . . . . . . ',' Character value,
*TAB
Null field indicator . . . . . . *NO *NO,
*YES
Decimal point . . . . . . . . . *PERIOD *PERIOD,
*COMMA
Date format . . . . . . . . . . *ISO *ISO, *USA, *EUR, *JIS,
*YYMD
Time format . . . . . . . . . . *ISO *ISO, *USA, *EUR,
*JIS
Bottom
F3=Exit F4=Prompt F5=Refresh F12=Cancel F13=How to use this
display
F24=More keys
and heres the data
Á £ k㨠kÕ kÄ ¢ ¨Õ kÅ Á ¢¢kÆ ¢£Õ kÓ ¢£Õ k× ¢¢¦ kÃ
£¨kà ¨kà ¤ £ ¨ Ù kÄ £ £kÆ §kÆ Ã × ¢¢¦
kÈ × kÔ × kÕ £ ¢kÖ k× k× ¢£ à k⣠£ × ¥ kâ£
£Á ¢¢kã £ kæ %Add,Mailbox,Abenaa Lockhart,Abena
a Lockhart,abenaa.bailey@xxxxxxxxxxxxxxxxx,Abenaa,Lockhart,242640, , ,US,
,0,0,0,0, , ,0, , , , , Add,Mailbox,Allene Gammons,Allen
e Gammons,allene.gammons@xxxxxxxxxxxxxxxxx,Allene,Gammons,730099, , ,US,
,0,0,0,0, , ,0, , , , , Add,Mailbox,Allison Luongo,Alliso
n Luongo,allison.luongo@xxxxxxxxxxxxxxxxx,Allison,Luongo,761592, , ,US,
,0,0,0,0, , ,0, , , , , Add,Mailbox,Ana Sanchez,Ana Sanche
z,ana.sanchez@xxxxxxxxxxxxxxxxx,Ana,Sanchez,583511, , ,US, ,0,0,0,0, , ,0,
,
, , , Add,Mailbox,Andre Jones,Andre Jones,andre.jones
@email.myunion.edu,Andre,Jones,510892, , ,US, ,0,0,0,0, , ,0, , , , ,
Add,Mailbox,Anissa Sheffield,Anissa Sheffield,anissa.sheffie
ld@xxxxxxxxxxxxxxxxx,Anissa,Sheffield,263502, , ,US, ,0,0,0,0, , ,0, , , ,
, Add,Mailbox,Annette Howell,Annette Howell,annette.how
ell@xxxxxxxxxxxxxxxxx,Annette,Howell,555758, , ,US, ,0,0,0,0, , ,0, , , ,
, Add,Mailbox,Antoine Joseph,Antoine Joseph,antoine.jose
ph@xxxxxxxxxxxxxxxxx,Antoine,Joseph,768106, , ,US, ,0,0,0,0, , ,0, , , , ,
Add,Mailbox,Avril Allen,Avril Allen,avril.allen@xxxxxxx
yunion.edu,Avril,Allen,083905, , ,US, ,0,0,0,0, , ,0, , , , ,
Add,Mailbox,Barbara Gilson,Barbara Gilson,barbara.gilson@xxxxxxxxxxx
on.edu,Barbara,Gilson,926117, , ,US, ,0,0,0,0, , ,0, , , , ,
Add,Mailbox,Barry Canada,Barry Canada,barry.canada@xxxxxxxxxxxxxxxxx,
Barry,Canada,402388, , ,US, ,0,0,0,0, , ,0, , , , , Add,Mailbox,Beatriz
Vidales,Beatriz Vidales,beatriz.vidales@xxxxxxxxxxxxxxxxx,
Beatriz,Vidales,910863, , ,US, ,0,0,0,0, , ,0, , , , , Add,Mailbox,Becker
Downie,Becker Downie,becker.downie@xxxxxxxxxxxxxxxxx,Bec
ker,Downie,854711, , ,US, ,0,0,0,0, , ,0, , , , , Add,Mailbox,Charlotte
Yarbrough,Charlotte Yarbrough,charlotte.yarbrough@xxxxxxxx
for some reason it is scrambling the initial header row, started data at
end
of header row, and is truncating at 132 wide.
Both of the PF's being copied are CCSID 37.....
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.
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.
midrange.com
