RE: Restoring a .txt file

["Angela Wawrzaszek" <awawrzaszek@xxxxxxxxxxxxxxx>]

No there was no place to store the flddfn


Angela Wawrzaszek
IT Supervisor
awawrzaszek@xxxxxxxxxxxxxxx
(315) 258-4205

-----Original Message-----
From: rob@xxxxxxxxx [mailto:rob@xxxxxxxxx] 
Sent: Wednesday, February 09, 2005 2:36 PM
To: Midrange Systems Technical Discussion
Subject: RE: Restoring a .txt file

See if there's an option on CPYTOIMPF?

Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





"Angela Wawrzaszek" <awawrzaszek@xxxxxxxxxxxxxxx> 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
02/09/2005 02:15 PM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
"Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
cc

Subject
RE: Restoring a .txt file






I don't specify anything,  on the cpyffrm prompts I leave it as *dlm
coming back in.  I don't know where or how to define this flddfnfile,
on client access you can define a file spec and store on the harddrive
but how to I define one directly on the as400?

Angela Wawrzaszek
IT Supervisor
awawrzaszek@xxxxxxxxxxxxxxx
(315) 258-4205

-----Original Message-----
From: Wilt, Charles [mailto:CWilt@xxxxxxxxxxxx] 
Sent: Wednesday, February 09, 2005 1:35 PM
To: Midrange Systems Technical Discussion
Subject: RE: Restoring a .txt file

Angela,

What are you specifying in the FLDDFNFILE parm of the CPYFRMIMPF?  How
are the fields specified in the FLDDFNFILE?

Charles Wilt
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
 

> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Angela Wawrzaszek
> Sent: Wednesday, February 09, 2005 12:39 PM
> To: Midrange Systems Technical Discussion
> Subject: Restoring a .txt file
> 
> 
>    Help!
> 
> 
> 
>     I have a .txt file that was saved from an as/400 
> inventory file.  It
> was saved as a fixed format file.   I now want to bring that .txt file
> back to the as400 to run queries on it.   However since it was fixed
> there is not comma delimiters etc.   So I copied it back to a 
> flat file
> on the as400 and then tried using the cpyfrmimpf command to 
> copy it back
> into its regular format.   The problem occurs because there is numeric
> data in the file.  Therefore the copy crashes because I am trying to
> copy  17.00  - which is beign treated as a character field to 
> a numberic
> field.
> 
> 
> 
> The command used to copy the data to the .txt file was:
> 
> 
> 
> 
> 
> CPYTOIMPF  FROMFILE(Mylib/MyFile) + 
> 
>              TOSTMF('home/yearend/yearend2004/MyFile.t +
> 
>              xt') MBROPT(*REPLACE) + 
> 
>              STMFCODPAG(*PCASCII) RCDDLM(*CRLF) + 
> 
>              DTAFMT(*FIXED) STRDLM(*NONE) 
> 
> 
> 
> 
> 
> Can anyone help me to restore this to its original data formats?
> 
> 
> 
> Thanks! 
> 
> 
> 
> 
> 
> 
> 
> Angela Wawrzaszek
> 
> IT Supervisor
> 
> awawrzaszek@xxxxxxxxxxxxxxx
> 
> (315) 258-4205
> 
> 
> 
> -- 
> 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.




-- 
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.