DSXchange

OK. that's good now.
I didn't know that depends on system.

There is only one user. But I don't remenber user/pass.
How I can create one more user ?

I lost user/pass to logon on server DataStage. I have a DataStage server installed on a windows 2000 server. I don't know how to connect it.
Help me !!

I don't know how Stage "FTP" works.
Can you explain me please ? is this stage wait for arrival of files ?
Is it possible to do this ?

We can determinate value of my parameter before the job starts because it's just the date of the day.
I'm reading from the file and not writing.

I have a sequential File with the filename : #Rep#/#NomClient#/BlackList#date#.txt When I call this job, I want that it will be get the file with the date of the day. Ray, you told me : perhaps in the calling sequence or job control code. But I will not recreate a job right for that. Have you got an...

It's really better like that. But it takes really long time to get data of Oracle. the configuration of the base and the network do not help us.

I also had the idea to charge the data in a Hash file. There is roughly 2 million lines to get. It is possible to load this into a Hash File ?

ogmios, can you explain this :
Alternatively do a left outer join and check on a field with IsNull (using 2 output links).

After my transformer, I have one sequential File Stage with two links. I feed a file with the lines which match and another with the lines which don't match. So if I understand well, you recommand me to load data in Oracle and do a Join statement. How I manage the lines which do not match ?

I have a DataBase Stage and a sequential File Stage linking to a transfromer. In the transformer, I bind the two fields coming from my two bonds. I started the job at 12:00 and it's always working.

Ok, thanks

I'd just seen In ORAOCI8, in update action, two choices :
- clear table then insert rows
- truncate table then insert rows

What are differences ?

The request (select client_id from client where upper(name)='#NomClient#') is instantaneous with SQL+. The big request takes about 11 minutes when I execute it with SQL+.

you think that cannot go more quickly ogmios ?
Can you explain me your idea about a redesign ?

You ask too many questions. Are you an expert Oracle ? my request is just a join between two table. This request bring back 80000 rows. There is also a select in a select. SELECT m.email FROM erreur e, #NomClient#_member m WHERE (e.member_id = m.member_id) AND (e.client_id = m.client_id) AND (e.clie...

Hi,
With the stage ORAOCI8, my request takes more than 10 minutes. I seen in the monitor that DataStage draft 100 rows/sec. Is it normal ?