DSXchange

Regarding the loop, a little further down there is another example, "Input row group aggregation included with input row data." Not that you want to aggregate in your case, but I'm just saying I think what you want to do is possible with a loop. You can get very creative with loops. Howeve...

I believe that mysql ODBC connectivity is supported by the bundled Progress DataDirect ODBC drivers. I don't know if mysql is supported as a QualityStage Match Designer Database, since it is not mentioned in the tech note.

QualityStage adds "data quality" stages to your DataStage Designer palette. If you check under the "processing" palette category, you should find the Pivot stage. You can mix and match DS & QS stages in the same job design.

I am trying to run a job where it should prompt me with ten different values during run time. My question is how do I define these values for a single job parameter? With a single job parameter, you will be prompted a single time for a single value. What is it you are actually trying to accomplish ...

Check out this IBM tech note:

http://www-01.ibm.com/support/docview.w ... wg21409481

It mentions DB2, Oracle, and SQL (meaning SQL Server; not mysql).

If you're on the Column Analysis screen, look in the top right corner for a down-arrow menu to click on. From there choose Create Report. You can create reports from other menus also. Run through the wizard. For Excel, choose Output Format of XLS.

Maybe it's not a duplicate line... The message says duplicate entry. Good luck with that one...

Yes... the Merge stage should work too!

Transformer stage loop should work as well. The product documentation has good loop examples.

On the Format tab set only these settings: Record level settings: Final delimiter = none Record length = fixed Field defaults: Delimiter = none Quote = none You can probably delete settings that are set to "none" but I'm certain the above combination works. Of course, make sure you don't h...

DataStage removes any single # from ExecCommand stage upon execution. I think it is a bug, as it should give a warning and also provide an escape character for a # sign. In place of this: !/^#/ Substitute in the regular expression octal code \043 in place of # like so: !/^\043/ Hex may also work as ...

Is that error coming when you run a job or when you attempt to import ODBC table definitions? Have you tried both ways and get the same error? If you have not tried running a job, you could manually define a column from a known table without importing all metadata first, just as a test. Perhaps ther...

I tried it on 8.7 with all default settings by adding descriptions to every source, processing, and target stage, then saving the job, not compiling it, generating the report, and all descriptions show up as expected. I'm not sure what version you're on, but perhaps it has a bug. Try it from a Desig...

The permissions on your DSParams file look OK to me. The group owner of the file... I'm not so sure. Also, it's showing a * at the end of the file name. Double check with ls -l DSP* on multiple project directories to compare. Whoever modified it last shows as the current file owner along with that u...

If you are asking about a multi-instance job, those can be parameterized and run many instances simultaneously with different parameter values or even same values all at once or in sequence. It sounds like your question may be slightly different. If so, can you give an example?