DSXchange

It's not something you would really choose to do in DataStage, but it can be done. Step 1 is the query to get the value. Step 2 is the command to set the environment variable. But, here's the rub. When the DataStage job finishes, its environment ceases to exist. So any environment variables that you...

... and a UniVerse table behaves much like any other database table - you throw SQL at it and get results back. Constrained queries are assisted by indexing on the constraining columns (except for leading wildcard constraints).

Table definitions require select privileges only to the system tables, not the actual database objects. So it is perfectly possible to import table definitions and yet not be permitted to access the actual database objects.

What's the relationship between Table A and Table B? That is, is there any key column that appears in both that could be used as the basis of an inner join? If not, what is the business rule? For example, are you sorting each? What to do if the number of rows is different? SELECT DISTINCT A.col1, A....

I'd prefer to simply link from there to here.

Does it really work, having experts getting paid to help novices? How is it organized? Who pays?

Search and RTFM are your friends, here. You need to do an -itag installation.

Probably the best is UniVerse System Description, but you would also need UniVerse SQL User Reference

Server edition will, however, use the new Repository in Hawk and beyond, and will therefore carry the overheads of translation to and from data types for storage. On the other hand, the intermediate services layer may speed things up. There may be some small enhancements to Server edition, particula...

Are you running 7.5 or an earlier release? (There are extra goodies in 7.5.)

No, it doesn't mean that at all. You can use the same Data Set, but you do have to ensure that the lookup will find all the keys it needs to, and that means that the stream and reference inputs must be partitioned identically (and sorted identically for Join and Merge stages) on the keys being used ...

In separate rows? Decomposing the string uses substring techniques as discussed. For splitting into separate rows, search the forum for vertical pivot.

1.5GB is not huge. Hashed files (with 64-bit addressing) can theoretically be up to 19 million TB in size (if your o/s permits).

Care to share? If you post what the problem was and how it was fixed, then someone else who encounters error 22 in this situation may be able to resolve it more quickly in future!

Please post your "criteria" - the exact expressions, please. Also, if there are any output column derivation expressions in the Transformer can you also post these? SIGSEGV is a segmentation violation. You might search the Forum for these terms. One common cause is using NULL in an expression that c...

To do it properly there's no way around a mandatory quiet time. This is true of all databases, really, though there are some strategies (like snapshots) that "pretend" it's a quiet time. There is a backup utility (uvbackup) shipped with DataStage, that no-one uses. It has the ability to back up a qu...