DSXchange

Still "Having problems proving latest claims in "Tips: Hash..."

Do it all the time. However, only 1 writer to a file at a time, please.

Your after routine ran a script xxxx.ksh that exited with a non-zero return code. Is this okay? You need to know, it's your script. The "-v" looks suspiciously close to the xxxx.ksh, is this a typo? If you want non-zero return codes to be valid, you have to check the box that says ignore non-zero re...

The Reporting Assistant. Search the forum, its uses and relevancy in future releases have been covered a lot.

Not really, it's more of a tool for getting mapping information out of DataStage. It's also been targeted for retirement, so there's really no point in using it going forward. MetaStage has been the designated tool for extracting design information and publishing since DS release 4.

You really need to know how many inserts and how many updates are being processed. The suggestions to split inserts from updates and bulk load the inserts are excellent ones. Your data could be trending 90% updates and 10% inserts, with the updates at the back of your source data. Your job could fly...

Do you mean the number of yellow lines of messages in the job log? You can figure this out by doing using the GetLogSummary API and counting the warning messages returned. Of course, if your job is set to abort after N warning messages you will be capped at the maximum allowed.

I don't know of a comprehensive, published, and supported list of all error codes possible. There's server side and GUI error codes, is there one in particular we can help decipher?

I pulled that from a DS 7.5 on Solaris site I'm at.

Did anyone read my post? User defined sql is not executed to view data in a reference lookup. Lookup's SQL by their very nature can't be used in the View Data button. Since the SQL is expected to return a single row, you have to provide the Where clause information. To view data, you provide nothing...

I know that FTP command line is faster than FTP stage because the FTP command line achieves maximum throughput by not waiting on DS to process anything. The transfer is dedicated, and has the potential to be very timely and reduce the chance of transfer errors, retries, and timeouts. Once the FTP is...

almost irrational dislike of containers I think I'm quite rational. I rationally hate the implementation of the concept, but I'm cool with the concept. DS Functions are great examples of reusability. DS Transforms are NOT well implemented. After 9 years of major releases of DS you'd think engineeri...

How about accomplishing this at the database level, like using a sequence generator. Does this have any disadvantages compared to the one generated by the Datastage. That sticks a choke point in the database. You have a process individually handing out the next key ala a sequence. If you are simult...

Use command line FTP and get the files local faster. Skip using the FTP stage altogether, which is probably keeping your connection open for a long amount of time.

Just for grins, how long do those FTP connections stay open currently?

Read it for yourself: # MAXKEYSIZE - This sets the maximum number of characters that can # be used within a primary key. The minimum value of 255 retains # the historical maximum key length as well as the historical encoding # of record locks within a 64-byte entry. Any other value, which must # be ...