OS/2 Shareware BBS: 8 Other

home *** CD-ROM | disk | FTP | other *** search

/ OS/2 Shareware BBS: 8 Other / 08-Other.zip / e52os2m.exe / db2sqlc0.bnd (.txt) < prev next >

Wrap

DB2 Bind | 1998-05-27 | 42KB | 440 lines

BIND V02 DB2SQLC0QAJXQHCMNETFIN 0 NETFIN INCLUDE SQLCA BEGIN DECLARE SECTION END DECLARE SECTION CONNECT TO :Db_Name IN SHARE MODE USER :User_ID USING :Password CONNECT RESET COMMIT ROLLBACK INSERT INTO NETFIN.BASE (SYSTEM_ID, MANAGING_ID, GROUP_NAME, OPERATING_SYSTEM, VERSION, MEMORY_OPERATING, MEMORY_BASE, MEMORY_USABLE, MEMORY_BOARD, MEMORY_ADAPTER, MEMORY_CACHEABLE, REFERENCE_DISK, NVRAM, DEDICATED_IRQ, SHARED_IRQ, PARALLEL_PORTS, SERIAL_PORTS, SYSTEM_SERIAL, PLANAR_ID, PLANAR_SERIAL, PROCESSOR_CARD_SER, BASE_DATE, BASE_TIME) VALUES (:System_Id, :Managing_Id:Managing_Id_Ind, :Group_Name:Group_Name_Ind, :Operating_System:Operating_System_Ind, :Version:Version_Ind, :Memory_Operating:Memory_Operating_Ind, :Memory_Base:Memory_Base_Ind, :Memory_Usable:Memory_Usable_Ind, :Memory_Board:Memory_Board_Ind, :Memory_Adapter:Memory_Adapter_Ind, :Memory_Cacheable:Memory_Cacheable_Ind, :Reference_Disk:Reference_Disk_Ind, :Nvram:Nvram_Ind, :Dedicated_Irq:Dedicated_Irq_Ind, :Shared_Irq:Shared_Irq_Ind, :Parallel_Ports:Parallel_Ports_Ind, :Serial_Ports:Serial_Ports_Ind, :System_Serial:System_Serial_Ind, :Planar_Id:Planar_Id_Ind, :Planar_Serial:Planar_Serial_Ind, :Processor_Card_Ser:Processor_Card_Ser_Ind, :Base_Date, :Base_Time) DELETE FROM NETFIN.BASE WHERE SYSTEM_ID = :System_Id INSERT INTO NETFIN.DISKETTE (SYSTEM_ID, LOGICAL_DRIVE, DEVICE_TYPE) VALUES (:System_Id, :Logical_Drive:Logical_Drive_Ind, :Device_Type:Device_Type_Ind) DELETE FROM NETFIN.DISKETTE WHERE SYSTEM_ID = :System_Id INSERT INTO NETFIN.DISPLAY (SYSTEM_ID, DISPLAY_ADAPTER, DISPLAY_TYPE, VIDEO_MEMORY, COLORS, HORIZONTAL_RES, VERTICAL_RES, HORIZONTAL_SIZE, VERTICAL_SIZE, VIDEO_SUBSYSTEM, SLOT_LOCATION) VALUES (:System_Id, :Display_Adapter:Display_Adapter_Ind, :Display_Type:Display_Type_Ind, :Video_Memory:Video_Memory_Ind, :Colors:Colors_Ind, :Horizontal_Res:Horizontal_Res_Ind, :Vertical_Res:Vertical_Res_Ind, :Horizontal_Size:Horizontal_Size_Ind, :Vertical_Size:Vertical_Size_Ind, :Video_Subsystem:Video_Subsystem_Ind, :Slot_Location:Slot_Location_Ind) DELETE FROM NETFIN.DISPLAY WHERE SYSTEM_ID = :System_Id INSERT INTO NETFIN.EXPANSION_SLOT (SYSTEM_ID, SLOT, BUS_TYPE, BUS_NUMBER, ADAPTER_ID, ADAPTER_TYPE) VALUES (:System_Id, :Slot:Slot_Ind, :Bus_Type:Bus_Type_Ind, :Bus_Number:Bus_Number_Ind, :Adapter_Id:Adapter_Id_Ind, :Adapter_Type:Adapter_Type_Ind) DELETE FROM NETFIN.EXPANSION_SLOT WHERE SYSTEM_ID = :System_Id INSERT INTO NETFIN.FIXED_DISK (SYSTEM_ID, DISK_CAPACITY, DISK_CYLINDERS, SECTORS_PER_CYL, DISK_HEADS, DISK_TOTAL_SECTORS, PHYSICAL_DRIVE) VALUES (:System_Id, :Disk_Capacity:Disk_Capacity_Ind, :Disk_Cylinders:Disk_Cylinders_Ind, :Sectors_Per_Cyl:Sectors_Per_Cyl_Ind, :Disk_Heads:Disk_Heads_Ind, :Disk_Total_Sectors:Disk_Total_Sectors_Ind, :F_Physical_Drive:F_Physical_Drive_Ind) DELETE FROM NETFIN.FIXED_DISK WHERE SYSTEM_ID = :System_Id INSERT INTO NETFIN.LOGICAL_DRIVE (SYSTEM_ID, LOGICAL_NAME, VOLUME_NAME, FILE_SYSTEM, FILE_ATTACH, DRIVE_TYPE, SECTORS_CLUSTER, SECTORS_BYTES, DEVICE_CAPACITY, AVAILABLE_SPACE, PHYSICAL_DRIVE) VALUES (:System_Id, :Logical_Name:Logical_Name_Ind, :Volume_Name:Volume_Name_Ind, :File_System:File_System_Ind, :File_Attach:File_Attach_Ind, :Drive_Type:Drive_Type_Ind, :Sectors_Cluster:Sectors_Cluster_Ind, :Sectors_Bytes:Sectors_Bytes_Ind, :Device_Capacity:Device_Capacity_Ind, :Available_Space:Available_Space_Ind, :L_Physical_Drive:L_Physical_Drive_Ind) DELETE FROM NETFIN.LOGICAL_DRIVE WHERE SYSTEM_ID = :System_Id INSERT INTO NETFIN.KEYBOARD (SYSTEM_ID, KEYBOARD_TYPE, COUNTRY_CODE, SUBCOUNTRY_CODE, CODE_PAGE) VALUES (:System_Id, :Keyboard_Type:Keyboard_Type_Ind, :Country_Code:Country_Code_Ind, :Subcountry_Code:Subcountry_Code_Ind, :Code_Page:Code_Page_Ind) DELETE FROM NETFIN.KEYBOARD WHERE SYSTEM_ID = :System_Id INSERT INTO NETFIN.MODEL (SYSTEM_ID, MODEL_NAME, EXPANSION_BUS, MODEL_NUMBER, SUBMODEL_NUMBER, BIOS_REVISION, BIOS_DATE) VALUES (:System_Id, :Model_Name:Model_Name_Ind, :Expansion_Bus:Expansion_Bus_Ind, :Model_Number:Model_Number_Ind, :Submodel_Number:Submodel_Number_Ind, :Bios_Revision:Bios_Revision_Ind, :Bios_Date:Bios_Date_Ind) DELETE FROM NETFIN.MODEL WHERE SYSTEM_ID = :System_Id INSERT INTO NETFIN.MOUSE (SYSTEM_ID, MOUSE_TYPE, MOUSE_BUTTONS) VALUES (:System_Id, :Mouse_Type:Mouse_Type_Ind, :Mouse_Buttons:Mouse_Buttons_Ind) DELETE FROM NETFIN.MOUSE WHERE SYSTEM_ID = :System_Id INSERT INTO NETFIN.PRINTER (SYSTEM_ID, PRINTER_PORT, PRINT_QUEUE, PRINTER_DRIVER, PRINTER_MODEL) VALUES (:System_Id, :Printer_Port:Printer_Port_Ind, :Print_Queue:Print_Queue_Ind, :Printer_Driver:Printer_Driver_Ind, :Printer_Model:Printer_Model_Ind) DELETE FROM NETFIN.PRINTER WHERE SYSTEM_ID = :System_Id INSERT INTO NETFIN.PROCESSOR (SYSTEM_ID, PROCESSOR, CO_PROCESSOR, PROCESSOR_SPEED, INTERNAL_CACHE, EXTERNAL_CACHE, PLANAR_SPEED, PROCESSOR_NUMBER) VALUES (:System_Id, :Processor:Processor_Ind, :Co_Processor:Co_Processor_Ind, :Processor_Speed:Processor_Speed_Ind, :Internal_Cache:Internal_Cache_Ind, :External_Cache:External_Cache_Ind, :Planar_Speed:Planar_Speed_Ind, :Processor_Number:Processor_Number_Ind) DELETE FROM NETFIN.PROCESSOR WHERE SYSTEM_ID = :System_Id INSERT INTO NETFIN.SYSLEVEL (SYSTEM_ID, PRODUCT_NAME, PRODUCT_VERSION, COMPONENT_ID, CURRENT_CSD, PREVIOUS_CSD) VALUES (:System_Id, :Product_Name:Product_Name_Ind, :Product_Version:Product_Version_Ind, :Component_Id:Component_Id_Ind, :Current_Csd:Current_Csd_Ind, :Previous_Csd:Previous_Csd_Ind) DELETE FROM NETFIN.SYSLEVEL WHERE SYSTEM_ID = :System_Id INSERT INTO NETFIN.MEMORY (SYSTEM_ID, CONNECTOR_ID, MEMORY_SIZE, MEMORY_SPEED, MEMORY_TYPE) VALUES (:System_Id, :Connector_Id:Connector_Id_Ind, :Memory_Size:Memory_Size_Ind, :Memory_Speed:Memory_Speed_Ind, :Memory_Type:Memory_Type_Ind) DELETE FROM NETFIN.MEMORY WHERE SYSTEM_ID = :System_Id INSERT INTO NETFIN.DASD_ADAPTER (SYSTEM_ID, PHYSICAL_UNIT, LOGICAL_UNIT, DASD_BUS_TYPE, DASD_SLOT, BUS_ATTRIBUTES, IO_ACCESS, HOST_BUS, HOST_BUS_WIDTH, MAX_SCATTER, MAX_CDB, ADD_MAJOR, ADD_MINOR, DASD_DEVICES) VALUES (:System_Id, :Physical_Unit:Physical_Unit_Ind, :Logical_Unit:Logical_Unit_Ind, :Dasd_Bus_Type:Dasd_Bus_Type_Ind, :Dasd_Slot:Dasd_Slot_Ind, :Bus_Attributes:Bus_Attributes_Ind, :Io_Access:Io_Access_Ind, :Host_Bus:Host_Bus_Ind, :Host_Bus_Width:Host_Bus_Width_Ind, :Max_Scatter:Max_Scatter_Ind, :Max_Cdb:Max_Cdb_Ind, :Add_Major:Add_Major_Ind, :Add_Minor:Add_Minor_Ind, :Dasd_Devices:Dasd_Devices_Ind) DELETE FROM NETFIN.DASD_ADAPTER WHERE SYSTEM_ID = :System_Id INSERT INTO NETFIN.DASD_DEVICE (SYSTEM_ID, DASD_SIZE, DASD_TYPE, UNIT_PUN, UNIT_LUN, ANSI_LEVEL, UNIT_STATUS, VENDOR_ID, PRODUCT_ID, PRODUCT_REVISION) VALUES (:System_Id, :Dasd_Size:Dasd_Size_Ind, :Dasd_Type:Dasd_Type_Ind, :Unit_Pun:Unit_Pun_Ind, :Unit_Lun:Unit_Lun_Ind, :Ansi_Level:Ansi_Level_Ind, :Unit_Status:Unit_Status_Ind, :Vendor_Id:Vendor_Id_Ind, :Product_Id:Product_Id_Ind, :Product_Revision:Product_Revision_Ind) DELETE FROM NETFIN.DASD_DEVICE WHERE SYSTEM_ID = :System_Id INSERT INTO NETFIN.SYSTEM_PROFILE (SYSTEM_ID, MODEL_NAME, MODEL_NUMBER, SYSTEM_SERIAL, SYSTEM_BOARD_SER, PROCESSOR_CARD_SER, SYSTEM_PURCHASED, DISPLAY_MODEL, DISPLAY_SERIAL, DISPLAY_PURCHASED, PRINTER_MODEL, PRINTER_SERIAL, PRINTER_PURCHASED, MODEM_MODEL, MODEM_SERIAL, MODEM_PURCHASED) VALUES (:System_Id, :Profile_Model_Name:Profile_Model_Name_Ind, :Profile_Model_Number:Profile_Model_Number_Ind, :Profile_System_Serial:Profile_System_Serial_Ind, :System_Board_Ser:System_Board_Ser_Ind, :P_Processor_Card_Ser:P_Processor_Card_Ser_Ind, :System_Purchased:System_Purchased_Ind, :Display_Model:Display_Model_Ind, :Display_Serial:Display_Serial_Ind, :Display_Purchased:Display_Purchased_Ind, :Profile_Printer_Model:Profile_Printer_Model_Ind, :Printer_Serial:Printer_Serial_Ind, :Printer_Purchased:Printer_Purchased_Ind, :Modem_Model:Modem_Model_Ind, :Modem_Serial:Modem_Serial_Ind, :Modem_Purchased:Modem_Purchased_Ind) DELETE FROM NETFIN.SYSTEM_PROFILE WHERE SYSTEM_ID = :System_Id INSERT INTO NETFIN.SYSTEM_USER (SYSTEM_ID, FIRST_NAME, MIDDLE_NAME, LAST_NAME, EMPLOYEE_ID, TITLE, DEPT_NAME, DEPT_NUMBER, DIVISION, START_DATE, SHIFT, SCHEDULED_START, SCHEDULED_END, HOME_PHONE, HOME_STREET1, HOME_STREET2, HOME_CITY, HOME_STATE, HOME_ZIP, HOME_COUNTRY, EMERGENCY_NAME, EMERGENCY_PHONE) VALUES (:System_Id, :First_Name:First_Name_Ind, :Middle_Name:Middle_Name_Ind, :Last_Name:Last_Name_Ind, :Employee_Id:Employee_Id_Ind, :Title:Title_Ind, :Dept_Name:Dept_Name_Ind, :Dept_Number:Dept_Number_Ind, :Division:Division_Ind, :Start_Date:Start_Date_Ind, :Shift:Shift_Ind, :Scheduled_Start:Scheduled_Start_Ind, :Scheduled_End:Scheduled_End_Ind, :Home_Phone:Home_Phone_Ind, :Home_Street1:Home_Street1_Ind, :Home_Street2:Home_Street2_Ind, :Home_City:Home_City_Ind, :Home_State:Home_State_Ind, :Home_Zip:Home_Zip_Ind, :Home_Country:Home_Country_Ind, :Emergency_Name:Emergency_Name_Ind, :Emergency_Phone:Emergency_Phone_Ind) DELETE FROM NETFIN.SYSTEM_USER WHERE SYSTEM_ID = :System_Id INSERT INTO NETFIN.SYSTEM_LOCATION (SYSTEM_ID, COMPANY_NAME, ADDRESS, CITY, STATE, ZIP_CODE, COUNTRY, SITE_NAME, OFFICE_NUMBER, BUILDING, FLOOR) VALUES (:System_Id, :Company_Name:Company_Name_Ind, :Address:Address_Ind, :City:City_Ind, :State:State_Ind, :Zip_Code:Zip_Code_Ind, :Country:Country_Ind, :Site_Name:Site_Name_Ind, :Office_Number:Office_Number_Ind, :Building:Building_Ind, :Floor:Floor_Ind) DELETE FROM NETFIN.SYSTEM_LOCATION WHERE SYSTEM_ID = :System_Id INSERT INTO NETFIN.SYSTEM_CONTACTS (SYSTEM_ID, INTERNAL_PHONE, EXTERNAL_PHONE, CELLULAR_PHONE, PAGER_NUMBER, FAX_NUMBER, EMAIL_ADDRESS, BACKUP_NAME, BACKUP_PHONE, TECHNICAL_NAME, TECHNICAL_PHONE, MANAGER_NAME, MANAGER_PHONE, SECRETARY_NAME, SECRETARY_PHONE) VALUES (:System_Id, :Internal_Phone:Internal_Phone_Ind, :External_Phone:External_Phone_Ind, :Cellular_Phone:Cellular_Phone_Ind, :Pager_Number:Pager_Number_Ind, :Fax_Number:Fax_Number_Ind, :Email_Address:Email_Address_Ind, :Backup_Name:Backup_Name_Ind, :Backup_Phone:Backup_Phone_Ind, :Technical_Name:Technical_Name_Ind, :Technical_Phone:Technical_Phone_Ind, :Manager_Name:Manager_Name_Ind, :Manager_Phone:Manager_Phone_Ind, :Secretary_Name:Secretary_Name_Ind, :Secretary_Phone:Secretary_Phone_Ind) DELETE FROM NETFIN.SYSTEM_CONTACTS WHERE SYSTEM_ID = :System_Id INSERT INTO NETFIN.SYSTEM_MISC (SYSTEM_ID, ENTRY_SLOT, MISC_INFO) VALUES (:System_Id, :Entry_Slot, :Misc_Info) DELETE FROM NETFIN.SYSTEM_MISC WHERE SYSTEM_ID = :System_Id INSERT INTO NETFIN.ALERT_LOG (SYSTEM_ID, ALERT_TEXT, ALERT_ID, ALERT_CLASS, SEVERITY, APPLICATION_ID, APPL_ALERT_TYPE, RECEIVED_FROM, SYSTEM_NAME, ALERT_DATETIME) VALUES (:System_Id, :Alert_Text:Alert_Text_Ind, :Alert_Id:Alert_Id_Ind, :Alert_Class:Alert_Class_Ind, :Severity:Severity_Ind, :Application_Id:Application_Id_Ind, :Appl_Alert_Type:Appl_Alert_Type_Ind, :Received_From:Received_From_Ind, :System_Name:System_Name_Ind, :Alert_Datetime:Alert_Datetime_Ind) DELETE FROM NETFIN.ALERT_LOG WHERE SYSTEM_ID = :System_Id INSERT INTO NETFIN.MONITOR_STATE (SYSTEM_ID, MONITOR_NAME, MONITOR_STATE, MONITOR_DATETIME) VALUES (:System_Id, :Monitor_S_Name, :Monitor_State, :Monitor_S_Datetime) DELETE FROM NETFIN.MONITOR_STATE WHERE SYSTEM_ID = :System_Id INSERT INTO NETFIN.MONITOR_VALUE (SYSTEM_ID, MONITOR_NAME, MONITOR_DATA, MONITOR_INTERVAL, MONITOR_DATETIME) VALUES (:System_Id, :Monitor_V_Name, :Monitor_Data, :Monitor_Interval, :Monitor_V_Datetime) DELETE FROM NETFIN.MONITOR_VALUE WHERE SYSTEM_ID = :System_Id INSERT INTO NETFIN.SOFTWARE_INVENTORY (SYSTEM_ID, MANAGING_ID, GROUP_NAME, PROGRAM_TITLE, VERSION, RELEASE_LEVEL, VENDOR_NAME, LOCATION, SOFT_INV_DATETIME) VALUES (:System_Id, :Soft_Inv_Managing_Id:Soft_Inv_Managing_Id_Ind, :Soft_Inv_Group_Name:Soft_Inv_Group_Name_Ind, :Program_Title:Program_Title_Ind, :Soft_Inv_Version:Soft_Inv_Version_Ind, :Soft_Inv_Release_Level:Soft_Inv_Release_Level_Ind, :Vendor_Name:Vendor_Name_Ind, :Soft_Inv_Location:Soft_Inv_Location_Ind, :Soft_Inv_Datetime:Soft_Inv_Datetime_Ind) DELETE FROM NETFIN.SOFTWARE_INVENTORY WHERE SYSTEM_ID = :System_Id Db_Name User_ID Password System_Id Managing_Id Managing_Id_Ind Group_Name Group_Name_Ind Operating_System Operating_System_Ind Version Version_Ind Memory_Operating Memory_Operating_Ind Memory_Base Memory_Base_Ind Memory_Usable Memory_Usable_Ind Memory_Board Memory_Board_Ind Memory_Adapter Memory_Adapter_Ind Memory_Cacheable Memory_Cacheable_Ind Reference_Disk Reference_Disk_Ind Nvram Nvram_Ind Dedicated_Irq Dedicated_Irq_Ind Shared_Irq Shared_Irq_Ind Parallel_Ports Parallel_Ports_Ind Serial_Ports Serial_Ports_Ind System_Serial System_Serial_Ind Planar_Id Planar_Id_Ind Planar_Serial Planar_Serial_Ind Processor_Card_Ser Processor_Card_Ser_Ind Base_Date Base_Time Logical_Drive Logical_Drive_Ind Device_Type Device_Type_Ind Display_Adapter Display_Adapter_Ind Display_Type Display_Type_Ind Video_Memory Video_Memory_Ind Colors Colors_Ind Horizontal_Res Horizontal_Res_Ind Vertical_Res Vertical_Res_Ind Horizontal_Size Horizontal_Size_Ind Vertical_Size Vertical_Size_Ind Video_Subsystem Video_Subsystem_Ind Slot_Location Slot_Location_Ind Slot_Ind Bus_Type Bus_Type_Ind Bus_Number Bus_Number_Ind Adapter_Id Adapter_Id_Ind Adapter_Type Adapter_Type_Ind Disk_Capacity Disk_Capacity_Ind Disk_Cylinders Disk_Cylinders_Ind Sectors_Per_Cyl Sectors_Per_Cyl_Ind Disk_Heads Disk_Heads_Ind Disk_Total_Sectors Disk_Total_Sectors_Ind F_Physical_Drive F_Physical_Drive_Ind Logical_Name Logical_Name_Ind Volume_Name Volume_Name_Ind File_System File_System_Ind File_Attach File_Attach_Ind Drive_Type Drive_Type_Ind Sectors_Cluster Sectors_Cluster_Ind Sectors_Bytes Sectors_Bytes_Ind Device_Capacity Device_Capacity_Ind Available_Space Available_Space_Ind L_Physical_Drive L_Physical_Drive_Ind Keyboard_Type Keyboard_Type_Ind Country_Code Country_Code_Ind Subcountry_Code Subcountry_Code_Ind Code_Page Code_Page_Ind Model_Name Model_Name_Ind Expansion_Bus Expansion_Bus_Ind Model_Number Model_Number_Ind Submodel_Number Submodel_Number_Ind Bios_Revision Bios_Revision_Ind Bios_Date Bios_Date_Ind Mouse_Type Mouse_Type_Ind Mouse_Buttons Mouse_Buttons_Ind Printer_Port Printer_Port_Ind Print_Queue Print_Queue_Ind Printer_Driver Printer_Driver_Ind Printer_Model Printer_Model_Ind Processor Processor_Ind Co_Processor Co_Processor_Ind Processor_Speed Processor_Speed_Ind Internal_Cache Internal_Cache_Ind External_Cache External_Cache_Ind Planar_Speed Planar_Speed_Ind Processor_Number Processor_Number_Ind Product_Name Product_Name_Ind Product_Version Product_Version_Ind Component_Id Component_Id_Ind Current_Csd Current_Csd_Ind Previous_Csd Previous_Csd_Ind Connector_Id Connector_Id_Ind Memory_Size Memory_Size_Ind Memory_Speed Memory_Speed_Ind Memory_Type Memory_Type_Ind Physical_Unit Physical_Unit_Ind Logical_Unit Logical_Unit_Ind Dasd_Bus_Type Dasd_Bus_Type_Ind Dasd_Slot Dasd_Slot_Ind Bus_Attributes Bus_Attributes_Ind Io_Access Io_Access_Ind Host_Bus Host_Bus_Ind Host_Bus_Width Host_Bus_Width_Ind Max_Scatter Max_Scatter_Ind Max_Cdb Max_Cdb_Ind Add_Major Add_Major_Ind Add_Minor Add_Minor_Ind Dasd_Devices Dasd_Devices_Ind Dasd_Size Dasd_Size_Ind Dasd_Type Dasd_Type_Ind Unit_Pun Unit_Pun_Ind Unit_Lun Unit_Lun_Ind Ansi_Level Ansi_Level_Ind Unit_Status Unit_Status_Ind Vendor_Id Vendor_Id_Ind Product_Id Product_Id_Ind Product_Revision Product_Revision_Ind Profile_Model_Name Profile_Model_Name_Ind Profile_Model_Number Profile_Model_Number_Ind Profile_System_Serial Profile_System_Serial_Ind System_Board_Ser System_Board_Ser_Ind P_Processor_Card_Ser P_Processor_Card_Ser_Ind System_Purchased System_Purchased_Ind Display_Model Display_Model_Ind Display_Serial Display_Serial_Ind Display_Purchased Display_Purchased_Ind Profile_Printer_Model Profile_Printer_Model_Ind Printer_Serial Printer_Serial_Ind Printer_Purchased Printer_Purchased_Ind Modem_Model Modem_Model_Ind Modem_Serial Modem_Serial_Ind Modem_Purchased Modem_Purchased_Ind First_Name First_Name_Ind Middle_Name Middle_Name_Ind Last_Name Last_Name_Ind Employee_Id Employee_Id_Ind Title Title_Ind Dept_Name Dept_Name_Ind Dept_Number Dept_Number_Ind Division Division_Ind Start_Date Start_Date_Ind Shift Shift_Ind Scheduled_Start Scheduled_Start_Ind Scheduled_End Scheduled_End_Ind Home_Phone Home_Phone_Ind Home_Street1 Home_Street1_Ind Home_Street2 Home_Street2_Ind Home_City Home_City_Ind Home_State Home_State_Ind Home_Zip Home_Zip_Ind Home_Country Home_Country_Ind Emergency_Name Emergency_Name_Ind Emergency_Phone Emergency_Phone_Ind Company_Name Company_Name_Ind Address Address_Ind City_Ind State State_Ind Zip_Code Zip_Code_Ind Country Country_Ind Site_Name Site_Name_Ind Office_Number Office_Number_Ind Building Building_Ind Floor Floor_Ind Internal_Phone Internal_Phone_Ind External_Phone External_Phone_Ind Cellular_Phone Cellular_Phone_Ind Pager_Number Pager_Number_Ind Fax_Number Fax_Number_Ind Email_Address Email_Address_Ind Backup_Name Backup_Name_Ind Backup_Phone Backup_Phone_Ind Technical_Name Technical_Name_Ind Technical_Phone Technical_Phone_Ind Manager_Name Manager_Name_Ind Manager_Phone Manager_Phone_Ind Secretary_Name Secretary_Name_Ind Secretary_Phone Secretary_Phone_Ind Entry_Slot Misc_Info Alert_Text Alert_Text_Ind Alert_Id Alert_Id_Ind Alert_Class Alert_Class_Ind Severity Severity_Ind Application_Id Application_Id_Ind Appl_Alert_Type Appl_Alert_Type_Ind Received_From Received_From_Ind System_Name System_Name_Ind Alert_Datetime Alert_Datetime_Ind Monitor_V_Name Monitor_Data Monitor_Interval Monitor_V_Datetime Monitor_S_Name Monitor_State Monitor_S_Datetime Soft_Inv_Managing_Id Soft_Inv_Managing_Id_Ind Soft_Inv_Group_Name Soft_Inv_Group_Name_Ind Program_Title Program_Title_Ind Soft_Inv_Version Soft_Inv_Version_Ind Soft_Inv_Release_Level Soft_Inv_Release_Level_Ind Vendor_Name Vendor_Name_Ind Soft_Inv_Location Soft_Inv_Location_Ind Soft_Inv_Datetime Soft_Inv_Datetime_Ind