DSXchange

Thank you for the information

rajesh

Hello Arnd,

may I know how u know all these commands? Is there any PDF or some other doc where can get all these commands information.

Its a question raised out of enthusiasm

rajesh

Is there any command or way to get the link row count for passive stages.

rajesh

thank you for all the replies. Yes, my intenstion is a cartesian product. I cannt use merge Arnd. Because I am trying to join these 2 in the mid of the mapping but not at the beggining. Hope u guys understand the situation. If the final soultion for this is merge only then I have no other go than to...

Thanks Arnd.

But I am not trying to lookup but to join.

And even tried Merge. BU this is not accepting any inputs.

rajesh

I am usign sequential file as source and after the transformation stage i am trying to join the transformed data coming from transformer and database table then insert into the target My intension is not to loopkup but to join the database table and the transformed data from sequential file . thanks...

Correction from my side regarding the way the job looks like,

actually the link for the sequential file is coming from transformer not from the source. which i couldnt represent here.


thanks
rajesh

I do have transformer before that. Actually i have source table from which the data is coming into the transformer and based on some conditions i am splitting data into sequential file and into database table. i could be able to get the count of records inserted into the databse table as it is activ...

Folks,

Could you please let me know how can i join Sequential file and a Database table?

I tried using SQL Builder but couldnt get tht.

Thanks in advance

rajesh

I got the row count.

Actaully I am using the wrong stage.

Stagename should be the name of the stage from which the rows start flowing into that link.

But how can we get the link row count if the data is flowing into passive stage(Sequential file) instead of active stage?

rajesh

Folks, I am trying to capture the no of rows passing thru a particualr link. For this i am using the following code "DSGetLinkInfo(jobhandler('test'), "Target", "Insert", DSJ.LINKROWCOUNT)" where jobhandler is the userdefined routine to retireve the JobHandle for the jo...

Thank you for the information. i am able to call DSAttachjob thru a routine but the retuned value is an integer. But According to the BASIC guide, "Do not assume that this value is an integer.", is what is written under the syntax of DSAttachJob So what i am getting is correct? Thanks rajesh

Actually I am trying to get the metadata/ run-time inforamtion of a partiular job. Basically i am setting job_handler for a job and by using this job handler i am trying to get the information of that job.

As of now i am using this in the transformation.

rajesh

Folks,

I am trying to use DSAttachJob Function to attach a job.

"DSAttachJob('test',DSJ.ERRFATAL)" where test is the name of the job.

I even tried appending version to the jobname.

But it is still showing in RED.

Please help me out.

Thanks in aAdvance
Rajesh

Folks,

If you guys are talking regarding passing parameters for the stored procedure as input values, then we can easily achieve this by creating user-defined transforms ans call those transforms in the procedure. this will allow you to given the input values during run-time.

rajesh