MQSeries.net :: View topic - Java Compute Node MRM Validation using ASBITSTREAM

jboller001 · Posted: Sat Jun 17, 2006 4:12 pm Post subject:

Does anyone have the correct syntax for using the ESQL ASBITSTREAM function with a Java compute node using the createSQLStatement method? The following code generates a SYNTAX error.

this.createSQLStatement("", "ASBITSTREAM(" + outBody.toString() + " OPTIONS BITOR(ValidateValue, ValidateContent, ValidateException) CCSID 1208 SET " +
messageSetId + " TYPE " +
messageSetType + " FORMAT " + messageSetFormat+ ")");

Exception List: (
(0x01000000):RecoverableException = (
(0x03000000):File = 'F:\build\S600_P\src\DataFlowEngine\PluginInterface\ImbJniNode.cpp'
(0x03000000):Line = 922
(0x03000000):Function = 'ImbJniNode::evaluate'
(0x03000000):Type = 'ComIbmJniNode'
(0x03000000):Name = 'application_to_canonical/Staging_To_Canonical_Transformer#FCMComposite_1_4'
(0x03000000):Label = 'application_to_canonical.Staging_To_Canonical_Transformer.JavaCompute'
(0x03000000):Catalog = 'BIPv600'
(0x03000000):Severity = 3
(0x03000000):Number = 2230
(0x03000000):Text = 'Caught exception and rethrowing'
(0x01000000):RecoverableException = (
(0x03000000):File = 'F:\build\S600_P\src\DataFlowEngine\PluginInterface\ImbJniNode.cpp'
(0x03000000):Line = 922
(0x03000000):Function = 'ImbJniNode::evaluate'
(0x03000000):Type = 'ComIbmJniNode'
(0x03000000):Name = 'application_to_canonical/Staging_To_Canonical_Transformer#FCMComposite_1_10.application_to_canonical/Staging_To_Canonical_UpdateIndividual#FCMComposite_1_6'
(0x03000000):Label = 'application_to_canonical.Staging_To_Canonical_Transformer.Staging_To_Canonical_UpdateIndividual.ExtractPayload'
(0x03000000):Catalog = 'BIPv600'
(0x03000000):Severity = 3
(0x03000000):Number = 2230
(0x03000000):Text = 'Caught exception and rethrowing'
(0x01000000):RecoverableException = (
(0x03000000):File = 'F:\build\S600_P\src\DataFlowEngine\ImbRdl\ImbRdlRdp.cpp'
(0x03000000):Line = 294
(0x03000000):Function = 'Parser::parseAllStatements'
(0x03000000):Type = 'ComIbmJniNode'
(0x03000000):Name = 'application_to_canonical/Staging_To_Canonical_Transformer#FCMComposite_1_10.application_to_canonical/Staging_To_Canonical_UpdateIndividual#FCMComposite_1_6'
(0x03000000):Label = 'application_to_canonical.Staging_To_Canonical_Transformer.Staging_To_Canonical_UpdateIndividual.ExtractPayload'
(0x03000000):Catalog = 'BIPv600'
(0x03000000):Severity = 3
(0x03000000):Number = 2402
(0x03000000):Text = 'Syntax error'
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = ''
)
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = '1.1'
)
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = 'ASBITSTREAM'
)
)
)
)
)