DSXchange

Just check to see if the lookup succeeded and constrain the job to only pass rows where that is true. Use the Link Variable NOTFOUND, and Not() it to check for 'found'. ... Sorry Chulett, I didnt understand ur concept. chulett is asking you to do, NOT(<linkname from Hashfile>.NOTFOUND) This <linkna...

Can you provide some more info. please like what will be the Syntax? Extract everything before the first space from your timestamp using the FIELD() function and then compare. QuestExpert, You should be having DataStage installed. Go to HELP and search Field() function. It is pretty straight forwar...

Clean up resources in Director not showing any of the process ID and Processes. I am not able to unlock the jobs being accessed by other users. What needs to be done to get back all the process ID. Try Search in dsxchange. There has been a lot of material posted! There are ways to get PIDs and stuf...

chulett wrote:

nivas wrote:I need to join to a hash file like follows.

You can't. A hashed join is an equi-join, period.

My bad.
I was all the time thinking that the >= and <= are going to be put as a constraint. Craig is right. You cannot have any other join with a hash file other than an equi-join.

Samit, Inactivity timeout settings ARE in Administrator general tab. The default is set to 86400 sec (I think). That is a full day! There is also a "Do Not Timeout" check box underneath the settings. Also, bear in mind that when the network connection is severed, this happens too. I encoun...

Its not allowing me to put sourceFiled<= at join to hash file Key Column. After <= I should some thing which datastage allows I am not able to completely comprehend your question. This is how I am interpreting your job design: Hash File (Two key columns) | | V Source File ------------------------> ...

I need to use one souce filed as lookup against hash file. My hash file has two key columns.I need to join hash file as follows. souce filed <=First key filed AND souce field>=second Key filed From reading your post, I am assuming that you need to put constraints, like Source field <= (less than eq...

arshi wrote: I given all the ways like computer name,localhost etc.
But it not working.

Why don't you try not Omitting Username/password. I mean, explicitly type your computer's login id and password (if any).

Log into the uvsh. Do a LIST.READU command. From here, you can go two ways, one way is to use DS.TOOLS [/b]. This has menu options, so it would not be difficult to navigate (make sure you make a note of the PID listed for your job in the LIST.READU command) Second way is to take the user number from...

First off, understand that a while a dblink does allow you to 'join' tables in disparate instances, the data from the remote database still needs to be sucked over into the originating database, built there and then joined to your tables. So, while it can be a simple solution to the problem, it's n...

The output had identical columns, and I should have mapped A->A, B->B and C->C, but I accidentally mapped C->A, B->B, C->C. The actual column names were easily confused, and I was careless in not mapping them correctly. The consequences of this, however, were that the C column contained entirely nu...

Hi, Being new to the forum and the tool I would need help with the following: 1. What is the difference between Datastage Server and Enterprise and which should be used and when? 2. What versions and editions of Oracle will the datastage version 7.x compatible with? Any online resources would also ...

The OCI stage in 7.5.1a (maybe 7.5?) is where official support for 10g arrived, from what I recall. Doesn't mean you couldn't access it in earlier versions, just that it wasn't "officially" supported. We accessed 10g via a 9i client without issue, for example. We use ORAOCI 9 stage (if th...

The OCI stage in 7.5.1a (maybe 7.5?) is where official support for 10g arrived, from what I recall. Doesn't mean you couldn't access it in earlier versions, just that it wasn't "officially" supported. We accessed 10g via a 9i client without issue, for example. We use ORAOCI 9 stage (if th...

Sharad, 7 million rows is not a lot if each row is 10 bytes. If each row is 100Kb then that is a different matter. ArndW is right. Keep in mind, Hash files have a limit of 2.2GB (if I remember it correct) and if that limit is exceeded, then we have data flowing into the overflow bucket and performa...