DSXchange

Note, too that (in version 7.1) there is a known bug in the Folder stage that manifests itself as an inability to handle large files. Even though you only specify the file name in the Folder stage, apparently it attempts to read the entire file anyway. This has been reported and an Ecase generated. ...

Check also whether there are any unsupported data types.
For example, an Oracle CLOB column is not handled. Changing the column derivation to CAST (columnname AS VARCHAR2(4000)) and the SQL data type to VarChar and precision to 4000 solved this particular case.

Get your DS Admin to look at the licences (the dslictool utility) to see whether there are any defunct processes holding licence seats. Also check the DS_LICENSE table records to see what DataStage believes your developer user count is.

You could also determine its PID then issue kill 0 calls to that process, which ask "are you there?".

How you delete a UniVerse table depends solely on how it was created; there are three or four possibilities. Searching the forum will yield all of them. Never delete a DataStage repository table; they are too difficult to recover. Exception: if you are instructed to do so by support, as part of reco...

Just for completeness. it's OK to position exactly to EOF - after all, you can't go past it! Therefore I normally use: SEEK filevariable, 0, 2 ELSE Call DSLogWarn("Error in SEEK", RoutineName) GoTo MainExit END Don't miss the fact that SEEK requires at least a THEN or an ELSE claus...

Crossing the International Date Line?

A hashed file created with a UV stage (or CREATE TABLE) can still use "caching and all the other cool tricks" when accessed through a Hashed File stage - provided it is eligible (smaller than cache limit).

Of course, with Sorcerer, one may not be cogizant of exactly what type of operation they're performing! It's intended to be "one front end fits all", and customizable to personal preference to boot! And, for example, with all functionality visible in all products, and a common repository, the distin...

It will do whatever you design it to do.

Enrol in the "best practices" class, which shows techniques for staging data and recording process metadata so that you can figure out what was loaded and what wasn't.

And please post on the correct forum (server job forum?).

Welcome aboard! :D Your question reveals your newness - you have posted a question on a forum that discusses server jobs, but make reference to a stage type that only occurs in parallel jobs. Can you be specific about what kind of job (server or parallel) you are using? There is an answer in each ca...

The following applies with effect from version 6.0. DataStage server is licensed per CPU. This is outside the scope of the question. DataStage clients are licensed for a maximum number of users; this means a maximum number of connected client machines. When a DataStage client connects, a number of t...

Cleanup resources only affects the currently selected job. However, your error message indicates that this is not the answer to your problem. Your problem is in the hashed file Lookup1996to2002, which has become corrupted, almost certainly (given the hex address of the group in which the problem occ...

Ensure that you can execute the UNIX command manually, logged in as the same user ID that you use to run DataStage jobs and attached to the project directory. This will allow you to determine whether there are any operating system obstacles to your using the command. Reset (not re-compile) the abort...

Technically, OPENSEQ does not create a sequential file. Ever. Even though the file does not exist, it can be opened. What it actually opened is a communication channel (= file unit) through which the software can interact with the file. OPENSEQ opens the channel, CLOSESEQ closes it. (There's some ot...