Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] suffix attribute for variable block length file

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] suffix attribute for variable block length file
 Login/Join
 
chetan
Member
posted
Hi ALL,
I have variable block length file(RECORD FORMAT=VB), i have made its master file description(MFD) with suffix attribute as FIX,
now when i allocate the MFD to file and try to print all records i do not get all the records of the file, however if I convert the file first to Fixed Block lenght and use it with same MFD it gives all records.

So i just want to know what SUFFIX attribute should be kept for Variable Block length File.

please help me in this regard.

regards,
Chetan

This message has been edited. Last edited by: Kerry,


FOCUS 7.2.3
mainframes
csv, excel


 
Posts: 8 | Registered: October 18, 2008Report This Post
Danny-SRL
Virtuoso
posted Hide Post
Chetan,

You say that your sequential file has variable length records. Focus knows very well how to deal with this type of file. So a few questions.

How do you allocate the file?
Do you have records of different length?
Do you have repeating groups?
Do you have different record types?
How do you convert your file to fixed length?

This information could help to find a solution.


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006Report This Post
chetan
Member
posted Hide Post
Hi Danny,
Below is the answer for your questions,

1.For allocating file i am using dynam alloc statement.
2.Records have same length but the block size is varaible ( i am referring to variable block(VB) format files in mainframes)
3.It does not have repeating groups.
4.Records type is similar.
5.I am using SELCOPY to copy data from variable block(VB) file to fixed block(FB) format file.


FOCUS 7.2.3
mainframes
csv, excel


 
Posts: 8 | Registered: October 18, 2008Report This Post
Danny-SRL
Virtuoso
posted Hide Post
Chetan,

So you have a sequential file: SUFFIX=FIX.
Did you define all the fields in the record?

If the file is cataloged then focus should read the DCB from the catalog. If it is not, then your DYNAM ALLOC should specify it.


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006Report This Post
chetan
Member
posted Hide Post
Hi Danny,
The file is cataloged ,but can you tell me how to specify it in DYNAM ALLOC statement.

Regards,
chetan


FOCUS 7.2.3
mainframes
csv, excel


 
Posts: 8 | Registered: October 18, 2008Report This Post
chetan
Member
posted Hide Post
I used the below command but it didn't work

DYNAM ALLOC FI VBFILE DA DXY.VBFILE.SAMF RECFM VB SHR REU

The attributes of the file are as follows:

Organization . . . : PS
Record format . . . : VB
Record length . . . : 324
Block size . . . . : 27998


FOCUS 7.2.3
mainframes
csv, excel


 
Posts: 8 | Registered: October 18, 2008Report This Post
Danny-SRL
Virtuoso
posted Hide Post
Chetan,

If your file is cataloged then this should be enough:
  
DYNAM ALLOC DDNAME VBFILE DSNAME DXY.VBFILE.SAMF SHR [REU]


If your file is not cataloged:
  
DYNAM ALLOC DDNAME VBFILE DSNAME DXY.VBFILE.SAMF SHR [REU] RECFM VB BLKSIZE 27998 LRECL 324 UNIT unit VOLUME volser


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006Report This Post
chetan
Member
posted Hide Post
the File is cataloged, but it doest not work. Frowner

I have used the format for uncataloged file but it does not work.


FOCUS 7.2.3
mainframes
csv, excel


 
Posts: 8 | Registered: October 18, 2008Report This Post
Danny-SRL
Virtuoso
posted Hide Post
Chetan,

Last try.

Can you run:
DYNAM ALLOC DDNAME VBFILE DSNAME DXY.VBFILE.SAMF SHR
TABLE FILE VBFILE
COUNT *
END

Do the same with your copied fixed record file.
Show the output (the number of records) and any messages.


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006Report This Post
chetan
Member
posted Hide Post
quote:
VBFILE


Hi Danny,
i have used the query suggested by you it gave below results.
for VB format file
COUNT *
COUNT
-------
11570

for FB format file
COUNT *
COUNT
-------
23141

for VB format the record count shows half the actual record count of the file.

There were no messages diplayed while running the query.


FOCUS 7.2.3
mainframes
csv, excel


 
Posts: 8 | Registered: October 18, 2008Report This Post
j.gross
Virtuoso
posted Hide Post
What does CHECK FILE display for your MFD?

What does the catalog show as the LRECL for the VB and FB copies of the dataset?
 
Posts: 1925 | Location: NYC | In FOCUS since 1983 | Registered: January 11, 2005Report This Post
chetan
Member
posted Hide Post
quote:
FB

the CHECK FILE shows
> check file VBFILE
NUMBER OF ERRORS= 0
NUMBER OF SEGMENTS= 1 ( REAL= 1 VIRTUAL= 0 )
NUMBER OF FIELDS= 54 INDEXES= 0 FILES= 1
TOTAL LENGTH OF ALL FIELDS= 324

catalog entry for FB file :
Data class . . . . . : SAMF
Organization . . . : PS
Record format . . . : FB
Record length . . . : 324
Block size . . . . : 27864


catalog entry for VB file :

Data class . . . . . : SAMF
Organization . . . : PS
Record format . . . : VB
Record length . . . : 324
Block size . . . . : 27998


FOCUS 7.2.3
mainframes
csv, excel


 
Posts: 8 | Registered: October 18, 2008Report This Post
Kerry
Expert
posted Hide Post
Hi Chetan,

The following online documents may be of help:

* Describing Multiple Record Types
* How to describe FIX MFD with RECTYPEs and SUB-RECTYPEs?
* Describing non-Focus files

Cheers,

Kerry


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.
 
Posts: 1948 | Location: New York | Registered: November 16, 2004Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] suffix attribute for variable block length file

Copyright © 1996-2020 Information Builders