DSXchange

Try setting APT_STRING_PADCHAR to a single space, rather than its default 0x00, which is usually displayed as ^@.

To get a more technical answer, search DSXchange for LUT_CreateOp.

You can produce a report from Designer, and preserve the intermediate XML. Then you can grab the pertinent section from that and parse into whatever tool you desire.

They don't have to use that expression. Mine is more efficient.

gnan_gun (is this the same thread/poster as the original one by pimmit22043 ?) The line you posted that builds the date doesn't contain a date conversion using date_from_string; perhaps you could post that line as well. These days the Transformer stage effectively builds an operator. The function n...

Your expression is unnecessarily complex. You seem to be using a job parameter as the initial value (this is good).

Generate a sequence beginning from 0 (initial value=partition number, increment=number of partitions) and add that to the initial value.

Then try using the "native" database type under orchdbutil.

Specifying ODBC forces orchdbutil to use ODBC protocols.

I'd have to search for it, and I'm kinda busy at the moment. Why don't you try searching www.ibm.com?

Yes. One of the pictures in the glossy literature from IBM shows just such a job (for version 8). It even goes on to do survivorship in the same job.

Your file is not sorted as you have asserted on the input of your Aggregator stage or, perhaps, the first line of your file is column headings and you have not asserted in the Sequential File stage that "first line is column headings".

Do consider purchasing premium membership which will let you see the entire posts of premium posters. All of the revenue from premium memberships is devoted to the hosting and bandwidth charges incurred by DSXchange. So, by taking premium membership you are not only helping yourself, you are also h...

Please post the record schema (from the generated OSH for this job). Please also verify that your field delimiter is comma and that your field quote character is double-quote.

I think you'll find that "have" in this context means "sell". The likelihood of getting source code is therefore vanishingly small.

At some point you need to investigate obtaining valid licences.

Meanwhile, how about marking this thread as Resolved?