DSXchange

I guess we ought not to have assumed that that configuration step had been done. Well done for solving, and well done again for a lucid post containing that solution.
:D

Insert a Column Generator (or Transformer) stage on the reject link to generate the required constants.

The string "__________" can not be converted to a Date data type. You need to handle that situation explicitly with an If..Then..Else expression.

Go to the Columns grid. Right click on the appropriate row and choose Edit Row...

This should open a dialog in which the extended properties of the column you are editing are displayed, and you should find field width among them.

Do you feel ready to mark the thread as Resolved?

If so, please post to aid future searchers about where you set the property to increase (memory) size to 512 (units?).

I don't know for sure what the basic executable is. I suspect it's for compiling PI/open and Prime INFORMATION code, but the honest answer is that I do not know. There are some things one does not need to know. Then again, it's identical in size to nbasic.exe, so it may be a synonym. Perhaps the BAS...

For the rest of you non-UniVerse-speakers out there, Kim is effectively referring to a SYNONYM for the table name. These are not blocked from the table definition importer.

Default execution mode for SELECT is, indeed, sequential. Execution mode is only enabled for SELECT if the table from which you are selecting is a partitioned table and you have set that property accordingly.

hJob1 = DSAttachJob("loadCounty", DSJ.ERRFATAL) If NOT(hJob1) Then Call DSLogFatal("Job Attach Failed: loadCounty", "CTLoadCounty") *Abort End ErrCode = DSSetParam(hJob1, "DBNME", DBNME) ErrCode = DSSetParam(hJob1, "DB...

Hello DaeHwan, If you are concerned that the time window might be a problem, go back to IBM and ask them on what basis they recommended this particular configuration? There are several very large corporations using 24+ nodes for DB2 (with large DataStage configurations such as 24 nodes in the DB2 no...

You must detach after the RESET mode run, and re-attach before the NORMAL mode run.

The component between the keyboard and the chair.

Not yet.

Where did you get 15 as a number?

The answer, as usual, is "it depends". It depends on the volume of reference data. It depends on the format (internal or external) of those data. It also depends on how you define "performance" in an ETL context.

Here is one way. I have not given this much thought. There will be better ways.

Create a job parameter specifying how many records to skip. Add a Sample stage after the Data Set stage, with its Skip set to that job parameter. Run these in sequential mode.