DSXchange

The links are there if you look. The tests are done by Prometric so any fee information would be there.

Can you post what "admin level settings" those would be, please?

That's not the issue, it says you're using user-defined sql and you're not selecting the same number of columns as you've defined in the stage.

Pretty sure that's been mentioned several times here as a bug with multi-instance jobs and the auto-purging of job logs. Try turning off the auto-purge for the job in question and see of that 'fixes' things for you.

The removal of that restriction has been mentioned several times here, from what I recall... I think even by Ernie.

Best way to learn about that is check it directly. From the Manager, navigate to the Routines branch and then Built-In\Before/After and you'll find it there. Double-click on it to open it and the Long Description will have all of the usage information you should need. From there you could even look ...

Still not sure I follow, but... have you checked the online help? There are API functions to "get" all kinds of information, including DSGetLinkInfo and one of the things you can get are row counts using the DSJ.LINKROWCOUNT InfoType. From a custom routine you can call it after-job or from...

Sure, if you write one. :wink: On a more serious note, you would be better served by providing more detail as to what exactly it is you are asking or attempting to do or the issue you are having trying to do something. So... could you try again, please? Give us a better idea what you are trying to a...

And do you have any idea what the date looks like in the 1 record that didn't make it into the output?

Your official support provider? :? I've never bothered with a 'compressed' table in Oracle, never really saw the point, so I'm out from that regard unfortunately. However, there really shouldn't be any difference in the end result when the same sql is run from a stage versus sqlplus so not sure what...

Well... I guess with 8.x everyting needs to be complicated and Java based. I was expecting something... simpler... more like what I receently did for a 7.5.x client side patch: Install the patch as follows: 1) Create a temporary directory 2) Unzip the patch into the temporary directory 3) Run the se...

Ask your vendor. They gave you the patch, they should give you the appropriate instructions as well. You sure there's nothing like a 'readme' in the zip file I assume you got for this?

From what I recall, the Sequential File stage will let you define it as a decimal and you can tell it there is a leading sign so it will do all the work for you. Can't check right now, but pretty sure I've done that.

Yes, post the actual unedited error message or messages you get from your derivation.

Yup, try both together - send the tablename in as a literal and you could both group on it with 'Last' to preserve it and also 'Count' it in another output field.