DSXchange

I defined it as varchar of 9999999 Hi everyone, I am using a xml stage to parse a xml which has more than 2 million characters, so I defined a varchar field with a length of 9999999 (9.9 million ) and I got the follwing error message row too big for inter stage rowbuffer does anyone know how to deal...

Hi everyone, I am using a xml stage to parse a xml which has more than 2 million characters, so I defined a varchar field with a length of 9999999 (9.9 million ) and I got the follwing error message row too big for inter stage rowbuffer does anyone know how to deal with this? your help will be great...

that command works. Thanks.

kcbland wrote:

Code: Select all

su - dsadm
{enter your password for dsadm, else you can use root}
cd `cat /.dshome`
. ./dsenv
bin/uvsh
list.readu
{find the row that shows your lock, look over to the USERNO column and get that number}
UNLOCK USER nnnnn ALL
QUIT

Hi,

I need to release a job on the UV level, but I can not remember the exact command to logon to UV. Can anyone tell me?

Hi everyone,

I need my parallel job to call a Teradata Stored Procedure, the stored procedure takes a few parameters as input and returns a few parameters as output. How can I do that? It looks like the stored procedure stage only calls Oracle stored procedures.

Thanks.

Hello everyone, I want to migrate all hash file from one server to another, does anyone know how to do it? I tried to physically move hash files but the ETL job on the new server can not recognize it. this is the error message: J_HASH_xxxxx..Trans_Dummy: |J_HASH_xxxxx..HASHxxxxxx.Trans_Dummy: DSD.UV...

Good morning everyone, This is the first time I have this kind of problem. I installed my DS client recently, and I tried to open a job activity stage in a job sequencer, but nothing happens, that is, there is no pop up window, but the job seems to be edited (that is, the there is a '*' in the end o...

yes. If I don't have the select privilege, the DRS stage won't work. I can even the view table on the DB2 stage. This problem only happens when I run the job.

ray.wurlod wrote:Do you have SELECT privilege granted on the requisite system tables?

Hi everyone, I posted this message earlier on the PX forum, but I built the same job in Server and the same error message appears. This error message appears on some of my DB2 API stages, and if I replace the DB2 stage with a DRS stage, the error message disappeared. Does anyone know what's going on...

The DB2 stage is simply reading a table. There is no trick at all.

bcarlson wrote:What is your DB2 stage doing? Is it a write? Can you provide more details?

Saravanan, Thank you for the reply. I remove the alias on the input and output db2 tables, and changed all chars to VarChars, but the problem still exists. Is there any other possible solution? Had faced the same problem for two different reasons. 1. Specified the alias for a table, but this alias w...

Hi everyone, This error message appears on some of my DB2 stages, and if I replace the DB2 stage with a DRS stage, the error message disappeared. Does anyone know what's going on? here is the error message: APT_CombinedOperatorController,0: Fatal Error: Fatal: [IBM][CLI Driver] CLI0131E Invalid stri...

Hi, I tried to install Datastage server (version 7.1r1) on windows XP home edition. and it complained that I can only install on NT, 2000 or XP professional. I installed the same thing on windows 2000 and I never had any problems. so do I have to upgrad my window xp to professional editional to inst...

Yes, you are right. The warning messages disappeared. Thank you for the help. The way AGGR stage works on sum of decimal type columns is. When it performs a SUM it makes sure that no row is "null". When we contacted an Ascential pro' with the same problem. He mentioned it was a compiler re...

amsh76 wrote:Whats your source?

both the source and the target are sequential files. but I don't think it is a problem, because I tried to replace them with datasets and the same thing happened.