DSXchange

dxk9 wrote:Here are some of the frequent errros which we face:


c.Fatal Error: Tsort merger aborting: Scratch space full

Did you try pre-sorting your sources ?

dxk9 wrote:Here are some of the frequent errros which we face:


c.Fatal Error: Tsort merger aborting: Scratch space full

Did you try pre-sorting your sources ?

Being Char(15), it will occupy 15 characters -immaterial of whether you trim or not.

If you are concerned about leading zeros, you can do a leading trim for zeros within a NullToZero function (as Varchar).

Did you do this?

Sainath.Srinivasan wrote:Try creating a dummy table with 2 columns - varchar and datetime.

Pass same value (after typecast) to both and check the result.

Also run an sql insert via SQL Server front-end rather than DataStage to verify the outcome.

The output column derived is defined to be dfloat (Decimal).

Convert it as Timestamp.

That must work. What is the error you obtain ?

Craig, I think the op indicates appearence of UV prompt as result of successful invocation of uvsh in the first case and failure to do so in second. Peddidsx, Can you compare the library path after loading dsenv in both environments. Did you manage to locate the missing .so file ? By 'which OS', I m...

Yes.

That is because APT_String is a class and thus a datatype in itself. You have operators over-ridden by APT_String.

What operation do you intend to perform ?

Your library path is incorrect or incomplete.

Locate the missing file and include it in your lib path.

What OS are you running ?

In that case, you will need a memory structure to hold the values.

Also when will you initiate the read from source ?

Your source must be autoread and your reference not.

There are few more things to check...but one at a time.

Btw, why don't you use the normal lookup or join stage ?

All I was saying that you must fix the Ora errors thrown from the job. (see last few lines of your message).

Which post ? What hidden ?

It is available in DS Server edition.

In PX, you can use a tx or lookup first row.

You need to fix the errors before looking into the Agg. AGG..Oracle_OCI_2: INSERT INTO Q_SALES(QUARTER, CUSTID, TOTALSALE) VALUES(:1, :2, :3) AGG..Aggregator_1: The value of the row is: QUARTER = 1987Q1 CUSTID = 102 TOTALSALE = 1195550 AGG..Aggregator_1: ORA-01438: value larger than specified precis...