DSXchange

Changing the absolute path of your DataStage directory is not practicable after installation; you need to change several internal settings, few of which are documented. Your only recourse if you need to change the path is to de-install and then re-install. Luckily, in UNIX you have the 'ln' command ...

What happens if you remove the unicode extended attribute setting? Are you 100% certain that you have unicode data coming in?

What does the director log show for the runtime value of NLS_LANG (no dollar sign prefix)?

The MOD function uses integer divisors and returns an integer value.

A very odd problem indeed - are you 100% certain that your job uses the Oracle userid 'NSO_REF' - if passed as a parameter then check the runtime values in the director log. Everything else looks perfectly OK. Perhaps you could try to create your own dummy table and see if you can connect to that on...

Problem 1. You have a field defined in the output link of your shared container which does not exist in your main job. Field names need to be identical. This means that your "SAR_SPEC_USE_1" field isn't defined in the link coming out of the shared container stage. Problem 2. You have the ...

<sigh> Since the characters are undefined in UTF-8 you cannot resolve the issue. Those two characters are not UTF-8 and that is why you are getting your error message. Perhaps your source file is another character set. What glyphs are those characters supposed to represent? Could you have an ISO-885...

Write a test job where you use the sort stage but actually sort the data and write to a sequential file, then compare your original with the sorted data and you'll see the difference.

Very strange, I would have bet that you would have gotten an error message. Could you do the same select on: DBA_EXTENTS DBA_DATA_FILES DBA_TAB_PARTITONS DBA_TAB_SUBPARTITONS DBA_OBJECTS ALL_PART_INDEXES ALL_PART_TABLES ALL_INDEXES This will ensure that all necessary grants are actually working. Als...

I've marked the previous posts as non-premium, just this once since the information is available elsewhere.

Page 164 of the [u][i]BASIC Programmers Guide[/i][/u] details what you want to know. The R format is right-justified. the % shows zeroes. I can't check now, but I think the format clause is wrong, the length (8) should be first. i.e. '8%R'

Did the SELECT work?

The grants are given to a user (or role). Try logging into Oracle using your favorite tool (sql developer, TOAD, or the like) and the user that you are using from DataStage. Then do a 'SELECT COUNT(*) FROM sys.dba_tab_partitions;'. What happens?

Did you ensure that all of the access grants were given: CREATE ROLE DSXE; GRANT SELECT on sys.dba_extents to DSXE; GRANT SELECT on sys.dba_data_files to DSXE; GRANT SELECT on sys.dba_tab_partitions to DSXE; GRANT SELECT on sys.dba_tab_subpartitions to DSXE; GRANT SELECT on sys.dba_objects to DSXE; ...

If you don't get a response from your sysadm, please post your platform and someone here will know the command to execute to find out your settings. All UNIXes are unfortunately not alike.