DSXchange

You do not and cannot "load with sign" into a Decimal field. Decimal numbers are stored in binary format, with one bit reserved for the sign. The only way you can store the sign is to use a string data type of some kind.

Set the array size to one of:

• buffer size / row size
  
  packet size / row size

or a small multiple thereof.

I suspect the question relates to a sequence governing parallel jobs.

You might like also to investigate using DataStage routines such as the AddMonths routine available here.

Maybe it's just a timing issue. Even though you issue a stop request the job finishes before it gets a chance to process your stop request.

Because CUSTOMER_NUMBER column was being propagated even though not named on the link.

Welcome aboard. Work your way first through the logic of Type 2 changes. On paper. This will trigger right thoughts about which stage types to use to implement that logic. If you still think you need help, post your analysis back here and we'll proceed further with it. Oh, and you probably don't nee...

... or a routine.

I read the specification as you wanting just two (or one).

Obviously a more generic solution will be more complex. If it's to be no
more than four you could probably stick with the If..Then..Else construct.

Otherwise you are probably going to need some kind of looping solution.

If you have those stage types you have Java PACK installed.

Doesn't need looping. I'm also assuming that you're intending to show concatenation with your use of "||" (though the DataStage concatenation operator is ":"). If Index(Sequence, ",", 1) = 0 Then Field(Codes, ",", Sequence, 1) Else Field(Codes, ",", ...

"Unemployment" is "not working". Please clarify what you are expecting to happen and what is actually happening. Provide details of any error messages where relevant.

What have you tried? That is, how have you programmed the properties of the XML stage, including xpaths?

How is your test environment's "read-only" status implemented? For example if it is implemented using file system permissions then the answer is a qualified no - the only way to bypass file system permissions is to operate with superuser privilege.

I have not experienced this behaviour but, again, my site does not experience any extended periods of idle time.

I also am unaware of any way to bypass restarting of the ASB agents in this scenario. That said, it's not difficult and doesn't take long - you just have to work around other users' requirements for access to the engine.