DSXchange

I left out an important point : in this case the table is being recreated.

I know this "how do i create a unique number for the data that doesn't have a good key candidate?" issue has been beaten to death. In searches I did and talking to other folks I haven't seen much use of @INROWNUM. What is the best practice or what are the pros and cons of using this to cre...

Ray,
we found the problem. "pre sort input file" option was not clicked in on of the UniJoin stages. To me that shouldn't be a show stopper as the metadata will be the same even if the record is presorted or not. When we restaged this, it worked like a charm..

Baha

Look for "dsjob" in your manuals and in this forum.. Running away from UNIX to Windose, eh?.. I usually like the other way around :D

Anka,
is this a match job where you are running into block overflow problem?
What's going on when you try to run the job in QS alone?
Also, what are the stages of the job?

The more information you can give us, the better..

Cheers..

qsrtmngr is running. On top of that I have no problems with importing metadata for Job1, Job2, 3, 4 but when I try to import it for the job that is made of all the stages of Job1, 2, 3, 4 in the same sequence , the thing fails..

Ok, here's the log entry where the metadata import fails. The case is open with Asc but wanted to check if there is anybody else who ran into the same problem.. Thanks.. qsrtserv(18092):12/06/2004 09:49:18 AM TRACE: RETURN [1]: [ioset_dicts.c] [v_IOSET_init_metadata] 81 qsrtserv(18092):12/06/2004 09...

How about using the good ole QualityStage/Integrity ? :D

AScential doesn't provide this forum. Actually they have their own, but with extremely limited access.

Full scanning and dumping a hash file to a sequential file is VERY FAST. DataStage adds overhead, he could consider writing a very simple BASIC subroutine to dump a hash file to a delimited text file. You don't have to worry about formatting, just do delimited. Simply select all rows from the hash ...

I have a DS job that uses a QS plugin. The way my QS project is setup is as follows: <ProjectABC> <Job1> Select stage <Job2> Unijoin + Transfer Stage <Job3> Unijoin + Transfer Stage <Job4> Unijoin + Transfer Stage <AllJobs> AllJobs is basically a replica of Job1 through 4. It has the same stages lin...

As of yesterday Tivoli has been uninstalled.

Has anyone experienced any problems with Tivoli and Ascential DS+QS being installed on the same server? In our case we have noticed problems with hash files and QS services failing after Tivoli was installed on the server..

It is interesting. Actually earlier this year when I posed the question about writing plugins I was thinking about this :) At the time I was not "made aware" by neither parties that there is such a plug in :) Let's wait for Ascential Hawk and let's hope that they won't change the name ever...

I didn't know Trillium had a plug-in for DS. Is this new?