DSXchange

Do you know what port number 10000 is used for? Did you accept all default port assignments during installation?

Have you verified that this port number is open, if you have a firewall for example? Check, too, that port number 10000 is not in use for any other purpose.

You may be able to effect this change with a Modify stage or, if you must use a Transformer, then DecimalToDecimal may work.

Welcome aboard.

Please be more precise. What is the "button of data source"?

Since the error message indicates an EOF error of some kind, I'd be looking first at the .odbc.ini and uvodbc.config files, to make sure that they are complete and that their last line is terminated.

OK, here's how I would go about this provided I had my customer's imprimatur. Create a stage variable containing the characters you want to keep. Use the "double Convert" technique to remove all the others. Convert(Convert(svKeepChars, "", InLink.TheString), "", InLink....

1. Find the 'b' that is giving the trouble. There is a search facility in the routine editor. 2. OpenSeq will take its Else clause if the file is successfully opened but does not yet exist. Search DSXchange for a routine called OpenSequentialFile that shows all the permutations. 3. Parsing of the ei...

Actually you only need to do it once.

Given your "challenges", the answer to your question about the generic job is "No". Partitioning of SQL queries should be able to be handled automatically by either the database server or the Connector stage. Restart logic, however, has to be designed in. You need to keep records...

Do you know what port number 10000 is used for? (You would have accepted this default when you installed.)

Clearly this is not a problem with installation, but with running a job.

Find out what the problem with port number 10000 is on your system.

Can you please post the result of the AlNum() function on each of your five use cases?

Where did the question mention Ctrl-M?

The upper limit on the size of a segment file is 2GB if that is the operating system's limit. Since the naming convention allows for 10000 segment files per node this is not really a restriction. Any other operating system limit on the size of a file may also affect the number of segment files per n...

Yes, but you posted your question in the Server Edition forum.

Amend my earlier reply to read Parallel Job Developer's Guide - you can find the page in Information Center easily enough.

Create an explicit Failure trigger, even if it only goes into a Sequencer. This will override the default handling of "errors" (non-zero exit status values). You might also disable "log warnings after activities that finish with a status other than OK" in the sequence's job prope...

Welcome aboard.

How much of the Server Job Developer's Guide chapter on the Complex Flat File stage have you read? An alternative source is IBM Information Center.

You should be able to adapt the examples there to suit your own requirements.

Not necessarily the case. The correct response is at least one segment file per node. There can be more than one.