DSXchange

Still unclear. If you spell out what needs to happen in writing under all conditions, it should be pretty easy to do whatever it is you need to do.


If ColumnA = 'dsx' then populate TARCOL1 with what?

If ColumnA is null, then populate TARCOL2 & TARCOL3 with what?

You can't have two 'else' statements in a single expression. Of course, you can have multiple else statements in multiple in-line expressions but each only has two halves. One 'if' and one 'else' per. If you need to populate three different columns, simply use three appropriate expressions, one in e...

No. Not with so little information, anyway. That error, by itself, means nothing. Post all of the errors you are getting and explain the basic structure of your job as well so we're not totally in the dark and making guesses.

And ignore anything logged during the 'Reset' processing.

As a beginner, there's really no need for you to be intimately familiar with the repository tables. Sure, you should know they exist but nothing in what you need to do, day over day, will require you to manipulate or query them in any fashion. The structures of these tables are specifically not publ...

For 'so urgent' you need to contact your official Support provider.

What kind of 'count'? A running count can be had using the @INROWNUM system variable. The total count that is going to be coming? I'm afraid you won't know that until you've gotten them all. If what you need is the latter, that typically involves two-pass processing or at least some kind of pre-pro...

It's a client command, so no. And there's no way to do this directly on the server that I am aware of.

Count them when/where? And then do what with the count? There's always "wc -l" from UNIX...

Since you are pondering a SQL solution, how would you do it from a pure SQL standpoint using your tool of choice? Disregarding DataStage, do you have audit columns in your target table that would even allow such a thing to be done?

Great! Please mark the topic as 'Resolved' now.

What is '10000' supposed to represent here? And keep in mind that time is represented as the number of seconds past midnight, so doing both as the same value (more than likely) makes no sense. Build a simple test harness routine that takes in your value(s) and tries to return your timestamp. Test i...

Welcome! It would help if you explained exactly how you are 'uncompressing' this zip file in your job.

That's normal because there are matching Transforms encapsulating those routines so it won't allow you to pick the routines directly. Choose the Transform. That goes for practically everything in the SDK. Or, create a copy off in your own normal 'custom' routines area so you can make it your own. Th...

No, they should be there automagically unless that's no longer shipping in the 8.x version - but I would find that very hard to believe.

You are looking in Routines\sdk\KeyMgt yes? You should find two routines there:

KeyMgtGetNextValue
KeyMgtGetNextValueConcurrent

No clue, but if I wanted to find out I'd ask an SA.