DSXchange

Well you could investigate the SET.MODE verb to try to enable read caching of the hashed files in question (see m for example), but there are no guarantees that this will work. In fact, I would be surprised if it did. To make use of hashed files cached in memory "they" had to change the underlying c...

It's probably no help, but the beginning of the error message (the tokens in square brackets) indicate that it is the client software, not the database server, that is generating this error message. From your query I can determine that this SQL is being executed on a DB2 stage serving rows to a refe...

Is this really a stage, or just one of those helper macros that create part of a job?
Forgive me for being cynical, but I can't believe there's a "one size fits all" solution for surrogate key handling.

Luckily, "edit this post" allows one to rewrite history! :D

Profound apologies for inattention to detail.

Peek doesn't give you access to stage variables - you have to generate extra output columns whose derivation is the stage variable value. Please don't use all upper case - it's poor "netiquette" and shouting here isn't appreciated either. Just this once I'll assume that your hitting of the Caps Lock...

It can also pick the file names. Open the directory as a table, with an Open or OpenPath statement. Generate a Select List of file names matching your criteria. Use ReadNext statement in a loop to process the file names. * Error checking omitted for brevity OpenPath dirpath To filevariable Then Sele...

A file can be opened for writing if it does not exist. This is probably what you have not coded for. As Kim says, the OpenSeq statement takes its Else clause in this circumstance, but he's only given part of the story. The OpenSeq statement will take its Else clause if what you're trying to do is il...

I imagine (without access to source code) that the BASIC code in which DataStage is written incorporates a timeout when it has to do things like wait for a lock to be released by another process. So, if it waits too long, it reports a write failure. It would be nice if the error message could be mor...

Computers are dumb. They do exactly what they're told. Whatever it is you've told the computer to do (via the program generated by compiling your DataStage components), has been done. You now need to investigate the components in very fine detail, to determine exactly what the program has asked the ...

Viswanath wrote:There is just one character that comes up from somewhere. We ran the same job with different Unix systems and we got the same result.

When FTP delivers a file in ASCII mode it closes the file, writing an end of file mark. This is a single character (Ctrl-D on UNIX, Ctrl-Z on DOS).

Others have encountered this, as a search of the Forum will reveal. It's probably a lack of scratch space on one or more of your nodes. The solution is to allocate more and/or to clean out unneeded files from any scratch space that you've already allocated.

Create a server job. Create job control code to select the files one at a time. Pass the file's pathname as a paramter to your actual job. The server job is now a custom job sequence, since it contains only code. I recommend placing an Annotation on the canvas to warn future developers that this is ...

Posting it on the DataStage forum rather than the Parallel Extender forum would be a good first step.

Your design looks fine to me. That's the recommended way to generate unique identifiers across multiple partitions. I'm afraid I have no idea why they might be generating zeroes, if things are as you describe.

Have you tried using a Peek stage to see what's happening?

Hi! I have a job that uses a hashfile stage, the directory is cleared before creating the hashfile, there is no VOC entry for the hashfile and the job works nearly all the times. But once in a blue moon I get the error "DSD.UVOpen": Line 503, WRITE failure. If I track this line it seems to be somet...