Interface to J.J. Kenny's Municipal Bond Database

The afsJJKenny.exe application and service contact the J.J. Kenny service via the internet, query the J.J. Kenny Municipal Bond database, and update the CUSIP information in the afs:TRADE database.

To update/retrieve CUSIP Descriptions

run afstrade
select File->Open->Security Description to open the Product Finder
click in the CUSIP/Tick entry box
enter a nine character CUSIP ID (or 8 character ID without the check digit)
click the Refresh menu item or toolbar button.
to retrieve updated CUSIP information from the J.J. Kenny database, select "Kenny Information Services" in the Source drop down box and click the Refresh menu item or speed button, or click the "Send to JJK" menu item or toolbar button.

You can also access this service via the CUSIP field on a Trade Ticket form. After you enter the CUSIP, if it does not exist in the afstrade database, the system will ask if it should query the J.J. Kenny database. Select yes to instruct it to update from the J.J. Kenny database.

Run as a Windows Service:   JJKService.exe
    DialUp connection to J.J. Kenny.
    Must be placed and run on a machine with a modem.
    To Install the Service:
        Double-click on the JJKinstall.bat.
        Bring up the Windows Services control panel within Windows.
            (Start... Settings... Control Panel... Services... under NT4 )
        Select the JJK Service entry.
            Set it to automatically start the J.J. Kenny service whenever the machine starts up.
            Make sure the service is set to interact with desktop.
    To Start the Service:
        Reboot the machine, or manually start the service using the Services application.

Run as an Application: afsJJKenny.exe
    Internet connection to J.J. Kenny (KDBS Online Service)
        No modem is needed.
            This app can be used with a modem if needed for a backup connection.

The AFS-JJK application and service require an afstrade.ini file to be placed in the same directory before running.

The [afsJJKenny] section of afstrade.ini :

EVENT_RATE={The rate afstrade events will be checked by JJ Kenny. Default to "3000"}

USER NAME={The user name for the AFSTrade database}

PASSWORD={The password for the AFSTrade database}

RunAsService={Run as an application or as a Windows Service. Currently Must be set to 0. Valid Values: 0 = Run as Application, 1= Run as Service. (Default = 1)}

WebUserID={ User ID for KDBS Online Service; assigned by J.J. Kenny}

WebPass= {Password for KDBS Online Service; assigned by J.J. Kenny}

LogFileDirectory={Location of the log output for the J.J. Kenny Application. Ex. C:\temp}

Last Updated: August 25, 2005