DSXchange

Curious. That wasn't my understanding.

What do you get if you introduce a null? (Put a specific value, such as 'X', as the Null Field Value.)

Try capturing the reject records into a sequential file, and have a reject link on that stage too (to a separate text file).

Hitting the end of your data will cause DataStage to generate a COMMIT irrespective of the number of records sent to the database.

It isn't. When you mark the int32 field nullable you lose the ability to store -128.

Try replacing the colon with an equals sign.

Assuming your currently logged drive is C:, try using a UNIX-style pathname, for example /Datastage/Testinputfiles/XML_in_Books.xml (MKS Toolkit will treat the first / as "C:\".)

No.

Presumably you used the odbcad32.exe in SYSWOW64 folder.

DataStage macro DSJobController will return this information. It is documented as returning a dot-separated list of all controlling sequences (though doesn't seem to do this at all versions). You can determine in JOBCONTROL.H that this is a call to DSGetJobInfo(). However there is no convenient mech...

Your design will work, but you will get a separate row for each source row that matches its condition. Is that what you require?

It is always the case that a solution that works on two nodes will work on four, or 2000. Such is guaranteed by the way that the parallel execution engine works.

Why not use command line options to effect the sort? For example ls -1rt
Also, are you putting this in the correct field in the External Source stage? Why is DataStage complaining about hostname? Is it expecting a UNC pathname? Try enclosing the pathname in double quote characters.

First byte or first character?

Either way, I'd read this as a single VarChar field and do the parsing and flattening in a Transformer stage. Use stage variables to preserve, and detect changes in, the header and segment records.

BASIC Program

Source Code

and DS stands for DeSign time

Use an NLS map that includes Greek characters.

Tip: It's a subset of ISO8859.

Run Time

Read the file using a single VarChar column and parse in a downstream Transformer stage. (This gives you the added benefit that parsing takes place in parallel processing mode.)