DSXchange

I mean i want to store the data there. For that, do we need to define the columns?

should Fields need to create in the excel like DB?

Thanks ArndW.

does it need UserId and Password also? or only DSN is enough?

Hi,

How can excel be connected with datastage?

Thanks,
Venkat

what you are telling, is correct, if data is 'always ready' state.

But here, from one link, data is coming after some validations. from another link, data is coming directly from file.

Will this slow the process?

Venkat

Ray, You mean Round robin will be better when sorting is not necessary.

Venkat.

Hi guys, I have used one link collector with two inputs. Number of records coming from two inputs are different. Rarely they will be equal. So Now I have little confusion of selecting the collection algorithm (Round robin or sort\merge). Please suggest me which will give better performance for my re...

Hi,

I want to know more about AUDIT Stage. Can anyone describe about AUDIT Stage??

Thanks in Adv.

VC

Hi, Actually this hash file is created long time back and we were using it for the last 2 months and then it was not giving any error.Today only i got this error while running this job.if i change the filename it will not give error.The folder is in the machine where datastage is installed. Regards VC

Hi,

We have created the file earlier but after getting this error we deleted all the files from the directory and still we are getting this error...

Hi All, When we try to create hash files , the job is aborting with the following error message : " GSAP_LOOKUP_CreateLkpForRegJobs..XrefSctyOvrdHash.ToBuildSctyOvrdHash: DSD.UVOpen The system cannot move the file to a different disk drive. (17): G:\Ascential\DataStage\Projects\DEV_ZGP0GSAS\mkd...

Hi, I want to delete/create an entry in table using SQL. But this has to happen before running my job. I have created subroutine and used in before job subroutine. It is creating an entry in the table but my job is running. It is going to infinite loop i guess. If anyone knows about this, reply soon...

Thanks Ray..


I have used the Print to file option...


VC

Hi All, Can we export/save the joblog or job status to a file?? I want to use that file in some other application so that i can derive the elapsed time of the job and other details. I just want to take the information about the job out of DataStage application... Please reply... Thanks in Adv.. Rega...