Focal Point
Control File for SOX Compliance

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/8411044272

February 19, 2008, 02:14 PM
Ed Hogan
Control File for SOX Compliance
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
February 20, 2008, 11:39 AM
PBrightwell
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
February 20, 2008, 11:57 AM
Ed Hogan
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
February 20, 2008, 12:31 PM
GinnyJakes
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
February 21, 2008, 10:51 AM
PBrightwell
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