DSXchange

Hello all

I have a big problem

When I create a new stream with a "User-defined SQL query" like this :

select SEQ_NUM_LIGNE.nextval from dual

I have this error with the VIEW DATA

P121axeBGSOCIETESalimODSPROPRIETAIRE..ODS_SOURCE: Table Name is a required link property for Link DSLink1
P121axeBGSOCIETESalimODSPROPRIETAIRE..ODS_SOURCE.DSLink1: DSP.Open GCI $DSP.Open error -2.

Anybody have a idea ?

For resolve this problem, I have a model with the same query, without this error, and I use for create all the job.

But I have a job with 2 call SEQUENCE.nextval and I can't resolve.

Help me please

Frederic in Paris

Which stage are you using to which database?

Stage ORACLE 8

Select 'generated SQL' and give value for the table name property. Then switch to 'user defined SQL'.

I try this solution before your answer and it's a good way.

But I don't understand. Sometimes all is right and sometimes I have this problem.

Thanks everybody for your help.


Frederic from Paris