DSXchange

ray.wurlod

Is there somewhere a Sequential File stage that is specifying this hashed file directory as its target?

Or perhaps a Hashed File stage with Type set to 19?

ray.wurlod

The syntax you have used is perfectly valid, if you are executing in the project whose pathname is C:\Ascential\DataStage\Projects\PROJ_NAME.

If that is not the case, then the relative pathname 'DSU_BP/MYCOMMON.H' may not, in fact, exist.

ray.wurlod

Identifiers are case sensitive. Give it as I did - all upper case.

ray.wurlod

Welcome aboard. Postal verification is where you have an address and look it up against a database supplied by the postal authorities to determine that it is an address (or delivery point) that actually exists. Search (here, Google, IBM, etc) for terms such as SERP, CASS, DPID - all of these are suc...

ray.wurlod

Please maintain a professional standard of written English on DSXchange. DSXchange is not a mobile telephony device; there is no need to use these SMS-style abbreviations, which are singularly unhelpful for those whose first language is not English (nor even for some of us whose is!). Ur was a city...

ray.wurlod

Find the run times by invoking DSGetJobInfo() or equivalent DSMacros. You can do this in a Transformer stage triggered by, say, a SELECT against the DUAL table. The answer to your second question is yes, but not directly - after all, an Oracle script is not a DataStage after-job subroutine. The afte...

ray.wurlod

Both. Partition parallelism is obvious. Pipeline parallelism results from the fact that each takes a process unto itself, and therefore requires inter-process row buffering to be enabled.

When's the interview?

ray.wurlod

It appears that some of the helper subroutines are not being loaded, perhaps because they can not be found. Again your VOC may be the culprit. Try this command

Code: Select all

SELECT "NAME", "DESC", "CAT.NAME" FROM VOC WHERE @ID LIKE '%DSR_PROJECT%' OR @ID LIKE '%DSR_NLS%';

ray.wurlod

Please mark the thread as Resolved, using the green button at the top.

ray.wurlod

I think it is time to involve your official support provider. It will probably be faster than following a trail of interconnected log files through DSXchange and across the planet. Please post any findings.

ray.wurlod

This is a good case to write specialized job control code. Keep an array of job names currently executing, and a similar array of job handles. You can discover all the information you need from these arrays. Also keep a scalar variable recording the number of jobs currently running, and don't start ...

ray.wurlod

You can, but would have to wrap the UNIX commands in a DOS command, for example

Code: Select all

 DOS /C "echo > .Type30"

Otherwise you can connect via telnet, source dsenv, and invoke dssh in your project directory.

ray.wurlod

boppanakrishna wrote:Hi Ray,

I have tried connecing through telnet server and ran the command

VERIFY.SQL SCHEMA PROJECTNAME

Please suggest me the next step i should follow

Regards,
Boppana

Code: Select all

VERIFY.SQL SCHEMA pathname_of_project_directory

ray.wurlod

boppanakrishna wrote:Hi Ray,

My DSEngine directory contains the files
VOC, D_VOC, VOCLIB and D_VOCLIB, are these the files which we should have?

Please suggest me if i need to search for any more files

Your DSEngine is, frankly, irrelevant.

Does your project directory contain a VOC file?

ray.wurlod

What's in the startServer log for the Application Server?

Search found 53125 matches