DTW_PAD_PGM_PARMS

AIX HP-UX Linux OS/2 OS/390 OS/400 PTX SUN Win NT





X


Purpose

Indicates to a language environment whether character parameters (data type of CHAR or CHARACTER) are to be padded with blanks when they are being passed to a program or stored procedure.

For IN or INOUT parameters, if the length of parameter value is less than the precision that is specified, blanks are inserted to the right of the parameter value until the length of the parameter value is the same as the precision.

For OUT parameters, the parameter value is set to precision blanks.

After the call to the program or stored procedure, all trailing blanks are removed from OUT and INOUT parameter values.

Set this variable in the Net.Data initialization file to specify a value for all of your macros. You can override the value by defining it in the macro. If DTW_PAD_PGM_PARMS is not defined in the macro, it uses the value in the Net.Data initialization file.

DTW_PAD_PGM_PARMS is supported by the Direct Call and SQL language environments.

Values

DTW_PAD_PGM_PARMS="YES"|"NO"

Table 13. DTW_PAD_PGM_PARMS Values
Values Description
YES All IN and INOUT character parameter values are left justified and padded with blanks for the defined precision of the parameter, before the parameters are passed to a program or stored procedure. Trailing blanks are removed after the call to a program or stored procedure.
NO No padding is added to character parameter values (values are NULL-terminated) when passing parameters to programs or stored procedures. Trailing blanks are not removed after calling a program or stored procedure.

Examples

Example 1: Pads parameters with blanks

DTW_PAD_PGM_PARMS="YES"


[ Top of Page | Previous Page | Next Page | Index ]