DSXchange

My preferred mechanism is to use a tr command at the end of the UNIX command pipeline to translate the newlines into something else (usually pipe, but comma is OK if there are no commas in your data). For example ls -1 filepattern | tr '\n' '|' Of course, this may have an empty line at the end, but ...

My experience is that, when the final item in the list fails, it is usually for this reason. You can add an extra command to your UNIX command pipeline to remove empty final line, or you can interpolate a user variables activity to achieve the same end.

What do you think will happen, and why? Have you examined one of your extant state files?

Do you have an empty line at the end of the list?

If you're using the dsjob command, then the project name is specified on the command line. If you are using the same project names in both versions, then specify the full pathname of the dsjob command (that is, from the correct engine) and make sure that the correct dsenv script has been executed an...

But it doesn't matter.

A surrogate key provides uniqueness, just uniqueness, and nothing but uniqueness. There's neither guarantee nor requirement that the numbers will form any kind of sequence.

Yes.

What's different between the two environments?

Don't answer "nothing" because that's clearly not the case.

For example, are the tables indexed on the key in dev and not in sit? Or is the database local to dev and remote from sit? There are several other possibilities.

You have not enabled multiple record return from the reference link.

This is perfectly expected behaviour where block size is set to 1000.

Actually, it doesn't. But it does mean that you have to name the columns to which transformations need to be applied - all the other columns can still be propagated. If these columns are the same across various tables then some generic jobs may still be possible.

IBM has announced "IBM InfoSphere Warehouse 9.7.3, with Terabyte pricing, new virtual image and Cognos 10 BI reporting".

Should we be worried about "Terabyte pricing"? Is this yet another new pricing model, or is it simply that the cost is $1T ?

Size in the hundreds should not be a problem.

If you have no transformations you can write one generic job. The Sequential File stage will use Runtime Column Propagation and a schema file to describe the layout. The pathname of the schema file will be passed as a job parameter, as will the target table name. Provided the date/time formats in th...

It should work if Max_files is truly integer. Try one of the comparison functions.