DSXchange

Doh! I forgot about that little sticky point... and it certainly is a very necessary step. Sounds like you should be fine after that.

Or you need to create a copy of the routine that can work with pathed hashed files. Hint - it's a change of one keyword in the routine.

I have a job which reads a database and looks up against a hashed file. The lookup returns just one row. So, the output contains one row with two columns. Now, I want to use these output values as parameters in the next stage. Explain exactly what you mean by the last sentence. How are you intendin...

Typical flat file interfaces don't put the onus of COMP-3 creation on the file creator. If I was in your shoes I'd push back on the requirement, insist on sending everything in 'display' format and put the burden of the COMP-3 conversion back on the target system where it is fairly trivial for them ...

ray.wurlod wrote:No, this is just DELETE.FILE failing because of entries pre-existing in the VOC file.

Granted, but trying to get to the root cause. Before that, something caused the delete of the VOC record to fail causing this error on subsequent runs... yes?

Hmmm... ok. Don't worry about how the database migration was done, that's a DBA thing and they like to keep that kind of arcane knowledge secret. Just wanted to see if you did something specific with DataStage as well as part of that. Shouldn't have needed to. Are there any other messages in the job...

Welcome Aboard. :D

How did you accomplish this 'database migration'? Specifically, what changes did you make to your DataStage environment? I ask because the two problems should in no way be related.

answering to chulett: why sould i do that? because i have configured the sequence job with multiple instances option. Thanks. Sometimes people ask a specific question about how to do X and they don't mention they are trying to use that answer to solve problem Y... and X isn't the right answer. You'...

Contact Support and they will make it available for download to you. You could also try the IBM/Ascential ESERVICES site if you have a login there.

sqlldr failed. And it noted you should "see the log file for the Oracle specific message". What did it say when you looked in the log file? You'll even note it provided the LOG filename from the sqlldr command line for you.

Exactly. I've seen Projects with three times that number of jobs or more. They can become unwieldy and slow to open in the client tools, depending on how they are organized - but proper use of categories can help alot in that regard. I believe you'll find a physical limit on an AIX server, but that'...

As -logsum option populates entire log history, but require only last executed log details for job. Is there any way to get latest log only with dsjob command That would be the -lognewest option. As noted, all of the command line options exist as 'DSGet' functions that can be used inside a job as w...

Well... how about How to Extract only number from alphanumeric?

Not unusual on UNIX systems to have regularly scheduled processes sweep the system for core files. They do tend to be fairly common. Too bad they aren't doing that here, just did a quick check of the limited areas on our dev server I can reach with my userid and found 56 of them.

we do not have these stages in the stage types folder of the repository tree. Then, in spite of what you have stated, you have not successfully installed the RTI components. Also in the job properties window we are not finding the option to ENABLE RTI services Confirms it. And the 'package installe...