Search found 53125 matches
- Mon Nov 29, 2004 4:25 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DataStage Certification
- Replies: 7
- Views: 3340
- Mon Nov 29, 2004 4:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Usage of uv and uvsh commands
- Replies: 4
- Views: 4353
You can find the uv and uvsh commands documented in the UniVerse System Description manual.
Since UniVerse is a database, the tables in it are primarily those that its users create. There are a few "system tables", which you will find mainly documented in the Administering UniVerse manual.
Since UniVerse is a database, the tables in it are primarily those that its users create. There are a few "system tables", which you will find mainly documented in the Administering UniVerse manual.
- Sun Nov 28, 2004 2:13 pm
- Forum:
- Topic: Unable To Login
- Replies: 8
- Views: 5050
- Sat Nov 27, 2004 3:56 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: To capture duplicate rows
- Replies: 7
- Views: 3553
... which is functionally equivalent to SQL
which you could execute, if the source is a file, via the ODBC driver for text files.
There are many other solutions for this particular problem.
Code: Select all
select columnname, count(*)
from filename
group by columnname
having count(*) > 1 ;There are many other solutions for this particular problem.
- Sat Nov 27, 2004 3:52 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Phantom error
- Replies: 6
- Views: 2655
- Sat Nov 27, 2004 3:50 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Error: FailedtoProp:internal error Bad number of subobjects
- Replies: 4
- Views: 810
You need to connect via telnet to your (Windows) server machine, and specify the project that you want to use. When the ">" prompt appears, type DS.TOOLS to invoke the menu. One of the menu options allows you to rebuild the repository indexes. Before using this you should be sure that no-one else is...
- Sat Nov 27, 2004 3:46 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to get job name which log not cleared
- Replies: 7
- Views: 1260
There is another routine in my most recent report for your site which can load the purge settings for existing jobs that don't have them. If no-one else has this routine you can obtain a copy from Rajiv Gupta. Someone at your site could easily adapt these routines to scan through your job logs to fi...
- Fri Nov 26, 2004 3:26 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: To capture duplicate rows
- Replies: 7
- Views: 3553
Show us the initialization and derivation expressions for your stage variables. You should be able to do this fairly easily, given that your data are sorted. svSeenAlready InLink.columnname <= svPrevValue And @INROWNUM <> 1 svPrevValue InLink.columnname The stage variables must be evaluated in that ...
- Fri Nov 26, 2004 3:19 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to get job name which log not cleared
- Replies: 7
- Views: 1260
- Fri Nov 26, 2004 3:04 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Abnormal Termination of Stage
- Replies: 10
- Views: 2892
Your previous description of your job made no mention of three sequential files. If it had, we could probably have resolved the issue more quickly. [To everyone] It is vital that you describe accurately and as completely as possible any error messages and job designs when asked. Otherwise diagnosis ...
- Fri Nov 26, 2004 2:59 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Moving from DataStage Server to Enterprise Edition
- Replies: 6
- Views: 1836
It is possible, with a number of severe restrictions, to use server job components in parallel jobs. Read about these in the Parallel Job Developer's Guide (the size of this manual will give you a strong hint about the learning curve). The two products ARE totally different, with only a small overla...
- Fri Nov 26, 2004 2:52 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Log files of a Datastage Job
- Replies: 21
- Views: 28485
Purge the log files of old entries on a regular basis. Enable auto-purge wherever possible. Create job designs that don't generate warnings or unnecessary informational messages. Periodically (ideally after purging), compress the internal space in the hashed files using the command RESIZE RT_LOGnnn ...
- Fri Nov 26, 2004 2:47 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: query regarding accessing log files and dumping them
- Replies: 3
- Views: 1951
- Fri Nov 26, 2004 2:43 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Req for list of possible values and descrip for Job codes
- Replies: 7
- Views: 4782
You have specified the complete list of server job exit codes, which can be found in DSINCLUDE/JOBCONTROL.H in your project directory. At the moment I do not have access to a machine with Parallel Extender installed, so can only suggest that you check header files in DSINCLUDE and, possibly, the Par...
- Fri Nov 26, 2004 3:36 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: generate Timestamp
- Replies: 13
- Views: 4182
From the HELP. Use the PRECISION statement to control the maximum number of decimal places that are output when the system converts a numeric value from internal binary format to a character string value. PRECISION expression Note that this is a declaration, not an assignment statement. There is no ...