SY400 – Batch Program to allow updates of the database
Before running this make sure there is 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, SY400. 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 SY400.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: Column Name should exist in USER_TAB_COLUMNS 19. PARAM3 NEW VALUE: Enter 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.
RUNTIME RESULTS
Start Time =
=========================================
JUR : 000
TAXYR : 2001
ID1 : MR01
ID2 : MR01
PARAM1 (Table
Name) : NRPCLVAL
PARAM2
(Column Name) : ASSROVER
PARAM3
(Updated Value):
=========================================
Total Records
updated: 1
=========================================
End Time =
Updated 7/25/2006