DSXchange

After putzing around for an hour and shortly before I was going to recommend re-installation I found that during the copy of our various configuration files from the development system to the test sysstem somehow an extraneous "?" character had made its way into the files and this syntax e...

Where and when are you getting the error message "could not load NLS"?

While the old DataStage repository uses a derivate of the UniVerse database, which is case sensitive, the new repository uses the settings of whatever the underlying database is. In your case I am guessing that the second database has been installed with a setting of "case insensitive", in...

I've got a strange error situation here: One of the admins installed DataStage 8.7 today, on a Windows machine named "SADAC560". The configuration fiel specifies APT_PM_CONDUCTOR_HOSTNAME = "SADAC560" but jobs fail to run, or compile. the value of the command line "uname -n&...

There is only 1 way to populate a dataset - from a DataStage job using the dataset stage. One can copy or dump from a dataset using "orchadmin" from the command line.

I don't see how that option can affect this error, since the problem is a data conversion one and has little to do with metadata. You can suppress messages using the message handler, but that is not the recommended route. Since ASCL-1252 (which is your basic windows code page) cannot represent this ...

The CDC Stage will give you the code for each of the two records to tell you which source it comes from and what the type of change is, using that you can decide which record to keep or to drop in a stage after the CDC.

Whenever I get that genruntime compile error in only one job I make a copy of that job, delete the original, rename the copy and then the force compile works. I just assume that somehow the internal state of the job is messed up for the compilation process but not broken enough to prevent a copy to ...

The 0xFFFD Unicode character that you read from Oracle using UNICODE (http://www.fileformat.info/info/unicode ... /index.htm) does not have a mapping into the DataStage character set ASCL_MS1252; hence your warning message.

Craig - I see your post and comments but have to admit that it at first confused me. If you have a data type of "date", "time" or "timestamp" they are, per definition (unless null) valid since they couldn't have been inserted into the data type otherwise and these 3 dat...

You cannot use the format of a date, time or datetime with the IsValid() function.
These are binary data types, and the format is for converting this to or from a display format.

The solution to the membership problem is the preferred method, but in this case the important part of the answer is visible.

The IsValid function takes 2 parameters, you have specified 3.
Perhaps this was your intent

Thanks Ray, I only looked at the first line and thought that the OP wanted only to remove numbers from a string; upon re-reading I saw that what I posted was incomplete. I like your solution, I don't recall having seen that before - it is elegant and simple and quick.

This would a good example of either a PIVOT or, if you have 8.7, use of transform stage looping.