DSXchange

Ok... hi, in keymgtgetnextvalue funtion what parameter is used if i used this funtion in job, whenever i run the job, sequence value is used can you give me solution for it. thank you First off, email is for private matters, not to continue a forum posting. Secondly, did you do as I asked and look a...

ICE wrote:Last week, I cleanup one project using ds administrator.

I'd be curious what exactly that means. Step by step, what did you do?

ICE, people have asked in the past but I don't recall you ever answering this simple question: Are you really still running a 4.x version of DataStage?

Locate any routine in the Manager and double-click on it. You'll be able to read the Long Description which usually explains everything you need to know about the routine. You can also examine the source code to get a better understanding of how it works. This would be true for the KeyMgtGetNextValu...

There's been a couple of recent posts on the 'where' of these sqlldr files. I seem to recall them going into your scratch space unless a particular ORA environment variable is set - something like ORA_SQLLDR_FILE_LOC but I know that's not it. Perhaps a search would turn it up unless someone recalls ...

They did.

The method I outlined doesn't "install the whole server again".

Those are 'parameter markers' or 'bind variables' and are placeholders for the actual data coming into the stage. In the OCI stage they are numbered while in most others they are positional and represented by a question mark. So, :1 would be where the value in column number 1 would be substituted in...

Ah... the joys of using 'custom' sql when there's no reason to. Let the stage generate the sql and then add your 'rownum < 2' constraint to the 'where' portion, that way you'll see the difference between what it needs and what you did. It's all about key columns and missing bind variables. Or, since...

Welcome! :D The Pivot stage is one of the 'optional' plug-in modules, so if you can't find it in the palette I'd wager whomever installed DataStage for you didn't select it. Which begs the question - what other stages got the same treatment? While you can use the Package Installer for stuff like thi...

kcbland wrote:And one wonders why INTEGER can't hold the answer?

No, but I do continue to wonder why someone would need these kind of numbers...

Yup, that's the one I meant.

Yah, umm.. well, except like that.

Excellent suggestion, old chap... excellent.

Wondering why someone would need to compute 'up to' 800 factorial. [shrug]

Technically, only #1 is the 'way'. 2. Add check point on the Project level in Administrator (Sequence Table And check the box Add checkpoints so sequence is restaetable on failure). This just sets the Project level defaults and ensures that when you create a new Sequence job after it is set that tha...