DSXchange

Roy has tried to write the Fold() or Fmt() function, which already exist as intrinsic DataStage BASIC functions to do exactly what you ask. Use this design. source -----> Transformer -----> SeqFile -----> (more) Read one column from source. In the Transformer stage apply the Fold() function,...

DataStage job logs are not files; they are database tables in the Repository (hashed files). Search the archive for "archiving log files"; code for achieving this was posted eons ago (probably on the Oliver site, so check this archive too). If you don't want to write code you could capture the log w...

Not saying that at all. What I'm saying - all I'm saying - is that, when the job is compiled, it needs to generate an object that can be cloned across multiple processing nodes.

That's getting very close to the realm of hiring consulting services! This forum, by and large, is for sharing answers to specific questions. Answering general questions ties up a lot of time which, particularly to self-employed consultants, means money. Developing training materials ties up even mo...

Not possible. Think about it. The SQLSTATE, DBMSCODE and LASTERR are generated as a result of failure of the "put" function. They're not available until AFTER the row has been sent, since they stem from the success or otherwise of sending the row.

How big is each row (including the key column(s))? On your DataStage CD is an unsupported utility called the Hashed File Calculator that will take away a lot of your grief (if not contributing all that much to your understanding, though its Help may be helpful in this regard). A lot of R&D effort we...

The term "scratch disk" has been around since at least 1968. Well before Torrent was even imagined. We had some on an IBM 360/20 at that time.

They're not defined BY DataStage, they're defined - as an enumerated data type - FOR DataStage. The easiest place to find them is in the DSINCLUDE directory, in DSD_BCI.H. EQUATE SQL.TYPE.NAMES TO "Char,Numeric,Decimal,Integer,SmallInt,Float,Real,Double,Date,Time,Timestamp,VarChar,LongVarChar,B...

It's a database table, not a UNIX file (or set of files). We'll come back to that in a moment. Try a long form listing to see how big DATA.30 and OVER.30 are. If either has reached 2GB then the log is probably corrupted. To recover, you'll need to get into the DataStage environment. First cd to the ...

Here's a routine. You may like the techniques. FUNCTION SearchDSJobObjects(Arg1) If UnAssigned(Arg1) Or IsNull(Arg1) Or Len(Arg1) = 0 Then Ans = @NULL End Else Open "DS_JOBS" To hDSJobs Then ClearSelect 8 ClearSelect 9 ClearSelect 10 Ans = "" * The...

Not sure what you mean by null here. Remember that a data set is something constructed by DataStage. Therefore, if it's been loaded with zero rows; you can get at best zero rows out of it. This is not an error condition (for a silly example your data set may have been populated with the records of a...

Swap space is actually something different. Swap space is disk used for memory pages that are not presently in use. Temp space pointed to be UVTEMP is only relevant for server jobs. In parallel jobs separate scratch space is allocated for each processing node in the configuration file under which th...

Not all knows Quality Stage in this forum to help you.

Why not?!!!!

"Scratch disk" is a term that means disk space used temporarily for whatever function might be required, for example to capture the output of a command or query, temporary storage of heaps for sorting, and so on.