DSXchange

Wonder of wonders I set Remote Server to 'DNYSOPH3' and was able to view data :P . While running the job , im getting the 2 following 'fatal' errors Oracle_Enterprise_0: GenericQuery:esqlErrorHandler Prepare failed for: GenericStmt_5 query is: select count(*) from sys.gv_$instance sqlcode is: -942 e...

Im using a Solaris SMP system. I want one Ora Enterprise stage to connect to Only one remote Oracle SID as defined in TNSNAMES.ORA. On the same note i will need to access other SID's using additional OraEnt stages. my TNS Names contains the following entry DNYSOPH3 = (DESCRIPTION = (ADDRESS = (PROTO...

How can i access multiple remote oracle database instances(all of the same version 10g) using Oracle Enterprise stage plug in ? To my knowledge , only one ORACLE_SID is accesible in Oracle Enterprise stage. The 'SID' is NOT a connection option in the Oracle Enterprise stage also.

Thanks
Ramesh

Not if the lock is owned by an abnormally disconnected process. That's when you need the UNLOCK command on the server.

Just wondering if having dsdlockd running can resolve locks left over by such disconnected
processes? Any idea/experience with this one?





Thanks
Ramesh

Hi Im pretty sure that this has been discussed before, but my searches arent showing any threads. Im trying to aggregate a flat file column that has 8000+ records. This column is defined as FLOAT. (Business expects data with variable number of digits after decimal point). The source data is a delimi...

I have used wrapped stages with Non -File inputs. Dont think that should be the issue.

Thanks
Ramesh

The issue is resolved . I installed the datastage client patch for Windows XP SP 2 , and now im able to see all the icons that i want.

Thanks
Ramesh

I have created a wrapped stage( on an unix command) and tested it . It works just great. However , im not able to see the stage with the bitmap icon that I have assigned to it :( ( for both 32*32 and 16*16 bitmaps). Anyone experienced this problem? Any help is appreciated. Thanks in advance Ramesh

I was always curious as to where documentation on distributed files is kept? Remember having seen a mention of it in the Hash Stage disk caching guide.
Is a distributed(hash) file also known as type 27?


Thanks
Ramesh

Im not so familiar with most computer games, though i believe its one of the reasons Windoze is popular. For Datastage I'd personally stick to various flavors of UNIX. I worked with DS on windoze for about 3 years and on Unix for 2 years , all great development work however took place with Unix vers...

Might as well be an issue related to chip speed. Revisiting the administrator guide might help. Search too had a few things to say about it I guess, though you might be familiar with that.

That reminds me of a prank once done using data stage: Sending in a resignation letter by using a valid 'From Address'.

'Business Requirements' would most probably be the answer.

Yes It Does, search the forum for "checkpoint". If you want the sequencer to run from the start , you will have to reset it , or else it will run from the first point of failure it encountered. In the sequencer properties you will find the following option " Add checkponts so that seq...

The "Unix Programming Environment" by Brian W. Kernighan and Rob Pike is my all time favorite, it pays attention to the small things we generally tend to overlook.