DSXchange

If you take your actual error message, the one you condensed down to 'inappropriate value' and search the forums, you find this has been asked and answered quite a number of times. I'd say a bajillion times, but for some reason Ray doesn't think that's a real number.

We get it, we get it. Since you seem to be on a roll today, Ken, let's continue rolling. The '(bad idea)' part of this caught my attention: For the life of me I can't figure out why it's such a big deal to select the max surrogate key on tables. These columns are usually indexed, either as a primary...

just4geeks wrote:

lstsaur wrote:When you said "TNSNAMES seems to be ok", did you mean that you verified it by running sqlplus to connect to your database?

yes we successfully connected to database from Unix box using sqlplus.

Thanks!

Can you do the same after executing the commands I posted earlier?

Does this job need to be a parallel job?

However we did not define ORACLE_SID in dsenv file. Is that needed? we only added ORACLE_HOME and LD_LIBRARY_PATH to dsenv file. ORACLE_SID is not needed in dsenv, just job to job... or set it in the Administrator as an environment variable and then override it in any given job should the need aris...

lstsaur wrote:Also, whenever you get the error such as, " Error While trying to retrieve text for error ORA-12154", double check your tnsnames.ora file that has no syntax error, e.g. unmtached ().

There is an assumption here that your tnsnames file is syntactically correct, you may want to check that.

just4geeks wrote:Also in $ORACLE_HOME, there is no lib32 . There is only lib present.

All that means is that it only comes in one flavor - but it could be either 32-bit or 64-bit libraries. Best to double-check with your DBA that have indeed loaded 32-bit Oracle libraries. Just for grins.

By definition, for an inner join one is left and one is right but it doesn't matter which is which.

we did not stop and start DSEngine after making changes to these ORA files. That's not needed, so you're ok there. A couple of thoughts - is there 64-bit in the picture here anywhere? Wondering if your $ORACLE_HOME/lib statement should really be lib32 instead. Also note that you don't need ORACLE_H...

No, just saying that I think you're heading for trouble with that combination. The error simply says it can't connect for whatever reason, usually that means your dsenv changes weren't quite right.

Did you stop and restart DataStage after you made them?

just4geeks wrote:We are trying to import table definition from Oracle9i but we have installed Oracle 10g client on our Datastage server.

Hmm... don't believe you can do this, at least not safely. 9i client to 10g server, yes, but not the other way 'round. Check with your DBA.

What is not working about it? The substring operator as posted will do exactly as you said you needed.

Welcome to the dark side of Kenneth Bland, ladies and gentlemen.

Dagnabbit, someday someone will listen Ken!

First suggestion would be to search the forums as you're not the first to ask this. Secondly, does not the Surrogate Key Generator stage exist in your version?