Progress/400
Product Guide


Adding a Parameter

The Progress/400 Data Dictionary allows you to add parameters to existing DB2/400 stored procedures. You can then use these parameters when running the stored procedure in your Progress application.

Follow these steps to add a parameter:

  1. Choose the Parameter mode button in the Progress/400 Data Dictionary main window.
  2. Choose Modify schema.
  3. Select the stored procedure from the procedure list that will contain the new parameter.
  4. Choose the Create Parameter button. The following dialog box appears:
  5. Enter a unique name in the Parameter Name field. This is the name by which Progress recognizes this object, so it should follow Progress naming conventions.
  6. Choose a data type.
  7. Table 9–3 lists the supported data types and their Progress equivalents.

    Table 9–3: DB2/400 Data Types with Progress Equivalents 
    DB2/400
    Progress
    Character Alpha
    Character
    Zoned Numeric
    Decimal
    Packed Decimal
    Decimal
    Pckd (even decimal)
    Decimal
    Long Integer
    Integer
    Short Integer
    Integer
    Character
    Logical

    A default format is supplied based on the data type. You can change the default format. The format or datatype determines the size of the parameter.

  8. Select the type of parameter being defined. There are three types: input to the stored procedure, output from the stored procedure, or input-output from the stored procedure.
  9. Enter any other information that you want to add to the new parameter definition. Choose the Help button to access detailed information on all of the elements in the dialog box.
  10. Choose OK to return to the Progress/400 Data Dictionary main window or choose Create to create the record and define another one. Up to 32 parameters can be defined for each stored procedure.
  11. You modified the data definitions in the server schema on the AS/400. Your server schema now contains definitions that are not reflected in the schema holder until you synchronize it.


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