Search found 53125 matches

by ray.wurlod
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.
by ray.wurlod
Sun Nov 28, 2004 2:13 pm
Forum:
Topic: Unable To Login
Replies: 8
Views: 5050

Are you using the same login ID as the one with which you installed MetaStage? If not, can you try that one?
by ray.wurlod
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

Code: Select all

select columnname, count(*)
from filename
group by columnname
having count(*) > 1 ;
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.
by ray.wurlod
Sat Nov 27, 2004 3:52 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Phantom error
Replies: 6
Views: 2655

The message is contained in the original post
Unable to open ODBC trace file
This is highly unlikely to have been generated in a Routine unless that routine was using BCI function calls to connect to a database via ODBC.
by ray.wurlod
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...
by ray.wurlod
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...
by ray.wurlod
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 ...
by ray.wurlod
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

Arun is at a site that has the 5.2 bug where auto-purge isn't propagated into newly-created jobs. Probably the easiest way is to create a routine or script that retrieves the oldest message in the log file and obtains the timestamp from that entry. FUNCTION OldestEntryTimeStamp(JobNo) Ans = ...
by ray.wurlod
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 ...
by ray.wurlod
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...
by ray.wurlod
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 ...
by ray.wurlod
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

Any statement beginning with an asterisk is a comment. Comments do not generate executable code.

The notation [1.0.2] refer to versions of the code as recorded in the history block at the top of the code, which you elected not to re-post. I always mark changes to code in this way.
by ray.wurlod
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...
by ray.wurlod
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 ...