DSXchange

Many ways to do this. What is your overall scheduling mechanism? For example, we use Control-M and it provides the current 'Business Day' as a job parameter. Or a job / script could query the system and set the environment variable accordingly first off.

Silly question, but are you absolutely certain the DataStage job is reading from the same pipe that the shell script is writing to? I also seem to recall something about the pipe needing to be in the Project directory??

ArndW wrote:Does "E:\putty\pscp" require any additional terminal input?

You didn't answer this question from Arnd, the key question IMHO. If it needs to stop and prompt for an answer, there's no one there to answer when run from a routine. That's a very common cause of a 'hang' in situations like this.

Was wondering if anyone would mention that.

Note, this has been answered in the other post created to continue this conversation. If anyone wants to throw their two cents into the bucket, please do it there.

As of now, I really couldn't explain it. Are you saying that you used that same shared container in a new job and it functions correctly there, whereas it doesn't seem to be working 'correctly' in the older jobs? Does it help if you simply recompile the older jobs? If there have been any changes in ...

Note: No oracle client has been installed on the server As I already have Oracle database server, which provides all the shared libraries required by Datastage. This statement concerned me but I wanted to get past the whole 64bit/32bit thing first. It is actually the client that provides the connec...

peppy_perky wrote:I have created a new job for testing and there DBMS Code has been captured correctly.

What's different about this 'new job'?

Is your Oracle 'lib' 64bit? You need to specify the lib32 equivalents of those paths in your LIBPATH settings if they exist.

Question: While you have two links into one hashed file stage, do they both reference the same hashed filename?

Yes, you have full control over link ordering - it's an option in the Transformer editor. There are two icons, one for Input and one for Output ordering.

Totally unnecessary to use the routine like that. While Validating can be used to create hashed files amongst other things, I can't remember the last time I actually validated anything now that we no longer have to do that to precreate them. Yes, boys and girls, once upon a time that was The Way to ...

The critical piece to enable those options is the RTI Agent installation on your ETL server. Everything else just makes sure it all works correctly once they do light up. The question is - did you license the RTI Agent or just install it? Unforunately, the only way to license it is during the Server...

Exactly. :D

That's all well and good... and clever. However, that only solves the initial creation issue. Ongoing, I'm sure the hashed file needs to be cleared in one fashion or another each run, and hanging the transformer off the reference hashed file solves both issues.

Never did understand how you were planning on 'updating' a sequential file.

And there certainly is a Link Collector stage. I don't recall it being one of the 'optional' ones, however. Does it show up for you in the Manager under the 'Stage Types / Server / Processing' branch?