DSXchange

i tried that, but my doubts are : 1- remote machine is a windows machine... should i use rm or delete? 2- in any case, with both of those commands, Director backs this message: Job jobName has no active stages... what it means? i have a server job with just ftp plugin inside, with no inputs and no o...

I pick up a file from a windows server via ftp and copying it on my unix DS server. At the end of my job i need to delete both files: the one on my DS unix server and the one on windows server. 1 - To delete the file on DS unix server i think i can call DS stage from sequence job "ExecuteComman...

hi chulett, i'm using your approach method to do what i need.. i have xml -->transform <--oracle stage (through reference) and from transform ---> collector (other data coming from other ways) i have in oracle stage "select C,a,b from table where C = :1) and in transformer a value of a tag link...

but i need a db connection... i need to use a value taken from an xml tag as a parameter...
ex:
<tag>valueTag</tag>
my select will be: SELECT A,B, from table where C = valueTag
ho can i use hashed file? i need to pass my valueTag to oracle stage...



thanks
Andrea

i am processing data from an xml file... before spreading these data in tables, i need to pick up the values of a tag and, with this values as parameter, pick up 2 other values from a table... these 2 tables need to be inserted in tables together with other data from xml file... don't ask me why.......

my idea was job1 -> utilityRunJob('job2', 'param1',0,0) in job2 i have an oracle stage, with a select like 'select A, B from table1 where c = param1'... this 2 values (A, B) need to be passed to job1.... it will also be 1record! in job1 i will have my data + A +B... i cannot be more clear :-( thanks...

my idea was job1 -> utilityRunJob('job2', 'param1',0,0) in job2 i have an oracle stage, with a select like 'select A, B from table1 where c = param1'... this 2 values (A, B) need to be passed to job1.... it will also be 1record! in job1 i will have my data + A +B... i cannot be more clear :-( thanks...

i want to call a job2 passing a parameter...
job2 is just a select on db, returning 2 values...
these 2 values should be passed to job1 (the caller)....

hope it's clear...

thanks
Andrea

in help guideline i see "output type" = array...

my called job should be a select which returns 2 or more values... my wish is to pass those values to the original job

thanks
Andrea

Hi to everybody...
i have a problem: how can i get return values from utility run job??
i am calling it from a transformer stage, where can i get back the values? and... they are in an array... how to get single values from return array?

thanks
Andrea

ok... that was what i thought... but... the new server job... can not have just transformer and oci stage...
should have something before transformer.... what?

Good morning. i have a server job, writing to oracle tables. if a record is rejected, i send mail using DSSendMailTester(), and set the error variable in the userStatus with setUserStatus()... in the sequence job, i get the userStatus and pass it to a new server job, because i want to get the userSt...

Hi everybody, I've a server job with multiple instances allowed (and I call it via web service). What happend is that, as normal, for each job execution a copy of the original job is created with name jobName.invocationID. My problem is that after the execution, the copy of the original job remains ...

Good morning to everyone... i have a job, starting in parallel mode and then calling a server shared container which writes on 3 tables with "enable transaction grouping". to rollback all the tables i call UtilityAbortToLog (please don't tell me i can't use it in production, i MUST rollbac...

>>Check the job properties. Is there an RTI Enabled check box?

that's why i was asking this...
i can see RTI enabled check box only in server jobs...
does it mean i can call only server jobs, from a web service?