DSXchange

1. No.

2. You must check them individually.

Most database vendors have their own. The Red Brick copy management utility is a particularly brilliant example of its kind.

I don't know, never having searched, whether there's a generic ODBC to ODBC product out there. Has anyone searched for one? DTS, maybe?

Learn patience. Your first post was 2am my time. If you want me to respond at that hour you will have to pay me A LOT OF MONEY.

The logic you are using is perfectly acceptable and does exactly what you require. It's probably also the most efficient. Why do you seek alternates?

reachmexyz wrote:Is this possible?

Yes.

Upstream of the Pivot stage create one additional column for each pivot column and load this with a constant, the name of the column (I use a Column Generator stage for this, using a Cycle with one Value). Include these additional columns as pivot columns in the Pivot stage.

What do you understand from the message?

Do spend some time thinking about what error messages mean - people have usually put a great deal of effort into generating messages that are meaningful.

What are your data types? What are you sending in these columns?

Show us all the properties of your StartLoop activity and the design of your job sequence. Without those your last question is impossible to answer (apart from "you're probably doing it wrong").

So that's two votes for "it does work" and then there's you.

What does this suggest to you?

It depends. Can evaluation of the conditions in the Case statements be assisted by indexes? If so then it's almost certain that performing the selection in the database will obtain a result faster than bringing all the rows into a job to be processed in a Transformer stage. There is some interesting...

The StartLoop activity has a list of these 50 numbers. They are delimited by some character, such as comma.

FUNCTION TestMCP(Arg1) TheString = "John" : Char(3) : "Smith" : Char(24) : "X1-234" Ans = Oconv(TheString, "MCP") Call DSLogInfo("Value of Status() is " : Status(), "Report") RETURN(Ans) Returns "John.Smith.X1-234" and Status() i...

That's what I'd advocate. The business rules may change, for example if you had to incorporate Russian regulatory requirements, but the data model itself possibly not. But remember always that the data model is ultimately driven by end-user requirements; presumably you are now dealing with a new set...

You could always add a second Sort stage sorting just on column1 in mode "don't sort, already sorted" and have that Sort stage generate a Cluster Key Change column.

We don't even bother trying to diagnose errors from APTCombinedOperatorController.

For starters please delete your duplicate post. Second, try to be just a tad more imaginative in your choice of topic. This will aid future searchers. UV_SCHEMA is the system table that records the existence, creator and location of DataStage/SQL schemas - in the main these are equivalent to DataSta...