DSXchange

Hi All, I wrote a server job control with the below code: CompSt = pCompareSt(job param, an integer) CompEnd = pCompareEnd(job param, an integer) output_file = pOutputFile(full path for o/p file) loop_count = ( CompSt- CompEnd) + 1 current_date = DATE() OPENSEQ output_file TO open_file ELSE Call DSL...

Hi Ray, I have used this now: number_of_stages = DCount(full_stage_list,",") count = 1 LOOP WHILE count <= number_of_stages stage_name = Field(full_stage_list,",",count) linknames = DSGetStageInfo(job_handle,stage_name,DSJ.LINKLIST) record = category :"|": job_name :&qu...

sure..will get back if i find any hiccups doing that
Thanks again !

oh..sorry, i just asked without giving a thought to it
Thanks Ray !

ok...Where can i find the detailed info regarding their usage ?

Hi, I need to make one seq file which contains 3 columns for each job in the project: 1. Job Category(In Repository) 2. Job Name 3. Stage Names : Link Names I am able to get upto #2 and first part of #3(till stage names). For that i have used job control using BASIC. DSGetJobInfo(with StageList + St...

Thanks Ray !

After little more search, i understand that we need to use the dssh command from the $DSHOME/bin. Do we need to execute dsenv here first and then execute dssh ? I don't have permissions to execute dsenv, hence checking whether i am on correct lines or not . But i still couldn't figure out how to mak...

Hi All, I have recently transitioned from DataStage EE to Server version. While working with Hashed files here in server, keen to know how to view the data in Hashed files from Unix like we do for datasets in EE using orchadmin commands ? Tried in administrator client, listing the hashed file(direco...

Fine Thanks very much.

The job is running fine on its own again
But, to be on safer side, i have added extra blocking columns.

One more thing, do we have any way to parameterize the Match specifications in the Reference match stage or something like that to provision Match specifications at Run Time.

Hi, I am running a job with Reference Match stage. I am able to test my Pass in the Match specification and the job as well was running fine. Now suddenly the job is getting aborted because of the below warning/error. Warning: "rmDelivryOffcAndOrgName,0: Maximum # relabelling loops exceed limit...

So stupid of me...
Thanks :D

Are these match specifications stored somewhere in the project directory or any other place in the DS repository.

Thanks for reply. I observed that cutoff values are specified at the bottom of Match Designer window. I think it would be good if i provide with you the intent. I need to perform Reference Match(Many-to-one) with the following(sample) data: Source Data Col1, Col2 A,International Bus. Machine A,Inter...