DSXchange

What option you are selecting to import metadata from oracle. It is Orchestrate or plug-in metadata. Orchestrate is better for Oracle, if you go by plug-in metadata, DS will make you suffer for your decision.

Thanks,
Shashank

Chandra, You can add another stage variable to indicate if Acc No is changing between prev and curr record. Out put records from Transfomer only when there is a change in Acc No. Mean while for every record you can keep appending the text to Descript variable. This was you can concatenate values fro...

You said that you made both as non-nullable. That means that your new function is identical to your old one - except for the new input parameters. If that does not work, you need to start by removing ... Hi Sainath, as far as return type is concerned, there is no difference. Only the input and logi...

Have you tried to use string instead of return char*? Do you mind to share how you concatinate it? Hi, I don't see a "String" return type while defining the routine. Only char* is available to return string. I used below code to concatenate. Here Ans, Val and Message are objects of string...

Hi, Recently we moved to DS8.1 from 7.5. I created few simple PX routines with type "External Function", using c++ programs. In one of them I'm passing 2 char* arguments and and this routine is returning char*. This routine is working exactly as expected. Then I created a new one, where I'...

Hi, I'm getting below error message while view data in OCI stage. >##E USER 000173 08:49:11(000) <OCI_PPN_PesParameter> Bad dboption list. Failed on Expected "," or "}", got: ".", line 1 >##E TCOS 000029 08:49:11(001) <main_program> Creation of step finished with status...

Hi,

I'm trying to concatenate few columns in a stage variable in DS server version. It works fine till some columns and gives up after adding more columns. Is there a specified length for stage variables.

Thanks,

Shashank

Hi Tom,

This is not a solution to your problem but I want to know more about how to read excel files from DataSatge. Could you please provide more details on this.

Thanks,

Shashank

I want to what is java source stage and can this be used to read excel files having multiple sheets. Each sheet can have different columns.

Is this stage available with DS7.5 or only in higher versions.

Thanks,

Shashank