DSXchange

Hi ArndW, I tried ur routine and its throwing this error which i cannot rectify. can u please help out... Compiling: Source = 'DSU_BP/DSU.linkrownum', Object = 'DSU_BP.O/DSU.linkrownum' * 0010 RowsOutput = DSGetLinkInfo(DSJ.ME,StageToCheck,LinkToCheck,DSJ.LINKROWCOUNT) ^ ',' unexpected, Was expectin...

Hi group, Am trying to get the summary of a job,, about the job name, source, target , no of record passed, pass or fail.. how can i get it... or else can anyone send me a routine to get only the record passed in to a target stage in a particular job. with getlinkinfo something... thnx in advance..

Hi all, 'Error calling subroutine: DSD.Browse (Action=3); check Datastage is set up correctly in project TEST' this is wht the error i get if i try to open DRS stage view list or if i run the job. DRS stage is my source here. previsiouly it was working fine, but suddenly now its throwing this error....

[quote="sagarkulkarni_in"]u can do this using a a dsjob command on unix prompt. try using it !!! Sagar[/quote] am using windows. so can u please help me how i can get the status in a separate file.. can any one say the commands to get the status of all the jobs in a category, so that if i ...

[quote="ArndW"]As of 7.5 you can call [i][b]dsjob -run[/b][/i] from a windows client to start a job on any connectable server. -Arnd.[/quote] Can you brief me out, in which directory i have to give this dsjob command and to execute, should i import any dll in the client side. i think only ...

How can i run a server job from a command prompt in a client machine. can any one please give me the steps.....


thnx

Shri

Hi, Am running a set of jobs, through scheduling or by running it through a sequencer, i want the staus of the jobs in a text file, means the Finished, Failed satus etc., in a text file.. how can i do this.. also please tell me more about DS_JOBOBJECTS and DS_JOBS.... thnx in advance.. Shri :roll:

Usually we will do equi lookup,, if my lookup is based on '<' or '>', how to implement the lookup condition. Am using the DRS stage as my lookup stage. please can anyone update me regarding this. I gave the logic too, in the previous post of this post.

I have 3 source driver tables.. emp A person B dept C the join condition which i give in the DRS source is as follows, WHERE B.EMPID=A.EMPID AND C.CTLVALUE=A.BUNIT AND C.RNAME='PER' ORDER BY A.BSC,B.OID But for a target column the transformation logic is, assume the column name is Num_of_Person, It ...

Hi all, I have a logic like <> symbols are used in the lookup condition, how to do a relational lookup. Someone said that, we need to use '?' symbols in the drs lookup.. i cnt understand the logic of '?' symbol in the sql query, also, in some place it was like :1 :2, what this number mentions like i...