Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 Subtract the ZD fields to provide neg... Balaryan DFSORT/ICETOOL 4 Wed Oct 11, 2017 10:51 pm
No new posts Addition of two records on 2 fields amar143 SYNCSORT 8 Tue Oct 03, 2017 11:14 am
No new posts Execute JCL step based on the content... sprikitik JCL & VSAM 2 Tue Oct 03, 2017 10:03 am
This topic is locked: you cannot edit posts or make replies. PS file data should be passed as symb... d_sarlie JCL & VSAM 15 Tue Oct 03, 2017 5:18 am
No new posts Garbage on output file Hervey Martinez SYNCSORT 4 Wed Sep 27, 2017 12:50 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us