DSXchange

If you mean a horizontal pivot where one row becomes many rows based on repeating key columns, then (oddly enough) the Pivot Stage is what you are looking for.

In the second section you mentioned about DS Server ( standard DS ) or DS 390 ? Either one, as this is just standard 'server' stuff. The 390 version includes everything in the 'standard' version plus the mainframe stuff. Is there other way to execute jobs on mainframe or just using DS 390? Only the...

The 'overwhelming' I meant was more on the order of the number of connections or threads per user or session rather than the amount of work being done. I've seen jobs hit some of these kind of limits on busy (or under configured) systems.

I see from the reply on ADN that XP is not a supported server platform.

Secondly when i execute RESIZE H_CUST_SUM_ID* * * 64BIT The command gives an error as RESIZE : Invalid file name,sizing parameter, or option on command line . I don't believe you can use this command on an external (i.e. 'pathed') hash file, which you seem to have. You may need to add a VOC entry f...

Can't say I've tried but I imagine it should work fine. Of course, it would need to be XP Pro and not Home, you'd need to make sure you had full Admin rights when installing and could even depend on the various versions involved. What exact version of DataStage? XP all patched up, latest Service Pac...

It is best (IMHO) to use a single OCI stage whenever possible when doing things like this. I've seen some people who, when needing to write to 6 different tables in the same instance, will use 6 OCI stages. This works, but keep in mind the fact that this will cause 6 connections to the database just...

Can you please be more specific. Do you mean to create two target transofrmers, one for inserts and one for updates. Yes and No. The only way to use different columns when inserting or updating is to use two seperate links, one for Inserts and one for Updates. However, you only need one transformer...

You would think those would be the people who shouldn't need it.

Again, as Ray mentioned, a whole lotta stuff is "greater than 0", but assuming you mean it is a number and greater than zero... If num(abc[1,1]) and abc[1,1] > 0 then "Yes" else if alpha(abc[1,1]) then "NO" else "UNK" The assumption here is the first cha...

Ah. Sorry. All 'Cleanup Resources' does is list process ids and allow you to 'log them out', i.e. kill them. You can do the same thing from your O/S command line. I would typically do a " ps -fu[userid] " or " ps -ef | grep PHANTOM " to find the appropriate PID to kill. There's also the DS.TOOLS men...

Amos.Rosmarin wrote:DSSendMail supports only a single recipient.

Unfortunately, this is true. Fortunately, that's true for Windows only. For a UNIX server, simply delimit the email addresses with white-space. FYI.

This should probably go back to your Support Provider as a question. I would think at least one of the errors would come back in the DBMSCODE, but it could be a bug in your version since it is a little on the old side.

From the "command line" you can make use of the dsjob command. One version of the syntax would be: dsjob [-server <server>][-user <user>][-password <password>] -stop Project Jobname|JobId You can read up on "dsjob" in the Server Jobs Developer's Guide in the Command Line Interface section. It has ma...

Sorry to be a little slow today... but what do you mean by "format errors"? Also, I'm curious what Array Size you are using, as something other than 1 can really goof up the error reporting out of Oracle.