DSXchange

A dynamic hashed file is like a table. As it fills up, it takes more space. As it "extends", it uses up space never to free it. Even deleting rows does not de-allocate the used space in the data portion, just the overflow. The only method to reclaim used space and shrink back to the minimum modulus ...

It sounds like you're a new user or don't have appropriate permissions.

What's your input stage? If it's Oracle, then add a WHERE clause to the SQL to include a job parameter date value.

Yeah, what Klaus said.

Welcome aboard. Here's a good place to start with learning about hashed files.
http://www.datastagexchange.com/Newslet ... chtips.php

Are you sure you're posting in the correct forum? This is the PX forum, hashed files are for Server jobs?

Welcome aboard. Please post all yellow and red messages from the job log. Please Reset the job using Director and post any yellow messages that appear.

Please describe the job design, stages used, etc. Any chance that before/after job routines are being called but don't exist in your project?

The fastest way to read a file into an array is like this: UNIXcmd="cat /here/there/yourfile" Call Execute("UNIX", UNIXcmd, ScreenOutput, ReturnCode) The screen output of the command is return in a dynamic array variable called ScreenOutput. To get the number of lines in ...

It's called the Registry. If you're trying to use the Oracle 8i plugin, then you need the Oracle 8i client software installed on the DS Server. Contact your Oracle DBA and Windoze Admin. If you're supposed to be using the 9i Client, then use the Oracle 9i plugin to talk to Oracle database versions 8...

We refuse to answer your question because it has been asked and answered too many times. Please just Search the forum.

Without any error mesasges, even when resetting, you're left with having to hunt down the bug. Check to see if any before/after job/stage routines are being called. If so, make sure they are still compiled. Opening a Routine and changing it without compiling it removes the compiled code. Jobs myster...

Still working on it. I couldn't get the SQL working, now I'm trying a DS BASIC function. This sure is a brain cruncher.

Hey, 2 years and this is your first post. Sounds like the forum Search facility works well!! Can you describe the job design, what kinds of stages, how they're used? If you're getting an abnormal termination, it could be the result of a math operation on a NULL value. We'll need to try to help pinpo...

Excellent, I think I got it. Give me a few minutes to work out the SQL.

What about your original DATA example of: From that, I need to create a table that can have every single possible combination of the above elements, like so: id, combo_num, element 1, 1, a 2, 2, b 3, 3, c 4, 4, d 5, 5, a 6, 5, b 7, 6, a 8, 6, b 9, 6, c etc. Your most recent example does not represen...

Okay, please show all 15 expected combinations. I had to show the method using a UNION because of your example. When folks do things like this it's extremely frustrating to give help.