 |
|||||
|
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
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. | |||||
Read-Only TopicGo | Search | Notify | Tools |
| Control File for SOX Compliance | Login/Join |
| Member |
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 | ||
|
| Master |
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 | |||
|
| Member |
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 | |||
|
| Expert |
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 | |||
|
| Master |
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 | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |