DSXchange

You will always get the warnings. Setting up a reject link doesn't stop the warnings from being logged, it allows you to capture the record that caused the warnings. The record was not 'loaded' to the target, it was sent down the target link to Oracle and then, when the database rejected it, also se...

Ok, what is the unexpected 1BJActivity? Let's see... if both 1A and 1B are to run before 2J, then both should be linked to just the 1Sequence. Set the mode to 'Any' and you should be fine. You don't need the second sequence for this purpose. I generally only use two triggers - 'Ran Ok' and 'Otherwis...

I'm going to chime in here with Flash and Vince. Just because the target data types are packed decimal doesn't mean you need to supply your export file with packed decimal fields in it. Heck, there's not really even a burning need to provide it in EBCDIC, either. Many FTP programs can do the convers...

All you really need to do is have a second link defined (with no constraint) and mark it as a Reject Row. Make sure it is the last link when looking at the link ordering and it will capture all database rejects.

What is your target stage and array size?

You may also be running afoul of the HyperThreading 'problem'. If you have one physical Hyperthreading CPU, it will be detected by DataStage as two CPUs.

Not sure what other recourse you would have other than turning off hyperthreading.

For what it's worth, Ascential Support was finally able to reproduce this problem in-house. If there is an actual resolution, I'll post it here as well.

You can get away with it because they have no VOC entry. Unless you've specifically added one to facilitate the use of some of the commands that require it, that is.

That's... interesting. We'd need to see specific examples of your data and the output order that you are seeing.

Ok.. what do you mean by "three jobs in one window"? If that means three Job Activity stages in a Sequencer job that are not linked together, then yes they will run in parallel. To enforce an order, you need to link them together - in the proper order, of course. The 'triggers' between the jobs will...

For hash files not in an account, i.e. ones that are specifically pathed and created via 'mkdbfile', simply delete them from your operating system.

I really don't think this can work. I'd need to build a test job to confirm but it just doesn't seem right. You have to supply all three keys to the lookup. Either all three match or the lookup fails. So, when C2=B then C2<>C and vice-versa. My first thought was something I've done before, two separ...

As mentioned, you probably have the Call Number defined as a untrimmed string and you are seeing perfectly normal string sorting. You would need it to be numeric to get the sort order you are looking for. As for the sum problem, you can't have the Half Hour Slot come after the Quarter Hour Slot in t...

You could setup a Stage Variable to track this, I would think. A simple check for the current value being greater than the saved value? Really depends on what you are trying to accomplish and when you need the max value.

It could be platform and/or version related. Sometimes they import as Length=38, Display=38 and that's when you can have problems. I've also had the problem with LONG fields. You can select them into VarChars in DataStage all day, as long as the data itself doesn't exceed the size of the field in Da...

Ray, while straight Oracle NUMBER fields are technically defined as 38, DataStage needs the metadata to be declared as 40 or it will give you the dreaded "OCI has fetched truncated data" error.