DSXchange

I'm really wondering how the points are attributed for each post ?! Is there a ten-page algorithm for this ? Although it seems pretty evident that no one will reveal the whole algorithm ("woah, what a lot of fun to post keyworded messages only to see my points growing !!"), i'm very curiou...

No OLEDB is involved in the crash, so it seems like i won't spend time looking for an answer this way. Like underlined Roy (reading between lines), there probably is a bug onto the Folder stage (or onto Routines) that forces the process to work into physical RAM. I'll wait the support to call me bac...

Thanks for your answers ! (... Well, not to Craig, who laughes at those using DataStage on Windows :lol: ) The facts are : - OS takes about 100-150 MB of RAM (seen at the server startup) - SQL server can take up to 1 GB of RAM and 100% CPU ressources (this is, by the way, really annoying when it occ...

Woaw, what a furious excitation around this matter. Please, no, no, it's too much, don't involve yourselves that way :)

... or :( , i don't know.

I think you have to let at least a blank between MT and the format...
It should look like , shouldn't it ?

If there aren't billions of lines in your target table (probably the case when talking about clients), what about a deadlock ? Something like a manual update/insert into your table, with no following commit ?

Well, in fact you're really right. The line indicated in the DataStage job's log matched the defective one into the RT_BPxx\*.TRANS2 file.

Anybody, if you know someone selling a not-to-used fully fonctional brain, please let me know.

I totally agree with Craig (for what is worth :)

Wow. The sun shines again. Here is what i found (sorry, you'll have a bit of work too) : Just make a search through the forums with the sentence "Nonnumeric data when numeric required. Zero used." In my case, Kenneth insists in many posts that this error raises when calculations are made o...

I just discovered i have the same problem on one of my jobs... - sigh - I ran into the project folder, starting a search (with the Windows Explorer) on my "JOB.xxx.DT.xxx.TRANS2" string. What i found is a painful, horrible and terrific kind of bytecode (not really hexa, but something full ...

Hello Kim, Well, i bet i'll have to learn to read (or, more useful, to understand what i read) ;) I just searched the forum for the sentence "Nonnumeric data when numeric required". It seems that there is no easy way to find out which field is the guilty one... It was written that one way ...

Please make a search before posting an issue that can easily be found within this forum : in the upper navigation frame, click "search", the fill the "search for" field with your keywords (could be "date conversion", for an example), make sure the radio button "ma...

Hello Kim, Instead of hacking files so ugly that you really don't want to know about them, why don't you add a reject file on the faulty design ? 1. Make a backup copy of the design 2. In the Designer interface, just add a flat file stage, link the transformer to this file, then propagate to the add...

I just voted "no", but agrees with Craig when he says that... They could be restricted to the Profile page and not included in any postings. You could control the Avatars and give us some tasteful ones to choose from.[...] it would be cool Without the question of the bandwith (although i m...

Curiousity ?! Argh ! I hope i answered a little to your questions... In fact it seems that BW interests a very few people, and amongst them, lesser people work with DataStage AND BW, since the B eautiful W ave has its own loading processes... If any "SAP savvy type" help us, maybe he'll an...