|
View previous topic :: View next topic
|
| Author |
Message |
sakrish
New User
Joined: 05 Nov 2008
Posts: 21
Location: chennai
|
|
|
|
Hi,
I want to copy records from file whose RECFM=U.
I am getting the following error
| Code: |
WER141A SORTIN RECFM IS U
|
Will copy comand work in DFSORT.
Please help me.
Thanks in advance
-Sai |
|
| Back to top |
|
 |
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19243
Location: Inside the Matrix
|
|
|
|
Hello,
You ask about DFSORT, but you are running Syncsort. . .
SORTIN may not be recfm=u. |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19243
Location: Inside the Matrix
|
|
|
|
Hello,
| Quote: |
| SORTIN may not be recfm=u. |
At least for release 1.2.x and prior . .
Which release of Syncsort are you running? If you don't know, it is at the top of the informational output produced when the sort is run. |
|
| Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006
Posts: 2481
Location: @my desk
|
|
|
|
| Quote: |
SYNCSORT Z/OS MSGS R=V1R2
WER141A ddname RECFM IS U
EXPLANATION: The ddname is either SORTIN, SORTINnn, SORTJNF1, SORTJNF2, SORTOUT, SORTOFxx, SORTOFx or the ddname provided by an OUTFIL FNAMES parameter. SyncSort does not support undefined record format for any of these files. |
|
|
| Back to top |
|
|
Escapa
Senior Member
Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA
|
|
|
|
| Quote: |
Will copy comand work in DFSORT.
|
DFSORT doesn't support RECFM=U, I dont know about Syncsort.
RECFM=U are generally load modules.
probably you need to explain what exactly you want to do to get better workaround? |
|
| Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
|
|
|
|
| Quote: |
| DFSORT doesn't support RECFM=U, I dont know about Syncsort. |
Yes, it's true that DFSORT doesn't support RECFM=U. It seems obvious from the WER141A error message from Syncsort that Syncsort doesn't support RECFM=U either. |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6248
Location: Mumbai, India
|
|
|
|
Hi,
May sound little picky, but how the records are going to be used once this
| Quote: |
| I want to copy records from file whose RECFM=U. |
process is completed, may be if you tell us that - some one would be aroud with an alternate suggestion(s). |
|
| Back to top |
|
|
sakrish
New User
Joined: 05 Nov 2008
Posts: 21
Location: chennai
|
|
|
|
Thanks all
I want to extract some records from a file whose RECFM=U.
The input file is a huge file having atleast 5000 records
Is it possible to do in any other way.
It would be helpful , if any one suggest some ideas
-sai |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19243
Location: Inside the Matrix
|
|
|
|
Hello,
How was this file created?
If this file was created on unix or windows, it should be built as a delimited text file.
If you provide more detail about the recfm=u file/data, we may be able to offer suggestions. |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19243
Location: Inside the Matrix
|
|
|
|
Hello Sai,
I'm about to be away from the system for a while. I'll check back in the morning.
If you can post the info on how/where the file was created, it will help. |
|
| Back to top |
|
|
Aaru
Senior Member
Joined: 03 Jul 2007
Posts: 1287
Location: Chennai, India
|
|
|
|
Sakrish,
| Quote: |
| I want to extract some records from a file whose RECFM=U. |
RECFM= U refers to a LOAD library. Why do you want to extract records form a LOAD library? |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19243
Location: Inside the Matrix
|
|
|
|
Hello,
We deal with some regularity with recfm=u files that are not load library datasets.
Hopefully, Sai will be able to post info on how/where the file was created. |
|
| Back to top |
|
|
Escapa
Senior Member
Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA
|
|
|
|
Hi,
I have found some datasets (which i was not aware of  ) at my shop whose RECFM is U or UA and contains valid data records i.e. it is not executable file.
It is created by program written in NOMAD
So similarly i have created sample one. Below is info about it
| Code: |
General Data Current Allocation
Management class . . : B2WFYP Allocated tracks . : 1
Storage class . . . : ALLSTD Allocated extents . : 1
Volume serial . . . : D1GE43 +
Device type . . . . : 3390
Data class . . . . . : PSM#FB Current Utilization
Organization . . . : PS Used tracks . . . . : 1
Record format . . . : U Used extents . . . : 1
Record length . . . : 200
Block size . . . . : 200
1st extent tracks . : 1
Secondary tracks . : 10
Data set name type : SMS Compressible : NO
Creation date . . . : 2008/11/11 Referenced date . . : 2008/11/11
Expiration date . . : ***None***
|
and data it contains is
|
|
| Back to top |
|
|
Aaru
Senior Member
Joined: 03 Jul 2007
Posts: 1287
Location: Chennai, India
|
|
|
|
Syncsort,
| Quote: |
I have found some datasets (which i was not aware of ) at my shop whose RECFM is U or UA and contains valid data records i.e. it is not executable file.
|
The organization is PS and not PO.
| Code: |
| Organization . . . : PS |
In a normal load library the organization would be PO.
| Code: |
| Organization . . . : PO |
|
|
| Back to top |
|
|
Escapa
Senior Member
Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA
|
|
|
|
| Quote: |
In a normal load library the organization would be PO.
|
Yes I agree,
I just wanted to say that is has data records.
And PO is trying to use such file as input to sort |
|
| Back to top |
|
|
Aaru
Senior Member
Joined: 03 Jul 2007
Posts: 1287
Location: Chennai, India
|
|
|
|
Sambhaji,
Ok.
| Quote: |
| It is created by program written in NOMAD |
Btw, what exactly is NOMAD? |
|
| Back to top |
|
|
Escapa
Senior Member
Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA
|
|
|
|
| Aaru wrote: |
Btw, what exactly is NOMAD?
|
One 4GL programming language used specially for reporting purposes. |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19243
Location: Inside the Matrix
|
|
|
|
Hello,
| Quote: |
| Btw, what exactly is NOMAD? |
An Acronym.
"NCSS Owned, Maintained, And Developed".
Years ago, NOMAD, RAMIS, and FOCUS were competitive DSS (Decision Support System) products. These were front runners of the "Information Center" (as opposed to the Data Processing Center) and the Data Warehouse.
fwiw. . . |
|
| Back to top |
|
|
Aaru
Senior Member
Joined: 03 Jul 2007
Posts: 1287
Location: Chennai, India
|
|
|
|
| Thanks Sambhaji and Dick. |
|
| Back to top |
|
|
Escapa
Senior Member
Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA
|
|
|
|
Coming back to problem PO has,
I tried copying same file (RECFM=U) to other changing output file RECFM using various utilities but couldn't succeed 
Finally I tried reading it using COBOL program and it did.
So PO can use same approach, i.e. using COBOL write all data to new file with RECFM=FB or VB and then use sort utility on it to achieve desired result. |
|
| Back to top |
|
|
0d311
Guest
|
|
|
|
IEBGENER supports processing of RECFM=U files...  |
|
| Back to top |
|
|
Escapa
Senior Member
Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA
|
|
|
|
| Quote: |
| IEBGENER supports processing of RECFM=U files... |
When I tried, it gave me error,
IEB311I CONFLICTING DCB PARAMETERS |
|
| Back to top |
|
|
Aaru
Senior Member
Joined: 03 Jul 2007
Posts: 1287
Location: Chennai, India
|
|
|
|
Od,
| Quote: |
| IEBGENER supports processing of RECFM=U files... |
Do you have any working examples? |
|
| Back to top |
|
|
ramsri
Active User
Joined: 18 Oct 2008
Posts: 380
Location: India
|
|
|
|
Hi,
It would be interesting to know how Sambhaji has worked it out using COBOL ! What would be LRECL of i/p file? I would like to see the code of the program. Would you please paste here?
Thanks. |
|
| Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008
Posts: 8700
Location: Dubuque, Iowa, USA
|
|
|
|
Aaru:
| Code: |
//STEP1 EXEC PGM=IEBGENER,REGION=6M
//SYSIN DD DUMMY
//SYSPRINT DD SYSOUT=*
//SYSUT1 DD DISP=SHR,DSN=TTSSRS0.COMPILES.LOADLIB(MF0037)
//SYSUT2 DD DISP=(,CATLG),DSN=TTSSRS0.MF0037.LOADLIB,
// DCB=*.SYSUT1,
// UNIT=SYSDA,
// SPACE=(CYL,(1,1)) |
and the output file is
| Code: |
Data Set Name . . . . : TTSSRS0.MF0037.LOADLIB
General Data Current Allocation
Management class . . : MCSTRG Allocated cylinders : 1
Storage class . . . : SCSTRG Allocated extents . : 1
Volume serial . . . : STRS16
Device type . . . . : 3390
Data class . . . . . : DCNOORG Current Utilization
Organization . . . : PS Used cylinders . . : 1
Record format . . . : U Used extents . . . : 1
Record length . . . : 0
Block size . . . . : 27920
1st extent cylinders: 1
Secondary cylinders : 1
Data set name type : SMS Compressible : NO
Creation date . . . : 2008/11/13 Referenced date . . : 2008/11/13
Expiration date . . : ***None*** |
|
|
| Back to top |
|
|
|
|
