DSXchange

I found the following from an Oracle site (but it is refers to DB2): AS IDENTITY clause specifies that the column is an identity column for the table. A table can have only one identity column. START WITH specifies the first value for the identity column. INCREMENT BY specifies the interval between ...

I suspect that you are logging in to DataStage with a username that is not an Administrator. If so, you will need to give this user rights to the location of this file.

John

I would use Environment Variables, but it depends on which version of 7 you are on. I know version 7.5 supports encryption, but 7.0.1 does not.

See the excellent write-up in the FAQs forum.

John

I would investigate the communication port numbers. I suspect that DS is communicating on a specific port and UniData is listening on another. I had to make these types of changes when connecting to a Universe database. The change involved adding the port number to the uvodbc.config file for the dat...

Does the file have a header row? If it does, it can use those names. Otherwise, it has to generate the field names.

John

FYI - it is common to format dates as YYYYMMDD so they can be sorted as a numeric field. Don't know if it helps you this time...

John

As you can see from the code, he is actually reading and writing to a file. This would allow access from other jobs, stages, etc.

John

You could use the INDEX function.
John

You will find it in 'servjdev.pdf'; search for 'multirow'.
John

Arnd,

I don't have 6.x available (I'm on 7.01), so I can't say for sure. The eService KnowledgeBase says it was available in 6.0r3 for both ODBC and Universe.

John

Without further details, I'd say: 1. you are reading in a fixed width sequential file. 2. you have fields defined that say add up to 100 bytes 3. the first record is being read in and there are more than 100 bytes before the line terminator You have extra data in the record, so it tells you there ar...

Multirow lookup is available from 2 stages: ODBC and the Universe stage. It is enabled from the properties of the transformer (not in the stage). One row from the primary stage will result in 0, 1 or multiple rows being available for output depending on the match on the key and the number of rows in...

Although you cannot View Data when it is set to $PROJDEF, you can replace $PROJDEF temporarily with the real value(s) and see the data. While it isn't fun to type everything in, it does allow you to verify connectivity, the SQL, the data, etc.

John

You can edit the Table Definition after it is imported.

John

It turns out the problem was related to promoting shared containers. I tried various combinations of promoting the jobs that used the shared containers first, then the shared containers. I also tried promoting them at the same time. Either way, I kept getting the error. So I went back to the origina...