Re: Fw: text files

[boothm@xxxxxxxxxxxxxxxxx]

It appears that the field always begins in column 165? 

In a case like that my preferred solution would be to define the flat 
file's record as one long field, say, "FullRecord" and also define a 
datastructure named "FullRecordDS" where the field CONQTY is defined in 
the datastructure at column 165.  Then, when needed in the Calcs, "     C  
    MOVE FullRecord      FullRecordDS"   That'd do all the data moves for 
you.  There are several trivial refinements for that solution. 

Toward your solution I'd  offer this:  Don't you have to substring a 
field, not a file?





_______________________
Booth Martin
boothm@earth.goddard.edu
http://www.spy.net/~booth
_______________________




"connie amerine" <camerine@midwestexp.com>
Sent by: owner-midrange-l@midrange.com
11/16/1999 08:13 AM
Please respond to MIDRANGE-L

 
        To:     <MIDRANGE-L@midrange.com>
        cc: 
        Subject:        Fw: text files

 
-----Original Message-----
From: connie amerine <camerine@midwestexp.com>
To: MIDRANGE-L@midrange.com <MIDRANGE-L@midrange.com>
Date: Monday, November 15, 1999 3:35 PM
Subject: Fw: text files

 
-----Original Message-----
From: connie amerine <camerine@midwestexp.com>
To: MIDRANGE-L@midrange.com <MIDRANGE-L@midrange.com>
Date: Monday, November 15, 1999 3:12 PM
Subject: text files

Our customer downloads a monthly order on a NT work station to us, I then 
FTP it to the AS/400. Once is it on the AS/400 as a flat file, I am 
attemping to use the file by using substring command to put some of the 
data into a sorted file. Once I use the substring and move the data into 
the physical file, it should be there, but.....I m getting the message 
that the field or indicater is not defined. 
 
5            SUBST<FILENAME>:165CONQTY    5
 
              MOVE CONQTY    CTYQTY
 
The code looks similiar to that...can anyone help?
Thanks in advance
Connie


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---