DSXchange

Either the on-line Help or the DataStage BASIC manual will give you complete descriptions of the Trim() function. You could also use the string_trim() function in a Modify stage.

There are no nulls. What you are seeing is a blank "TYPE". This is an incorrectly (or lazily) stored VOC record. Don't worry about it. Try SELECT "TYPE",COUNT(*) FROM VOC GROUP BY "TYPE"; (TYPE is a reserved word in DataStage/SQL used in the CREATE TABLE statement. That's...

And what are your buffer sizes, particularly the maximum buffer size? These are set by environment variables.

Create a Lookup File Set showing, for each time zone, the offset from GMT (or UTC if you're a purist!), the date daylight saving kicks in and the date daylight saving kicks out. Keep this maintained (up to date). Use a Lookup stage to get the offset, and adjust hours accordingly (convert hours to se...

While it does not matter in DataStage itself you do have to get it right in a number of locations. In SQL, double quotes are used for identifiers and single quotes for string constants. In shell scripts, single quotes are "hard quotes" while double quotes are "soft quotes": some expansions are possi...

As far as I am aware there is no such version as 7.6. Maybe the news hasn't reached this corner of the globe yet.

The next version will be either 8.0 or 8.1 and is a radical re-design. Search for "Hawk" both here and at IBM web site.

You need at least -f -v -s options as well as a specification of where to get a list of things to back up. The solo "-" means "use stdin".

It's done differently in parallel jobs, because there are multiple streams of data being processed: blocking those flows is not permitted and forcing single-threading (to get unique values) is discouraged. Instead, there is a Surrogate Key Generator stage or Column Generator stage that can be used i...

It might be worthwhile re-installing the SybaseOC plug-in stage using the Package Installer on your server.

Do you have Sybase client software installed on your DataStage server? This is absolutely required. As far as Sybase is concerned, a DataStage job is just another client application.

Use output link variables DBMSCODE and LASTERR. LASTERR contains the text.

This is a glitch in the way that View Data works, and the fact that EXAMPLE1 uses a reserved word (DATE) as a column name. Naughty. You should still be able to import the table definition, however, and use it in a job. In the Derivations field in the Columns grid, specify "DATE" rather than DATE.

Your Aggregator stage has exhausted its available memory. While there is a set of tunables for addressing how the Aggregator stage allocates memory, there is still a finite upper limit. Sorting the input by the grouping columns means that some memory can be freed as soon as one of those values chang...

Yes. For each possible alternative the rule set contains the alternative and its corresponding standard form. Thus you can decide what the standard form is to be. You can also impose rule set overrides for particular cases - for example Robn is to be standardized as Robin rather than Robert.

A single-domain field is most easily thought of as a single column. A single column contains a finite number of discrete values - these are its "domain". Arguably the domain is the set of legal values, but that's what data quality is about determining. With Character Concatenate investigation you ca...

System variable @INROWNUM maintains the count of rows on the input link, while each output link maintains its own @OUTROWNUM (on each partition in each case). You could collect these into an extra two columns on each output link, and use downstream Copy stages to split them out, and Aggregator stage...