MQSeries.net :: View topic

Monk · Posted: Mon Dec 03, 2007 9:21 pm Post subject:

Hi ,

I use MB 5 on windows 2K.

I m trying to insert a NULL value into a DB2 table for a column of type TIMESTAMP. i have configured it to be nillable.

when i do a insert from my ESQL & pass NULL to this column.
I get a exception..
following is the exception..

<MessageID>414d51205742524b5f514d20202020209ad7534720002c07</MessageID>
<ExceptionList>
<File>F:\build\S500_P\src\DataFlowEngine\ImbComputeNode.cpp</File>
<Line>472</Line>
<Function>ImbComputeNode::evaluate</Function>
<Type>ComIbmComputeNode</Type>
<Name>MF_VOC_SERVICE_REQUEST#FCMComposite_1_2</Name>
<Label>MF_VOC_SERVICE_REQUEST.SendXMLResponse</Label>
<Text>Caught exception and rethrowing</Text>
<Catalog>BIPv500</Catalog>
<Severity>3</Severity>
<Number>2230</Number>
<RecoverableException>
<File>F:\build\S500_P\src\DataFlowEngine\ImbRdl\ImbRdlStatementGroup.cpp</File>
<Line>158</Line>
<Function>SqlStatementGroup::execute</Function>
<Type>ComIbmComputeNode</Type>
<Name>MF_VOC_SERVICE_REQUEST#FCMComposite_1_2</Name>
<Label>MF_VOC_SERVICE_REQUEST.SendXMLResponse</Label>
<Text>Error detected, rethrowing</Text>
<Catalog>BIPv500</Catalog>
<Severity>3</Severity>
<Number>2488</Number>
<Insert>
<Type>5</Type>
<Text>.MF_VOC_SERVICE_REQUEST_Compute.Main</Text>
</Insert>
<Insert>
<Type>5</Type>
<Text>39.9</Text>
</Insert>
<Insert>
<Type>5</Type>
<Text>UpdateFileTxnTable(CAST(InputRoot.XML.Files.DealerCd AS CHARACTER), CAST(InputRoot.XML.Files.File[nCounter].Filename AS CHARACTER), CAST(InputRoot.XML.Files.File[nCounter].FileHash AS CHARACTER), CAST(InputRoot.XML.Files.File[nCounter].FileSize AS INTEGER), CAST(InputRoot.XML.Files.File[nCounter].TotalMsgs AS INTEGER), CAST(InputRoot.XML.Files.File[nCounter].FileBlkSize AS INTEGER), CAST(InputRoot.XML.Files.File[nCounter].FileBlkNo AS INTEGER), 'INP', 'NEW', '0', CURRENT_TIMESTAMP, NULL, CAST(InputRoot.XML.Files.AppId AS CHARACTER));</Text>
</Insert>
<RecoverableException>
<File>F:\build\S500_P\src\DataFlowEngine\ImbRdl\ImbRdlRoutine.cpp</File>
<Line>1221</Line>
<Function>SqlRoutine::setupChildEnv</Function>
<Type>ComIbmComputeNode</Type>
<Name>MF_VOC_SERVICE_REQUEST#FCMComposite_1_2</Name>
<Label>MF_VOC_SERVICE_REQUEST.SendXMLResponse</Label>
<Text></Text>
<Catalog>BIPv500</Catalog>
<Severity>3</Severity>
<Number>2930</Number>
<Insert>
<Type>5</Type>
<Text>MODIFIED_DT</Text>
</Insert>
<Insert>
<Type>5</Type>
<Text>NULL</Text>
</Insert>
<Insert>
<Type>5</Type>
<Text>TIMESTAMP</Text>
</Insert>
</RecoverableException>
</RecoverableException>
</ExceptionList>

Now 'MODIFIED_DT is of type TIMESTAMP and its nillable in DB2.

if i do a manual insert in DB2 using INSERT command in Db2 prompt and pass a NULL to this column it works fine.

Any ideas why i cant insert a NULL from ESQL ?.
_________________
Thimk