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