Follow

Flat File PMR

-         Log into Remote Desktop

-         Start up Notepad by doing the following:

o   Click on the Start button;

o   Click the Run… menu item

o   In the dialog box that appears, type Notepad

-         In the Notepad window, type the following to create the query that will be used to generate the PMR detail data that will be in the database temporary table:

o   exec dbo.spGetPortfolioMonitoringDetailData_V3 '31 MAR 2016', 733253733253962714, NULL, NULL, 0, 0, 0, 1, NULL, NULL, 'TF1535739509,TF1529260440', 1

-         Save this as C:\PMR\keystone-detail.sql, and close Notepad.

-         Open a new Notepad again as before

-         In the Notepad window, type the following to create the query that will be used to generate the PMR summary data that will be in the database temporary table:

o   exec dbo.spGetPortfolioMonitoringSummaryData_V3 '31 MAR 2016', 733253733253962714, NULL, NULL, 0, 0, 0, NULL, NULL, 'TF1535739509,TF1529260440', 1

-         Save this as C:\PMR\keystone-summary.sql, and close Notepad.

-         Open a command prompt by doing the following:

o   Click on the Start button

o   Right-click on the Command Prompt menu item

o   Click the Run as Administrator menu item

-         In the command window, type the following to generate the PMR detail data for bank (ex. Keystone Bank):

o   osql -S CRLiveSQL -d CreditRegistry_Nigeria -E -I -i C:\PMR\keystone-detail.sql

-         Wait until you see the command prompt (i.e. the text beginning with C:\ or D:\) again; this will tell you that the query has finished running.

-         In the command window, type the following to generate the PMR summary data for Keystone Bank:

o   osql -S CRLiveSQL -d CreditRegistry_Nigeria -E -I -i C:\PMR\keystone-summary.sql

-         Wait until you see the command prompt to know that the query has finished running

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk