« Ofax overview | Main | CLM Overview »
September 9, 2008
Perkin's Soil Overview
his file comes from CLM (perkins loan data) Microsoft SQL database which is located on winchester
First thing you do is make a backup of the table szasoil
Remote into the server winchester
Start Enterprise manager
Choose the CLM database
Under tools, start SQL Query Analyzer
Open the file soil_current which is in a folder clm in the programmers folder.
The file is a union query. You need to increment the seq no on both sides of the union. It is currently on 7. Save the file with the new seq no.
Run the query and then save the result in a file called soil.csv
close Enterprise Manager, SQL Query Analyzer, and exit winchester
FTP the soil.csv file over to apollo sqlload it into wouprd using the control file soil.ctl
run szrsoil.exe This creates the soil file for the business office that they send to revenue
Posted by wendlerb at September 9, 2008 10:13 AM
Comments
Post a comment
Thanks for signing in, . Now you can comment. (sign out)
(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)