DSXchange

Information Analyzer does not compile anything. Therefore you need for a C++ compiler must arise out of something you are doing with DataStage (which might, of course, include preparing data for Information Analyzer).

In the extended job properties - it's called Field Width. Right click on row in Columns grid and choose Edit Row... from the menu.

Two Aggregator stages. Detail ----> Copy1 -----------------------------> Join2 ----> Target | ^ | | +--> Copy2 -----> Aggr1 -------> Join1 | ^ | | +--------> Aggr2 -----------+

Of course it's working! And being discarded to /dev/null, which is what you specified. That part is working also.

In case of files, Can I bring them on one unix box and use them as one source? So that it will work as a stage for me? Definitely. Your database connections from DataStage specify locations for the database servers, and your database client software (on the DataStage server machine) look after the ...

You want to suppress the status code and now you want the status code?

If the dsjob command has the -jobstatus option, then the exit status of dsjob is the exit status of the executed job.

Not sure. Could it mean job parameters?

It really doesn't matter in DataStage either. The advantage of the flat file approach (in either tool) is that you perform the extraction only once, and restart from a given point is easier because you have the staging area (the flat files). The advantage of the "directly into tool" approach is that...

Similar concept, but not a template per se. Fast Track uses a spreadsheet-like interface for source to target mapping (you can make generic expressions or use DataStage expressions in the derivations, and you can import the same from Excel, for example); Fast Track then generates DataStage jobs base...

How about you tell us the contents of the file (with line terminators). You might need to wrap a Trim() function around the function that you already have. Trim(Trim(cat_SPO_CNT.$CommandOutput,@FM,"A")) Trim(Convert(@FM,"", cat_SPO_CNT.$CommandOutput)&...

As a test, can you make a copy of the job and replace the BASIC Transformer stage with a regular parallel Transformer stage? This will isolate the problem to the BASIC Transformer stage (or to the interface between the parallel and server environments). It does not really matter that new stage does ...

Maybe and, then again, maybe not. It is possible that you have run a job that wrote 0 rows into a Data Set? It may be (I currently have no way of checking) that the segment (the actual data file) does not get created unless a row is written to it, even though the descriptor file is created. This is ...

Except that, when there's a sign, it's eight characters long. The year is given by something like 2000+Mod(InLink.TheInteger,1000000)+Mod(Int(InLink.TheInteger/1000000),10000) The month and day can be extracted using integer division and remainder or by substring techniques. ...

The weights are given in the objectives. The more stuff you know well the better your chances of passing. At least read through the material once.

Does the last line in the file have a line terminator? (Can you position to the empty "line #5" in an editor such as NotePad?)