DSXchange

Then the script needs to have sourced the $DSHOME/dsenv script and then needs to invoke the $DSHOME/bin/dssh command to effect the CLEAR.FILE command within a DataStage shell. You also need to know the job number so that you can identify the correct RT_LOGnnn number.

You set the generator properties for the individual columns. For example you can generate random dates after 1999-01-01 by setting the method to random and the epoch to 1999-01-01.

There is no documented limit.

If the CLOB it is split, and ROWID tells you how many parts. You have to deal with this in your design.

If the size of the DSX file is now 0 bytes you have managed to empty it of content, probably by using the wrong command in whatever editor you're using.

Are there any error or warning messages? When you look at the job log, were the parameter values passed correctly to the job from the sequence?

In a parallel job use a Row Generator stage.

In a server job use a Transformer stage with at least one stage variable.

Build the output lines in VarChar stage variables. Output them on separate output links keeping only the final version of each, using either LastRecordInGroup() function or downstream RemoveDuplicates stages. Base these on a "generated" constant "key". Bring them together using a...

If you really do want to monitor changes to SDKSequences, you have the option of converting it to a UniVerse table and creating triggers that can audit these changes (including writing who and when information, and even the operation and before- and after-images, to a file).

prasad.bodduluri wrote:clear SDK sequence using data stage administrator using CLEAR SDK.SEQUENCE

1. This is never a good idea.
2. The command you gave is not valid anyway.

Clearly you did not build your expression using the Expression Editor. Had you done so you would have learned that activity variable references in expressions do not require surrounding sharp signs. If it's only the integer portion you require, you could also use Oconv(Getcount.$CommandOutput,"...

Using the Match Designer test utility you can view a histogram of matches and slide the cutoffs along to investigate their effect. In association with doing that, you need to identify row pairs in which the aggregate weight is at or near the threshold, and make a decision about whether the lower-wei...

suneelchallagali wrote:...till yesterday every thing was fine...

What has changed?

I'm not totally clear as to your actual requirement, but will offer these thoughts around the two questions in your most recent post. 1) Wholly within? (aRange.lowvalue >= bRange.lowValue) AND (aRange.highValue <= bRange.highValue) 2) Direct comparison (bRange.lowValue >= 2013-01-01) AND (bRange.hig...

Can you run jobs from the command line using dsjob command?