DSXchange

Just to clarify, it's an operating system restriction that only one process can write to a sequential file at a time. It's not a DataStage limitation. If you think about it for a moment the reason will become clear. There's only one "write pointer". So, if more than one writer at a time were allowed...

To create a plug-in stage you need to program the stage itself in C (which means you need a C compiler for the particular platform). Custom GUIs are programmed in C++. All this is in the "Plug-In Writers Guide" which, as Wolfgang suggested, can be requested from Ascential. You can also create custom...

That DataStage cannot open a file in DSD_BP.O is a problem within DataStage. It's trying to execute a function that it expects to find there. You could try examining the file JOB.1628820055.DT.1297519047.TRANS7 in the RT_BP645 directory; at or near line number 522 will be the call with which DataSta...

Do you have NLS enabled? (That is, is there a tab called NLS on your SequentialFile stage?)
Have you logged a call with support on this issue and, if so, what did they advise about the "Map detected" message?

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

I tend to use the BASIC statement ReadV to test for the existence of "flag" files, since they can be zero length. If the ReadV statement is successful, then its Then clause is taken, otherwise its Else clause is taken. The directory in which the file is to exist or not is opened with a regular OPEN ...

When you reset the job, was there an informational message (Type = Info, green icon) in the job log with "From previous run..." as the first line? This event usually contains the diagnostic information needed to determine why the abnormal termination occurred.

"Phantom" is just DataStage's name for a background process. All DataStage jobs run as background processes (executing DSD.RUN), and some active stages within jobs run as child processes of these (executing DSD.StageRun). You will see these, for example, in a listing of processes (ps -ef in UNIX, Ta...

Kim's answer covers almost everything I wanted to say. You may need to consider "" (the zero length string) and NULL (the unknown value). NULL isn't a problem, since if the result of the condition test is NULL in an IF statement, the ELSE path is always taken (the rationale is that we can't assert t...

The obvious answer for source code to Routines is copy/paste from the Manager or Designer Routine Editor window! [^] The file doc_tool.mdb is a Microsoft Access repository used by the DataStage Documentation Tool (accessed from the Manager client). You export metadata from your DataStage repository ...

Try including the -run option in your dsjob command.

Enter dsjob with no command line options to get the top-level syntax.
Enter dsjob -run but with no other command line options to get the run-level syntax.

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

Reset the job. When you reset a job after it has aborted with an abnormal termination of stage, there is often an entry (sometimes more than one) called "From previous run..." that provides extra diagnostic information. After the job aborts and until it is reset, this information is kept in the &PH&...

If that's all the data in your text file, you could define the Format in the Sequential File stage to be delimited by ";". Now you will be seeing two columns. Import the "table definition" from the Sequential File and specify that it is delimited by ";". If, on the other hand, vikas;735 is just one ...

I seriously doubt that you need 200 columns in a hashed file. The function of a hashed file is to service reference lookups fast. Typically a hashed file has one or two key columns, and a very few non-key columns that are returned for the particular row for which the lookup was successful. Large row...

Based on the KISS principle, I would advise that you use separate projects for each subject area. You may also require a project for things such as conformed dimensions that are common to more than one subject area. And, where I have specified "project" here, it really means three projects, one for ...

SLEEP hh:mm This form of the SLEEP statement will sleep until the specified time (on the server!). What you seem to require, however, is a loop containing short sleeps, checking periodically whether to execute some control function (such as finishing) and checking at a longer interval whether to sta...