DSXchange

Well, go to the Search page here and enter "Unbalanced input from partition" and check the Exact match option. You'll find it's been covered before.

Did you fully qualify the DNS name for the server (instead of something like 'dsserver', try whatever your site uses like 'dsserver.world.net').

Turn off any Monitors? Get out of the job and see if it is still locked? Make sure it's not running? Do a Status file clear? Export and reimport the job?

Mostly in that order...

use the default dsn "localuv" when using the UV/ODBC stage to conduct relational type accesses to hash files created by DS. Make sure that you have used the SETFILE command to register these hash files into the "VOC". Keep in mind that you are simply strapping a SQL interface over what is basically ...

What is the release of Universe you are attempting to access? You show DS on Windows, is the Universe server on Unix? Have you configured the ODBC.ini to have the appropriate entries? How did you succesfully get the count of the "hash files?" What hash files are you talking about? Are you attempting...

You need CANNOT use job parameters in the way suggested. Your derivation has to be CODED into the job design. If you have a few expressions, simply use stage variables to derive the result a few difference ways. Then, use a job parameter to act as the switch which decides which derivation to use. If...

Your metadata is different between the portion of the design that writes to the hash file and the portion that reads/references the hash file. Hash files have specific requirements for their use. They are NOT relational in nature, data is stored positionally. ALL METADATA for links to hash files hav...

Search this forum for "DB2" and "date" and you'll get to learn all the issues with using the plugin with dates. My apologies in advance...

Ray is suggesting a mathematical way of taking care of a 5 digit number rolling to 6 digits because a junior-skillset programmer allowed a Y2K issue to come your way. If you have a 6 digit number, make the assumption that you're in the 2000 century and adjust the number to a include the appropriate ...

Is "30" 1630, 1730, 1830, 1930 or 2030? When a date does not have century information, you have only can guess at a 100-year window. You must have a year picked to be the transition point, in this case check your uvconfig file as you are defaulted to 1930. So, tell me, how would you know if 30-jan-0...

You are probably getting fouled up with the quotes. Experiment and write a script and just execute the script instead of the echo command with redirection.

DSExecute has issues with quotes in the command, it can get messy.

Y2K alert... If LEN(TheDate) = 5 Then Ans=Oconv(Iconv(TheDate, "DYJ"), "D-YMD[4,2,2]") Else If LEN(TheDate) = 6 Then Ans=Oconv(Iconv(TheDate[2,5], "DYJ"), "D-YMD[4,2,2]") Else Ans="" End

Please describe what your job is trying to do. Include stage types, databases involved, etc. If you have any before/after job/stage routine calls, or use any user-written functions.

Believe it. It's a feature that been talked about for years. You have a before and after routine call that a transformer can make. You have @INROWNUM variable to tell you the line number you are on. You have @OUTROWNUM variable to tell you the line number for the output link you care about. But what...

Reverse engineer a .dsx file and normalize the contents