DSXchange

Hi I have a job that extracts data from a table in oracle database and puts it into a dataset.this job takes the a parmeter 'period' SAY 'apr-07' and runs the job. we have to extract the data for n number of such periods.The table is very huge and is not partioned so we were extracting the data for ...

Hi, I was getting similar kind of error AppLib::_GetConnectionInfo: Unable to create DbConnectInfo object: DbConnectInfo::New: Unable to create Hash2Sql object for table 'DbConnection': Hash2Sql::new: Failure on &ExecSQLColumns for table 'DbConnection': CoreOdbc::_ExecCatalogFetchAll: Problem en...

Resolved with the help of Rhys Jones on developernet. The table contained fields with reserved words as their field names I changed them and it works now.

Hi, I am using ProfileStage Version 7.51 build 10. on OS : Windows NT While running the column analysis I am getting the following error: 6/6 11:56:58: \\HDMCJUNAPPTST8\ColumnAnalysis: 5070 0 Unable to select rows from table 'Talon_C1479' at DSN 'sap_lcm_cm_ps_work'. I am able to do the column analy...

I created a service with Text over JMS binding.I am doing this to improve the performance ..I am getting real bad performance if i do a SOAP over HTTP binding.Ascential suggested this solution to use the Text over JMS binding. But i cant callit in Datastage webservices .So can any one help me how to...

You can do this with a COMMON variable accessed using a custom FUNCTION, but you MUST disable row buffering, remove IPC stages, and disable read/writecaching for your premise to work no matter what. Another method would be to write the value to a single row hash file on the last transformer and ref...

If you do not have active-to-active stage interprocess buffering enabled then all the transforms will be executed by one process, and row 2 won't be read until row 1 processed; so there is no need for passing global values between stages. I don't understand why you have this restriction in your job...

If you do not have active-to-active stage interprocess buffering enabled then all the transforms will be executed by one process, and row 2 won't be read until row 1 processed; so there is no need for passing global values between stages. I don't understand why you have this restriction in your job...

You can access a link's value using @INROWNUM in the same transform. If you wish to use that value in another transform downstream, then add this value to a new column in the output derivation. I'm not sure I understood your question or problem, but this might answer it. If not, perhaps you could e...

I want to assign the inrow number value af link X to a variable in stage Y

Can i use the DSJ.LinkInrownumber.

Can I just put my link Name in this command?????

Any help is greatly Appreciated

Thank you

Hi,

I tried both ways but still not able to resolve the issue

Thanks,
Anand.

Hi All, I am getting an empty value in a field from Binary EBCDIC flat file. When I tried to load it into an Oracle table it says that its a null value and rejects the value. I tried writing a simple transform function to identify whether the incoming value is empty or null and tried replacing it wi...

sathyanveshi wrote:Hi Anand,

Thanks for your response. But may I know where can I get the Microsoft JVM as I couldn't get it from Microsoft site.

Cheers,
Mohan

It is available in the MetaStage installation cd \\jvm\MSJavx86.exe

or try to search in google for MSJavx86.exe

Anand.

Hi, I installed MetaStage yesterday. After installation and restart of my machine, when I tried to run the MetaStage application, I encountered the error in a dialogue box: "Unable to start application. The Java Virtual Machine cannot be loaded - Class not registered". I then installed th...

A job is executed by a BASIC routine called DSD.RUN. Source code for this is not available. A Transformer stage is executed by a BASIC routine called DSD.StageRun. Source code for this is not available. The code generated for a Transfomer stage by compiling a job can still be viewed in RT_BPnnn, wh...