DSXchange

IsValid() will do for (5) and (6).

When's the interview?

Precision and scale are set for the Decimal data type. When you are converting this to a string, the precision and scale of the Decimal input field are preserved in the string output field. You may also need the optional argument fix_zero, to specify that a decimal number consisting of all zeroes is...

What, that the Data Set has no segments? Or is it 2 segments? Or 1? I am getting thoroughly confused. What - precisely - is your issue?

And what happened (in the Segments grid) when you selected a partition in the Data Set Management utility?

Routines that are supplied with DataStage are read-only because the vendor and support folks expect to be able to find them and to find that they behave as documented. So don't delete any of these. If you (someone at your site) has made some of your site's other routines read-only, then this should ...

Posting the same question in multiple forums will not get any better answers, and it's frowned upon because it wastes the time of those who have to read them.

This question has been answered in the Server forum.

Search the forum, looking for "lock" and, in particular, "LIST.READU". This will help you to ascertain the owner of the lock, and LISTU will link the owner number to the owner name. You can then use UNLOCK - if safe to do so - to release the lock. Or, if you have the deadlock daemon (dsdlockd) runn...

You're completely on the wrong track. Each job has a "user status area" into which the DSSetUserStatus() function can put a value. That value can subsequently retrieved, even after the job has finished, either through a Job activity's $UserStatus activity variable, or by calling the DSGetJobInfo() f...

Read the error message. NO EXPORT HANDLING IS DEFINED.

This is what I was getting at when asking you about whether Null Field Value is specified.

The problem now is in your Sequential File stage. This is pellucid in the error message.

You have to select one of the partitions for the Segments grid to be populated, and it is then populated with the pathnames of the segment files that are used on that partition.

Are you?

Fascinating.

Buy MetaStage and have them collected automatically. (Note that MetaStage ceases to exist with effect from version 8.0).

Download ETLstats from Kim Duke's website which is a set of tools that will gather these statistics and put them wherever you like.

Don't re-invent the wheel!

You do. Look at the osh generated and executed by View Data. It includes a head operator to limit the rows according to your selection.

Neither right operand of the MATCHES operator includes any wildcard characters. Are you interested in doing an "equals" comparison or a "contains" comparison? The equals comparison is straightforward - simply replace the MATCHES operators with "=" operators. The contains comparison requires you to e...