DSXchange

"ASCL_ASCII" is your defined source datatype, this is apparently not the correct character set, you need to set it to the correct one. If your source is actually unicode then set it as such and the errors and warnings will disappear.

Ray - you ruined the suspense I was trying to build up

Perhaps your Oracle library search paths and environment variables are different.

What version of Oracle are you using and is the Oracle DB server on the same machine as the DataStage engine? Have you tried using ODBC in PX to connect to Oracle?

Write a short Basic routine and return the value of "NUM('45e45')". Is that returning a 1 or a 0?

I realized I meant that each date needs to be 10, not 8, characters long. Have you checked this? My guess is that you have extra characters in your string. Another check you could do is and see if the error persists.

That is good news, it means that there is still some data there. From the Administrator command do a "COUNT DS_JOBOJBECTS" and post the error message.

An how big are the 2 files in the subdirectory?

The first step should be doing the actions I suggested in my first post.

Ray posted excellent advice, I could just repeat what he recommended as initial steps. If you have any idea how this happened it would be good know as it might change the approach to solving the problem. I would also recommend that unless you have the exact same error messages as the original poster...

Are you using the "StringToDate" function? Also, if you modify the call to do you get the same warning? If yes, check to ensure that the length of your date is always 8 characters.

The output of the "more" command most likely contains more than just the filename, it will also have a linefeed. Use "echo" on the return value to see what it contains, then you can parse out the actual filename with a SUBSTR() or FIELD() command.

You posted on another thread which looks like it might answer your question. You will need to explain where you are getting this error message, and what you might have tried to fix it. Also, if you look into your project directory on UNIX, is the subdirectory DS_JOBOBJECTS there, what are the access...

The exact same error or a similar one involving DS_JOBOBJECTS? Which version are you working on and which part of Ray's advice did you attempt?

This question has been asked (and answered) many times so far. If you are on a Windows DataStage server then it is easy to use the ODBC drivers for Excel that come with the system. If your DS is on UNIX, then it is more difficult, usually involving purchasing software that lets you use ODBC on UNIX ...