FUJITSU FS Logo
HomeMigrationsProductsServicesInformationNewsPartnersStudentPricingAbout Us
Quick Search  
DowloadSupport
Home > Products
Product title  
Windows Products
What COBOL for Me?
NetCOBOL for .NET
NeoKicks
NeoBatch®
NeoSort
NeoData
EZ Source™
NetCOBOL for Windows
PowerCOBOL
PowerBSORT
PowerFORM
Data Converter
Data Editor
Training Videos
Unix Products
NetCOBOL for Linux
NetCOBOL for SPARC Arch
Data Converter (SPARC Arch)
Data Editor (SPARC Arch)
NetCOBOL for HPUX
PowerBSORT

 

 

PowerBSORT


Contents

PowerBSORT significantly shortens the time needed to merge or sort data for business processing. You get rapid, high-performance merging and sorting of large volumes of data without disrupting your current environment. PowerBSORT thus offers a straightforward way to slash response times for merges and sorts.

 

Highlights

  • Improve merge/sort times by as much as 100% over other solutions
  • Boost the efficiency of data searches by loading sorted data into DBMS tables
  • Simplify merge, sort, and copy operations with an easy-to-use interface
  • Speed processing without extra programming effort or disruption to your environment

PowerBSORT handles a variety of file types. It sorts and merges Btrieve files and COBOL85 files directly on Windows 98/Me/NT/2000/XP/2003 platforms.

Additionally, you have flexibility in the way you use PowerBSORT. You can include PowerBSORT in both COBOL and C-language applications.

Along with the merge, sort, and copy functions, PowerBSORT provides a record reconstruction feature that creates an output record by relocating and combining fields from the input record with self-defined values. Further, a same-key feature combines values from multiple records into a single record by adding the summation field values when records have the same key field value. The same-key feature is used with the sort or merge functions.

All the features of PowerBSORT are easy to use, with menus and a tool bar making choices clear. PowerBSORT gives you more than one way to perform many actions. When specifying a sort key, for example, you can either type the specification or use a specialized dialog box. A key can also be selected from the list of previously specified key fields by clicking PowerBSORT's History button. Detailed on-line help is always available.

Tests have shown that PowerBSORT merges and sorts data approximately 30% faster than the sort function in COBOL. You can shorten sort times even more using the PowerBSORT command window. By substituting PowerBSORT for the merge/sort utility you currently use, you gain immediate productivity improvements.



PowerBSORT Features

  • SORT – sort records in a specified sequence
  • MERGE- merge sorted records
  • COPY - output records from one file to another
  • Record Selection - select records to SORT, MERGE or COPY
  • Record Reconstruction - pick up the specified field of an input record, and reconstruct the record during sorting, merging or copying
  • Same Key - during SORT or MERGE you can output records according to the input order, delete all records except only one record, combine records into one record by summing up the summary field values for the records with the same key.
  • Supported Files - NetCOBOL files, Btrieve files,
  • Data Types - ASCII Code (compares as passed as 8 bits)
  • Fixed Point Binary Number (C integer type)… Big Endian/Little Endian
  • Floating Point Binary Number
  • Packed Decimal Number and External Decimal Number in COBOL

Detailed Features and Benefits

The table below lists key features and benefits of PowerBSORT.

New in: Feature Summary Detail of Feature Benefit of Feature
  Sort/Merge/Select/ Sum/Reconstruct files

PowerBSORT provides the following sort and related functions for COBOL, text and binary files:

Sort records by a specified key.

Merge files according to the order specified by a key field.

Copy files from one organization to another.

Select records from files.

Combine two or more records, summing a specified field.

Use input data to create different record structures in the output file.

You can sort files without having to write special programs.

+V4 Windows interface PowerBSORT has an improved Windows interface so that you can control your sort/merge/copy operations interactively. Achieve your sort/merge results quickly by pointing and clicking.

+V4 Sorts COBOL relative files PowerBSORT can now sort COBOL relative files as well as the other COBOL file formats. You can apply PowerBSORT functions to the full of COBOL file organizations.

  Callable from C PowerBSORT includes subroutines that can be called from C. Enhance your C applications with the functions of PowerBSORT.

  Callable from VB PowerBSORT includes an OCX control so that you can invoke its functions from Visual Basic. Enhance your Visual Basic applications with the functions of PowerBSORT.

"+Vn" in the "New" column indicates a feature that contains new or improved elements as well as existing elements. When "+Vn" is in Italics, it refers to the italicized detail items. The number n indicates the release in which the new feature was introduced.

 

An In-Depth Look at PowerBSORT
The following sequence of screen captures lets you see the features of PowerBSORT at work. The screen captures are taken from PowerBSORT's interactive interface supplied with the Enterprise Edition of NetCOBOL (previously called Fujitsu COBOL); you can of course call PowerBSORT directly from your programs without going through the interactive interface.

PowerBSORT's Interactive Interface
Sorting
Specifying Key Fields
Range of Key Field Types
Summing

PowerBSORT's Interactive Interface
PowerBSORT provides a handy interactive interface for performing file sorts and merges. This can be useful for one-off operations, or for checking sort parameters before cementing them in your code.






Sorting
With PowerBSORT's interactive interface sorting is straightforward and fast: specify the file to be sorted with its format, the output file with format, the key field and record length, and away you go! The "View" buttons take you to dialogs to help you select files or setup the key fields.




Specifying Key Fields
Key field specification couldn't be easier. PowerBSORT gives you a preview of the records. You can either enter the key field offset and length or select the appropriate area in the record contents window.




Range of Key Field Types
PowerBSORT can cope with many types of keys - simply select the type from the pull-down list.





Summing
One of PowerBSORT's useful extra features is the ability to sum particular fields for records that have identical keys. For example you may want to combine all sales records for a region into a single record with the total figure for all the sales - this is a quick and easy operation with PowerBSORT. It can be performed at the same time as sorting or merging files. Other "extras" are the ability to select which records to include in the output file, and to construct output records from a mixture of input record fields and data you specify.

Platforms Supported

  • Microsoft® Windows® 98
  • Microsoft® Windows® Me
  • Microsoft® Windows® NT
  • Microsoft® Windows® 2000
  • Microsoft® Windows® Server 2003

Frequently Asked Questions

1. What are the run-time charges for using PowerBSORT?

Answer: You need to have a PowerBSORT license for any machine using PowerBSORT. Contact your NetCOBOL sales rep for details of volume pricing.



2. How much can PowerBSORT speed up my COBOL program sorts?

Our tests indicate PowerBSORT improves sort speeds by a factor of around 30%.


3. From which products can I use the PowerBSORT OCX?

Answer: Any OCX compliant tool should support the PowerBSORT OCX. We have done extensive testing with Visual Basic.


4. Where is PowerBSORT documented?

Answer: There are three help files in the PowerBSORT folder and another that you can access from the Properties dialog box for the OCX control. These provide extensive information about using PowerBSORT. To open a help file double click on the help file name in Windows Explorer.


5. Can this work like mainframe sorts - for example to do batch sorting?

Answer: Yes - PowerBSORT has a command line interface that enables you to create batch or command files to drive sorts. For one-off sort tasks you can use the interactive interface that helps you enter the data to drive a sort in a quick and friendly manner.


6. How helpful is PowerBSORT in Y2K scenarios?

Answer: PowerBSORT handles 4 digit dates. It also allows you to do windowing of dates - so data containing dates can be sorted in the order of sliding date windows.


 © 2003 - 2006 Fujitsu Computer Systems Corporation. All Rights Reserved.