DSXchange

Thanks Mucho! I have it working now. The proof-of-concept Routine is below. From this point there are a couple of directions that I can take it... ...obtain the job version of a specfic job at run-time, to include with my job run audit data. ...generalise it a bit and select the job names and versio...

Hi, I want to capture a job's version number (i.e. the version number in the General tab of the Job Properties window) in my runtime meta-data. A perfect solution would be a using an InfoType in the DSGetJobInfo function, but this does not seem to be supported (at least its not documented). Neither ...

Hi Ray,

Thanks for your reply. I was just going by your earlier post to Titto (which I found on a search) when you said

Same as DSJ.JOBSTATUS in DSGetJobInfo

I must have misunderstood. Are you able to clarify?

Thanks again,
katz

Hi, It is the equivalent tags (meanings) for these stage status values that I desire to find out. The Job Report ( DSMakeJobReport ) and DSGetStageInfo ( DSGetStageInfo (jobHandle, stageName, DSJ.STAGESTATUS) ) are returning status values of 5, 7 and 9 for some stages. I am analyzing some job execut...

Hi All, I am looking for the meaning of the Stage Status codes which can be returned from DSGetStageInfo . My DSINCLUDE file does not have any DSJS equates for values on DSJ.STATUS between 4 and 10 (server version 7.5.1.2), yet I am capturing Stage Info status values for 5, 7 and 9. Does anyone know...

Hi, It is possible to use the property of passive stages (i.e Hashed File and ODBC) that no output links can be opened until all input links are closed, in order to force the execution sequence you desire. In my opinion, it would be a bit of a "cludge" and will require an "extra"...

Hi All, I am requested to set-up datastage in such a way that each of our developers logs-in to the datastage clients with their individual unix log-in account, but that all unix objects created/modified by them (or the executed jobs/routines) should be owned by user dsadm. The objective is to elimi...

Hi reddy, I am not able to recreate your output exactly, but with the COPY command I do get a non-printable character of hex(1A) as the last character of the file. I don't get this character if I use the /B option (binary file copy) with the COPY command. For example, COPY /B file1.txt + file2.txt +...

hi anshumangupta1206, I have noticed that the Job Report when executed in an After-job routine ( DSMakeJobReport using handle DJS.ME ) captures the correct job status. At least this is true when outputing an XML job report - I have not tested the other report levels. It would be possible for you to ...

Well, the error message is 'Abort raised in <Jobname>..Afterjob

Does it help?

We have the following bit of code as part of a routine ********************************************************** writeJobLogToFile: v_jobLogFileName = v_FileNamePrefix : '_JobLog.txt' v_maxEventID = DSGetNewestLogId ( v_jobHandle, DSJ.LOGANY) if ((v_maxEventID <= 0) or (v_maxEventID = DSJE.BADTYPE)...

Hi urshit_1983,

Thanks for your quick reply. I cannot see why I need execute permission on the named pipe file (for owner, group, and all other users) but since I'm shooting in the dark, I can give it a shot.

katz

Thanks ArndW, Of course! *slaps palm to forehead* Sometimes its difficult to see the forest, for the trees. Your suggestion has worked a treat. I will query with IBM support on the more general question on passing multi-byte characters through named pipes. But for now, simply setting the NLS map to ...

Thanks for you replies. I have always used the DSLogFatal function in instances where there is an imperative need to abort the job, but on this project I need to justify its use in light of the warning printed in the BASIC guide. I was thinking that there is perhaps a better method to abort the job,...

I have questions regarding the DSLogFatal Function. The BASIC Guide warns that DSLogFatal should not be used in a transform. Use DSTransformError instead . However, the DSTransformError function only logs a warning message, not a fatal one. The sdk routine UtilityAbortToLog uses the DSLogFatal funct...