DSXchange

Clearing the file while the job is running is not a wise approach, it might cause the job to abort. Oh wait, it did

The chapter on conversions should cover that (I don't have it accessible right now) but I am sure that this is one where an implicit conversion will work, i.e. just drag the VarChar column to an appropriately defined SmallInt output column.

If you are only seeing the first and last rows, I would expect that you get a warning message of some type; if not during the 'view data' call then at runtime. These messages will help clear up the question.

ds_developer - this a COMP-3 type, so it is binary and packed.

poorna_76 - did you specify a binary FTP? If not, if would corrupt packed field contents.

yes, since if other uses create a job or files through compilation, they won't be accessible by your dsadm, i.e. if you try to recompile a job and the object was created by another user, leaving dsadm "r" but not "wd" rights.

The 'not enough space' message can be somewhat ambiguous at times, making this problem a bit more difficult to debug. The advice to test it with a 1-node configuration file is sound, if the error remains then possibly you have other causes than actual physical disk or memory space. You should look a...

Anudeep - the Folder stage in Server will return the contents of all files matching the pattern as a single column, which then needs to be parsed. As Craig has stated, you can use a Job Sequence and a loop to process all file names in a directory, passing the name to a job as a parameter. Please, re...

The "Folder" stage was created specifically for this type of processing.

According to your first post, there is no hashed file used. Where do you write these records counts? The IPC stage itself is probably not causing your erroring, but by using this stage you make DS use distinct processes at runtime, which in turn is probably causing your problem.

The mathematics of CRC are interesting and well-defined, plus you can find C code implementations of CRC for 32 and 64 bit in the public domain. Start on this Wikipedia page

Vinodanand wrote:...DSD.UVOpen Unable to open file '/dso/dsoweb/clients/upac/eligibility/logs/INP_PERS_FILE_CNT_12752'...

Is this hashed file used in one of your 3 lookups?

And if you remove the sed command from the filter does the job work?

What about the UNIX access rights to the directory RT_CONFIGxxxx and the files in that directory?

Is this a test of our ability to guess what your logic is?

Doing a sort of any type in this specific scenario will be much slower than simple declaring <n>/2 stage variables (where <n> is the number of columns to compare); then setting the result of each to the min of the 2 values, like leaves, then processing each leaf with its neighbour and so on. Not pre...