PREVDTD is present only for deleted and not re-created objects.
Doubtless there is somewhere in the XMETA repository where this information is also kept, but I have not yet had the opportunity to analyze where this might be.
Search found 53125 matches
- Thu Oct 30, 2008 9:08 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Missing Folder
- Replies: 3
- Views: 1510
- Thu Oct 30, 2008 9:05 am
- Forum: General
- Topic: export and import job on UNIX
- Replies: 14
- Views: 18599
- Wed Oct 29, 2008 6:36 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Missing Folder
- Replies: 3
- Views: 1510
I don't know for sure whether this will work in version 8, but it's worth trying.
Code: Select all
SELECT INSTANCE, PREVDTD, PREVDELETOR FROM DS_AUDIT WHERE PREVDTD LIKE '2...' AND CLASS = '2';- Wed Oct 29, 2008 3:49 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Log Corrupted
- Replies: 15
- Views: 5197
- Wed Oct 29, 2008 1:55 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Log Corrupted
- Replies: 15
- Views: 5197
Clear or repair the log hashed file. Search here for clues.
- Wed Oct 29, 2008 1:53 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: NLS Language Error 139
- Replies: 2
- Views: 1162
Search for the exact error message, which I would guess is about the NLS_LANG environment variable, but I'm not going to waste my time speculating. Post the exact error message and we'll be able to be more help, assuming that you don't find what you need when you search.
- Wed Oct 29, 2008 1:50 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: ODBC Error connection
- Replies: 8
- Views: 4065
- Wed Oct 29, 2008 9:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need to search a Sequential file for example x.csv in jobs
- Replies: 10
- Views: 2371
Code: Select all
SELECT NAME FMT '32L', CATEGORY FMT '40L' FROM DS_JOBS WHERE JOBNO IN (SELECT OBJIDNO FROM DS_JOBOBJECTS WHERE EVAL "@RECORD" LIKE '%x.csv%');- Wed Oct 29, 2008 9:15 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Teradata Connector Read/Write issue
- Replies: 7
- Views: 7220
- Wed Oct 29, 2008 9:13 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Userid using which the Datastage job is triggered
- Replies: 5
- Views: 1467
- Wed Oct 29, 2008 9:08 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parallel job reports failure (code 141)
- Replies: 2
- Views: 936
- Wed Oct 29, 2008 9:07 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: NLS Problem?
- Replies: 10
- Views: 9503
- Wed Oct 29, 2008 9:05 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: universe database
- Replies: 5
- Views: 1484
There IS a limit with 64-bit hashed files, it's probably more than the operating system file size limit. The theoretical limit is 19 million TB (approximately) but that all has to be on the one file system. Please note also that UniVerse is a separate database product. The DataStage Engine has not b...
- Wed Oct 29, 2008 8:59 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: ODBC access to Progress - transaction handling
- Replies: 3
- Views: 1210
- Wed Oct 29, 2008 8:56 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: ODBC Error connection
- Replies: 8
- Views: 4065