Progress/400
Product Guide


Adding a Procedure

The Progress/400 Data Dictionary allows you to add a stored procedure definition to the Dictionary Library. The Progress/400 Data Dictionary stores the definition in the P__FILE file, so that you can evoke the stored procedure through Progress applications.

Follow these steps to add a procedure:

  1. Choose the Procedure mode button in the Progress/400 Data Dictionary main window.
  2. Choose Modify Schema.
  3. Choose the button. The following dialog box appears:
  4. Enter a unique name in the Procedure Name field. This is the name by which Progress recognizes this object, so it should follow Progress naming conventions.
  5. Enter both the Program Name of the object on the AS/400 and the Library Name where the program resides. The Program Name name must be unique within the server schema and the name must differ from any existing physical file in the library.
  6. Enter a description in the Description field. Choose the Help button to access detailed information on all of the elements in the dialog box.
  7. Choose OK to advance to the Define Parameter screen or choose Create to create the record and begin defining another stored procedure.
  8. If you want to create parameters for this stored procedure, see the "Adding a Parameter" section.

  9. Create parameters for this stored procedure if applicable.
  10. You modified the data definitions in the server schema on the AS/400. Your server schema now contains an object that is not reflected in the client schema holder until you synchronize it.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095