NR404 – Batch Program to allow updates of the database

NR404 updates a particular column in the database with a new value. For example, it can update status, or return filed flag, or production control flag, for selected parcels. Before running this make sure that we have a record in REPORTS table with the following Parameters: REPT = 'SY400' UPDFLG = 'Y' PLAB1 = 'Table Name' PLAB2 = 'Column Name' PLAB3 = 'New Value'

NOTE: The specific fields with permissible entries to be filled in or left blank are listed below. Ignore fields that are not in the list next to the screens.

Figure 1. SY41 (TOP)

1. Job: Report name should always appear here. For example, NR404. 2. Server Name: Keep the server name that first appears. 3. Printer_Name: Select a valid printer or keep the displayed printer if one is present. 4. Jurisdiction: Enter your jurisdiction. 5. Tax Year: Enter the current Tax Year. 6. Spool File Name: Enter NR404.LIS to create the file in text format. 13. FCU: Formatting code. Keep the default printer setting that is present when the screen appears. If blank, enter HPLP132. 14. WHERE_STMT: Additional where clause used to specify which records to select. Can also be Null. But if entered should start with fieldname (No AND/OR operator is required in the start) and if multiple fields are being used, AND/OR clause should be used in between fields. Field names being used should be valid fields of the Table. Program does not check for valid fields and if entered wrong, returns an ORACLE error. 17. PARAM1 TABLE NAME: Table Name, should exist in USER_TAB_COLUMNS. 18. PARAM2 COLUMN NAME: RETFLAG Table Name, should exist in USER_TAB_COLUMNS. 19. PARAM3 NEW VALUE: New Value which is to be updated to the table and column specified above

Figure 2. SY 41 (BOTTOM)

Press [Submit Job]. The system will notify you when the report is finished.

Updated 7/24/2006