DSXchange

Hi , everybody !!! I have a hashed file tha contains 1000 rows. Each run of some jobs insert into the file 10 rows and the option "Clear before writing" is unchecked. I need to update each time these 10 rows . The problem is all rows (each time therwea can be 90 that are different) get NUL...

No.

Hi , everybody !!! I hae a job run by Job Sequence . Immediately after the job is finishing (It transfer all rows) and I get message : "Job <My Job Name > has finished, status = 97 (Stopped by operator)" . Because of it the whole my sequence failed. I have tried to change job's name and re...

Hi !!!

If anyway to preserve order of rows in hashed file according the order they enter the hashed file ?

May be to use different type of hashed file ?

Thanks

Hi , everybody !!! I have a question regarding NLS . I have a job that each run have about NLS 2000 warnings since DS failed to map some values are come from Database. My job fails after 50 warnings . I increase it to 2500 in Director but each time the job is run by job sequence and the job failed a...

first columns are in seq files . For third column I have another seq file.
I can to load both files to DB and do there a cross join . But I want to do it in DS.

I put an example that more clear :

Seq_file 1
A B
A C
Seq_file 2
1
2

I want to get :

A B 1
A B 2
A C 1
A C 2

hi !!!

I need to perform the following task :

A B 2
A C 3
A B 4
A C 1

I need to get all combinations of two first fields with a third field :

A B 1
A B 2
A B 3
A B 4
A C 1
A C 2
A C 3
A C 4

If any easy way to get it in DS ?

Hi , everybody !!! Sometime the job containign Link Collector failed with messages tht relates to its temporal files (ds_ipcopen() - Error in open /tmp/ade...) and Link initialization. We have given a answer that it is because of lack of resources on Datastage server. If any problem to this issue in...

1. I need to do it automaticly and schedule this ftp command
2. I use it know and I am not happy with this

Hi !!!

If any way to run UNIX script hrouth FTP ? THis script will run the Ds Job.

Thanks,
Nissim

I have already tried . I get 5-7 % improvement . May be anybody use some definitions inside SEQ FILE stage ?

Hi , everybody .

How I can speed up the writing to seq file . I am sure that botlneck in writing to seq file . I am get about 3500 rows/sec.

Some programming tricks ?

Thank you all . It seems to collect statistics permanently and not from time to time is the best way.

Hi !!!

I need to know when last time the JOB finished with status Ok ( =1)
Can I know it with DS Functions without to scan Log of Job ?

Thank you

Hi !!!

If any way to do befor SQL statement in DB depending on value of Job Parameter ?