DSXchange

Is there some place that I can download from?

I have installed both DS 7.1 Server and client on my machine. I am able to run the jobs successfully.
I can open the jobs and Job sequences, but the issue is that I am unable to open any sequences in Job sequence.
Is there any resolution/patch for this issue?

Tony,

Can you please share your Routine. It will be very helpfull....

Thanks
Clara

Thanks for the info, Naveen :D

Ray, When you said "Enable write cache"
Does that mean check the "Allow stage write cache"

Also in a hashed file when do you use - Pre-loadfile to memory?

********STOP messing up the site!*********** You dont have any right to talk ths way about senior members specially Craig! First commit on correcting your attitude , then on learning datastage I am already with a very good company in a good position Stop boasting about yourself too. There are people...

shilpa79 wrote:It worked.

Thanks a lot for your help.

Can you please let everyody know, how you solved it?

when i use the UtilityHashLookUp Routine in my JobActivity's expression box i get this error
My hash file being XXX

I am using Is it wrong? Is it something with quotes ?

kduke wrote:Put your hashed file in the current project then you do not need SETFILE.

Will this not clutter up the project space?

What is the best way to decide on the destination of a hashed file?

Thanks for the explaination.

I am familiar with using SETFILE to set pointer inside VOC.
Do we have to write a routine to do it, or is ther another way to automate this.

Kris, i have a couple of questions - How do i get the reference of the hash file when i call the UtilityHashLookUp Routine in the expression box of the Job Activity? - It asks me for 3 parameters even though the third one is non- mandatory. - Do we need a pointer entry to the VOC, before calling it ...

Kenneth and Gateleys,

Thanks for your inputs, could you throw more light on $PROJDEF.
Is there a list of General Environment Variables?

A few doubts..

What is the difference between Job Parameters and Environment variables?
Is it just a scope thing or is there more to it?
Is it better to use Environmental variables to Job Parameters if you use same parameters very often?

Katz,

Your routine captures the job log into a file? Did i understand it right?

It looks good !

Can you please explain what this routine does.

The fileA will be moved to PathB.
Your file movement would be PathB/fileA rather than PathB/fileB

If you dont give a name to the file during your move it retains the same name as the source file

So your will be in -

/nz/etl/crt/dbx/in with the same file name i.e client_ext.lst