DSXchange

I've just upgraded to 7.5 and am starting to play around with it. I've created a very simple sequence job (ie one JobActivity) which calls a very simple server Job (Universe Table---------->Transformer----------->Sequential File) For some reason the Sequence Job refuses to compile. It comes up with ...

Why not write a second job that calls Ray's routine which stops the job (you could also add code to reset the job) and schedule it to run just under 10 minutes after the first one.

I tried the same thing and got the same problem. TEST #1 ******* Arg1 = 2004-02 Arg2 = L Test failed. Program "DSU.convMonth": Line 7, Unable to open the operating system file "DSU_BP.O/DSU.ConvertMonth". [ENOENT] No such file or directory Program "DSU.convMonth": Line ...

I'm trying to load complete documents into an Oracle table with a column defined as XMLType. DS can read whole documents through the folder stage through a column defined as unknown and that's great. However the OCI plug-in doesn't support an Unknown type and if I use a VARCHAR, the data is truncate...

At the site I'm currently working at, there are a whole lot of QA standards used with DS jobs (e.g. all stages must be commented, all stage variables must be commented, short and long job descriptions must be filled in.) Normally you would have to open various DS objects to check all these when doin...

Thanks Craig.

That all makes sense but can you shed any light on why DataStage comes with some transforms that are exactly the same as their routine counterparts (eg UtilityMessageToLog).

The transform itself is static (ie the code is included in-line) but if the transform calls a routine then all we are doing is putting the routine call in-line.

Doesn't sound like much of a gain to me.

which brings up another question.

The UtilityMessageToLog tranform simply wraps the UtilityMessageToLog routine. Is there any advantage in doing this?

And again - when you call this from a transformer stage, are you calling the routine or the transform?

Since routines and transforms are obviously in different namespaces. how does DataStage know which one to use (assuming you have a transform and a routine with the same name) ?

Also, is there any way of actually checking ?

I've done something similar using the following method.

The sequencer runs the first job

First job calclulates the 2nd parameter and sets its USER STATUS to the calculated value.

The sequencer then sends the USER STATUS of the first job to the remaining jobs.

Does anyone know if there is any way of using a job parameter as a means of constraining a query? Example: select emp_no from emp where dept = :1 I am aware that you can build an SQL file and use that as the query source in an OCI stage but are there any other solutions? The common strategy seems to...

I'm trying to create an xml document from a flat file using XML Pack 2 and for some reason I'm getting a throughput of between 5-60 rows per second which is way too slow. The box should not be an issue because I'm running on a SUN sparc 4 x 900M with about 8G of real memory. I've tried to generate a...

Does anyone out there know if it is possible to read Clustered Tables from a SAP application. From the small amount of documentation that I've seen, it seems that the data in clustered tables is compressed so I'm guessing the answer is no.

Can anyone confirm?