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
 

 

How to take particular fields from a VB file

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
varalakshmi.G

New User


Joined: 04 Jun 2007
Posts: 55
Location: Hyderabad

PostPosted: Tue Sep 18, 2007 3:30 pm    Post subject: How to take particular fields from a VB file
Reply with quote

Hi,

Could u tell me that,if I want to retrieve only particular fields from a VB file and To sort that file What is the syntax of INREC fields.

Thanks in advance,
Varalakshmi.G
Back to top
View user's profile Send private message

CICS Guy

Senior Member


Joined: 18 Jul 2007
Posts: 2150
Location: At my coffee table

PostPosted: Tue Sep 18, 2007 3:38 pm    Post subject:
Reply with quote

Have you looked at a sort manual?
Back to top
View user's profile Send private message
guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Tue Sep 18, 2007 4:26 pm    Post subject:
Reply with quote

Hi Varalakshmi,

Would u please provide us the sample i/p & o/p so that we can provide u sort card.
Back to top
View user's profile Send private message
Aaru

Senior Member


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

PostPosted: Tue Sep 18, 2007 5:05 pm    Post subject: Reply to: How to take particular fields from a VB file
Reply with quote

As requested please provide us more details on your requirement.

One thing that has to be kept in mind while writing SORT card for VB datasets is to include the 4 bytes for RDW.

Please do a search on this forum as we have discussed this before.
Back to top
View user's profile Send private message
varalakshmi.G

New User


Joined: 04 Jun 2007
Posts: 55
Location: Hyderabad

PostPosted: Tue Sep 18, 2007 6:14 pm    Post subject: How to take particular fields from VB file
Reply with quote

Hi,
I have an input file of VB format and i want only some particular fields of this i/p file and i want to do sorting on this file.I have added 4bytes to the length of the field while declaring the control card and i declared as
INREC FIELDS=(39,18)
SORT FIELDS=(39,18,CH,A) but it is giving U016 error.
Could u tell me abt this error.


Thanks.
Varalakshmi
Back to top
View user's profile Send private message
CICS Guy

Senior Member


Joined: 18 Jul 2007
Posts: 2150
Location: At my coffee table

PostPosted: Tue Sep 18, 2007 6:22 pm    Post subject: Re: How to take particular fields from VB file
Reply with quote

varalakshmi.G wrote:
I have an input file of VB format and i want only some particular fields of this i/p file and i want to do sorting on this file.I have added 4bytes to the length of the field while declaring the control card and i declared as
INREC FIELDS=(39,18)
SORT FIELDS=(39,18,CH,A) but it is giving U016 error.
Could u tell me abt this error.
Wouldn't the inrec need the 1,4 for the llbb also?
What is the message number and text for the error?
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: Tue Sep 18, 2007 9:26 pm    Post subject:
Reply with quote

Varalakshmi.G,

Assuming that you've accounted for the RDW in the starting positions, the correct DFSORT statements would be:

Code:

   INREC BUILD=(1,4,5:39,18)
   SORT FIELDS=(5,18,CH,A)


You must specify the RDW (1,4) in the INREC statement, and you must use the positions from the reformatted record for the SORT statement.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Split file based on comparsion to 2 f... Div Grad DFSORT/ICETOOL 3 Thu Jul 27, 2017 9:16 pm
No new posts Extra character appears in file when ... Balu5491 All Other Mainframe Topics 1 Wed Jul 26, 2017 2:39 pm
No new posts SSH - known_hosts file configuration vasanthz All Other Mainframe Topics 2 Wed Jul 26, 2017 2:10 am
This topic is locked: you cannot edit posts or make replies. Fetching data from BAI File arunsoods JCL & VSAM 1 Wed Jul 19, 2017 4:28 pm
No new posts Write out NODUPS but just from one file Jay Villaverde DFSORT/ICETOOL 8 Fri Jul 14, 2017 12:44 am


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