DSXchange

Yes, this has been sent to support as well. Thought will check in the forum if some one has already went thru this issue before. Anyway i will update the thread as soon as i hear from IBM

Hi Ray,
In Target Oracle, it is defined as VARCHAR2(5000 BYTE).

Hi, We are moving our jobs from 8.5 to 11.7 and our jobs extract data from SQL Server to Oracle 12c. These jobs are RCP enabled and we use ODBC stage for loading data into target. This jobs extracts data from intermediate Dataset to Oracle. We don't have any problem running these jobs in 8.5, but in...

Hello everyone, i am in the process of migrating parallel jobs from 8.5 to 11.7. some of my jobs use surrogate key's and we are using Surrogate key falte files in transformer stage. i copied all the *.key files from old to new environment but when i run the jobs in v11.7 , it is unable to read the s...

I resolved this issue by using ODBC stage. when i executed the same query using Oracle enterprise stage its triming the last characters in the query which are more than 1220 and throwing a fatal error that SQL query not prepared properly, when i used the same after removing some fileds(only to reduc...

It seems there is a limit for No.of characters and its around 1220 for oracle and 2000 for teradata. i am able to run the same through ODBC stage without any issue.
thanks

i was able to execute that from SQL plus. but when i try to do that from oracle stage its aborting and i am tryng it from ODBC stage.

Hello guys, I am facing some problem related to Oracle stage. In my oracle TARGET stage i am passing a query which i am Selecting and Updating on the same table and that query is too big like it has 1219 characters. the problem here is if my query is more than 1220 characters its not executing the q...

Thanks every one who responded immediately.
I choose to go with STR function and it solved my problem.
Thank you very much once again.

Hello, I am facing a strange problem when i try to concatinate Zero on left side of an integer its not takng that i dont know what the problem is can any one help me on this? I have to check fo the len of the integer and if the lenght is 1 then i have to pad 2 zero's and if len is 2 then i have to p...

Thanks us1aslam1us for immediate reply,
Is there any way i can avoid these warnings rather than handling after they were generated?
:shock:

I too face the same problem alonge with this i am getting one more warning :( I am finding the count using the query in oracle stage and what should i give the data type for the count? *Implicit conversion from source type "dfloat" to result type "int32": Possible range/precision...

Hello every one, I have a requirment where i need to find the child level. My source data is like A / \ B C / \ / \ D E F G / \ / \ / \ / \ H I J KL M N O Parent Child a B a C b D b E c F c G : : In the target table i need to find the level of the child, ie B is a Child of A so its level will be 1 a...