| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| DB2 Insert using Data Insert node SQL0407N (solved) |
« View previous topic :: View next topic » |
| Author |
Message
|
| lancelotlinc |
 Posted: Mon Aug 29, 2011 9:29 am Post subject: DB2 Insert using Data Insert node SQL0407N (solved) |
 |
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
Hi all,
WMB 7.0.0.2, DB2 9.5
I have an error using the Data Insert node:
| Quote: |
| (0x03000000:NameValue):Text = '[IBM][CLI Driver][DB2/AIX64] SQL0407N Assignment of a NULL value to a NOT NULL column "TBSPACEID=4, TABLEID=6, COLNO=0" is not allowed. SQLSTATE=23502 ' (CHARACTER) |
The Data Insert node has a map for this field:
| Quote: |
| xs:integer($source/ns1:request/ynfo/yId) |
Trace node shows this value going to the Data Insert node:
| Quote: |
(0x03000000:PCDataField):yId = '192515' (CHARACTER)
|
Before I begin recoding in ESQL Compute node to do a direct SQL insert via passthru, anyone suggest some things to check as to why the Data Insert node is not able to process?
SQL Statement generated by Data Insert node is
| Quote: |
| (0x03000000:NameValue):Text = 'INSERT INTO Database.XYZ.ABQ.ALY ( COL0NAME ) VALUES (CAST(source_body.zzz.(XMLNSC.Element)yId AS DECIMAL) |
DB2 thinks its getting a null value, but I see the correct value in Trace output.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
 |
| lancelotlinc |
| Posted: Mon Aug 29, 2011 12:04 pm Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
|
| Back to top |
|
|
| smdavies99 |
| Posted: Mon Aug 29, 2011 9:24 pm Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
| lancelotlinc wrote: |
| oooops. Forgot to remove the Soap Envelope. My bad! |
Te-he.
Now go and sit on the naughty step for using 'bad' instead of 'mistake'.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
