DSXchange

I believe you can add the environment variable - APT_IMPEXP_ALLOW_ZERO_LENGTH_FIXED_NULL. From the Parallel Job Advanced User Guide - When set, allows zero length null_field value with fixed length fields. This should be used with care as poorly formatted data will cause incorrect results. By defaul...

This sounds as if you are trying to insert a string into a timestamp. If the db data type for the column is a timestamp then you would need to convert your string to a timestamp and then insert or update.

This sounds reasonable to me......, but I could be way off and often am!

I believe you need the MS Visual Studio C++ compiler that ships with Visual Studio. I have heard that using the free version on the MS MSDN site is problematic and requires patches from IBM to make it work.

Once installed there should be no further configuration on your part to make it work.

Ray,

That approach would probably also work in an External Filter stage.

You are correct, but it's a bit tougher.

Greg, Don't know if you found a decent solution to your issue, but you could use the following unix command - tr -cd '\11\12\40-\176' < $INPUT_FILE > $OUTPUT_FILE This will strip all non-printable characters from a string and I would think it would be much more efficient than throttling down to a se...

Craig,

No offense taken and I knew what you meant - I just don't want everyone to think I am a "raging" lunatic! which I am, but only a select group of people know that :D

Regards

I believe your issue are corrupt indexes. You can search this forum for steps necessary to correct this issue, but I believe it requires getting everyone out of the project (all DS applications) and rebuilding indexes via DS.TOOLS. I'm sure others will chime in, but I believe these are the basic ste...

Craig and Kim, Thanks! I thought I was going to have to open another can of CRC whoop butt! You will get a unique number (checksum) for each input. This is used for several purpose, for example, duplicate check, dedupliacation, Surrogate key generation, lookup.... You can easily get more information...

The most stage variables I have used in a Transformer stage is 220. It was successful.

Just because you can does not mean you should

You need two (2) output links with one being an insert of the new record properly defined as an insert (correct values etc...) and you need an update link that properly expires the old record (correct values etc..., but usually only the key, date(s) and active indicator are needed on this link since...

Not to mention that it is probably poor form to have 60 stage variables in a single transformer! Maybe look at separating into two (2) or possibly more.

Regards,

And the keepers of the DSXchange forum want me to pay money to see all of the following post - Quote: "I know what you're thinking, punk," hissed Wordy Harry to his new editor, "you're thinking, 'Did he use six superfluous adjectives or only five?' -- and to tell the truth, I forgot m...

If you have loaded the meta data for the stage (source columns tab), but have not chosen any columns on the "Select Columns" tab then it will return nothing as you are getting if there is lingering metadata. You can look at the destination column tab once the select columns tab is clear to...

Craig,

Just saw this one and it got my blood boiling!

To all on this post, There is clearly a misunderstanding of what a CRC is and how a CRC is generated. It is quite possible that two totally different rows of data will generate the same CRC value and that is ok (mathematically possible and happens quite frequently for a given data volume). What the ...