DSXchange

The word you require is "your", not "u r". If anything, "u r" would abbreviate "you are". However, we here at DSXchange strive for a professional standard of written English, nothing less than you would use in your professional documentation or in an essay to gain some academic qualification. The r...

You should enclose your code in Code tags, to preserve the indenting and make it easier to understand. You should not report the status returned from SQLAllocStmt as having been returned from SQLExecDirect. That way lies utter confusion. When analyzing the error, there are three possible handles whe...

Wrapping your code in Code tags (to preserve the indenting) would have made that easier to see, though I admit fault for missing it. How about modifying the after-stage subroutine with some diagnostic statements so that you can see exactly what's happening? What is the value of Command if FileOutRow...

1. Read the diagnostic information carefully. It tells you precisely what the problem is.

2. Provide more scratch disk resource on every node in your configuration file.

Definitely not.

Use find to search for the log file. Look first on all scratch disks defined in the configuration file used to run the job.

Note: the generator is creating a number.

You can not apply the transformation within the generator operator. You must add the leading zeroes in a downstream Transformer stage.

Not you, Joe, but how many commentators/reporters use "statistics have shown" or "studies have shown" without backing it up? That's why standards are different for academic publishing. It really exasperates me (maybe because one of my majors is in the mathematical bases of statistical theory) when p...

Using a filter command puts the DataStage job second in a pipeline. Imagine in UNIX doing command1 | command2 That's what you are doing with a filter command, except that command2 is the DataStage job; the Sequential File stage stdin is fed from stdout of the filter command. The impact of a filter c...

To create a null in server jobs use the system variable @NULL. Server jobs only have out-of-band null; they do not really have the concept of in-band null except in the format/column properties of table definitions of, particularly, sequential files, where you specify how null is represented in the ...

I can not see in CountRowOut where the row count is calculated nor where Reason is set to anything but "". On that basis, FileOutRows seems never to be set and would therefore always be 0 when accessed from CleanupFileOut. Therefore the Erase command will never be executed. Check that your routine c...

In version 8.0.1 you may run server, parallel and sequence jobs on any supported type of DataStage server. This includes the Windows Server 2003 platform.

... which you can isolate using grep or some similar utility.

I have a daily BAT file which preserves two generation of export files. It deletes the older, renames the other and exports the entire project. It is run at a time when no developer activity is occurring in the project.

DataStage server jobs will only ever return the first match unless you enable multiple row return, which you can only do if the stage on the other end of your reference input link is an ODBC stage or a UV stage. Otherwise you need to find some other strategy, such as performing an outer join in the ...