DSXchange

Don't see anything obviously wrong, as long are you are certain of your ORACLE_HOME value. Which version of DataStage are you running? You are using a 10g Oracle home in your dsenv and use of a 10g client isn't officially supported until 7.5.x, hence the question.

Did you stop and restart the DataStage server after making those changes? And are these changes located after where the LD_LIBRARY_PATH is set in the dsenv file?

kollurianu wrote:i have a user defined sql

WHERE wtn=:1

Please post the entire user defined sql statement you are using - that can't be it.

And your Oracle error is saying that there is no column called "LKEY" in the "LOCATION_KEY_REF_INFO" table owned by the "DMETRO" schema. Is that not true?

The Oracle stages do not use ODBC for their connectivity. You need to properly configure your dsenv file and then restart DataStage. It's all spelled out in the Plug-in Installation and Configuration Guide.

Must be something going around - I'm seeing this issue for the first time today. Existing connections are fine, but any attempt to create a new connection is greeted with the 'Project is locked' message. It's not a license issue, as noted there is a specific message from that we've seen before. I'm...

Sort them, as in alphabetically by column name? No, there's no way to do that automatically. You are aware that there is a 'Find/Replace' tool inside the Transformer editor, yes? Looks like a pair of binoculars.

That's what sales people are for. Of course, you'll get two different answers from the two different camps... and I'm assuming "reference" actually means "difference" here. If not, then as Arnd noted, you would need to expand on your question a wee bit more.

ray.wurlod wrote:This is going to be a very long, very slow way to learn ED, one command per post at a time.

Curious, Jim...what do you mean by "view the data"? What data, exactly?

I wonder if you can rerun the Server installation and accomplish this? I've never tried, but if you rerun it, it will go into Maintenance mode where you can add plug-ins. I wonder if it is as easy as simply 'deselecting' them there and it will remove them from the Server?

Isolation level none means that you CAN read uncommitted transactions. That's what I was trying to get at in my earlier post. As was I. You'll also read ones committed between the start of one job and the start of the other, even with a 'proper' isolation level. I just don't think it's reasonable t...

I don't believe "Intelligent Assistants" are the same as templates. From what I recall, they were something that Ascential attempted to put together that never really worked the way they wanted them to work, so they were removed from the product. They were "Wizards", something that from a job templa...

It's not an integer, but rather an alphanumeric value: "000987A87".

Ray, he's already said that is the case:

Nick_6789 wrote:And further adding on, yups, the database is being actively written into as I run the job by some other application users.

Are you sure that the difference in the row counts can't simply be a result of the fact that the jobs run at different times against a table that is actively being written to? That would seem to be the obvious culprit here. Your conclusion that "the number of records extracted should be identical" i...