DSXchange

RECORD.SIZE performs a calculation to set GROUP.SIZE and LARGE.RECORD. The problem's probably there. It's not a required tuning parameter and should therefore be left blank.

Put the compiler declaration PRECISION 14 at the top of your code.

To answer the original question, one method would be to use the ODBC driver for text files. You know the name/value for the first row, you can build that into a DELETE statement. But it will be slow.

Most of the answers will still work there.

will always return what follows the first space (and precedes the second space). All of the data you've cited in this thread have a space between the date and time parts.

The Sequential File stage that you use in the job is an object that instantiates the class of Sequential File stages. This is stored as a record in the DS_STAGETYPES table in the repository. You could hack this and change the defaults. Open the properties of the stage type in Manager (or Designer) t...

That's fine. If you can represent that as a COBOL format and import from that (put it in a file) then you can readily use the CFF stage. Is every field BCD, or do you have a mix of encodings? Otherwise you can read the entire record as a VarChar (I've assumed that each line has a line terminator) an...

It is claimed (at IOD) that the multi-job compile through the GUI is "much faster" in Hawk. Did not ask (yet) about dscc.

You can create business rules routines and store their names in a hashed file keyed by some kind of rule ID. You can then create a routine that invokes the named routine using late binding (also known as indirect call).

The StartLoop activity can be controlled by a "list of things" that can be an explicit list or a regular expression that generates such a list. This is probably the easiest. To learn it, create a job sequence with just a StartLoop, Routine and EndLoop activity. The Routine can call UtilityInfoToLog,...

... and be sure that C:\Temp\Bkup folder exists and is writable.

Client: minimum 2GB memory. Server: minimum 2GB memory; at least 8GB recommended. Source: Information on Demand conference paper IBM Information Server (Hawk) Migration and Installation presented today by Jim Tsimis from IBM Advanced Technical Support. No information on software cost; my guess is th...

Put a Copy stage between them, as advised earlier in this thread.

Your replacement value for null does not contain four characters. It must, if it's destined for a string[4] field.

Irrespective of that, Modify is very verbose about what it's doing. Create a message handler to demote this warning to an informational message.

What algorithm are you using in the Generator property? All you have to do is use a Cycle and specify it as the correct number of spaces. But you do have to configure each generated column separately.