DSP.Open GCI $DSP.Open error -2

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
Sant
Participant
Posts: 15
Joined: Thu May 12, 2005 12:08 am

DSP.Open GCI $DSP.Open error -2

Post by Sant »

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
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Which stage are you using to which database?
Sant
Participant
Posts: 15
Joined: Thu May 12, 2005 12:08 am

Post by Sant »

Stage ORACLE 8
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

Select 'generated SQL' and give value for the table name property. Then switch to 'user defined SQL'.
Sant
Participant
Posts: 15
Joined: Thu May 12, 2005 12:08 am

Post by Sant »

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
Post Reply