DSXchange

This is not a UniVerse problem per se - it would occur no matter which database you were using. You have not complied with SQL grammar, which specifies that an UPDATE statement must have a WHERE clause. In database stages in DataStage the WHERE clause is generated by marking one or more columns as K...

Please help me out .Its urgent. We don't do "urgent" here. DSXchange is an all-volunteer site whose participants post as and when they can. If you need urgent help sign up for premium service with your support provider, and learn the true cost of urgent. Please help me out. We'd love to help you ou...

Version Control does not support Information Analyzer/ProfileStage.

If on Windows there is on .odbc.ini file; instead the ODBCINI key in the Registry is used (edited with ODBC Administrator). The uvodbc.config file is only for DataStage. Reports are stored in the IADB (Information Analyzer database, formerly PSDB (ProfileStage) or MRDB (MetaRecon)). This requires a ...

Welcome aboard. Just as in SQL there is no such thing as a rejected record when a join is performed. A row is output from the join if the join criteria are satisfied. Nothing else happens.
This is why the Join stage does not have support for a Reject output link.

Why do you need database connection details in a Transformer stage?! This stage type does not connect to databases.

The same way you'd check any environment variable.
executed from any DataStage job.

There's no such thing as non-nullable in the return from a lookup. If the lookup fails and the rule is Continue, then any column from the reference input will be set to null. It follows that any field on the output link that receives one of these columns must also be nullable. Deal with it downstrea...

The usual technique is to preserve them somewhere - perhaps in another queue - until the rows are committed. Search the forum for examples.

Why are you using an ODBC Enterprise stage? There is an issue with the DB2/UDB Enterprise stage when DB2 is on a different platform; this may apply to the ODBC Enterprise stage as well. Try using a DB2 API stage.

You need to create a VOC pointer for SDKSequences hashed file. You may also need to create a file dictionary for SDKSequences. Do this first:
and let us know the outcome.

One function is for Modify stage, the other is for Transformer stage. The chapter in Parallel Job Developer's Guide on Modify stage is incorrect in stating that NullToValue() can be used in Modify stage. Try using double quotes around the default value ("1800-01-01"). What is the default date format...

It's simple supply-and-demand economics. If you have sufficient free resources then the demand for those resources can be satisfied. If you don't they can not.

DS.REINDEX rebuilds indexes only on Repository tables that contain design-time metadata. Unless you are having problems with the Repository there is no need to use this command, as Ken noted. Also, as Ken noted, this command does not repair corrupted hashed files. If you have created indexes on a ha...

How is the NLS_LANG environment variable set?