DSXchange

ray.wurlod

Just accept it. With NLS enabled Oracle reports that it uses three bytes per character (and, indeed, mostly does). DataStage's NLS map translates that into DataStage's internal UTF mapping (variable number of bytes per character) when reading, and back again when writing. It all works OK. Don't worr...

ray.wurlod

There are no new stage types compared to 7.5. Why would there be? There are new versions of some (stage types are versioned independently of the base product). There are some new items of functionality, such as parameter sets. The main reason to upgrade from 8.0 to 8.1 is that there are fewer bugs i...

ray.wurlod

How many columns are actually defined on that link?

ray.wurlod

The IVVM.LIC file should be somewhere in the branded_odbc directory. Check whether anyone at your site has (re)moved it. The drivers are authorized for use with DataStage stages, and should not expire under these circumstances. If you attempt to use them from other clients or code, then they do expi...

ray.wurlod

Search.

This exact topic has been posted before.

ray.wurlod

Please run the exact query that I specified. There should be four records reported.

ray.wurlod

You have marked the thread as Resolved. Please make a post indicating HOW it was resolved.

ray.wurlod

What happens if you use a job parameter that is NOT an environment variable?

ray.wurlod

Get a premium membership and read the rest of my response.

ray.wurlod

Please be more careful with spelling ("please" rather than "plz" and "give" rather than "giv"). We like to maintain a professional standard of written English on DSXchange, not least because it is easier for those who do not have English as their first langua...

ray.wurlod

Try the following query to determine whether the stage types are installed in the project. It will return rows if they are, and no rows if they are not.

Code: Select all

SELECT * FROM DS_STAGETYPES WHERE EVAL "UPCASE(@ID)" LIKE '%TERA%' OR EVAL "UPCASE(@ID)" LIKE '%ML%';

ray.wurlod

I did.

ray.wurlod

I did.

ray.wurlod

I couldn't get that to work either. But if you create the I-type in the file dictionary of DS_AUDIT and use that, it's all good. SELECT MOD_DATE, COUNT(*) FROM UNNEST DS_AUDIT ON MODS GROUP BY MOD_DATE; To get the I-type into the file dictionary and functional you need two commands - one is SQL (wit...

ray.wurlod

I couldn't get that to work either. But if you create the I-type in the file dictionary of DS_AUDIT and use that, it's all good. SELECT MOD_DATE, COUNT(*) FROM UNNEST DS_AUDIT ON MODS GROUP BY MOD_DATE; To get the I-type into the file dictionary and functional you need two commands - one is SQL (wit...

Search found 53125 matches