DSXchange

I have tried using 025, 222 for all this it fails with the following error: DST_BenefitPlanLoad_MBR_PAY_DSGN_STEP_SUM_DIM_ins: Error when checking operator: "delim_string" property must have a string value; text: delim_string=222 You should be entering that as the Delimiter property, not ...

Hmmm... then I wonder why have the ',s' modifier if '%m' or '%d' does the trick?

I don't have my documentation with me and search isn't turning up what I'm looking for - there's a date format modifier that allows a portion (month, day, etc) to be 1 or 2 characters... 's' is coming to mind but it is spelled out in the docs. James, I don't think the single letter formats handle bo...

It's been discussed here quite a bit as your search should have revealed. Much of the talk, however, would have been specific to a Windows DataStage server. For UNIX, from what I understand you'll need Excel ODBC drivers... I have no clue if those are included or if they are something your company w...

palak08 wrote:I tried doing link ordering in Transformer, but of no use.

What exactly does this mean? Proper link ordering is your answer. That and an Array Size of 1 and (perhaps) a Transaction Size of 1 as well.

Huh... I thought the PID was used as part of the name.

There's no need to delete anything if it is no longer being used. If it really bothers you, switch to user defined, delete the SQL and then switch it back.

There's no "not supposed to" here. Just curious why the question was asked. Many times we see questions like this asked because of an underlying problem when people should be explaining their problem to us rather than starting with their perceived solution, which many times... isn't. If yo...

Un-hijacked. And your answer can be inferred in what Ray wrote to the hijacker.

Un-hijacked.

While you can specify multiple, please understand that only one is actually needed. And I found an example of the error I recalled, one such example is noted here: "Error: The link contains more than one repetition rule". Looks like either only the XML Input stage has the error reporting l...

Yes. That is what they do. Why do you ask?

I'm surprised that even ran as only one 'repetition element' is allowed and I could have sworn it errors out when multiple are detected. What exact version of DataStage are you running?

Nex time please start a new post rather than jumping the end of someone else's only somewhat related post. I've split this one out for you.

chulett wrote:You 'tried to convert' how, exactly?

jwiles wrote:What is your derivation logic, your source column and target column metadata?

So... do we have to guess?