DSXchange

Take a look at the properties of the Folder stage in Manager, or from the Repository view in Designer. There are two "columns". One is the "key" which, from the O/S point of view, is the file name. The other is the "record" which, from the O/S point of view, is the entire file. The second of these i...

No index is created on the primary key of a UV table because, under the covers, it's a hashed file, so that the physical location of a the record having that primary key is calculated via the hashing algorithm - no need for a table scan of an index, or of the main file, which is where a hashed file ...

Never tried stopping a single instance! Hmm. Food for thought (and work for Ascential engineering methinks).

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

Ah, you've got me there! I know that it can be done, but don't have how in my head. As is usual on weekends I am sitting in an aiport lounge awaiting a flight to my next destination, so don't have access to my archives. Might be worth asking Ascential support! Ray Wurlod Education and Consulting Ser...

Did you import the table definition from a DCLGen file or from an FD file? If so, what does DataStage report? You could probably tolerate signed integers, redefining them as unsigned if necessary in a WORKING STORAGE section. After all, the sign bit in an integer is always in the most significant bi...

I take it that last bit was something to do with some kind of sporting event. Right now I am in New Zealand. The Rugby World Cup is under way in Australia (rugby is the NZ national religion), and the New Zealand cricket team is having a hot time of it in India. Actually what I meant to write when I ...

There are many good reasons why DataStage Engine (the database formerly known as UniVerse) is used for the DataStage repository, among them efficiency. At DS 6.0 there are seven tables for design time metadata. In a fully normalized form - which is what the Documentation Tool produces - this require...

In fact, the command on some operating systems to create a named pipe is mkfifo.
On others it's mknod, which isn't nearly as self-explanatory - but that maintains the UNIX mystique!

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

Well, there's one bet you'll lose! [:D]

Not only did I go to the class(es), I now make a substantial proportion of my income from presenting them throughout the Asia-Pacific region. Which is only part of the motivation for encouranging people to attend!

VarChar(65535) ?

Can't help any more than that! Kim's is exactly the answer I'd have given. [8D] Except, maybe, the STOP statements. Check out the STATUS statement (not the STATUS function) in the BASIC manual (in the Docs folder where you installed DatatStage clients). Ray Wurlod Education and Consulting Services A...

If the tables are in the same data source, use user-defined SQL.
SELECT col1, col2, col3 FROM table1
UNION
SELECT colA, colB, colC FROM table2;
... with all the usual caveats about data type matches and so on.

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

The job that is called can always determine the name of its parent with a call to DSGetJobInfo(DSJ.ME, DSJ.JOBCONTROLLER).
There's probably also a DSMacro for this; I don't have access to DS this week.

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

I've seen something like this with DS on Windows, a dialog box opened to get the new user id/password, but didn't get focus, so that DS stayed in the foreground with no indication of what was happening.[xx(]

There IS an FTP stage for server jobs. Perhaps you have not installed it. It's a plug-in (that is, optionally installed) stage.
It is installed on the server using DataStage package installer (which is called dspackinst on UNIX).

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518