respAdd3StateField()

This procedure adds 3-State field into response. Procedure converts input 3-State value (text) into JSON true/false/null values then store it as field value. The input value is converted using several converson patterns.

ParameterTypeDescription
element30A VARYING, VARSIZEMandatoryName of element
fieldName30A VARYING, VARSIZEMandatoryField name
value10AMandatoryInput 3-state value (text)
pattern10I 0Optionalconversion pattern

Following input boolean values are supported:

  • ’true'
  • ‘false’
  • ’null'
  • ‘Y’
  • ‘N’
  • *BLANK
  • ‘1’
  • ‘0’

Following conversion patterns are sypported:

  • #true_false_null (default)
  • #Y_N_BLANK
  • #1_0_BLANK

The procedure returns pointer of field. If procedure can’t add field, then returns null.

Examples:

respAdd3StateField('data': 'freeOfCharge': 'true');
respAdd3StateField('data': 'freeOfCharge': 'false');
respAdd3StateField('data': 'freeOfCharge': 'null');
respAdd3StateField('data': 'freeOfCharge': 'true': #true_false_null);
respAdd3StateField('data': 'freeOfCharge': 'false': #true_false_null);
respAdd3StateField('data': 'freeOfCharge': 'Y': #Y_N_BLANK);
respAdd3StateField('data': 'freeOfCharge': 'N': #Y_N_BLANK);
respAdd3StateField('data': 'freeOfCharge': *BLANK: #Y_N_BLANK);
respAdd3StateField('data': 'freeOfCharge': '0': #1_0_BLANK);
respAdd3StateField('data': 'freeOfCharge': '1': #1_0_BLANK);
respAdd3StateField('data': 'freeOfCharge': *BLANK: #1_0_BLANK);
respAdd3StateField('data': 'freeOfCharge': XXFOCC: #Y_N_BLANK);