DME Field Max Valuel

You can add &SELECT=EMPLOYEE<=12345 to your DME to get the values equal to or less than the employee number you want. I'm not sure if the employee value has to be in quotes so try it both ways.

Kathy - when you're in Design Studio if you select Tools and then API Builder you can select DME and build the DME with the Select limits to get the correct syntax, etc. This is a great utility for new DS developers.

If you are using auto numbering then do a DME on PRSYSTEM table.

MAX will limit the number of records, for instance if you put 100 in there it will stop after reading 100 records, not employee 100.  

SELECT is not very efficient.

You can set a range in the DME key like this:

Obj.key= "1->100";

If you are trying to find the last employee number used then get the company record (PROCESS-LEVEL of blank) from the PRSYSTEM table for the field LAST-EMPLOYEE

Posted By KathyB on 08/05/2009 02:57 PM
is there a max command I can use with the DME call?

Assuming you're on LSF9, there are some new DME parameters; so for company 4321, this will give you the highest employee number:

PROD=PROD&FILE=EMPLOYEE&FIELD=EMPLOYEE&BEGIN=1=999999999&INCPREV&MAX=1