|
View previous topic :: View next topic
|
| Author |
Message |
Jo Peterson
New User
Joined: 10 Jan 2007
Posts: 2
Location: New Jersey
|
|
|
|
I am getting a variable length asterisk-delimited file from a vendor that does not deal with the mainframe through my client. It is not the normal variable length file that we see in COBOL - fixed fields with a variable table occurring 1 to many times at the end. This file is completely variable with asterisk delimiters - no maximum record length. He created it this way so the FTP would work more efficiently. We are dealing with 4 million records. I was looking at the Inspect and Unstring statement in the COBOL manual and it seem to say you need a fixed record length with variable length fields within it. Don't I need a maximum record length for use in the JCL and in unstringing the data in COBOL? Is there another way to do this? I haven't coding extensive in COBOL in a couple of years. I need the info in case my client needs to tell the vendor to go back to making two files using fixed length data.
Thanks Jo |
|
| Back to top |
|
 |
William Thompson
Global Moderator
Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ
|
|
|
|
Jo,
You can read the file defined as "U", undefined (I think the file's declared max length has to match the FD's).
If the records are (in effect) unblocked, you should be able to scan across the record inspecting, unstringing, by reference modification and indexing/subscripting without any real trouble.
I had a vaguely similar situation and grew to love the unstring verb, with its counter and pointer functions and the use of linkage areas and the set pointer and set address.
Sounds like a fun challenge....
Bill |
|
| Back to top |
|
|
William Thompson
Global Moderator
Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ
|
|
|
|
Jo,
| Quote: |
| I have only used unstring statement with one field like an address or name not using counter or pointer or linkage area. So I still have to ask for the maximum record length or just the maximum field length? |
If you can get the record read, just start at the beginning and do it. If some of the structure is defined, set the address of an 01 (in linkage) with that structure to where you discover it in the record.
Scan along with RM until you get to data that you can "dsect" in linkage.
But judging from your circumstance, maybe getting it put (back?) to a more conventional format would be your best bet.
Bill |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19243
Location: Inside the Matrix
|
|
|
|
Hello,
Do you have a record definition of this input? Once the file is ftp'd to your mainframe, you'll want to find the dcb information. You'll also want to if these records are terminated with a cr or cr/lf (carriage return - line feed).
While the overall record length may be unpredictable, the order of the fields should be predictable (and hopefully, some rules on the maximum size of each field). If they just sent you some undefined "stuff" it could get ugly. An early thing to do is to make sure the content is as expected. Also, we'll hope for no embedded asterisks in the data . . .
Will this file be sent to you periodically or is this a one-time exercise? If it is one-time, there may be alternatives that would not be satisfactory for regular processing that would suffice. Might also help with downstream testing of the converted data while the "real" solution is being implemented.
Let us know what you find out and more info will be sent to you.
. |
|
| Back to top |
|
|
Jo Peterson
New User
Joined: 10 Jan 2007
Posts: 2
Location: New Jersey
|
|
|
|
Dick,
This is not a one-time process. It will be done 12+ times a year. I do have a layout of the data. Found people here that have worked with variable files. They say to find the biggest field and multiply it times the number of fields to get the maximum record length. Someone will then write a COBOL II program with a huge unstring statement to unstring each field into the largest field length area then move each to its correct length.
Example : max record length 100. Unstring date (8) into 100 byte date field then move to final 8 byte date field.
My only question is how to define the JCL output DD in the FTP step and the input FD in the program.
Thanks Jo |
|
| Back to top |
|
|
William Thompson
Global Moderator
Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ
|
|
|
|
Jo,
Sounds like better news than you had the other day.... 
| Jo Peterson wrote: |
| My only question is how to define the JCL output DD in the FTP step and the input FD in the program. |
Unless the file is VB, I still think you are stuck with U.....Since your FTP is defining it, it shouldn't be a problem to read it, just define the max lrecl the same.
Bill |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19243
Location: Inside the Matrix
|
|
|
|
Hello,
If there some existing JCL that ftp's similar data from the same source, i suggest looking at that and (other than lrecl) use the same ftp commands as well as the output DD ststement. |
|
| Back to top |
|
|
William Thompson
Global Moderator
Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ
|
|
|
|
| Jo Peterson wrote: |
Do you mean that if the max length is 9000 , for example, the lrecl and blksize on the output in the FTP step are both 9000 and recfm is U? And in the program's FD?:
FD IN-REC
LABEL RECORDS ARE STANDARD
RECORD CONTAINS 9000 CHARACTERS
BLOCK CONTAINS 0 RECORDS
RECORDING MODE IS U. |
That is my understanding...I recall Bill Klein mention that the max length has to match exactly..... |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19243
Location: Inside the Matrix
|
|
|
|
Hello,
If you can run the ftp on the mainframe to create this file, you can look at the file specification in TSO 3.4 and code your FD accordingly. |
|
| Back to top |
|
|
vmutyalapalli
New User
Joined: 09 Jun 2005
Posts: 5
Location: India
|
|
|
|
Hi,
Can we unstring a part of the record as follows using refrence modification:
Working-storage Section.
01 Record Pic x(40).
Unstring Record(1:20)
into
R1, R2, R3
I tried with this. It is saying illegal operand in unstring. Can I know is there is restrictions that we cannot use like above or are there any version restrictions??? I am using cobol 74
Thanks in Advance |
|
| Back to top |
|
|
William Thompson
Global Moderator
Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ
|
|
|
|
| vmutyalapalli wrote: |
Unstring Record(1:20)
into
R1, R2, R3
I tried with this. It is saying illegal operand in unstring. Can I know is there is restrictions that we cannot use like above or are there any version restrictions??? I am using cobol 74 |
Is reference modification allowed in that COBOL? Delimited by? |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19243
Location: Inside the Matrix
|
|
|
|
Hello,
If you want to unstring the first 20 bytes of "Record", redefined it and name the first 20 bytes - like
| Code: |
01 Record pic x(40).
01 Rec-20 redefines Record.
05 first-20 pic x(20).
05 filler pic x(20). |
Change your "unstring" to use first-20.
As Bill mentioned, remember to include the "delimited by" (you can usually use the "\" when you actually have no delimiter and just want to split the data into multiple fields - of course, if there is no delimiter, a more detailed redefines would work as well). . . |
|
| Back to top |
|
|
|
|
