DSXchange

There's a problem with the OLEDB provider. Prove this a follows. Create a job with an OLEDB stage and an output link from it. Populate all required properties then View Data. You will get similar error messages. Since there are no other stages in the job, the OLEDB stage is clearly the culprit. Veri...

The status of dsjob was correctly 0. It (the dsjob command itself) completed successfully.

If you want the status of dsjob to be the status of the job itself, then you must use the -jobstatus option rather than the -wait option.

Hi everyone, I am waiting for your answers! Can you please tell me if there would be any compatibility issues? Thanks, Gaya3 A whole two hours had gone by. You really must learn patience if you are going to participate in an all-volunteer site like DSXchange. If you need urgent answers, you will ne...

Reset the job. Examine any "from previous run" log message.

You have marked the post as resolved. Please post how it was resolved, to aid future searchers.

Use @VM rather than Char(253) - even though it's the same thing. Char(253) here is a function call, not a data type.

Based on your sample, the date is always the last three space-delimited fields or the last one if it is of the form nn/nn/nnnn. Extracting them should be reasonably straightforward; for example a Field() function or maybe a MatchField() function governed by If..Then..Else to get the raw date. For ex...

Space or permissions in the project directory?

Was the Terminator executed? (There will be an entry in the job log.)

Are the two values spelled, trimmed and cased identically? Is your VarChar large enough for this string?

Welcome aboard.

Did you install Information Server first or the compiler first?

In my experience it is best to install the compiler first.

That having been done you need to make sure that the four environment variables that inform DataStage about the compiler and linker are correctly set.

NOT LIKE is not supported. That's SQL. You can use NOT LIKE in a Filter stage.

In a Transformer stage, you must build an expression using Not() function and Matches operator. Or you can test the first character of the string as an explicit character value.

None of which I'm aware.

Which might only mean that it's a well-kept secret, but I doubt it.

Not in a server job.

Please post in correct forum.

Show us the precise properties of the StartLoop activities.