DSXchange

Error checking!!! You didn't check whether the job was attached successfully, and you didn't check whether DSSetParam succeeded. You (like way too many others) blithely assumed that all would be well, and proceeded to issue a run request. And, as Craig pointed out, you didn't wait for the job to com...

Get a slower machine! Usually MUTEX errors are caused by the machine being "too fast for its own good", to quote one of Ascential's support staff. It's to counter running out of attempts to gain MUTEX locks that the SPINTRIES and SPINCOUNT configuration parameters were introduced in the uvconfig fil...

I'm assuming you had tried Ans = EBCDIC(Arg1) : "Dohhh" but what about Ans = EBCDIC((Arg1)) : " Doohh" ? The inner parenthese convert the reference to Arg1 into an expression containing a reference to Arg1, preventing side-effects. (The missing/mismatched ...

chulett wrote:Pardon my ignorance, but is it really any different from sending an email? Quite a number of the messages we send out via 'email' are targeted to pagers and cell phones...

My current client would like to know how you implement this. Please?

So, you're on Windows after all!

I'm not aware of any restriction on using C:\, although it's never a good idea to write things into the root of a file system, in case it becomes full.

What happens of you use C:\. (with a "current directory" dot as the final piece of the pathname)?

There's not really anything in the clients that let you do this. Certainly a simple renaming of categories can be accomplished with an UPDATE statement against the appropriate Repository tables. Making a copy can also be done, but would require a lower level tool. For example, UniVerse COPY command ...

Yes? How? Please share. We do.

Which column is expecting a number but being passed a non-numeric value?

Once you've established that, fix your design or fix your table definition.

Depends. What is your source? Figure out how to constrain the extraction so that the first 5000 rows are either not extracted, or bypassed.

Even if you can't do this at source, you can constrain a Transformer output so that the input row number is greater than 5000.

In PX you don't have to. That's the whole point! Partitioning (both of processing and of data) is the only thing over which you have control, first through the configuration file, which specifies the number of processing nodes to be allocated to the job, and second through the partitioning options o...

My all-time favourite piece of UniVerse is the caption for option 6 of DEADLOCK.MENU: Select victim for deadlock resolution This is used for manual, rather than automatic resolution. Deadlocks should not really occur in DataStage Repository, because all operations use the same code stream (the "help...

The code's OK (but, next time, format it and surround it with CODE tags). My guess is that the arguments and the key values actually in the hashed file do not coincide - maybe there are trailing spaces in the latter. Make sure that the number of trailing spaces, leading zeroes, etc., is identical. B...

Clearly the major contenders are Microsoft's family (Visual Basic, VBA and so on) and the variants of what used to be termed Pick BASIC underlying UniData, UniVerse, D3 and their genre, of which DataStage BASIC is a derivative. Still encounter a bit of GW/Basic in Asia, too, particularly on older ap...

Provided the input file is sorted, these techniques are OK. Thinking slightly outside the square, another approach is to use the ODBC driver for text files and generate the sub-totals with a grouping query. Of course this does not insert them after the detail rows in the output; however there's prob...

It's all in Chapter 9 of Administering UniVerse manual, which can be downloaded from IBM web site.