DSXchange

Kim, been using multivalues for years for SCD lookups. This technique was demonstrated by me 6 years ago. The problem came when DS 5 prevented you from passing multivalue strings as arguments to a function, so I switched to a pipe-delimited storage forum, and took on the burden of converting pipes t...

Give this a read:

http://www.dsxchange.com/viewtopic.php?t=85364

Just clear the Status file from the Director client. Since you did a kill, the job has not been able to go to its status file and say it's not running anymore.

Start here, and it links to other posts that fill in the rest:

http://www.dsxchange.com/viewtopic.php?t=86234

It's time to call technical support and get some value out of that maintenance agreement. The forum is good for quick and dirty support, but it sounds like you probably have a known issue. If you're on 5.x, most bugs have been found and documented. I suspect that you have some issue specific to your...

yeah yeah yeah

Ray's right, of course.

Put this at the top of your routine:

It's supposed to be simultaneous connections to a given server. But, they really have issues. If you install a client under a 3 user license, and other clients under a 10 user license, then the 3-user people get locked out if more than 3 are in, but the 10 user are not locked out until more than 10 ...

Subroutines are called:

If you are doing a real-time solution using Datastage Server (unknown since you hijacked this post, friendly advice: I suggest you start new ones next time so we get your system/release information) then maybe you should look at the new RTI release. Actually Ken, you must have missed this a few pos...

You are correct, bulk loading or splitting into separate stages is not an option for us (unless we can somehow ensure Transaction Grouping). That is, if we perform an update then an insert, yet the insert fails, the previous update must not take effect. We do not have failures often, however if we ...

Make sure that the job is set to create the hash file if needed. Actually, as of 6.x at least this isn't needed. It will always create the Hash if it doesn't exist, even if the 'Create' box is not checked. So, it seems like the only reason to actually check it off nowadays is to override the defaul...

Add a Routine Stage to your sequence where the clear needs to take place. Create a routine with two arguments: hash file name and clear switch job parameter. Have the routine issue a "CLEAR.FILE hashfilename" statement using the API DSExecute (search this forum) with TCL as the command type if the c...

You DO NOT want to EVER pass blobs, clobs, whatever thru an ETL tool. I hope I'm clear enough on this matter. You should be passing tokens such as a filename in its place. This means that you don't have to juggle megabytes of data and pass it around. Think about the underlying mechanics of what's go...

If you have MetaStage then simply pass the metadata thru to your modeling tool. It's probably a good idea to have all of your staging hash, sequential, and work tables modeled anyway....hint hint