DSXchange

Read the error message.
There is a mandatory property called FKEYCOLS for which you have not supplied a value.

You MUST solve "cannot open DS_JOBOBJECTS" before an import can succeed. There is a current thread open on that problem.

chandra wrote:can any body tell the architecture of server 7.5 and 7.0

Can anybody tell the architecture of server 7.5 and 7.0 what? Talking to architecture falls into the same category as talking to trees, but is less satisfying.

What is meant by "fails" in your question? Please clarify.

English is one of the official languages of India. "arch diff bwn" is not English. Do you document your work so sloppily? Please bear in mind that there are participants here whose first, even second, language is not English, and who struggle to understand sloppy usage.

Do you mean Job or Job Sequence ?

These terms are mostly used when describing how data arrive from other sources (often mainframes). A PUSH means that a process on the other source initiates the transfer. DataStage will typically wait for a file to appear. A PULL means that DataStage initiates the transfer (perhaps via an FTP stage ...

Does the other table have exactly the same four columns defined exactly the same way?

Let's find out what the problem is. Open the Administrator client then open the Command window for the project. Execute the following commands one at a time, and post the results. Commands are case sensitive - use only upper case.

Markus, in case you are confused, the plethora of answers results from the fact that DataStage server edition does not have data type restrictions. So some of the answers use substring and concatenation techniques (OK if you can guarantee that your dates are always YYYYMMDD format), others use date ...

You need separate Hashed File stages - one for lookups, one for writing - even though they refer to the same hashed file. Put an annotation on your design canvas to alert future developers to the fact that both stages refer to the same hashed file. HFStage1 HFStage2 | ^ | | V | ---> TransformerStage...

Are you really working with a nine character string here? If you are using a five digit year, then the substring extractions will need to be changed.

Apart from probably needing an extra job to process each detail file, to generate the value(s) for the summary, that's fairly close. A job sequence that contains a loop will help to construct the required files from the outputs of DS Job 3. Within the loop run DS Job 4 to calculate the summary for t...

It's simply a matter of time shifting. By using MINIMUM.MODULUS when creating the hashed file you are pre-allocating the disk space required. If you use MINIMUM.MODULUS 1 (which is entirely legal) you incur the "hit" of extending the file while loading it, which means that your load will not be as e...

The system-wide limit on the number of simultaneously open dynamic (Type 30) hashed files is set by the T30FILE configuration parameter. If this value is 200, then you will fail to open (a job that creates it probably tries to open it) the 201st. It is always a bad idea to perform lookups - of whate...