DSXchange

Not sure what you are asking here or what you've already been able to glean from searching the relevant DataStage manuals (Parallel Job Developer's Guide and Parallel Job Advanced Developer's Guide). APT_ORCHHOME specifies the location of the parallel execution engine. The parallel execution binarie...

UV is not a user. UV and uv are the names of UniVerse accounts (the UniVerse equivalent of a DataStage project approximately). UniVerse uses operating system login ID as user and operating system password as password. For database fill in the name of an account (project).

There's no such thing as a null in a Sequential File, since a Sequential File does not have true data types. However the parallel Sequential File stage treats the file as if it does have true data types, so you must provide null handling (for example Null Field Value property), because "" is neither...

That is not your requirement, because the number of Mondays in July can vary over the years: it may be four, it may be five. Your actual requirement is to determine the number of Mondays in July of the year mentioned in the date. The solutions above can yield this.

A buffer comprising all the columns defined as "Key" is the basis of comparison.

You have a number of choices. CurrentDate() gives "today". You can put in the date as a literal string, for example StringToDate("2008-11-11"). You can employ a reference to a job parameter in which the date is hard coded.

Not Final Delimiter. This is not the same as Record Delimiter.

Either use the compilation option "automatically handle activities that fail" and make sure that the control stream downstream forces an abort (use a Terminator activity), or use an explicit Failure trigger from the Execute Command activity that forces an abort (for example use a Routine activity th...

OK, when you go into Control Panel/ODBC Administrator to configure the DSN, what values do you put into the Configuration Editor (opened by clicking the Configure button)? Take a look at either of the examples (UV/ODBC Sales Sample or UV/ODBC Service Sample - they are User DSNs) that installed when ...

... and I'd even added that to my Favorites!

Can you see the 0d at the end of this string? That's a Char(10). You have to figure out why it's there in the data and/or why your format specification does not match what's actually in the file. Can you post the record schema associated with this link?

The usual approach to this is either to use a Sort stage within which a Key Change column is generated; immediately the duplicates are identified. Another approach uses a fork-join design in which an Aggregator determines the count of records for each key. the count is joined back to each row having...

Best would be to find an employer who is looking to take on a junior DataStage developer. IBM does not offer a "personal edition" of this particular software.

The only way you will be able to access the DataStage database through an ODBC client is to obtain an ODBC driver for UniVerse. One is available from IBM, others are available from third party providers. But remember that you have been warned that much of the DataStage repository metadata has been d...

Welcome aboard. You have told DataStage that there is no delimiter, but there is a record delimiter. The 0d in the raw string is Char(10), the UNIX line terminator character. That is what is generating the error.