DSXchange

Hi,
Most likely your problem will be resolved if you rebuild (not copy paste) your mege stage a new (I've been this way before ).
I've had my share of this behaviour.
Be aware performing merges of huge files might proove to be:
1. slow
2. fail if you don't have enough resorces.

IHTH,

Hi, I found many a time using fully qualified names in ODBC to produce errors. So I simply erase the column derivations (annoying but works). It might just be a limit for column name in the odbc or something, I never gave it to much thought since I had lttle time and the work-around worked well enou...

My guess they use an ES7000 or something like that from unisys
They are capable of reaching the mentioned configuration and are quite capable machines performance wise as well.
And yes they run on windows OS (NT data center or similar perhaps win2003 today)

Hi, When you think of it what differs running a simple script/command/whatever in parallel on unix? (nothing really) You can have 2 scheduals at the same time each running different jobs. You can run then in the background as well using & in the command line. Assuming you do want to wait till bo...

Sorry to dissapoint you but getting them to sponcer your attendance in Ascential 2005 has better chances And no one can blame them for DS behaving this way !!! It is simple if you could work undisturbed with 2 CPU liscense on a 32 CPU machine why should you pay for more? even if you proove you restr...

Hi And welcome aboard ,
you can use Basic Match operator for one, or any other function that can veify the existance of a string in a bigger string like Count()/Locate(),Index() and such.

IHTH,

Hi, Your example sugests the data is sorted in ascending order so in this case You can manage the functionality using stage variables. since they are computed sequentially use the last stage variable to hold the current value, this way when you compute stage variables that apear before the last one ...

Hi,
Using my 6th scense I think whatever you want to get is do-able via the MetaStage, or perhaps some other means staded in Vincent's post at the FAQ forum (do read it - as there are only several posts there you'll find it quickly )


IHTH,

That is the exact dilema! when I say independant I mean as far as that config is concenred there are only x processors all available to DS so there is no way DS sees more then in the liscense you have. In short if you have 8 processors there is no way to get rid of this if you only have a 4 CPU lisc...

Hi, In general the routines mentioned for attaining/comparing the current and previous valuse use the basic's common space to save the last row's value and compare it with the current row's value. The only thing the compare routine does is return @TRUE (or 1) if the value you have is the same you ha...

Hi,
This was covered before.
in short unless the partition is independant as if it was a stand alone machine it will detect additional CPUs.
If this is the case and despite that you have a problem you should loag a support call.

Hi, Is your working directory the one of the project you want to run the job under? as you can ead from the message -local can be used only if your current working directory is the one of the project you run under. To find out what is the project's directory open DSAdministrator and select the proje...

Hi, Kim posted a list not long ago. In any case the list should be in any JOBCONTROL.H file inside the dsinclude directory under any project directory you have. This contains many code numbers and their meanings, among them are the "Possible return values for token DSJ.STATUS" there you'll find the ...

Hi,
on 2nd thought DRS can support native connection and still support many DB types so why do you use ODBC again???

Hi, You might also recheck the default library/package that the used user gets to and make sure it is pointing to a real DB and not some arbitrary directory with (as mentioned) huge amounts of files. I have seen cases that improper configuration caused the mentioned behaviour. p.s. make sure your fi...