DSXchange

Only by creating your own rule set. Names are too variable to use any out-of-the-box rule set. And, even with your own rule set, you need a thorough understanding of the "rules" - for example, how are Western, Korean, Russian, Japanese and Arabic names standardized? (Tip: there are differe...

Yes the Indian address and area rule sets are available in version 8.7. There is no Indian name rule set, however.

Check the Other folder.

Not really, because I'm not that familiar with the Trillium API. Assuming that it's like the ODBC and DB2 APIs, your code may need to do some or all of the following when reading from Trillium: establish connection environment establish connection set connection properties (eg. transaction isolation...

Look in the job log to determine the result of the Before-SQL statement.

Try sorting and partitioning on D,A,B,C.

The proper way to handle it is to design a restart mechanism into your job design. Most of these will require you - within the job design itself or within a second job used for the "recovery phase" - to ascertain how many rows were successfully committed. This usually requires some way uni...

Do you want the rightmost six characters every time? Do you want everything after the underscore character irrespective of how long? There are many possibilities. The link James provided will allow you to research them all, but a more specific question would allow us to help more cogently.

Not just "someone" either - it has to the the Site Technical Contact who is registered with IBM as such.

My preference would be:

The fourth argument of your Field() function is actually specifying the return of only one field. So it's doing exactly what you're asking it to do.

At current versions it has to be DSODB.

Is the field indexed in the database?

There are no leading zeroes stored in the Data Set. These are only added when the data are displayed. (They are also added when decimal values are converted to string, such as when writing to a text file.)

jhansi wrote:but it gives only one record as output.

There IS only one minimum value in the sample data you posted.

Initialize stage variable to a very large value. As each row is processed compare the column to the stage variable. If the value in the column is less than the value in the stage variable, replace the stage variable's value with that value. Once the last row has been processed the stage variable (an...