DSXchange

ILArchives..JobControl (@FAILED2): Controller problem: BASIC routine is not cataloged: DSU.ForceFail the above is the error DS throwing when I am tried to execute a Sequencer which also has a routine named 'ForceFail' to kill the sequencers forcibly in the event of an error in any of the jobs/sequen...

Please give us more details abt ur environment. but one thing I am sure which u might have noticed is that if you have one processor ur parallel jobs will run slower when compared to Serial jobs because of time sharing..

more details like if ur using Parallel Extender will certainly help..

I am taking a guess here..

Check with ADABAS if they have any ODBC drivers .. if they have then that is ur solution... if not check with DS if they have any stage for ADABAS stage.

Phatom 1988 Program "JOB.1683879296.DT.1295430175.TRANS1": Line 297, Nonnumeric data when numeric required. Zero used. This is the warning message I am getting in my job log. Frankly there is no TRANS1 named Transformation in my job and I couldn't figure out which Transformation/column is ...

I understand what you are saying. But one of the look ups has just 11 rows and another one has just 45 rows. Do u think I still shld go for the lookups for these stages? i am not being lazy here :lol: , but just wondering to what magnitude that will reduce the performance. the two main stages in thi...

Hi folks, I want to speed up my job. I couldn't figure out what is slowing it down. I have a OCI stage which is bringing in 98,000 rows and there are 6 lookup OCI stages and all of them are very few say in 100's(this is the reason for not going to Hashed file stage). When I have the original OCI sta...

http://www.tools4datastage.com/forum/to ... C_ID=85322

I believe this is the link for finding file size posted by Kim Duke.


thanks

I want to achieve relative paths in DS for the Sequential file stage. is this possible. I need this as the directory structure is different in my dev and prod areas. and another question is that where can I change the parent/root directory for DS on the DS server. In my case the DS is sitting on top...

even i am *guessing* that in the target OCI stage the column size is not enough to accomodate the data it is pulling from your PeopleSoft source. thats what atleast the warning looks like. try this, allow 50 warnings for executing your job and also 20 rows in the limits of the job while executing it...

Can someone tell me how do you pass the job name to the routine that is being called in case job aborts. I am using Rick Schirm solution as suggested by Kim Duke. I was not able to pass it as parmater. If I do that I am having compliation problems. Thanks PS: I got this, all I have to do is enclose ...

What is the "Expression Type" that takes care of this?

Thanks Ray Wurlod, I am working on it now.

WOW Kenneth that stuff you posted abt UniData is amazing. I have no idea abt Unidata at all.

thanks for that.

Thanks Mr.Bland for you time! Well most of my source stages are UniData, I think I have to go for 'eliminating unused columns'. Can you clear this for me? I assume that DS Server first requests all of the columns are present in the stage properties and then later discard them if not present in the o...

Will unused columns in Source stage will effect performance ? I mean when we use 'Load' utility to load the table definition/metadata in the Source stage for whatever it is ODBC table or Sequential file, u load all of the columns for a given table and you may not use them in many cases. Will this ef...