DSXchange

Thanks Chullete.

I executed the sqlstament in sqlplus,there are no errors.

My job is very simple srcoraoci--->trm---->trgoraoci when i clicked view data its displaying without errors. The problem is when i run the job i am getting only one log entry it says error type is fatal deps.sourceDependent: ORA-00911: invalid character and job aborted. I am wondering whats the caus...

Hi,

I designed a sequencer job with 22 jobs but the problem is it won't compiled.
I split that sequencer job into two parts(one is 16 jobs and other is 6 ) and compiled,its works fine.

I am wondering is there any limit(no.of jobs) on sequencer job.

Thanks in advance.

Sri

HI AMITH,

I am not using XML stage in any of my sequencer jobs.

Thanks.

HI ALL, We upgraded DS6 server to DS7.1. When i tried to compile sequence jobs,i am getting the following error: <Desc>XML parser error on input line 0: source='',reason='The system cannot locate the resource specified. '</Desc> I recreated the one of the simple sequence job on DS7.1 it worked fine....

Some methods are: 1.) Use surrogate key values (integer) instead of char COuld u pls explain more in detail?? 2.) Use direct-call / wired stage instead of ODBC My source system is AS/400 which i can connect through ODBC driver becose its located in Some other place. 3.) Use IPC stage (if you have m...

Hi ALL, My product dimension is 600000 rows n tried to update that table taking too long( My product no is CHAR field ). Update action is updating existing or insert new rows. Job design is ODBC staging table ----> Transformer -----> ODBC dimesion table Update action is updating existing or insert n...

Keith,

whatever u said is true when we convert columns into rows.But i need to generate one more column values for day_num(i.e 1,2,3,...31).Is there anyway i can generate numbers based on those columns Dol_day1 is 1,Dol_day2 is 2 ... Dol_day31 is 31.

Thanks.

Hi, my database table structure looks like Year Month Cust_no Prod_no Dol_day1 Dol_day2 Dol_day3 Dol_day4......Dol_day31 2004 10 100 200 100.00 200.00 300.00 400.00.... 3100.00 2004 10 100 201 111.00 222.00 333.00 444.00 ....3400.00 I need to covert that table into Year Month Cust_no Prod_no Day_Num...

HI ALL,

When i tried to export whole project from test server,its giving the following error:
Error calling subroutine: *DataStage*DSR_SELECT (Action=7); check DataStage is set up correctly in project kraftmaid
(Subroutine failed to complete successfully (30107))
How to resolve this issue?

Thanks.

Hi ALL, My job is simple, i tried to insert data into a decimal column(i.e decimal(12,2)) i am getting the following error: factpossample1.CTransformerStage1.DSLink4: DSD.BCIPut call to SQLExecute returned informational message. SQLSTATE=01004, DBMS.CODE=0 [Ardent][SQL Client][ODBC][Microsoft][ODBC ...

HI Chulett, U are exactly right,that installtion damaged my server n now i reinstalled my previous version n imported all my jobs.Here my backup is no good so that i got only executables,table definitions,routines bu not job designs. I am very much worrying about job designs. Usually we take Server ...

HI ALL, I reinstalled Datastage Server n improted all jobs from my Backup file(i.e .dsx file) but i can see only executables,routines,table definitions but not job designs.Unfortunately i don't have any other backup for my projects. IS there any way i can get those jobs from my server backup?.Pls le...

Hi ALL,
When i tried to open EXISTING job(afterposcustno) in designer i am getting the following error:
"Job afterposcustno is being accessed by another user"
ANY IDEA WHY ITS GIVING ERROR??



[/b]