DSXchange

Thanks Ray for your response

I am not seeing the second part of your post. can you please repost the content

Found a solution to this issue. This post can be marked as resolved.

Journal was not enabled on the AS400 and it worked as soon as Journal was enabled.

Thanks for giving some pointers

Getting this MetaData mismatch error LdBDetailTable..Detail_F554211B.DataToInsert: DSD.BCIOpenR results of SQLColAttributes(SZUPMJ) gave MetaData mismatch COLUMN.TYPE Expected = Decimal Actual = Numeric one workaround would be to change it on each occurance but this is propping up for most the jobs ...

Make sure you have LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/.dslibs:$dshome/lib:$ODBCHOME:$ODBCHOME/lib:$ORACLE_HOME/lib32:/usr/lib/lwp; export LD_LIBRARY_PATH and PATH=$PATH:$dshome/bin:$ODBCHOME:$ODBCHOME/bin:$ORACLE_HOME/bin; export PATH with the relevant ODBCHOME,ORACLE_HOME,dshome,ODBCINI already set ...

Please make sure you have $ORACLE_HOME/lib32 in your
LD_LIBRARY_PATH

Looks like it is missing in your dsenv file

Well we upgraded As400 from 5.2 to 5.3
Not sure if this upgrades the DB2 also

aoriano,
Thanks for your response.
This query was working fine.
The AS400 was upgraded and we started getting this issue

Is there someway we can confirm that this is only a DB2 issue?

Please let me know
Thanks
Anandha kumar

Getting the following error when trying to insert data into DB2 from Datastage 7.5.2 on solaris 2.10 It is fine when we try to view data LdBDetailTableTESTTEST..Xfm.DataToInsert: DSD.BCIPut call to SQLExecute failed. SQL statement:INSERT INTO J73DISDTA.F554211B(SZEDUS) VALUES (?) SQLSTATE=S1000, DBM...