DSXchange

Job, link and stage names can have underscores in version 7.1r1 (Engine release 7.0.1.1r4). :D They must, however, begin with an alphabetic character. There are no limits on the name of a hashed file other than what the operating system imposes. Even a single underscore is legal as a hashed file nam...

I normally include the schema (owner) name as a job parameter, and inlude it explicitly in the Table Name field.

Using a job parameter makes it easy to move from development through to production where the schema name may be different.

If you REALLY want to set environment variables in Windows you can; open System Properties (right click on My Computer, choose Properties), select the Advanced tab, then click Environment Variables button.
You need to re-boot for them to take effect. Blame Bill.

Generate the next value into a stage variable using the KeyMgtGetNextValue function. Use that stage variable as the derivation for the output column on both output links (one to each table). Stage variables are evaluated once per input row. Column derivations are evaluated once per output row per ou...

What is the reported status of the job that won't start? This symptom can occur if the job has not been compiled.
Does the Job Run Options dialog open?

A small correction. Prefer the following: Ereplace(EntireRow, ",", Char(013) : Char(010), -1, 0) Using 1 rather than -1 as the fourth argument replaces beginning at the first occurrence. -1 means "replace all occurrences" (that is, the function is implicitly self-do...

How did you try to execute the job? Please describe your method explicitly and completely. Does the job have any parameters? Did the Job Run Options window (in which you can set parameter values, run and warning limits and tracing) appear? Are you sure you clicked OK and not Cancel in this dialog? I...

Did anyone reset your sequence, or change the name by which the sequence was being invoked? I would expect any roll-around to start generating negative numbers. Presumably the Oracle column is NUMBER(38), so the MAXINT value discussed above wouldn't be a problem. For the quick and dirty solution, ta...

If you're at the UV shell by the means indicated above, you need another step. You must move to your project. The command for doing this is LOGTO (approximately the equivalent of cd). LOGTO ProjectName Once there, you may need to use SETFILE to create a VOC pointer to the hashed file. To determine w...

Welcome aboard! Are all columns in the same association? If not, try putting them all in the one association, and normalizing on that. You may need to edit the file dictionary of the hashed file AND re-import the hashed file's table definition afterwards (or edit the Columns grid to record the fact ...

Installing isn't enough. You have to start DataStage. Have you done this?

If you have, you will be able to see DataStage processes, such as dsrpcd, running if you execute a ps -ef command. Can you see dsrpcd?

How are you trying to start a job?

KeyMgtNextValue is a BASIC routine. There have been recent posts here about using BASIC Transformer stage in parallel jobs; the same may apply to BASIC routines. That said, KeyMgtNextValue and KeyMgtNextValueConcurrent do not have any link to anything except the argument value supplied. They can be ...

While DataStage can certainly do all that you specify (without needing great skills), it seems an expensive solution if that is your only task. On the other hand, if you're likely to have more data migration tasks, or are thinking of developing a data warehouse or similar, then it's probably a wise ...

chulett wrote:

ray.wurlod wrote:So far I've avoided using DSPrepareJob.

Just... because? Seems to be working just peachy for me.

Just because. Always done it that way.

Having been burned with "attach lock" errors I always detach and attach, as your code does. Because they're effectively in adjacent statements in the one routine, I don't really lose control, though I do have to set parameters afresh. So far I've avoided using DSPrepareJob. And I never use DSLogFata...