DSXchange

Hi,
I'm now working on an internal audit system, that as always should be as generic as possible. It should show differences between our systems. eg: a customer that is in the sale system but not in the billing system, or that has important differences in both systems

What I was planning to do:
create a config table which would mainly hold 2 queries (select the customer in the sale system and in the billing system. Data would be coming out in a fixed format key1-x, value 1-x.
this I send to a diff-stage or change capture. This gives me customers in one system both not in the other and customer different in both systems.

Now the workflow I think would need to select all records in the config table and then loop a job that would have query1 and 2 as jobparameters.


questions:
- any comments about this high-level setup? wuold you do it in a completely different way?
-jobparameters: the queries can be quite big, is there any constraint on the size of these strings? I think I'll anyway have to write them without any formatting, comments,... so purely one line of sql.

No practical limit.

There may be a limit to the length that you can enter as a default value, imposed by the grid control rather than by the underlying technology.

I think you should limit it to the maximum length that your implementation allows for command line length, as that will effectively limit what length strings can be passed using the dsjob command.

I was actually thinking of looping inside datastage.

so:
job to get number of audits
LOOP for 1to number
get queries
run auditjob
END loop.

In that case I wouldn't worry about the length of your parameter as you are using DataStage (server) strings which are limited by your available user virtual memory (if malloc() can allocate space, it can be added to the string)