DSXchange

What? No, I want you to define for us what specifically you mean by 'special' characters.

just4u_sharath wrote:To my understanding trim can only wipe away spaces.

Not true.

Define 'special'.

Stored Procedure stage.

If you search the forums for your error - No default type conversion from type "timestamp" to type "dfloat" - you'll find you're not the first person to ask this question.

... based on a hashing algorithm, hence the name. Now, if you want sorted output you can: 1. Create the hashed file in an account or create a VOC record for it if pathed 2. Create an index over the desired field (may be optional but certainly recommended) 3. Use a UV stage to access the hashed file ...

One would typically use the Stored Procedure stage... or is DB2 not supported there?

Parallel or Server, you can always use a job parameter for part or all of a filename.

Simply answer is - don't expect it to be. If the order matters, resort the data after you extract it.

Define 'quite large'. For rows coming in in a guaranteed order by col1, you can use stage variables to do the concatenation. Standard 'group change detection' on Col1 and, while Col1 is unchanged, build up a list of Col2 values in another stage variable. When Col1 changes, dump out the previous aggr...

Any particular error / abort or do we get to guess?

A row who's total length is two bytes.

If you think two-byte rows are good, you can double that peformance using one-byte rows!

So... are you saying you can add new columns as long as an appropriate function is used?

ramasubba wrote:seq->tr->seq - compile & run successfully

The assumption here is the compiler must be both installed and configured. Rayo-san.

In a multiple server install, $DSHOME is not set by default. Read the multiserv.pdf for the details.

Actually i got to generate sequence ID'S.After that, i'll load d data into DB.So i ll generate the ID'S irrespective of the rejection.So i need to pull the ID'S again without generating again cos am supposed to maintain uniqueness.Is there any logic for single rejection run?and moreover am supposed...