TEST #1
*******
Arg1 = s
Test completed.
DSLogFatal called from : DSGetStageInfo
Message to be logged is...
> Job control fatal error (-7)
> (DSGetStageInfo) Unknown stage name dsNgr32 in job NGR_34_TTP_FEE
DSLogInfo called from : Debug
Message to be logged is...
> -7
I have been reading this forum for 4 years now. I am amazed by the depth of knowledge and enthusiasm of Ray. The dsxchange should be re-named as rayxchange.
In private correspondence (we work for the same company, though on different projects) TV John assures me that the stage name is correct. Investigations continue.
Last edited by ray.wurlod on Wed Jun 01, 2011 6:08 pm, edited 1 time in total.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Thought that might be next... heven't there been posts in the past indicating that (for whatever reason) some of these functions just don't seem to like datasets?
-craig
"You can never have too many knives" -- Logan Nine Fingers
hJob = DSAttachJob('NGR_34_TTP_FEE', DSJ.ERRFATAL)
Call DSLogInfo(DSGetStageInfo(hJob, 'dsNgr32', DSJ.STAGENAME), 'STAGENAME')
DSLogInfo called from : STAGENAME
Message to be logged is...
> dsNgr32
Call DSLogInfo(DSGetStageInfo(hJob, 'dsNgr32', DSJ.STAGEDESC), 'STAGEDESC')
DSLogFatal called from : DSGetStageInfo
Message to be logged is...
> Job control fatal error (-7)
> (DSGetStageInfo) Unknown stage name dsNgr32 in job NGR_34_TTP_FEE
DSLogInfo called from : STAGEDESC
Message to be logged is...
> -7
Call DSLogInfo(DSGetStageInfo(hJob, 'xfm_GLCondition', DSJ.STAGENAME), 'STAGENAME')
DSLogInfo called from : STAGENAME
Message to be logged is...
> xfm_GLCondition
Call DSLogInfo(DSGetStageInfo(hJob, 'xfm_GLCondition', DSJ.STAGEDESC), 'STAGEDESC')
DSLogInfo called from : STAGEDESC
Message to be logged is...
> Test description on transformer xfm_GLCondition
Result = 0
I tried looking for the description in DS_JOBOBJECTS, but couldn't see it anywhere. Come on Ray ... I know you've got the answer up your DS Wizard's sleeve!
Amuse yourself with this in the meantime. It verifies that DSJ.STAGEDESC returns -7 on the system where I'm working too. Both when the stage has a description and when the stage has no description.
SELECT "DESC" FROM DS_JOBOBJECTS WHERE OBJIDNO = (SELECT JOBNO FROM DS_JOBS WHERE NAME = '<<JobName>>') AND OLETYPE = 'CCustomStage' AND NAME = '<<StageName>>';
Ray Wurlod: Information Champion, Certified Genius.
Your Guinness awaits you at the Sherlock Holmes public house - next time you drop into the Melbourne office. (also, our Tuesday night trivia team there could REALLY use your help)