Hello guys,
While Deleting Data by DB2 EE Stage,Error as follows:
DB2_UDB_Enterprise_1: Unable to convert the adapter spec ostrstream object with a value of `' to ustring.
DB2 is remote DB.It's normal while insert,update,select.If any one ever resovled similar problem, please help me.
Thanks
DB2 EE Stage ERROR While Deleting Data
Moderators: chulett, rschirm, roy
-
- Charter Member
- Posts: 34
- Joined: Tue May 31, 2005 8:17 pm
- Location: ShangHai,China
Daniel,
I recall having had a similar problem sometime in the past; it had to do with the way that the custom SQL was interpreted - so my question would be whether or not you are using your own SQL in the stage or using generated code? If it is custom, could you perhaps post it?
I recall having had a similar problem sometime in the past; it had to do with the way that the custom SQL was interpreted - so my question would be whether or not you are using your own SQL in the stage or using generated code? If it is custom, could you perhaps post it?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Charter Member
- Posts: 34
- Joined: Tue May 31, 2005 8:17 pm
- Location: ShangHai,China
Re: DB2 EE Stage ERROR While Deleting Data
I realise this was posted a while back but maybe this will help people in the future:daniel0623 wrote:Hello guys,
While Deleting Data by DB2 EE Stage,Error as follows:
DB2_UDB_Enterprise_1: Unable to convert the adapter spec ostrstream object with a value of `' to ustring.
DB2 is remote DB.It's normal while insert,update,select.If any one ever resovled similar problem, please help me.
Thanks
I was getting this same error, when I had a DB2 EE stage delete step, with a Row Generator feeding into it. The RG was generating a column called DUMMY.
The problem was that I was not using the column in my DELETE sql (user-defined).
When I changed the DELETE SQL to include
WHERE ORCHESTRATE.DUMMY = 'DUMMY'
it worked fine (obviously setting the rg to generate the column with the value of 'DUMMY')
[edit]I'm not certain that this works - the error has now gone, but the DELETE doesn't seem to be happening! I'll update this as and when I find out what's going on.[/edit]
Re: DB2 EE Stage ERROR While Deleting Data
I've got to the bottom of this, kind of. My delete wasn't working because sometimes the Delete stage would reject the dummy input record, and so I'm guessing ORCHESTRA.DUMMY would be null (?) but certainly not 'DUMMY' which was the predicate necessary.RobinM wrote:[edit]I'm not certain that this works - the error has now gone, but the DELETE doesn't seem to be happening! I'll update this as and when I find out what's going on.[/edit]
I've changed the job to instead have a DB2 EE stage -> peek, doing a dummy query in the SQL and the delete statement in the open command - and this works.
-
- Charter Member
- Posts: 34
- Joined: Tue May 31, 2005 8:17 pm
- Location: ShangHai,China
I am able to resolve the problem :D .
Since I am mapping a dummy row from a transformer I have to use it in my sql. I set the corrsponding mapping for the column INSERT_UPDATE_CODE in transformer as SetNull().
And it works fine.
Code: Select all
UPDATE CDW_STG.EMPLOYEE_DIM SET CDW_STG.EMPLOYEE_DIM.INSERT_UPDATE_CODE=ORCHESTRATE.INSERT_UPDATE_CODE
WHERE CDW_STG.EMPLOYEE_DIM.INSERT_UPDATE_CODE IS NOT NULL
And it works fine.
Kris
Where's the "Any" key?-Homer Simpson
Where's the "Any" key?-Homer Simpson