DSXchange

*** Error executing command: orchdbutil show D3_CUSTOMERS_INTERFACE_ALL -dbtype oracle -server psdev -dboptions ********* ##I TFCN 000001 16:55:21(000) <main_program> Ascential DataStage(tm) Enterprise Edition 7.5.2 Copyright (c) 2004, 1997-2004 Ascential Software Corporation. All Rights Reserved ##...

:!: You've not only posted your problem in someone else's thread, but mixed a PX job problem in with a Server one. Best if you repost this in a new thread in the PX forum. That way we also know what your version number and O/S platform is, right now we'd have to guess. I am really sorry to do so..I...

Hi, We have created a job with an seq file followed by a xml input stage..then a copy stage and finally the data will be written into a seq file... the xml structure is <?xml version="1.0" ?> - <customers> - <customer id="55000"> <name>Charter Group</name> - <address> <street>100...

Sorry for the hold up guys. With the Seq file stage it worked but I also had to do put in that "FILENAME" & "RECORD" info. I have not yet re-attempted with the folder stage I will do so and let u guys know teh results. thanks again. Hi, We have created a job with an seq file...

OK, its' just that there was a known issue with the remote Oracle PSDB. Does the problem go away when you re-boot the server - that is, does Message Switch auto-start? If not, is there anything in ... The problem does not get solved while we reboot the server too..The messageswitch service cannot s...

ray.wurlod wrote:Is your PSDB Oracle and on a different server? ...

The PSDB is in the SQL SERVER 2000 which is installed in my machine..THE SQL SERVER,profilestage client,message switch,and analysis server are in the same machine.

installed the profile stage and when I login, it gives me following error message: "Message Switch is unavailable - please start the message switch service to allow analysis to be performed" I tried to start MGXSWitch service manually but It starts and immediately stops. It gives following...

When I create a parallel job in datastage 7.5x2..This job is not visible under jobs tab in reporting assistant..While If i create a server job I can view that job ..What could be the reason?? Is there any setting which I will have to do??

Are NLS_LANG and LANG_C environment variables correctly set? ... Where do is set them and what values should it contain..Pls send me some link if there is an info there already in the forum..I did nt find anything like that? I am getting this err.. ##W TDOR 000160 18:40:22(000) <main_program> An NL...

I faced the same problem while reading the data from an oracle table could u pls tell me how u resolved the problem??

"]Did you imported all columns ?[/quote]

Yes i did import all the columns!!!Can u chk once..If u get the same error while veiwing data using a ODBC stage connected to db2 table...I have inported all the fields from the table...

kumar_s wrote:Is the metadata loaded and the metadata of the selected column list matches? ...

Yes the metadata has been loaded..using the import option from the table...The table has the same column names as have been loaded..

I am trying to connect to a db2 table using a parallel job. The steps i have done: 1 Created an ODBC called ConnectDB2. 2. Have provided the tablename,datasource name,user and password when i say view data it given me an error Error executing View Data command: ##E TOPK 000000 19:16:48(003) <_PEEK_I...

Hi Guys, I got certified with 94% score. Sree I also got certified with 84% score yesterday. but there were some questions that I still couldn't figure out. Hi, Could u help us?? We will be taking the 415 test soon..Which are the pdfs which we have to go thru and if there are some sample questions....