DSXchange

I would write the sequence so that it waits for a file activity (i.e. a file on the DS server machine either appearing or disappearing) before continuing. Then you can have any type of a process touch or delete this control file and the DataStage job will continue processing. This makes it easy for ...

RL - shared record lock, RU - update record lock. If a program takes RL shared lock (usually through using the BASIC READL statement) others can still read this record; the RU lock (via the BASIC READU statement) takes an exclusive lock that prevents other processes from updating that hashed file re...

You can handle message in PX by right-mouse clicking on the warning message in the director, then selecting "add rule to message handler" and then fill out the information in the screen.

Munish,

even though the key might be quite large in years to come it will still be more "compact" than using a derived key with some other mechanism.

durgaps,

you posted a completely new topic about the "capture" temporary files onto a topic that was last updated in July 2003. If you are interested in getting information on your issue, please post a new topic in the appropriate forum.

If you use the naming convention {YourJobName}.{InstanceName} you will be invoking a multi-instance job.

Why don't they let me use PL/1 or LISP for transformation, either.

Are you looking for the actual SQL code that is executed at runtime? For most database accesses this is very straightforward code and you can see what it looks like if you go to the stage in question and click on the "Generate custom SQL" button; this will default to create the same SQL code which i...

It means that there are locks that DataStage has internally which might not point back at actual processes. Most common cause for this is use of "kill -9". Do the pids that these locks refer to still exist?

DataStage sequences can be written to do this. Since there are so many ways of branching or waiting on "triggers" it is hard to answer your question directly. Often the presence or absence of a file is used as a switch, or even as a trigger to start processing. External scripts can be called and the...

Aakash,

that is not necessarily the case. The illegal @FM character in the key will display as a line break, as do the valid @TM characters. More likely causes here are the file filling or being corrupt.

suresh_dsx wrote:..i am unable to zip the files...

What is the error message your script is producing?

DataStage job parameters are assigned different variable types in the job (i.e. string, path, encrypted, integer and [I'm not sure about this] date). You have a parameter that is one of the non-string type and have tried to pass a value that is not allowed at runtime. You need to change your run-tim...

In the programming languages that I've used when doing sequential file I/O you always need to open the file prior to using it. Usually you open this file and assign the reference to this file to a variable and then use that variable in all future operations to read, write, reset or close the file. T...

Avik, what you are doing is exactly what the switch stage was designed for - using one column's values to direct output. As noted earlier, you can use moth a filter and a transform to do the same thing. Barring bad design or implementation issues, it makes sense to use a purpose-written stage to eff...