DSXchange

DSR_JOB is not a file or table, it's a "helper subroutine". That it can't be found is grave news, and restoring from backup may or may not help, depending on why and how it's gone. It may be that the VOC, or "catalog" entry for this subroutine has been deleted, or that the executable (./DSG_BP.O/DSR...

You need to tell it which project it's running in and which job to run.

Because hashed files operate by destructive overwrite, it is highly probable that writing to a hashed file with incorrect metadata (describing the key columns) has resulted in loss of data.
You have no safe option other than to re-run into a hashed file for which the metadata are correct.

If all you want is leading zeroes, you can use the FMT function. Fmt(InLink.TheNumber, "R%10") While this is not a computed field in the COBOL sense, I suspect that all your users are requiring is "computation" of the leading zeroes. Otherwise, ask the other department to be more s...

The term "table definition" is loosely used within DataStage. A table definition can mean different things, depending on whether it's describing a sequential file, a database table, a stored procedure, and so on. A table definition contains lots of things, including format information (if for sequen...

If you have DataStage you have the Tutorial. Everybody learns differently, and in different circumstances, so I doubt that the procedures I followed while learning would benefit you terribly much. For example, my initial exposure to DataStage was as an employee of the vendor. You clearly do not fall...

You have to update the licence before it expires!

Yes it's possible but I would be VERY WARY about this approach. You can expect to see major changes in the engine, probably as soon as the next major release. Anything that relies on undocumented access to internal variables will simply not be supported after it goes belly-up.

You can send email to Certification@AscentialSoftware.com to get on a list for more frequent updates. That said, I have had no response from them despite three emails to them in the past two months. According to Ascential Developer Net certification "will be available in Q4 2004".

The entire architecture of DataStage is designed around the concept of re-usable components. Anything you create you can save and re-use elsewhere. If that somewhere else is a different project, there are several ways of getting the component into the new project. Tools range from copy/paste through...

Where did you encounter the expression? I am guessing that it is an attempt to describe the language in which you can execute commands within the dssh environment. Included in this are: two separate query languages a data entry/update facility a menus processor scripting "languages" ("paragraph" lan...

It's just a warning. DataStage expects Decimal data types to have a scale (otherwise it expects Float). So a warning is logged informing you that the "scale" in the metadata is being adjusted, presumably from unknown to 0. Why a warning and not an informational message? Because it's an unusual event...

It's quite easy to write in DataStage BASIC, given a modicum of programming skills in that language. I really believe that two minutes is ridiculously short as a checking interval; you're going to be chewing up resources just to watch the jobs! Make it longer - five minutes, maybe, or ten. If you do...

The "feature" is already there. You will need to create a hashed file that is capable of supporting multi-valued column. For example CREATE TABLE tablename (ID_USER INTEGER NOT NULL PRIMARY KEY, SITES VARCHAR MULTIVALUED); Import the UniVerse table definition into your repository. Create the...

Mandy, can you please expand on this technique?