DSXchange

chulett

chulett wrote:You need to establish a handle to the "srcDlyCalcTxns_LN" job and not use DSJ.ME at all. The 2nd & 3rd arguments are Stage Name and Link Name respectively from the job the handle is attached to. And then detach the handle when you are done with it.

chulett

Only execute the code to run those jobs if the 'result' value is greater than zero.

chulett

Someone could have manually added a column to the table in the job without updating the metadata, there's nothing forcing them to match other than disciplined developers. However, sounds more like the metadata and the job were updated in dev but the updated metadata wasn't promoted into the producti...

chulett

Then please mark the post as Resolved using the button at the top of the screen.

chulett

No idea what your error has to do with the code you posted but your call to DSGetLinkInfo will never be executed:

Code: Select all

If Errcode Then 
   GOTO ENDJOB 
   result = DSGetLinkInfo(DSJ.JOBNAME,DSJ.xfmDailyCalcTxns,DSJ.Extract_DailyCalcTxns,DSJ.LINKROWCOUNT) 
End

Does that formatting help show you why?

chulett

First tell us what 'not running' means, what issues you are seeing where. I'm not about to guess what errors you may or may not be getting, especially with all those custom routines.

chulett

Check again. You need to establish a handle to the "srcDlyCalcTxns_LN" job and not use DSJ.ME at all. The 2nd & 3rd arguments are Stage Name and Link Name respectively from the job the handle is attached to. And then detach the handle when you are done with it.

chulett

nm - revisit the online help for the DSGetLinkInfo syntax, it needs Job Handle + Stage and Link names. DSJ.ME is the handle to the job invoking the call, btw - i.e. your job control.

chulett

Which bit is the modified bit and what's not working about it?

chulett

Please search the forums for "milliseconds" as this has been asked and answered in the past. The answer depends on your O/S as well and its ability to deliver milliseconds.

chulett

You can use DSGetLinkInfo() to check how many records went down the creation link or DSExecute() for O/S commands to check the actual file: "wc -l", "test -s", etc.

chulett

Both Developer's Guide pdf documents have a chapter fully explaining the Command Line Interface for DataStage.

chulett

UNIX 101. Fully qualify the path, add the directory to your $PATH, sit in the directory and prefix the command with "./", etc etc etc.

chulett

The hashed file will either need to have been created in an account, or a VOC entry created for a 'pathed' file using SETFILE, in order to use this command.

chulett

With this being 8.x and thus recovery being more complex than earlier versions, I'd suggest opening a case with your official support provider.

Search found 42189 matches