Add DDU Drop keys to your database

Information relating to the presorting process in AccuZIP6, which may include rate change information and news about important updates as well as regulation changes or DMM Rules interpretation.

Moderators: Chrissy, Steve, Terry, Donna, Dave, Eric, MartyH, Kristen, Geoff, Vince

Post Reply
User avatar
Eric
Moderator
Posts: 1909
Joined: Tue Sep 19, 2006 3:29 pm
Contact:

Add DDU Drop keys to your database

Post by Eric » Fri May 18, 2012 3:14 pm

These instructions will allos you to add DDU Drop Keys to your database. Drop keys will fill into a dropkey field in your database for records that are part of at least 10 records per carrier route.

Download the ddudrop.zip file and extract it into the C:\Program Files\AccuZIP6 5.0\DMM folder.

Open the C:\Program Files\AccuZIP6 5.0\DMM\ddudrop.dbf file.
Open the database to which you’d like to add DDU keys, and validate that file.

With both databases still open, pull down the Edit menu to Command.

Create a new command and give the command a name.

Paste the following command into the Command Statement Syntax area:


ON ERROR com_Mesg=MESSAGE()
SET SAFETY OFF
SELECT("ddudrop")
INDEX ON LEFT(zip,5)+ALLT(crrt) TAG mytag
SELECT("your_database")
ALTER TABLE ALIAS() ADD COLUMN dropkey C(9)
REPLACE all dropkey with ddudrop.dropkey for SEEK(LEFT(zip,5)+ALLT(crrt),"ddudrop")
REPLACE all dropkey with ddudrop.dropkey for SEEK(LEFT(zip,5),"ddudrop") AND EMPTY(dropkey) AND "ALL" $ ddudrop.crrt
com_Alias=ALIAS()
SELECT LEFT(zip,5)+crrt as zip FROM (ALIAS()) GROUP BY 1 HAVING COUNT(LEFT(zip,5)+crrt)<10 INTO CURSOR _zips READWRITE
INDEX ON zip TAG zip
SELECT(com_Alias)
REPLACE dropkey with "" FOR SEEK(LEFT(zip,5)+crrt,"_zips")



On the 5th line of the command, change your_database to whatever your database is named. If your database name contains spaces, use underscores in the command where the spaces in the database name would be.

Run the command, then close the command window. Your database will now have a dropkey field as the final field in the database, and it will contain the appropriate DDU Dropkey code.
Chat with an AccuZIP6 technician weekdays from 7-4 PST with AccuZIP6 Live Online Support

Post Reply