DSXchange

If you are using any Lookup File Sets, the files they create are named in the same way, and often times those need to be saved. It's not always safe to delete such files. I discussed this with someone at IBM recently and they may enhance it in a future release so we can tell how the files were creat...

In your job on all the columns tabs, try setting the SQL Type to Double, leaving the Length and Scale empty. Also in your SELECT, remove the TO_CHAR function as Craig hinted.

A simple variation on the theme: DecimalToString(input_column)[9] If you read the database column as a decimal(8,3) then it should automatically pad with leading and trailing zeros. If it does not for some reason, then you could define a stage variable as a decimal(8,3) as an intermiadiate step. The...

11.3.1.0 + Fix Pack 1 (now available) = 11.3.1.1

I'm curious as to the "truncation issue" in the subject line. Is the data loaded but truncated as well?

I would not expect this function to remove any type of nulls.

TrimLeadingTrailing - Removes all leading and trailing spaces and tabs from a string.

Oracle DATE type stores both date and time, I suppose because Oracle is "different" ...

My 11.3.1 still uses crontab...

One internet search suggests to restart the cron service after making changes to TZ (timezone). Talk to your UNIX Admin.

Great! Thank you for sharing the magic setting combination.

Yes, I know, this is a reply to a 6-year old post... I just happened to check the FastTrack license cost online today and it is still only offered in a 10-user pack for $80K. At least the price has not increased! :wink: A few theories as to why that may be: 1) When an organization purchases FastTrac...

I hit a known issue on 8.7 related to the WSDL import function. It required a client side patch to be installed for DataStage Designer before any WSDL could be imported. I am not on 8.7 now, however, being a "known issue" means you can search on various key words and find the path to downl...

In 11.3, the Authorized Users metric was removed effective July 24, 2014 (per ibm.com web site). However, if you go to the ibm site and search on "Information Governance Catalog" and click on view prices and buy (or see the link below), there is an AU part number there to purchase... https...

Try starting with some searches on "RCP."

Just seeing the one example, I am wondering what the other values may look like. Are they all like abc"xyz" or could they also include variations like "abc"xyz, "abcxyz", ab"cx"yz, "abc""xyz", abc"def"ghi"jkl", abc"...

Doesn't @DATE give the current date in an internal format? You could add 1 to that number, convert the result to a normal looking date format, then check the day part of it, if it's equal to 1...