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     Control File for SOX Compliance

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Control File for SOX Compliance
 Login/Join
 
Member
posted
We send WebFOCUS built data files to outside Agencies, and for SOX compliance need to supply a Control File. The Control file supplies pertinent data about the data file being delivered. Representative information on the Control File is:

Data File Name = name of the data file
Sending System Name = name of the company sending the data file
# of records = number of records on the data file
Size in bytes = size of data file in bytes
Creation Date = creation date of the data file
Creation Time = creation time of the data file
Control amount = total amount of the controlling field, To be determined


WebFOCUS 716 MVS DB2 AIX UDB
 
Posts: 18 | Registered: November 14, 2005Report This Post
Master
posted Hide Post
Are you trying to use WebFocus to create the control record as well as the file? What is your question?


Pat
WF 7.6.8, AIX, AS400, NT
AS400 FOCUS, AIX FOCUS,
Oracle, DB2, JDE, Lotus Notes
 
Posts: 755 | Location: TX | Registered: September 25, 2007Report This Post
Member
posted Hide Post
My questions are: does WebFOCUS have the capability of creating that kind of data? If so how? If not how have other Developers dealt with such a request?


WebFOCUS 716 MVS DB2 AIX UDB
 
Posts: 18 | Registered: November 14, 2005Report This Post
Expert
posted Hide Post
You can FILEDEF a file and do -WRITE commands to it to put in information in it.

You can use &LINES for the number of records and other system variables for the date and time. For the size in bytes, you could possibly put the results of an operating system command into a file that you could -READ to get that info.

You are going to need to be creative but I see no reason why you can't do this in WebFOCUS.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Master
posted Hide Post
Let me rephrase my question. Are you creating a control record that will be part of the file or are you extracting data for an EDI transfer? The way you extract the information is pretty much the same, but what you do with it is different. The hard parts are the size in bytes and the total. If you only need a grand total: run your fex and create your file, save your &LINES in another variable, create a second fex that reads your held file as input and sum just the total. Then -READ it into a variable. I can't remember if there is a way in MVS to get the file size from the system, check your user manual under PDS or calculate the number of records * the lrecl. Put all of your system data (either hard coded or in variables) into 1 record and -WRITE it to a file. Concatenate the two files.

If you have multiple control values (say one for each location) this gets to be much harder, but the general logic is the same. If you are creating EDI records the extraction process is much the same and you build it around your fex.


Pat
WF 7.6.8, AIX, AS400, NT
AS400 FOCUS, AIX FOCUS,
Oracle, DB2, JDE, Lotus Notes
 
Posts: 755 | Location: TX | Registered: September 25, 2007Report 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     Control File for SOX Compliance

Copyright © 1996-2020 Information Builders