DSXchange

Okay thanks.
I guess there is no other way than to go through all 70 projects in manager....

Victor

Hi all, I am working at a quite large site: we have 70 datastage projects. And for some reason you really don't want to know :wink: I need to find out in which of the 70 projects the Oracle Bulkloader (OraOCIBLK) is used. I know that I can manually browse each project, and each of our 5000 datastage...

Hello everybody,

I am facing this exact problem as described in this old post.
Anyone who knows what could be the problem?
I am running DS 7.01

thanks in advance,

Victor

Hi all,

Forgot to say that I did solve this with one extra line in dsenv: Victor

The biggest problem is that a tables relationships within a project are overwritten if you import another project that uses the same table....

Victor

Hi all, I am looking for experiences with the usage of Metastage in situations where datastage jobs are built in several separate datastage-projects. We are building and maintaining a quite large DWH-environment where we have set up a large number of smaller projects to cope with the complexity of o...

Ah, that space...didn't notice that
I actually copypasted the setting from ...which does return the string with that space....

Victor

I would do most of this in Oracle. In a single query you can get rid of duplicate records, and create a single table based on the key column, like: select * from (select distinct <columns> from a) a, (select distinct <columns> from b) b, (select distinct <columns> from c) c where a.key = b.key and a...

Yes, I meant
DUTCH_THE NETHERLANDS.AL32UTF8
(what space?)
And yes: NLS is installed.

Victor

Hi all,

Does somebody know what NLS setting to use in datastage server to access data in an Oracle database in AL32UTF8?

thanks in advance,

Victor

Thanks to all. did the trick.
It returns 7.0.1.1
The aboutbox on the client says just 7.0

Victor

Hi all,

How can I check the exact version of datastage server.
In administrator it just says '7.0', while I would like to know if I am running 7.01 or 7.01r1 or ....
Is there some command that returns the correct version?

Victor

Thanks for all the help!
The solution with a pipe runs smooth.

Victor

Yes, I do have a recordtype indicator.
The trouble is that when I split the file in a Transformer, I cannot use the sequentialfile-definition to read the record into columns, but am forced to use lots of substrings [,] to read the record.....

Victor

Hi all,

I have a sequentialfile as input that has two recordtypes.
The two recordtypes are of a completly different layout.
I have a table definition for both recordtypes. Can I use those to write the contents of the file to two database tables?

thanks in advance,

Victor