DSXchange

How about just a simple "C:\"?

nima, How are you measuring the size of the hash file? If it is a default type 30 file you will have two actual OS files in a directory with the name of the file. These DATA.30 and OVER.30 files will contain your data, but the relationship between their content size (sum of bytes of keys and data) a...

Actually, if you define a quote character for your string data you can have any number of occurrences of your delimiter character (as well as your quote character). The difficulty is with your line terminator character, the parsing algorithm cannot tell the difference between an embedded character a...

I did some tests last week using identical logic between lookup filesets and datasets, I think I created the data lookups in one job (about 6 or 8 different ones) and then used them in another set of jobs from a lookup stage. The only differences were the different set types and those design changes...

DHiraj, the nice thing about the Ascential sdk add-ons is that they are also supplied with the source code. A quick look at the way the program uses the Arg1 (the hash file name) shows that the OPEN command is used. You could make a copy of this program and put in some logic that checks Arg1 to see ...

As Jean-Pierre stated, a Before/After subroutine cannot be tested like a function. I usually write and test my routine as a function by changing the parameters around to match the function format, and when I'm ready I cut-and-paste the code portion (because by switching from routine to function and ...

I haven't used the routine but my first thought would be to try it without the trailing /

Have you activated any filters in your Director? When you start your job with an instance, does it run correctly? Do the job entries show up in the main job's log, and if so, do they contain the instance in the log text?

Your DataStage configuration file specifies the total number of type 30 files that can be open concurrently. This value can be found, and changed, in the `cat /.dshome` directory and the file is uvconfig. The value for T30FILES should be increased to accomodate your installation's size. Once you hav...

Devyani, slowly but surely I am seeing a bit direction in this thread. It seems that you don't have the read routine yet, but wish to get it from this forum, you want to create a Function: GetJobParameter(ParameterName) EQUATE ProgramName TO 'GetJobParameter' OPENSEQ 'ParameterFile' TO InFil...

Sanjay - don't use VarBinary, declare each and every occurrence as VarChar. So even if your table uses VarBinary, declare it as VarChar in your Oracle OCI input. That way you avoid the problems you are describing. As far as DataStage goes, this is transparent (with the proviso of NLS as mentioned ea...

Devyani, I'd really like to help you, but I feel that I just can't understand what you are asking. Could you give a small pseudocode or similar example? If I understood your text correctly, you have a function that gives you parameter runtime values. Let's say it is called GetParamValue(<parameterna...

Lance - my first thought is that the Lookup Sets are just pointers to the actual data files, you can use the orchadmin command or the graphic manager plugin to get the file paths to the actual data files. What really sucks is that there is no way I know of to view the contents of a lookup file set ,...

Devyani, is your question about how to call your parameter function from a routine stage in a sequencer? If that is the case, the Sequencer takes care of all the details such as parameter definitions for you. If this is not the case, perhaps you could explain your requirements in a little bit more d...

ewartpm,

If DELETE.DF doesn't work, delete the component files separately, delete the VOC entry for the master file and then remove the component entries in the &PARTFILES&.

Bonne chance,