IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Can we use Syncsort to copy records with RECFM=U


IBM Mainframe Forums -> JCL & VSAM
Post new topic   This topic is locked: you cannot edit posts or make replies.
View previous topic :: View next topic  
Author Message
sakrish

New User


Joined: 05 Nov 2008
Posts: 21
Location: chennai

PostPosted: Fri Nov 07, 2008 11:36 am
Reply with quote

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
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Fri Nov 07, 2008 12:06 pm
Reply with quote

Hello,

You ask about DFSORT, but you are running Syncsort. . .

SORTIN may not be recfm=u.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Fri Nov 07, 2008 12:10 pm
Reply with quote

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
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2481
Location: @my desk

PostPosted: Fri Nov 07, 2008 12:13 pm
Reply with quote

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
View user's profile Send private message
Escapa

Senior Member


Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA

PostPosted: Fri Nov 07, 2008 12:13 pm
Reply with quote

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
View user's profile Send private message
Frank Yaeger

DFSORT Developer


Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA

PostPosted: Fri Nov 07, 2008 9:38 pm
Reply with quote

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
View user's profile Send private message
Anuj Dhawan

Superior Member


Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India

PostPosted: Sat Nov 08, 2008 12:38 am
Reply with quote

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
View user's profile Send private message
sakrish

New User


Joined: 05 Nov 2008
Posts: 21
Location: chennai

PostPosted: Sat Nov 08, 2008 7:45 am
Reply with quote

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
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Sat Nov 08, 2008 8:06 am
Reply with quote

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
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Sat Nov 08, 2008 10:52 am
Reply with quote

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
View user's profile Send private message
Aaru

Senior Member


Joined: 03 Jul 2007
Posts: 1287
Location: Chennai, India

PostPosted: Sat Nov 08, 2008 11:11 am
Reply with quote

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
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Sat Nov 08, 2008 11:20 am
Reply with quote

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
View user's profile Send private message
Escapa

Senior Member


Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA

PostPosted: Tue Nov 11, 2008 2:29 pm
Reply with quote

Hi,
I have found some datasets (which i was not aware of icon_confused.gif ) 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
Code:

sample record
Back to top
View user's profile Send private message
Aaru

Senior Member


Joined: 03 Jul 2007
Posts: 1287
Location: Chennai, India

PostPosted: Tue Nov 11, 2008 2:34 pm
Reply with quote

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
View user's profile Send private message
Escapa

Senior Member


Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA

PostPosted: Tue Nov 11, 2008 2:46 pm
Reply with quote

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
View user's profile Send private message
Aaru

Senior Member


Joined: 03 Jul 2007
Posts: 1287
Location: Chennai, India

PostPosted: Tue Nov 11, 2008 3:03 pm
Reply with quote

Sambhaji,

Ok.


Quote:
It is created by program written in NOMAD


Btw, what exactly is NOMAD?
Back to top
View user's profile Send private message
Escapa

Senior Member


Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA

PostPosted: Tue Nov 11, 2008 3:06 pm
Reply with quote

Aaru wrote:
Btw, what exactly is NOMAD?

One 4GL programming language used specially for reporting purposes.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Wed Nov 12, 2008 9:34 am
Reply with quote

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
View user's profile Send private message
Aaru

Senior Member


Joined: 03 Jul 2007
Posts: 1287
Location: Chennai, India

PostPosted: Wed Nov 12, 2008 10:05 am
Reply with quote

Thanks Sambhaji and Dick.
Back to top
View user's profile Send private message
Escapa

Senior Member


Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA

PostPosted: Thu Nov 13, 2008 12:59 pm
Reply with quote

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 icon_sad.gif
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
View user's profile Send private message
0d311

Guest





PostPosted: Thu Nov 13, 2008 1:11 pm
Reply with quote

IEBGENER supports processing of RECFM=U files... icon_neutral.gif
Back to top
Escapa

Senior Member


Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA

PostPosted: Thu Nov 13, 2008 6:16 pm
Reply with quote

Quote:
IEBGENER supports processing of RECFM=U files...

When I tried, it gave me error,
IEB311I CONFLICTING DCB PARAMETERS
Back to top
View user's profile Send private message
Aaru

Senior Member


Joined: 03 Jul 2007
Posts: 1287
Location: Chennai, India

PostPosted: Thu Nov 13, 2008 6:31 pm
Reply with quote

Od,

Quote:
IEBGENER supports processing of RECFM=U files...


Do you have any working examples?
Back to top
View user's profile Send private message
ramsri

Active User


Joined: 18 Oct 2008
Posts: 380
Location: India

PostPosted: Thu Nov 13, 2008 9:39 pm
Reply with quote

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
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8696
Location: Dubuque, Iowa, USA

PostPosted: Thu Nov 13, 2008 9:49 pm
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   This topic is locked: you cannot edit posts or make replies. View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM Goto page 1, 2  Next

 


Similar Topics
Topic Forum Replies
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Pulling a fixed number of records fro... DB2 2
No new posts VB to VB copy - Full length reached SYNCSORT 8
No new posts Join multiple records using splice DFSORT/ICETOOL 5
No new posts EZT program to build a flat file with... All Other Mainframe Topics 9
Search our Forums:

Back to Top