DSXchange

Welcome to DSXchange. :D

Rather than General, there is a "Looking for Talent" forum which would have been more appropriate for this post. Please use that forum in future.

Can QualityStage 7.0 (or 7.5) use a Vality INTEGRITY repository? If not, can QualityStage import an INTEGRITY export (.IMF) file? Has anyone had experience with this? I have a client, currently using INTEGRITY, who wants to move to QualityStage, and not have to re-design all their work. Understandab...

Like you, no idea. My response would have been to answer with the question "what do you mean by options in this question?".

(But I did think my anagram was clever. On a number of levels.)

How about YOU have a go at designing the sequence, and we'll constructively criticise it?

Designing things is how some of us earn our living. Providing the same service for free on DSXchange is not something I (for one) am not prepared to do.

Welcome aboard. :D DSXchange is not a substitute for your official support provider. If you can not solve a particular problem yourself, your first port of call should be your support provider - after all, you're paying them to support you. We're happy enough to comment upon your attempts at diagnos...

Four calls to DSSetParam() will be needed before DSRunJob() is invoked to run ReportJob. DSJ_JOBSTATUS is not a valid DataStage constant; it needs to be DSJ.JOBSTATUS.

One option with DS Admin is SAD mind (anagram preserving case, would you believe?).

20MB per ROW ?!!! Maybe some kind of re-design is in order. That is an utterly ridiculous row size. What's in a row? Do you really need to move it all together? Can you move part rows? Or even not move some parts through DataStage at all? Anything that doesn't need transformation can be moved outsid...

This is a much easier task if your export includes default property values.

The six tables in the CATALOG schema have an extra level of protection (a bit set in the file header) that prevents their being changed other than by appropriate DDL statements. Copying these tables can not be guaranteed to work, because they contain an internal Security and Integrity Constraints Ar...

You will need a routine or a BASIC Transformer stage.

The only mechanism you can use to update UV_USERS is to use GRANT and REVOKE statements. Nothing else will work. This means, in turn, that you need to be able to log in as the user who has been granted DBA privilege, as recorded in that UV_USERS table. That having been done, you will also find that ...

Get a more reliable network.

How long is a piece of string? How complex are your transformations? If you're doing none, memory demand will be negligible, estimate as the size of your buffer sizes times the number of links. If you're not using buffers, estimate as the size of a row per link.

There are three quote characters available. Surround the string with one of the others. Concatenate if you must. Convert('"':"'", "", InLink.TheString) The first piece is a double quote character surrounded by single quote characters, the second piece is a single quo...