Purpose: Use Work with File Sets to work with a set of selected files within CWDirect.
You can use a file set to:
• copy the selected files from a specified library and company to another specified library and company. For example, you can copy files from an existing company to a company you have just created, or from a production environment to a test environment.
• reorganize the files to enhance system performance. For example, you can remove deleted records in a file to reduce the file size.
In this topic:
• Enter File Set Details Screen
• Selecting, Deleting, and Displaying Files for a File Set:
• Submit Copy File Set Pop-up Window
• Work with Files for Reorganization Screen
How to display this screen: Enter WFST in the Fast path field at the top of any menu or select Work with File Sets from a menu.
MSR0352 DISPLAY Work with File Sets 5/07/99 14:37:54
Opt Set Description
Type options, press Enter. 2=Change 4=Delete 5=Enter File Set Details 9=Submit Copy File Set 20=W/W for File Reorg
ALL ALL FILES (USED TO DELETE COMPANY DATA) BFS BASE FILE SET CLN CLEAN UP OLD COMPANIES DDT COMPANY FILE SET UP (COPY OF PT1) DWM FILE SET EMB RESET COMPANY ITEM FILES HNJ HNJ COPY FILE SETS JMN JMN FILE SET KAL ALL FILES LIZ SECURED FEATURES COPY LJM QA FILE SET +
F3=Exit F6=Create F12=Cancel |
Field |
Description |
Set |
A code for a set of files. Alphanumeric, 3 positions; optional. |
Description |
A description of a set of files. Alphanumeric, 40 positions; optional. |
Screen Option |
Procedure |
Create a file set |
Press F6 to advance to the Create File Set Screen. |
Change a file set |
Enter 2 next to a file set to advance to the Change File Set Screen. |
Delete a file set |
Enter 4 next to a file set to delete it. |
Select the files for a file set |
Enter 5 next to a file set to advance to the Enter File Set Details Screen. |
Copy the files in a file set from one library and company to another library and company |
Enter 9 next to a file set to advance to the Submit Copy File Set Pop-up Window. |
Remove, select, unselect or submit a file for reorganization |
Enter 20 next to a file set to advance to the Work with Files for Reorganization Screen. |
Purpose: At this screen you can define the file set code and description of the file set. To select the files for the file set, use the Enter File Set Details Screen.
How to display this screen: On the Work with File Sets Screen, press F6.
MSR0353 ENTER Create File Set 5/07/99 14:55:47
Set code . . . . . .
Description . . . .
F3=Exit F12=Cancel |
Field |
Description |
Set code |
A code that represents a set of files, for example system control values and secured features. Alphanumeric, 3 positions. Create screen: required. Change screen: display-only. |
Description |
A description of the file set. Alphanumeric, 40 positions; required. |
To change: Enter 2 next to a file set you wish to change at the Work with File Sets Screen to advance to the Change File Set screen.
At this screen you can change only the File set description field. See the Create File Set Screen for a description of the fields on this screen.
Purpose: Use this screen to define the files you wish to include in your file set. At this screen you can select a file to include in the file set or delete a file from the file set. Once you are comfortable with the files you have defined, you can review the files that you have selected.
How to display this screen: On the Work with File Sets Screen, enter 5 next to a file set.
MSR0355 DISPLAY Enter File Set Details 5/07/99 15:33:14
Set code KAL KAL FILE SET - ALL FILES
Filename File Appl
Type options, press Enter. 1=Add to set 4=Delete from set
A/P Batch APAPBP A/P Check APCHCK A/P Check Invoice APCKIN A/P Check Name/Addr Ovrrd APCHKE A/P Invoice Detail APINDT A/P Invoice Detail Hist APINDH A/P Invoice Header APINHD A/P Invoice Header Hist APINHH A/P Invoice Header Note APIHNT A/P Invoice Header Work APINHW +
F3=Exit F8=Toggle all/selected F12=Cancel |
Field |
Description |
Set code |
The code and description of the file set for which you are selecting files. Set code: Alphanumeric, 3 positions; display-only. Set description: Alphanumeric, 40 positions; display-only. |
Filename |
The description of a CWDirect file. Alphanumeric, 25 positions; optional. |
File |
The system name for a CWDirect file. Alphanumeric, 10 positions; optional. |
Appl (Application area) |
The application area assigned to a file. You can assign a file to an application area in order to group related files together; for example an application area of O/E indicates that files assigned this area are related to order entry. Alphanumeric, 3 positions; optional. |
Selecting, Deleting, and Displaying Files for a File Set:
Screen Option |
Procedure |
Add a file to the file set |
Enter 1 next to a file to add it to the file set. The system highlights the file in a different color to indicate the file is selected. See the sample of selected files, below. |
Delete a file from the file set |
Enter 4 next to a file to delete it from the file set. |
Toggle between displaying all files and displaying only selected files |
Enter F8. The system toggles between displaying all files and displaying only the files that you have selected for the file set. |
MSR0355 DISPLAY Enter File Set Details 5/07/99 16:03:48
Set code KAL SCVS AND SECURED FEATURES
Filename File Appl
Type options, press Enter. 1=Add to set 4=Delete from set
SCV Transactions SCVTRN Secure Feature INSECF Secure Feature Help MSSFHP System Control Value MSCTLV System Control Value Help MSSCVH
F3=Exit F8=Toggle all/selected F12=Cancel |
Submit Copy File Set Pop-up Window
Purpose: Use this window to copy a file set from one library and company to another library and company.
Note: The Item Tax Exemption file and the Zip/City/State files are not included when you copy a file set.
About copying e-commerce related files: If the file set you want to copy includes e-commerce related files, you must first remove the triggers from these files before copying, and then add the triggers to the files when you are finished. Triggers are programs which monitor the download files for changes and initiate download notifications when changes occur. The files which include such triggers are:
• Item (INITEM)
• SKU (INSKU)
• Item Offer (INIOFR)
• Item Price (INIPRC)
• SKU Offer (INSKOF)
• SKU Price (INSPRC)
To remove triggers from e-commerce related files, follow these steps:
1. End all batch jobs, including ASYNC jobs, in the environment from which you are copying files.
2. All other users must exit the environment.
3. At a command line, enter: CALL ECC0185 ’RMV’. This command will remove triggers from all necessary files within the environment.
After you have copied the files, replace the triggers, following these steps:
1. End all batch jobs, including ASYNC jobs, in the environment from which you are copying files.
2. All other users must exit the environment.
3. At a command line, enter: CALL ECC0185 ’ADD’. This command will replace triggers from all necessary files within the environment.
How to display this screen: Enter 9 next to a file set at the Work with File Sets Screen.
Submit Copy File Set
Set code: KAL KAL FILE SET - ALL FILES
Library Company Copy from . . . . . . . . . . CWM35QDTA Copy to . . . . . . . . . . . CWM35QDTA
Perform copy function? . . . . . . . . . . . Delete destination company before copy? . .
F12=Cancel
|
Field |
Description |
Set code |
The code and description of the file set you wish to copy. File set code: Alphanumeric, 3 positions; display-only. File set description: Alphanumeric, 40 positions; display-only. |
Copy from library |
The name of the source library from which the files in the file set will be copied. The library for the company you are currently in defaults, but you can override it. Alphanumeric, 10 positions; required. |
Copy from company |
The code of the company from which the files in the file set will be copied. Numeric, 3 positions; required. |
Copy to library |
The name of the destination library to which the files in the file set will be copied. The library for the company you are currently in defaults, but you can override it. Alphanumeric, 10 positions; required. |
Copy to company |
The code of the company to which the files in the file set will be copied. Numeric, 3 positions; required. |
Perform copy function |
This field indicates whether you wish the files from the source library and company to be copied to the destination library and company. Valid values are: Y = Copy the files from the source company's library to the destination company's library. When you copy files to a destination company, the system replaces the existing files. N = Delete the files in the current file set from the destination company so that the system can purge the files. Alphanumeric, 1 position; required. |
Delete destination company before copy? |
This field indicates whether the files defined in the file set are cleared from the target company before you perform the copy, regardless of the value you defined in the Perform copy function field. Valid values are: Y = Delete the selected files from the target company. N = Do not delete the selected files from the target company. If there are currently any records in a selected file for the target company, the file will not be copied from the source company. You should set this field to N if you are copying files from an existing company to a new company. Alphanumeric, 1 position; required. |
Work with Files for Reorganization Screen
Purpose: Use this screen to delete records from selected files in order to reduce the file's size and increase system performance.
You can:
• remove a file from the list of files that you wish to reorganize.
• select a file for reorganization.
• unselect a file for reorganization.
• submit a file for reorganization
How to display this screen: On the Work with File Sets Screen, enter 20 next to a file set.
MSR0466 DISPLAY Work with Files for Reorganization 5/10/99 8:46:41 KAL Co. Set code KAL KAL FILE SET - B2B ORDER Deleted Total Percent Opt File File name Records Records Deleted Sts
Type options, press Enter. 4=Remove From List 7=Select 8=Unselect
BBDDTL B2B Distribution Details 1 18 5.55 BBDIST B2B Distribution 2 8 25.00 BBOMSG B2B Override Messages 0 0 .00 N BBOVER B2B Override 0 0 .00 N
F3=Exit F7=Submit Selected Files F8=Submit All Files |
Field |
Description |
Set code |
The code and description of the file set you selected. Set code: Alphanumeric, 3 positions; display-only. Set description: Alphanumeric, 40 positions; display-only. |
File |
The system name for a CWDirect file. Alphanumeric, 10 positions; optional. |
File name |
The description of a CWDirect file. Alphanumeric, 25 positions; optional. |
Deleted records |
The current number of deleted records in this file. Numeric, 10 positions; display-only. |
Total records |
The total number of records in the file, including the number of deleted records. Numeric, 10 positions; display-only. |
Percent deleted |
The percentage of deleted records in the file. Numeric, 6 positions; display-only. |
Sts (Reorganization status) |
This field indicates whether the file is available for reorganization. Valid values are: blank = The file is available for reorganization. D = The file is deleted N = The file is not available for reorganization. R = The file has been submitted for reorganization. S = The file is selected for reorganization. Alphanumeric, 1 position; display-only. |
Screen Option |
Procedure |
Remove a file from the list |
Enter 4 next to a file. The system removes the file from the screen. |
Select a file for reorganization |
Enter 7 next to a file. The system places the file in an S (selected) status. |
Unselect a file for reorganization |
Enter 8 next to a file. The system places the file in a blank (available for reorganization) status. |
Submit the selected files for reorganization |
Select F7 to submit all of the selected files for reorganization. The system displays a message similar to the following indicating the files have been submitted: Job 045791/KLETENDRE/RGZBBDDTL submitted to job queue QBATCH in library QGPL. |
Submit all files in the file set for reorganization |
Select F8 if you wish to submit all of the files in the file set that include deleted records for reorganization. This allows you to reorganize all of the files that include deleted records without entering 7 next to each file. |
| Working with Default Options (WDFT) | Contents | SCVs | Search | Glossary | Reports | Solutions | XML | Index | Consolidating Order Billing History (MOBH) |
SO03_07 CWDirect 18.0.x 2018 OTN