DSXchange

Issues can arise from system resource contention if you are running an extremely large number of processes in parallel. If these are sequential in nature then I would not believe that resource contention would be your problem.

First, you may be experiencing resource contention so this may/maynot be causing the issue you describe. The -99 or unknown error may indicate just this type of problem. What are the 90 phantom processes? Second, Ray and Ken may wiegh in with more information, but I believe the dslictool file is not...

I believe you can do a search for SCD, or Slowly etc... and find a bunch of information regarding the implementation of SCD's within DS. I believe Ken and others have given wonderful discourse on how to do this.

Regards,

If your source files/tables are the same (same metadata) and the output from the job will be the same for each source then you can simply parameterize your job (filename, output file name etc...) and then set the "Allow Multiple Instance" property to true for this job then create a sequenc...

Do you set the "Execution Action" to "reset if required, then run" in the job activity stages? I have seen this behavior before when the job is not in a runnable state for whatever reason.

bin is the directory and uv is the UniVerse executable.

It would seem to me that there is a user written routine involved here that calls the wrong function. You are calling -
and it should be -

I believe the answer to your question is not as simple as some algorithm or formula that can be given to you here. I'm not sure Ascential publishes such information in a definitive way. My experience has always been that there is a point of diminishing return, meaning that at some point the overall ...

I fat fingered the i and l - sorry!

Phil, I'm not sure that 30 seconds is sufficient on its own. You should issue the following commands to ensure that nothing is returned prior to starting the services - netstat -a | grep rpc ps -ef | grep phantom ps -ef | grep dsapi or dsslave If these are clean then you should be able to start, but...

DSExecute is a subroutine therefore it is a CALL like =

Call DSExecute("UNIX",CMD,RET,SYSRET)

The output of the command is held in RET and you can interrogate SYSRET for status.

Bill, Do you have access to Remote Desktop Connection via your client? I think this would be the easiest and simplest way of doing this. Here is an example call to programmatically create a DSN for Excel - SQLConfigDataSource(NULL,ODBC_ADD_DSN, "Excel Files (*.xls)", "DSN=New Excel Da...

Seems to have crept in since Ascl took over the maintenance of Version Control from our friends at DCS! Has Ascential made any further code enhancements since maintenance was turned over to Ascl? The last change I made to the product prior to turnover was to address ecase - 58690 (Version Control i...

Sarat, The pivot stage within DS is for horizontal pivots or creating multiple rows from a single row of data. A vertical pivot (or the ability to map vertical data from many rows into a single row) is not supported. I have not done exactly what you ask for many years, but I'm sure some others will ...

Phil, I'm not quite certain though as to why we are seeing this behavior. It is likely that COMPARE resolves to either strcmp (non nls systems) and strcol (nls enabled systems) and both of these work fine when one or both of their arguments are null. Also I do not believe it is a DS thing rather it ...