DSXchange

Does this PC have less memory than the others? This most common reason for failure of SQLAlloc... functions is that no memory can be allocated.

The lookup keys can be different for each reference input link. However, when there is no ability to specify a Key expression (such as when there is a Lookup File Set feeding the reference input link) then a column that is identically named and typed as the key column must occur in the stream input ...

There are possibly two user IDs involved. One is you, the other is one of dsapi_server or dsapi_slave. This might explain the difference in reported nofiles settings.

Any number of simultaneous queries is permitted by database servers and operating systems. It's when (if) you want to perform updates/writes that locking issues occur.

For less than $1 per week you CAN read all of the premium posts. This money goes only part way towards funding this site. Without funding, it will cease to exist. Do you want that?

I think you need backquotes (`) rather than single quotes (') around the date command.

Ya shouldn'ta tried it on Friday the 13th! For this one you really do need to involve your support provider. We will otherwise waste far too much time seeking to know about your hardware configuration, whether particular environment variables were set, software versions, and so on. Your support prov...

Correct spelling is Ralph Kimball. Bill Inmon has a different perspective.

Do you have the Prepare Report Data check box checked?

So your spirit will be Jamaican rum?

Many lakhs of rows in a single transation? Note from the message that it is coming from the ODBC driver; this means that something relating to the database has run out of memory - probably your enormous transaction.

Make sure that the data are partitioned on the same column in which you're trying to perform the comparisons - they won't work if the previous value is on a different processing node!

Or you could buy a paid engagement to get it working at your site with your particular configurations.

I believe you're missing the NLS Guide (among the documents in the Docs folder). When the external character set is, say, one of the Asian ones, then DataStage uses Unicode internally. NLS character maps exist on the boundaries to map those character sets into Unicode when reading into DataStage, an...

Your support provider can provide. They may know them as "OEM 75 Manuals". There should be no charge. They (the manuals) are also handed out on IBM DataStage EE training classes.