DSXchange

The default value for a date must be a valid date. 0000-00-00 is not a valid date (there is no day zero, there is no month zero and, indeed, there is no year zero - the day before 0001-01-01 is 0001BC-12-31.)

Import from most recent export?

(Why did you mark your job version 7?)

Your routine could be made more efficient, and does not include a full leap year rule (there's also a "divisible by 400" part to the rule).

From .odbc.ini only if the connection type is ODBC and the DSN is recorded in the uvodbc.config file for the project. From tnsnames.ora if the connection type is Oracle and the ORACLE_HOME environment variable value is correctly set. By appropriate database client mechanisms for other connection mod...

You will, however, need to prevent functions in the Transformer stage from receiving NULL as an argument. (Relaxing this restriction is on the road map, maybe even in the next version of Information Server.)

How is the pattern I+ being handled by your rule set?

Just remember, if you're signing a contract at Christmas time, that there's no sanity clause.

Sort your data using a Sort stage and generate a Key Change column. (Better is to use three Sort stages to generate a "last in group" column.) Accumulate the long string in a stage variable, outputting every row (or, if you have it, when "last in group" occurs). Use a Remove Dupl...

You are relying upon an implicit conversion from Decimal to String - do you really need Trim()?

Your date format string specifies seven digits but you only have five. Perhaps your date format string should be "%yy%ddd".

Check out the schema for the database and check whether u can create a dummy value to the database table (from oracle)..if u could nt create the dummy value ..contact u r database admin to provide the privilges to insert the data into the table (probably they could have created the synonym for the ...

U can find the DataStage help because he installed them when he installed his client software and his client connects directly to his server. The second person personal pronoun in English is spelled "you", not "u". If you can open the Web Console then you can access online help. ...

Don't believe it is, when there's only one server involved. Licensing is at the server level, not at the project level.

You could build your own interceptor in each project, but that's not an out-of-the-box solution.

Welcome aboard. 81002 = connection (between client and DataStage server) is broken. This might be because an inactivity timeout triggered, because there was a glitch in the network between the two machines, or because of a failure on the server side, particularly in one of the "agent" proc...

These kinds of words (like "TA" for "trading as") can be classified into a suitable class. That will make the parsing and pattern-action easier to implement. You may need more patterns to handle things like "T/A".

Reinstall the client, and this time choose Documentation as well as Client.