Fileaid tool

Access all standard file types regardless of record length or format for application integration Compare data files or objects to simplify the test results validation process Reformat files by easily modifying an existing file format instead of starting from scratch Extract and load related subsets of data from multiple databases and files Ensure all test conditions are met by selecting the precise application test data you need Customize test data for a particular application and specific conditions Automate these activities using tools you already own, such as Jenkins.

Get powerful IMS test data management. Take charge of your Db2 test data. Quickly browse and edit Db2 data Edit multiple tables simultaneously Manage Db2 objects Gauge the impact of column changes.

Extract and load related subsets of data from multiple databases and files Ensure all test conditions are met by selecting the precise application test data you need Customize test data for a particular application and specific conditions Automate these activities using tools you already own, such as Jenkins. Getting started with File-AID is easy.

Contact BMC Sales. After giving the selection criteria press F3, it takes you to the previous screen Selection criteria Menu , there you can save these criteria for future use or you can just press F3 to display the results.

Here the advantage is once we have specified the selection criteria as specified above, we can also save it to the PDS members so that when we want to browse the dataset with same selection criteria, we can just specify the PDS and member name in the main browse screen as shown below:. If we want to Modify the previous selection criteria we can do it M Modify option.

All the selection criteria saving and using the saved dataset is same as formatted criteria. Here the way of using the selection criteria is different.

Here it uses the positions instead of the layout variables. Give the criteria as shown above and press enter and go back it displays the result. Most of the options are self explanatory. This option is used to check the layout of a copy book.

This is much useful for checking the layout; find the length, position of each variable in the copybook. It also shows you the errors if any in the layout. This is much useful to check any errors in very big file layouts. Ex: If accidentally I have given 05 level I between 03 levels as below.

We have already discussed about this in detail in my previous posts. Let us see option 2. INPUT' is the input data set which conatains data. New Screen will be displayed which contains data. This screen shows data record by record, If you want to go to next record press F11 , for previous record F Also used for Copy the records from one file to another partial record or condition can be included.

This file should already exist. Also the length of the file is greater than and in VB format. Don't need to present already. Once you enetered the details. Press Enter.