DSXchange

Build a routine. Count the number of fields and then loop through them, concatenating together the result.

You'll need to figure out or look up what Excel uses for its 'zero date'. Shouldn't be too hard.

Why not apply a Date format to the speadsheet column so you get a 'real' date in your saved csv rather than Excel's internal date number?

It's been discussed here quite a bit. Rather than someone typing it up one more time, how about searching for a signifcant portion of your error message? An exact search for "ParamValue/Limitvalue is not appropriate" should turn up what you need to know.

What is the datatype of this 'message' field in your database? Some types, like TEXT fields, are not easily supported - if they are supported at all.

Forum software removes all of the 'extra' spaces from posts unless you wrap things in code tags, so your 'dummy' data doesn't even look close to fixed width data unless you do what Ray must have and 'Reply with Quote' to see the raw data. 699991267250AV Ivan Ge388425101143953563022008435087 41 Eight...

You should probably open a case with your official Support provider as there isn't a ton of 8.x experience here yet. I just wanted to make sure you were using 10gR2 as that seems to be the supported Oracle release and the only one that stands a chance of working, from what I've read here.

What version of Oracle?

What version of the Oracle database? Oracle client? Search the forums for CLOB, you'll find quite a number of discussions on the subject as they can cause all kinds of problems. Here's one example a search turned up for me: m Look at the others as well. I personally have never had a need to try to d...

If it is already 'parameterized' - i.e. a Job Parameter, can you not just refer to the parameter name itself in that column's derivation?

Thanks Gateleys. I'd searched for the KBA utility name, figured that would be included in any post with the code. When that didn't turn anything up and you posted, I stopped searching. Thanks for providing the link.

I find it strange that 'help' here is only considered to be limited to naive people asking questions and experts answering. Guess I expected too much when asking experts to read a 8 page pdf. Hardly. As I noted in the first reply, patience is a virtue here. Not everyone checks in all the time nor h...

Was just going to post the same thing. I could have sworn it was posted here, but couldn't find it. It used to be available at the old DataStageXchange site but is 'No longer available' there.

Yes, that would have been good to mention. What is the metadata for this Oracle field in your job?

It has no idea you have implied decimals there, you need to "unimply" it - divide it by 1000 or there is a FMT option to change the scale.