DSXchange

Hi,
I recently tried importing match specifications from an XML file and it works great. I was wondering if there is some way to reflect the changes made to an XML file picked up by the match job at deploy time without having to reimport the xml file into a new match stage ?
Thanks.

Sure seems like a hassle in parallel extender when it comes to things like that. I used to do the delete in a before SQL during my server days all the time. Wonder if Open command is of much use for me.
Appreciate your response as always Ray.

Hi, I am having trouble deleting records in a table by ID before I load data to the same table using Oracle Enterprise Stage. I am using the Load / Append mode in the properties with the Open Command as DELETE FROM TABLE WHERE ID='#ID#'. I get these fatal warnings ORA-00054: resource busy and acquir...

I have added additonal functionality to an existing multiple instance job used in all our sequencers which was not foreseen as well not in the scope of the project at the time. This new functionality put added requirements on the sequencer and I was hoping to find the least invasive procedure to be ...

Ideally I wouldnt want to, but there are a lot of existing sequencers that need to be changed in that case. There is a common multiple instance job that runs in many sequencers and by aborting the sequence by killing it from the multiple instance server job will avoid me having to change all the seq...

Hi,
I have a server job that is being called by a sequencer. I want to kill/Abort or stop the calling sequencer from the server job if a particular condition is not met in the server job. What would be the best way to do this ?
Thanks.

As part of the same topic, how do you multiply a vector with a scalar.

For example.

X=[1,2,3,4,5]
Y=2*X=[2,4,6,8,10]

Did anyone try to do Matrix algebra using dynamic arrays in Basic ?

Turns out it is very simple. SUM(X) gives the sum of all elements in the array !

Hi, I am trying to do some arithmetic on an array. I have two sets of data. X=[1,2,3] Y=[10,20,30] I would like to be able to do some arithmetic like this. SUM(XY)-SUM(X)SUM(Y) = (10+40+90)-(1+2+3)*(10+20+30) I know how to multiply arrays but not sure about summing elements in an array. I have a fee...

Hi Ray, Yes, we capture every job statistic after its run, like what table was loaded and if it was successful. Once i get the tables used in a job, it will be fairly easy to figure out if the source table loads were successful. The only missing piece is, the query above does not give me tables used...

This SQL seems to work for what I want. Not yet sure if this is fool proof and the best way to do it. Some more testing needs to be done. I reverse engineered a very identical SQL code posted on here that figures out the Hashed file usage in a project . select EVAL DS_JOBOBJECTS."@RECORD<14,1>&...

Hi, I am trying to extract the source table information of a job from the universe reporsitory. I know that this information can be pulled from reporting assistant , but I am attempting to extract the source table information in a sequencer before a job runs, to verify if the source tables used in t...

The column auto match was good. Wish we could do the same for similar sounding names, more like sounds like feature. Some columns are mapped to very different names in my spread sheet. The auto match feature doesnt work in that case. But Auto match did map about half the columns. A little helpful bu...

Is it possible to do a straight map of source and target columns from a spread sheet ? I have a spread sheet which has over 200 columns being mapped to some 200 columns in my target. Instead of dragging and dropping every column in the transformer, I was wondering if someone tried something to make ...