DSXchange

I need to just delete data from a table in a server job. How do I acheive this using DRS stage? I am trying the following: [Transformer] > [DRS Stage] In the DRS stage, I have configured the table name and given a User defined sql which will delete the data. Now during compile, it complains Transfor...

If you are not very keen in capturing the success/error message. You can put the truncate stagement directly in the before tab of the DRS stage. Thanks Narasihma. I tried to do this(see my first post), but was not able to, it kept on throwing errors. Any idea whats wrong? I also tried: CALL myschem...

I can think of a few options: 1. Create a shell script which invokes the stored proc and execute it as a Before Job sub routine. 2. Create a separate job which has a Stored Proc stage and run this job before the data load job. (The stored proc truncates a given table and returns a success/eror messa...

I highly doubt you can get a OUT parameter from the before/after sql tab. For that you need to run it via STP stage. ... If my design is as follows: [Transformer] > [DRS Stage] Where do i put in the [STP] stage such that it is invoked once before the data is laoded via the DRS stage? I do not see a...

I am trying to call a oracle stored proc say TRUNC_MYTABLE(tablename varchar in, msg varchar out) I want to execute this proc before loading data via DRS stage, hence am using the SQL > Before tab. After going through the posts I tried various combinations of the following in the DRS Stage > SQL > B...

Retrieve the value and Set the UserStatus inside your transformer. In your second transformer you can retrieve in your second transformer while specifying the Initial value of your stage variables. This way it will only be called once. Search on more details on how to set and retrieve UserStatus. T...

I need to initialize 3 variables(one time only) in a Transformer stage. These values are to be retrieved from a sql select against a oracle db. Whats the best approach for doing this initialization? I checked the Stage right click Stage variables properties dialog box and then the Initial Value colu...

OK. Thanks!

OK. I checked the docs and seems like COmmand Stage is not supported on Unix platforms!

Thanks Craig! I looked at some other posts in the forum and one approach(your name was there too :lol:) was to create a sequence job such that J1(to truncate) = [Transformer] > [Relational Database Stage] J2(load data) = [Sequential Stage] > [Transformer] > [Oracle OCI Load] Ofcourse the second opti...

I wonder why is that option not supported. Is it possible to use Oracle OCI Load stage and provide it with a custom ctl file, using which it can load in Automatic mode. Since in Manual mode, it will not actually load the data. I do see a ' Oracle 7 Load ' stage which has in its properties the option...

I want to perform bulk loads using Oracle OCI Load stage. Job design is something as below: [Seq File] > [Transformer] > [Oracle OCI Load] In the properties of Oracle OCI Load stage, i have specified Automatic mode. And this works fine. But all it can do is insert data. How do I specify other option...

Thanks!

Hello, Is there any function (like floor) which will always round the parameter to closest LOWER integer? e.g. 6.5 > 6, 6.9 > 6, 0.1 > 0, 0.9 > 0? I tried fmt() but it rounds both ways(higher & lower). I also tried using fmt(Arg1-0.5,"0") but it wont work for any value less than 0.5 (r...