DSXchange

Tell us what "doesn't work" means. If the db credentials you are using are passed into the job as job parameters, there's no reason you can't bind them into a Before Job call to ExecDOS or anything else.

Store it as a string in that format.

Have you contacted support for any of this?

Read the file as a single long string and count the delimiters. The column import stage can then process the good ones, if needed.

Hmmm... that can be a LOCALE issue where the fact that you are using the comma (rather than a period) as the 'decimal separator'. It's also something you can set for a decimal column directly. Perhaps try that in the transformer?

Cool. And yes, I got the count thing backwards. [sigh] Need to slow down a bit and not be posting when I should be working. [shhh, don't tell anyone] Normally, one would have a list like this: "12,15,33" so you would need to count the commas and then add one. But when you have a list like ...

You need to do this where/how? In a DataStage job of some type, command line script, elsewhere? Knowing that will drive the answer.

So to know how many values are in the last field, count the delimiters into a stage variable. In your case, if there is always a trailing delimiter then count and subtract 1. Then loop while @Iteration is less than or equal to that number, using the Field function to pull out the "@Iteration&qu...

Since you didn't specify, most of my comments assumed a sequential file output. Sorry but I also misread your output example, was thinking you just needed those values parsed out into separate fields in the same record, hence the 'append' comment. :( So you actually need a pivot, specifically a hori...

Since you don't know how many values may be in that last field then your best course of action would be to use 'transformer looping'. There you can get the count for each record and 'loop' that many times to parse those out and append them to your output. That or perhaps just 'convert' all those com...

We'll see if anyone has had any experience with this issue but any time I see something like "everything about it works as expected except for this one thing" you are probably firmly in support's hands.

A search here for "try catch" only finds your post.

My main concern... is, what happens if job fails To me, that's one of the primary drivers of any design, CDC or otherwise - how does it recover from failure? We always keep "jobs" as atomic as possible, discrete units of work so that failure during one step doesn't mean repeating multiple...

For a "POC" I would think you would be trying both ways in order to make that determination for yourself.

Obviously, the "You cannot reply to topics in this forum" message isn't true or we wouldn't even be here.

If I had answers, not to worry I would post them. Just "moderating" things in the forums at the moment, can't help with your specific issue. And that's messed up, no clue why you would be seeing all of those "You cannot" messages. Does it matter what forum you are browsing, meani...