Okay thanks.
I guess there is no other way than to go through all 70 projects in manager....
Victor
Search found 27 matches
- Wed May 28, 2008 12:54 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to find out if a certain stagetype is used in a project
- Replies: 9
- Views: 4585
- Tue May 27, 2008 5:16 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to find out if a certain stagetype is used in a project
- Replies: 9
- Views: 4585
How to find out if a certain stagetype is used in a project
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...
- Thu Jun 08, 2006 3:04 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Abnormal termination as Pivot Detected
- Replies: 3
- Views: 2365
- Mon May 15, 2006 12:17 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: NLS setting for Oracle with AL32UTF8
- Replies: 7
- Views: 6203
Hi all,
Forgot to say that I did solve this with one extra line in dsenv:
Victor
Forgot to say that I did solve this with one extra line in dsenv:
Code: Select all
NLS_LANG=.AL32UTF8; export NLS_LANG
- Mon Feb 27, 2006 2:06 am
- Forum:
- Topic: Analyzing cross-project relationships
- Replies: 3
- Views: 1813
- Mon Feb 20, 2006 5:24 am
- Forum:
- Topic: Analyzing cross-project relationships
- Replies: 3
- Views: 1813
Analyzing cross-project relationships
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...
- Thu Jan 12, 2006 2:56 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: NLS setting for Oracle with AL32UTF8
- Replies: 7
- Views: 6203
Ah, that space...didn't notice that
I actually copypasted the setting from
...which does return the string with that space....
Victor
I actually copypasted the setting from
Code: Select all
SELECT USERENV ('LANGUAGE') FROM DUAL;
Victor
- Wed Jan 11, 2006 3:33 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Multiple tables loaded into single target table
- Replies: 5
- Views: 2862
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...
- Wed Jan 11, 2006 1:44 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: NLS setting for Oracle with AL32UTF8
- Replies: 7
- Views: 6203
- Thu Jan 05, 2006 7:17 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: NLS setting for Oracle with AL32UTF8
- Replies: 7
- Views: 6203
NLS setting for Oracle with AL32UTF8
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
Does somebody know what NLS setting to use in datastage server to access data in an Oracle database in AL32UTF8?
thanks in advance,
Victor
- Thu Aug 25, 2005 12:57 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to check server version
- Replies: 4
- Views: 2770
Thanks to all.
did the trick.
It returns 7.0.1.1
The aboutbox on the client says just 7.0
Victor
Code: Select all
uv - version
It returns 7.0.1.1
The aboutbox on the client says just 7.0
Victor
- Wed Aug 24, 2005 3:46 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to check server version
- Replies: 4
- Views: 2770
How to check server version
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
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
- Mon Apr 25, 2005 3:08 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Multiple recordtypes in a single flatfile
- Replies: 8
- Views: 4207
- Thu Apr 21, 2005 12:06 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Multiple recordtypes in a single flatfile
- Replies: 8
- Views: 4207
- Wed Apr 20, 2005 8:26 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Multiple recordtypes in a single flatfile
- Replies: 8
- Views: 4207
Multiple recordtypes in a single flatfile
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
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