DSXchange

Thanks Ray and guys.

I have faced similar issue with spaces in the date field from mainframe source. Before reading this post I used It never worked.

Thanks again guys.

-NB

Hi,

Check the permissions on the directory..! Is only happening with this job are are all jobs?
provide more details if you have.

-NB

Hi !

You can use the ORAOCI itself for calling your store procedure. you can call stored procedure in ORAOCI stage ->OUPUT/INPUT -> SQL->after (or) before

Use -NB

On success of SERVER2 DS Job, Include a routine activity and Use full path for the batch file in the routine .

\\SERVER1.yourdomain.com\Temp\Test.bat

-NB

Can Moderator Change the Post Topic ?..Same Problem ..no one can guess what is inside !

Hi,

Check all the columns are mapped with required data type and length. Run debug and verfy the log.

-NB

Thanks Ken,

In the meantime , I have requested the extract programmers to change the delimiter 'comma' to pipe "|". Works fine now.

-NB

Hi Bapajju or All,
How you solved this?

I have the same issue name field contains comma like "Commerce, Inc."
Using 7.5 server edition on windows. How to handle this while defining the file?.

Thanks in advance
-NB

Hi All,

You can find the certification details below link

http://www-03.ibm.com/certify/tests/obj415.shtml

Please someone update the FAQ also.

-NB

Meena,

Check the look up condition, if its alphaneumeric spaces may not be compared.

Also Check this post, sometime you might have duplicate in lookup
viewtopic.php?t=101343&highlight=duplicate


-NB

Thanks All,

The literal with Key Expression - worked out Great for me.

Regards
-NB
----------
Nothing is so strong as gentleness. Nothing is so gentle as real strength.

In Server Edition 7.5, The merge will support for only two flat files.


-NB

Hi, I am facing one issue to join flat file and hashed file (created from Oracle table). Server edition 7.5 Issue: ==== Primary Source : Flat file has columns A,B.C,D And Hash File has column F (derive from table by SQL query) and this will have only one value like Max of some column. Now My Target ...

I have the local admin rights and installed. This is happening only I try to access the "View Data" or Run the job.

With DS admin user id/pwd it is working fine. For all rest of the users its giving the same error. Seems the issue is on the server side.

Thanks
-NB

Hi,

I am getting the same error with oraoci9.dll, But the message is Access denied.

Fatal ds_loadlibrary: Win32 error in LoadLibrary of oraoci9.dll - Access is denied.

Means the dll is not registered or I do not have the permission ?!

Thanks
-NB