DSXchange

You can use a Transformer stage as a row generator. Create a stage variable initialized to the internal form of the starting date (the initialization expression can use Iconv() and the starting date can be a job parameter). Increment the stage variable by 1. Output link constraint is that you are le...

Changing the VOC does not unlock anything.

If you use DS.TOOLS to unlock, the requisite entries are moved to your VOC file automatically.

Seems to be.

If it's in YYYYMMDD format, then you need either [4,2,2] (not [2,2,2] which specifies a two-digit year) or nothing after the DYMD part of your Iconv() specification. Both of the following will work for YYYYMMDD format: Iconv(TheDate, "DYMD[4,2,2]") Iconv(TheDate, "DYMD") You then need to use Oconv t...

It might be interesting to ask how they got in there in the first place.

The easiest thing to do is to filter them out when extracting - add another WHERE condition in the SQL so that "blank rows of data" (whatever that means) are not selected.

In BASIC, where there are no data types, there is no need to declare variables. Variables come into existence when first used. It follows from this that, where a variable name is used as an rvalue (for example on the right hand side of an assignment statement), it may be in an "unassigned" state - t...

What is the setting of "Use Project Defaults" in the job properties Performance page?

What happens if you convert the value marks into some kind of delimiter - maybe comma or pipe? You can do this with a virtual attribute descriptor in the file dictionary with expression CONVERT(@VM,"|",fieldname). Return this as a single-valued VarChar field.

Please post the exact error message.

Div() performs integer division. It is documented as doing so. Wolfgang's solution using AsFloat is about as elegant as you're going to get (you may need to adjust the outer function according to your requirements, for example AsDecimal).

Does adding zero to each number remove the leading zeroes?

Does the second job perform more computation than the first (derivations and the like)?

My nick was never ray - on any site. :D

It's definitely possible. There is a manual about it - Plug-In Stage Writer's Guide - available for the asking from Ascential/IBM. But you need to be a very competent C programmer to create the stage type and a competent C++ programmer to create a GUI for it.

The limit is at least 2GB so it's not that.

Please post the entire error message, which will show you the query and the column about which it was complaining.