DSXchange

Hmm... I always assumed the 'SB' in 'ASB' stood for Service Bus and that the 'A' was... Ajax or Aqualogic or something. No?

Something like a Citrix server for example? I don't believe there would be any issues with that or at least I don't recall seeing any during the small amount of time I was using a setup like that back in the day.

Two good examples of the problem with leaving out information regarding your issue or with providing a 'simplified' example. People take the time to respond and their responses are invalid because they didn't have all of the facts to work with.

Right, it wouldn't help as DataStage would still be stripping the internal quotes unless you escape them to protect them, as you've already seen. It's been discussed here quite a number of times as the problem goes way back... an exact search for "stripping quotes" should help.

i checked/unchecked the FILE HEADER check box...i found no change in the file output... Well, then you are either confused or not doing what you think you are doing. If you write 263 data records to a flat file with that 'header' boxed unchecked, you'll have 263 records in the target file. With tha...

Fully compatible, no. Mostly compatible, yes, but you'll find some odd issues with certain stages from what I recall when I did the same. You really should upgrade the clients to match.

OK... does 'deleted in Database B' mean actually gone / deleted / no longer there or is it more of a logical deletion by setting a flag? Assuming the former, worst case you could build a reference hashed file of B invoices and then stream them in from A, sending a delete transaction back to A if the...

Thank you for posting your resolution. Can you please also mark your post as Resolved using the button at the top of the page? Thanks.

OK. First you need to ensure both servers are configured identically and correctly and that you installed all of the optional plugins that you need in Production. After that I would suggest you start by creating a small test job in production with minimal stages and getting that to work before you w...

I'm assuming this 'production' is a separate server, yes? Is this your first attempt at running any jobs there?

Not to worry, first one is free.

If this is resolved for you now, please mark it Resolved using the big button at the top of the page. That will help future searchers know that there's an actual answer buried somewhere in the thread.

OK. Stage variables are evaluated in order, which is a key concept. That lets you use them to hold a value from a previous row and compare it to the current row's value. For example: Variable Derivation Initial Value svMarksChanged Link.TotalMarks <> svPrevMarks @FALSE svPrevMarks Link.TotalMarks &q...

No, just stage variables. A search here for 'rank' should turn up a number of recent conversations as September seems to be Ranking Month around here. Track the rank in a stage variable and only increment it when the 'total marks' value changes, and when you do increment it, increment it by the numb...

First see if an exact search for "The current soft limit on the data segment" helps at all.

I try to avoid unnecessary work. :wink: I was worried that it might actually reset it when it didn't need to, but hadn't tried it on a job that wasn't aborted to see. From inside job control code, you can use the DSPrepareJob() function regardless and it will handle the 'if necessary' part internall...