DSXchange

Hello, I could only view your partial reply...!!!... Thx Premium membership would allow you, among other things, to read the entirety of posts by the five premium posters. Premium membership is one of the ways DSXchange hosting and bandwidth charges are paid for. By taking premium membership you ar...

The jobs are independent of each other. Therefore you need to persist the information somewhere. A text file is as good a place as any, and is easy to read with an Execute Command activity or a Routine activity. You might also consider using a server job for processing the one row, then you can read...

I don't believe it can be done, other than invoking DataStage/SQL from the command line. You don't want to go there - it involves querying a separate status table for every job.

Column length is the "precision" for SQL data types. Field width can be longer than this (even though that is wasteful) - for example an "Integer" (length 10) might be supplied in a field 16 characters wide, padded with leading zeroes. The value is still the same, but the two sizes are different. Si...

What happens to the counts (as a test) if you don't specify the XML option on DSJobReport?

Instead of that I will make my oft-repeated plea for professional standards of written English. The second person personal pronoun in English is spelled "you", not "u". Its possessive form is spelled "your", not "ur". The contraction of "you are" is spelled "you're", not "ur" or "your". The first pe...

Premium membership costs less than 30c per day and will allow you, among other things, to view the entirety of the five premium posters' contributions. All revenue from premium memberships is devoted to defraying hosting and bandwidth costs incurred by DSXchange so, by taking premium membership, yo...

The Derivation field (or if blank, the Name field) on the Columns grid becomes the SELECT clause.

The Table Name field becomes the FROM clause.

There is no intermixing. If you need qualified column names in the SELECT clause, you must specify those in the Derivation field.

Similar, but not the same.

Please search for the actual error message you received and, if that does not solve it for you, begin a new thread.

Welcome aboard.

Now that you've solved it can you please post again advising where the problem lay?

This kind of knowledge can be obtained from IBM UniVerse manuals or by taking a class.

Yes, if it has the capacity. A minimum of 3GB of memory (4GB if you're using VMWare or similar), and LOTS of disk space - not so much for the installation, you can get away with about 500MB for that, of which about half is temporary and returned at the end of the installation - but for disk and scra...

Welcome aboard. The primary key column from the Lookup reference is ordinarily dropped because (necessarily) you already have its value from the stream input. This is attempting to be efficient. Whether pnum is null or not is irrelevant, since this is on the stream input; it does not affect the look...

In most cases, no.

For one table, or even if there is more than one table but the table names are unambiguous, you don't need to quality the column name with a table name. On the Columns tab simply clear the Derivation fields. If you do need qualified table names, to use the job parameter reference as the column name ...