DSXchange

As supplied the routine works with integers. Most join columns in star schemas use integer as their data type, so this is a reasonable approach. If you want larger values than MAXINT (2,147,483,647) then you will need to adapt the routine. To avoid losing precision, make sure that your new routine i...

It's possible but messy; you need to process the entire string a character at a time keeping track of whether or not you're inside a quoted string, generating "clean" output. You can do this with sed or awk or C or DataStage BASIC or Perl or whatever else takes your fancy. For quotes within quotes y...

LASTERR is "the error text returned by the driver or database server".
Blame Bill Gates.

VC must bring components to the client; it's capable of promoting between UNIX-based and Windows-based DataStage servers.

"Add more memory" is a valid response to a "running out of memory" symptom.
Sometimes hardware solutions are the easiest to implement, especially if you've tweaked everything else.

Have you successfully installed all the pieces? Did you perhaps install in a non-default location (that is, not in C:\Ascential)?

Interesting!

My present site is running 7.1 on AIX, and libuciwrapper.so, ucirpc_clt.o and the UCI SDK are all present. I guess the calls to them have been removed.

$echo is a reference to a shell variable. Perhaps that shell variable is not defined, or has "" assigned to it? This would be a "do nothing" command with no output.

Try it without the $ character at the beginning.

Can't find any such reference in the 7.1 readme. Where do you think you saw it? BCI is outbound, UCI is inbound. So if DataStage (the client) uses BCI functions to connect to a UniVerse data source (the database server), it's the UCI on the UniVerse server that would service the request. It would no...

You have a stage that is connected to the database into which you're trying to load the data. It might be an ODBC stage, an OLEDB stage, a DRS stage, or a database-specific stage. On the Inputs link for that stage, there will be a property called something like "update action" containing a drop-down...

No. There is no join path. The log files contain the decoded text in the MSG.TEXT column. This text contains parameter markers. Values with which these parameter markers are replaced are stored in the multi-valued column MSG.ARGS . You can see the text with parameters replaced by selecting the virtu...

Just set the method to "update" on the second run.

Here's a reply from the guy who actually ran the Profile Stage analyses at my current site. Hope it's useful. I'm not sure how useful this information is going to be because, as you pointed out, there are many factors that affect the processing time. Probably the most relevant example that I can rec...

The link variable LASTERR returns the error text.

Beware that, with all Microsoft databases, it tends to be verbose so, if you're wanting to capture it into a table, make sure the column's a wide one!

New in 7.1.

If you go to 7.5 you also get LoopStart and LoopEnd activities.