ProcedureParameter rs5p4b = createParameter("in3", ParameterInfo.IN, DataTypeManager.DefaultDataTypes.STRING); //$NON-NLS-1$
rs5p3b.setNullType(NullType.Nullable);
rs5p4b.setDefaultValue("YYZ"); //$NON-NLS-1$
QueryNode sq3n1b = new QueryNode("CREATE VIRTUAL PROCEDURE BEGIN SELECT e1, e2 FROM pm1.g1 WHERE e1=pm1.sq3b.in UNION ALL SELECT e1, e2 FROM pm1.g1 WHERE e2=pm1.sq3b.in2; END"); //$NON-NLS-1$ //$NON-NLS-2$
Procedure sq3b = createVirtualProcedure("sq3b", pm1, Arrays.asList(rs5p2b, rs5p3b, rs5p4b), sq3n1b); //$NON-NLS-1$
rsDefaultsParameterString.setDefaultValue(new String("x")); //$NON-NLS-1$
ProcedureParameter rsParameterBigDecimal = createParameter("inBigDecimal", ParameterInfo.IN, DataTypeManager.DefaultDataTypes.BIG_DECIMAL); //$NON-NLS-1$
rsParameterBigDecimal.setNullType(NullType.Nullable);
rsParameterBigDecimal.setDefaultValue(new String("13.0")); //$NON-NLS-1$
ProcedureParameter rsParameterBigInteger = createParameter("inBigInteger", ParameterInfo.IN, DataTypeManager.DefaultDataTypes.BIG_INTEGER); //$NON-NLS-1$
rsParameterBigInteger.setNullType(NullType.Nullable);
rsParameterBigInteger.setDefaultValue(new String("13")); //$NON-NLS-1$
ProcedureParameter rsParameterBoolean = createParameter("inBoolean", ParameterInfo.IN, DataTypeManager.DefaultDataTypes.BOOLEAN); //$NON-NLS-1$
rsParameterBoolean.setNullType(NullType.Nullable);
rsParameterBoolean.setDefaultValue(new String("True")); //$NON-NLS-1$
ProcedureParameter rsParameterByte = createParameter("inByte", ParameterInfo.IN, DataTypeManager.DefaultDataTypes.BYTE); //$NON-NLS-1$
rsParameterByte.setNullType(NullType.Nullable);
rsParameterByte.setDefaultValue(new String("1")); //$NON-NLS-1$
ProcedureParameter rsParameterChar = createParameter("inChar", ParameterInfo.IN, DataTypeManager.DefaultDataTypes.CHAR); //$NON-NLS-1$
rsParameterChar.setNullType(NullType.Nullable);
rsParameterChar.setDefaultValue(new String("q")); //$NON-NLS-1$
ProcedureParameter rsParameterDate = createParameter("inDate", ParameterInfo.IN, DataTypeManager.DefaultDataTypes.DATE); //$NON-NLS-1$
rsParameterDate.setNullType(NullType.Nullable);
rsParameterDate.setDefaultValue(new String("2003-03-20")); //$NON-NLS-1$
ProcedureParameter rsParameterDouble = createParameter("inDouble", ParameterInfo.IN, DataTypeManager.DefaultDataTypes.DOUBLE); //$NON-NLS-1$
rsParameterDouble.setNullType(NullType.Nullable);
rsParameterDouble.setDefaultValue(new String("13.0")); //$NON-NLS-1$
ProcedureParameter rsParameterFloat = createParameter("inFloat", ParameterInfo.IN, DataTypeManager.DefaultDataTypes.FLOAT); //$NON-NLS-1$