DSXchange

Hi Anuj,

Are you sure that your Oracle server (149.27.178.145 ) is reachable from your DS server?

also you can test the connection from "/branded_odbc/demo/demoodbc" and the driver VMora19 with "/branded_odbc/bin/ivtestlib".

Hi Abhi, may be you could find a second opinion here:

viewtopic.php?t=91040&highlight=linkreport

have a nice day.

chulett wrote:Only valid advice for UNIX servers, I'm afraid. No such thing on Windows.

ops sorry.. i'm living in the unix world... Windows should have the path for this Library (oraoci9.dll) defined in some place, right?... did you try reboot? this always help.

I think that may be you need to add the ORA home directory in your ..DSEngine/dsenv file.

Check the difference between your servers.

You can use DS Universe tables for temporal tables to run sql queries.

yes, you need to enable hashed file cache sharing in the Job Properties to allow multiple processes to access the same hash file in cache.

Do you have the DSHOME/branded_odbc/lib seted up on the LIBPATH in dsenv file?

I see the same error message when I run ./bind20 and i didn't load the ds env vbles.

Hi,

you need to run . ./dsenv before ./bind20

Hi fahad, I think that you need to start journaling for those "Library.files" on as400 in order to allow DataStage(odbc) to insert/update/delete on those tables. these are the step on AS400: 1 Create a journal receiver (CRTJRNRCV). 2 Create a journal (CRTJRN) specifying the journal receive...

Ray this warning started after an ODBC driver upgrade. The solutions I found are possibles, but implicate a lot of coding modifications.

So, I think that it should be another option like add a char set in the odbc.ini or use another NLS in the odbc stages. I tried both, but no luck yet.

Thanks,

This warning appear in a whole column mapped in a direct reference. I solve the problem when I put a hash file in the middle. But this is not the solution I want... any idea on how to solve this issue? this is the detail: Reference (China code page CCSID 937) | Input value--->TRF--->Output value (La...

You can create a (hash file) lookup with this table and check the existing keys, also you can compare the changes and use an insert/update option.

With oracle another option could be truncate then use ora bulk load.

regards,

Are you able to compile this job?

Status 0 represents RUNNING status.

Yes, you can.
You just need the same metadata definition.

ok, we have NLS installed and I know that this db2 reference is an as400 server in china, so i asume that has a chinese char set 937... but now what should i change to eliminate this warning?

thanks