DSXchange

okay. could you please brief me how to make the routine handle nulls or give me any reference to where it is documented.

In server routines we can pass Nulls in arguments which can be checked inside the routine with IsNull() function but guess Nulls cannot be passed to and from parallel routines.... Am i right? guess we need to replace nulls with dummy values before passing as arguments.

As Ray Suggested you can use a sort stage and sort over the key columns and record start date then use a transformer with a pair of stage variables in such a way that you have both the current record sequence number and previous record sequence number then use two stage variable (svr1,svr2) , svr2:-...

What i understood is that there is a sequential file which you like to be read from a fileset stage and you are wondering how to define the *.fs file. If my understanding is right then here is how i can help the *.fs file is not defined by the developer when you create the file set DataStage creates...

Heard that 8.X uses DB2 for housing the repository, in that case do the files DS_JOBS, DS_AUDIT and DS_JOBOBJECTS exist or did they get replaced by any DB2 tables?

I donot have access to 8.0 else would have checked.

ray.wurlod wrote: VOC (from "vocabulary") contains every word and token that might be used at TCL level in a DataStage project

could anyone expand TCL.

Heard the term VOC many a times but dont actually know what it is except that it is a file that contains a list of functions. Could anyone highlight what this file is and its significance. I checked in some of the guides but didnot find any reference, if any one can provide the reference to the docu...

ray.wurlod wrote:I provided a complete solution. And corrected your erroneous syntax.

Its really good to have such people who support the learners........ :D

Can some one throw some light on the function add_to_heap()

ArndW wrote:There is a whole PDF documenting the differences and link caching functionality.

In which datastage document is it discussed? I cant find anything in the server job developer guide

I am trying to write to a hashfile using "Allow Statge Write Cache" option set. I am facing the following warnings. djsStgFidelityBackFill_QC_52..hshTmpFidRed.lnkNewColmns: Read link private caching enabled, cache size (128MB) djsStgFidelityBackFill_QC_52..hshStgFidelityTmp.lnkOtherArrFide...

How does authentication of user id and password happen and how is it different from Version 8.

Thanks in advance

Hi Is is mandatory that the remove duplicates stage should be provided with sorted data? What if the data is not sorted explicity and forcing DataStage not to insert any sorts.... would it cause any data issues ? Same question goes for Join stage and Change Data Capture stage Consider that we are ha...

Hi

Most of the times the data browser window hangs up and i am forced to close the designer is there any means by which i can just kill the process related to the data browser to get the window closed so that i may not have to close the sesigner?

Resource Disk: It's the location where your persistant data is stored like datasets, filesets etc. Scratch Disk: It's the disk space which is used by datastage to create temporary files as and when needed Ex:Datastage creates temporary files while sorting the data which are cleared out after sort ha...