DSXchange

Try connecting to another machine so that your network card is active. Only a physical connection is required; you don't need to have any remote disks mounted or anything.

Which Sunday date(s) are you seeking to generate? Try rewriting your specification so it's a bit clearer. For example, you might want to generate one row containing the date of the Sunday prior to the Wednesday start date. That one's easy - convert to Julian and subtract 4, then convert back. Or do ...

You have not actually asked a question. What it is you want to know? Whether your design is sound? How to convert hexadecimal data?

It's not currently possible, and highly unlikely to be possible in the next release. DataStage is not intended to work with dynamic metadata. A search of the forum will uncover at least one technique for tricking DataStage into doing so, but it's not possible "out of the box". RCP is not possible in...

Data Set utility is for managing Data Sets, which are stored in internal (binary) format. It is not for managing File Sets. File Sets are stored in external (human readable) format. Look first in the control file (*.fs) to determine the locations of the data files making up the File Set, then view t...

You need first to import the external function definition, using the Manager client.

That's been some testimonial!

It's not static in the sense of a static variable in C. It's static in the sense that it does not perform automatic space management. Dynamic hashed files do automatically grow and shrink in response to the total volume of data to be stored. Dynamic (type 30) hashed files are the default because the...

Welcome aboard! :D

I'm not aware of any environment variable that can help, but what you can do is to switch to user-defined SQL. In this you can employ the non-standard Informix INTERVAL phrases.

I fear that you're going to have to complete the uninstall manually, including removing the Registry entries using regedt32.

It does, but only for members on the Inner Circle group (self-employed contractors). Dennis suggested a resource for self-employed contractors that might develop into a (paid) premium site.

<hope>Surely IBM already had enough lawyers and didn't need Ascential's? </hope>

IF you create them under the User Defined area you will be able to see them!

It may also be the case that you're trying to get more data into the hashed file than formerly. That becomes the more likely explanation if you find that the cache sizes have not been changed.

They (DataStage environment variables) are visible in the Administrator client. Therefore, they are mentioned in the Administration manual. However, no list can be "complete" that is customizable. DSJobName is a DataStage macro, not an environment variable. There are also system variables (having na...