DSXchange

Hi Guys,

Iam having a problem binding the db in AIX/DB2 environment.

when I do a bind20 datasource name
I get a msg saying

datasource not found.

I have entered the dsn at .odbc.ini,uvodbc.config and dsenv .

Any thoughts from u guys would greatly be appreciated.

Regards
suparv

Hi I am trying to use the Stored Procedure Stage, which uses a Transform procedure type, I have mapped the input and output parameters correctly. I want to call a function, with which returns a value for each row. I keep getting the following error while trying to run the job. Stored_Procedure_3,0: ...

The Oracle db version we are using is 10g

Hi I am trying to use the Stored Procedure Stage, which uses a Transform procedure type, I have mapped the input and output parameters correctly. I want to call a function, with which returns a value for each row. I keep getting the following error while trying to run the job. Stored_Procedure_3,0: ...

Hi Guys we have an Oracle 10 g target database and we have an enterprise edition 7.5 on Aix 5x.After adding the dsn name (<DWDEV.WORLD>) AND DBMSTYPE = ODBC in the uvodbc.config file and when iam tryin to import odbc table definitions iam gettin the following error. DSR.MetaGeta(GET.TABLES)(SQLConne...

Thanks for your reply, but we have a PX installed, i believe it comes with the plug-ins, pls correct me if iam wrong.

Hi We have a AIX 5.3 box on which we installed DSX 7.5.We are building a datawarehouse on the same box.What are the things i shud do for creating a new project, the project would have both server and parallel jobs.I know how to create a new project from the DS administrator, apart from that what are...

Thank you for the suggestion

Hi

I am trying to use a Oracle stage for a lookup, instead of creating a hashfile. Could anyone tell me if this would create any performance issues, on the Database side as well as on the Job?

Thanx

Hi I wanted to know how much space do the table definitions occupy on the server, is it required to allocate separate memory for the metadata or does Datastage allocate the memory based on the number of columns. And also if the total of table definitions is too big, then will it effect the performan...

Hi I am trying to create a Match stage,using Udup Option, and I am getting this error when I want to give values in the Extract. "Run Time Error '91' Object Variable or With block Variable not set." It allows me to modify or add pass, I can even go to the reports and modify, but when I go ...

Hi

Could anyone tell me if there is a way to call QS jobs using the "dsjobs" command??

Thanks

Hi Everyone

Could someone please help me with SAP?

I need to run a SAP r3 program which is already coded and validated in SAP. I just need to run it in SAP through datastage, with out regenerating/re-building/coding it in Datastage SAP plugin.

Thank you

Thanks a lot

it worked....

Hi I have 2 jobs which are linked. records in Job1 are the parameters to job 2. So Job 2 runs as many times as there are records in job 1. Ex: if there are 2 records in Job1, then Job2 would would run 2 times, each time taking one record in Job1 as its parameters. The target table in job 2 has to be...