Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Can we use Syncsort to copy records with RECFM=U
Goto page 1, 2  Next
 
Post new topic   This topic is locked: you cannot edit posts or make replies.    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
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    Post subject: Can we use Syncsort to copy records with RECFM=U
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

Site Director


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

PostPosted: Fri Nov 07, 2008 12:06 pm    Post subject:
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

Site Director


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

PostPosted: Fri Nov 07, 2008 12:10 pm    Post subject:
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: 2161
Location: @my desk

PostPosted: Fri Nov 07, 2008 12:13 pm    Post subject:
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    Post subject:
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 Moderator


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

PostPosted: Fri Nov 07, 2008 9:38 pm    Post subject:
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

Senior Member


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

PostPosted: Sat Nov 08, 2008 12:38 am    Post subject:
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    Post subject: Reply to: Can we use Syncsort to copy records with RECFM=U
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

Site Director


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

PostPosted: Sat Nov 08, 2008 8:06 am    Post subject:
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

Site Director


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

PostPosted: Sat Nov 08, 2008 10:52 am    Post subject:
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: 1288
Location: Chennai, India

PostPosted: Sat Nov 08, 2008 11:11 am    Post subject: Reply to: Can we use Syncsort to copy records with RECFM=U
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

Site Director


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

PostPosted: Sat Nov 08, 2008 11:20 am    Post subject:
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    Post subject:
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: 1288
Location: Chennai, India

PostPosted: Tue Nov 11, 2008 2:34 pm    Post subject: Reply to: Can we use Syncsort to copy records with RECFM=U
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    Post subject:
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: 1288
Location: Chennai, India

PostPosted: Tue Nov 11, 2008 3:03 pm    Post subject: Reply to: Can we use Syncsort to copy records with RECFM=U
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    Post subject:
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

Site Director


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

PostPosted: Wed Nov 12, 2008 9:34 am    Post subject:
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: 1288
Location: Chennai, India

PostPosted: Wed Nov 12, 2008 10:05 am    Post subject: Reply to: Can we use Syncsort to copy records with RECFM=U
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    Post subject:
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
View previous topic :: :: View next topic  
Post new topic   This topic is locked: you cannot edit posts or make replies.    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Goto page 1, 2  Next
Page 1 of 2

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts syncsort: copy lines after the keyword shreya19 SYNCSORT 7 Fri Dec 02, 2016 9:47 am
No new posts Limit duplicate records in the SORT pshongal SYNCSORT 6 Mon Nov 21, 2016 12:54 pm
No new posts Syncsort - Hard coded Value in output PORYES SYNCSORT 1 Thu Nov 03, 2016 9:23 am
No new posts How to split the records using the am... vnktrrd DFSORT/ICETOOL 24 Fri Oct 28, 2016 7:33 pm
No new posts Sort records based on numeric field. Alks SYNCSORT 2 Wed Oct 19, 2016 10:14 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us