DSXchange

Hi, I have around 800,000 records in a table and I do some transformations on these and then putting the columns into another table. During this if I run the job it gives me an error saying:Fatal Error: Tsort merger aborting: Scratch space full AND Fatal Error: Pipe read failed: short read Also if I...

hey, Thanks for the replies, using TRIM worked for me though I still dont understand why a varchar 8 type needed it in my case.

Anyways, thanks a lot!

it is a varchar(8) type field and also the query:
select count(1) from myTable where String_Column='A'
is working fine so I dont think this is the issue.

I have an ODBC source through which I put the records into a transformer. There are two outputs to the transformer. In one constraint I put String_column = "A" and in the other String_Column <> "A". The above does not seem to work. When I just put one output and say String_Column...

Iam using the SQL Server 2005 as the DB and Datastage 8.1 Parallel Version.
It is giving me an error datatype not supported because of the lenght of these three columns.

When trying to load using ODBC, datastage is not able to do so.

Hi,

Iam using varchar(max), varchar(4000) and varchar(5000) in the ODBC Source.
I think such large types are not allowed.
Can sombody tell me what is the max type I can use for datastage.

Thanks!

Hey,
Thanks Grace
It sure helped

We can use the SP stage in the Parallel job, but this will be a source, we cannot use this in between.
Using this stage we can return the dataset.
Hope it helps

Hey, I'm working on huge sets of data and to load the entire table from the source does not makes sense. I can write a query to get the required records only but I want to use as little SQL as I can. I want to write a sp that will have a certain input param which can be passed by say, an ODBC stage....