DSXchange

Empty String An empty string (also called a zero-length string, and sometimes erroneously called NULL), is a string that has no characters in it. Therefore it does not have an ASCII value (nor a Unicode value). A zero-length string can participate happily in string comparisons (it is less than ever...

You really should post server questions in the server forum, rather than the parallel forum.

By "count" do you mean count how many hashed files there are, or do you mean count the number of records in a particular hashed file?

Which database? There IS more than one, despite what Oracle bin Larry would have us believe. As a general rule, truncate is a fast operation that recovers space formerly occupied by data. Delete deletes individual records, and the operations are logged in the transaction log. It tends to be a rather...

Almost certainly a problem with your code. I have in the past created such a routine that was quite happy up to 999,999,999,999. (You should have posted this on the server forum.) Perhaps if you post your code (surround it with Code tags) someone can spot the fault. Does your code work in English on...

I believe Abort does a kill -15 under the covers.

Try this from a TCL command prompt. CATALOG DSU_BP DSU.ExecTCL LOCAL Provided that DSU.ExecTCL still exists in DSU_BP.O this should fix your problem. Otherwise, there are deficiencies in this particular project installation. If it's only DSU_BP.O/DSU.ExecTCL you may be able to copy this file from a ...

Usually the inability to find a library indicates a deficiency in your library search path. Make sure that this is correct in $DSHOME/dsenv. If that's not the problem, make sure that dsstpora.so is actually installed somewhere in the file system. If it's not there at all, this could also explain a "...

DSStopJob leaves the job with status "stopped by operator" (DSJS.STOPPED) whereas Abort leaves the job with status "Aborted" (DSJS.RUNFAILED).

That is the only difference; in either case the job is not in a runnable state.

The low post count, on the other hand, suggests "new". The Export that Arnd suggested gives either a proprietary format (DSX) export or an XML format. Search the Forum for where to find the style sheets for the latter. You can also, of course, copy the code from the Routine's Code window into some o...

Have you had disk full condition in the project directory's file system?

You can definitely create header files. A per-project header file should be placed in dsinclude in the project. To include it in code use $INCLUDE DSINCLUDE filename.H You can, if you prefer, place a per-project header file in the DSU_BP directory. To include it in code use $INCLUDE DSU_BP filename....

How about converting it with a TO_CHAR function in the original SQL that extracts it from the table?

You might also try using a delimited identifier.

I can not guarantee that this will work but, if it does, it will avoid having to fiddle with table definitions or column aliases.

The value returned by DSGetJobInfp(DSJ.ME, DSJ.JOBSTARTTIMESTAMP) should - as you imply - remain constant throughout execution of the job. Sounds like you may have uncovered a bug - report it through your support provider. In the meantime, set a job parameter with the job start time from the control...

This concept is simple, visible, manageable, and tailored to your situation. Beautiful words, and so succinct. And correct, too. There's no such thing as a free lunch. If you want restartability, you have to design it in, and pay a cost in terms both of staging data and recording process metadata. ...