DSXchange

is there any way to call server routine in paralljob

I tried with index but its working only for 2 condition.
I mean if the value having 'H' then its working other wise job getting abort.

Craig,
I will test it and let you know.

ColinGorman,
I have to do it in a datastage job.

Thankyou all for your responses.

Hi Nirdesh,
Thanks for your response. I have to read the file names only, no need to read the contents of the file..

Thanks,

Hi All, I need to load names of all the files(in a directory) into a flat file. I have searched the forum n found some useful posts like.. http://www.dsxchange.com/viewtopic.php?t=118304&highlight=read+file+name If you simply need file names in a directory why not use a Sequential stage with a f...

Hi all I am looking for the utility - DataStage Shell Integration Those of you that attended Ascential World may remember in the Tips & tricks presentation we mentioned a neat little utility that provides integration between Windows Explorer and DataStage .dsx files. This neat little unsupported...

awesome.that works.thanks much

Thank very much for your quick response.OK that works....i gues aim almost there...the etl_job_hist and etl_row_hist are getting populated.but etl_param_hist has param_name but param_value is not getting populated. I am assuming it should get populated?any ideas how should i go abpout it?

I do have this part in my code...right...is this what u meant or is there something else?hJob = DSAttachJob((JobName), DSJ.ERRNONE)
Name = DSGetJobInfo(hJob, DSJ.JOBNAME)
If Name Matches "'-'1N0N"
Then
Ans = "Failed to attach job " : Quote(JobName)

Iam planning to use this in the end of a sequence to fetch counts from both parallel as well as server jobs.Am i on the right track? FUNCTION GetLinkCount(JobName, StageName, LinkName) $IFNDEF JOBCONTROL.H $INCLUDE DSINCLUDE JOBCONTROL.H $ENDIF hJob = DSAttachJob((JobName), DSJ.ERRNONE) Name = DSGet...

can u please tell me where can i modify the jobs to see which path is dsjobdb writing to and which path dsjobreportdbdriver reading form...it will help me to debug.

Ok. My dsjobcmd in dsjobreportdb is "/landing01/dataint/Ascential/DataStage/DSEngine/bin/dsjob -report XML" . My filepath is /dataint/sprint/dev/datastage/projects/sprint ( this is my project path) My filename in the stage is KimD/#jobName#.xml The xml is not getting created where it is su...

I do have a KimD direcotyr below my project folder.It has the follwing folders Backups Jobs Routines RowHist Scripts Sql2Html
.This is where I am expecting the xmls but of no use .

thanks for the quick response.Ok i checked my dsjob ommand directly in the command line it works fine.I am using absolute path.I am guessing the issue is with file path. I tried using absolute path as the value for filepath parameter in dsjobreportdb and dsjobreportdbdriver.when i run the driver it ...

Ok.May be I am not clear with my question.When I run the dbdriver job with a sequence name.what is my expected output.Because when I run the dsJobreportdb, job there is no xml created at all so all my tables JOBHIST,ROWHIST AND PARAMHIST are populated with 0 rows. My dsjobcmd in dsjobreportdb is &qu...