DSXchange

Regarding the ORA-1406 problem in Oracle Connector Stage with multi-byte characters - with the help of IBM guys, we got the following result: using NVarChar SQL type (instead VarChar with Unicode attribute) allows to run the complete Job containing Oracle Connector without ORA-1406 error. But while ...

Hi!
I're right Chulett :D

We could aford such a time lag because we were in the Job design up to our ears
Now it's time to test and such a surprise.. )
So, if we well get the solution I will post here or maybe somebody else will post if he knows.

Also what I've found concerning the ORA-1406 : There was an APAR JR36822: IS81 SERVER OCI JOBS FAIL WITH 'OCI FETCHED TRUNCATED DATA' WHEN NON 7-BIT CHARACTERS ARE READ FROM ORACLE (UTF8) https://www-304.ibm.com/support/docview.wss?rs=14&uid=swg1JR36822 for DS 8.1 on the IBM site. It tells that ...

Hi Chulett and Jim! Thanks for the info. I used it but with no success Where exactly did you use it? I've set it inside the Oracle Connector Stage, on the "Columns" tab: SQL Type = Varchar Length = 96 Probably i've missed the point, may be I should set it in some other place to be able to ...

Hello Ray!

Why 96? I used it but with no success

Hi Chulett! Ofcourse i did some before posting! ORA-01406: fetched column value was truncated My column in DataStage is varchar 512, DB field value is varchar2 (32 char) and contains 30 cyrillic charachters. Seems that there is no reason to truncate my 30 characters :) NLS values of the DB and NLS_L...

Hello! We have DS 8.5. I've faced with the followig problem using the Oracle Connector Stage in DS 8.5: When I try to make a "veiw data" in the Oracle Stage from a field (varchar2 30) with cyrillic characters, i am getting the folowing error message: "While reading data for column XX,...

Finally got it working! I have imported a Stored Procedure Definition through the: Import - > Table Definitions - > Stored Procedure Definitions On the General Tab , I set Data Source = my DB TNS record value (which is in server's tnsnames.ora) Username / Password - it is obvious ) DataBase Name = S...

Hi Sreeni ! Thanks for Your reply. Pls let me clearify some details. Did you mean that Stored Procedure Stage can be used also for calling a DB function? I was not sure about this and previously tried to specify my funtion inside the SP stage properties and have got some errors. But I'll try one mor...

Hello! I have the usual job stream structure Source Stage -> Transformer stages -> Target Stage I am getting some correct arguments - Arg1, Arg2, only during the Transformer stages phase of a Job. My goal is to issue a custom SQL query: Select Owner . FunctionName (Arg1, Arg2) from Dual to get a sin...

I don't know about 3:50am, my watch read 11:50am and the sun is shining... 8) ... Yes you are right ) I should have said about equality in minutes of the posts :) But our opinion on this subj is helpful, in this way it works. If there will be no any workable solutions, I'll mark the topic as resolv...

It seems that the Lookup stage doesn't like the same column being used twice for the key. Duplicate your PL.A1 column and then use the original and duplicate for the lookup. ... Hello ArndW ! We have posted simultaneously at 3:50 am :) Thanks for Your reply, if there would be no better solution for...

Also what I have figured out regarding this problem, is that when I artificially inject a column PL.A2 which is equal (by its type and value) to PL.A1 and then use the following condition in lookup: PL.A1 = RL.B1 AND PL.A2 = RL.B2 - lookup works with no errors. Assuming the above info, it seems that...

Hello! I have faced the following situation with Lookup stage (normal lookup): My Lookup has a primary link ( PL ) and a reference link ( RL ). Primary link contains a column A1 , by which I want to lookup a record through the reference link. Reference link has two columns B1 , B2 . The lookup logic...

Hello! I have a few questions about two stages, Merge and Lookup. 1. Merge stage - Is it possible to use Merge stage to translate several links with different set of columns into one output link? It asks for a key field, so as it may seem that it's possible to inject DUMMY column with equal value (f...