Search found 53125 matches

by ray.wurlod
Wed Jun 28, 2006 4:09 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: client components
Replies: 5
Views: 1117

Have you loaded the DataStage patch for XP sp2 ?
by ray.wurlod
Wed Jun 28, 2006 4:07 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: 10 Table Move
Replies: 7
Views: 1698

I'd also recommend a separate pair of jobs for each, with an intermediate staging area using text files. These text files can be the data files for the DB2 bulk loader if required. You can start as many of these jobs simultaneously as the system's capacity can bear. Try not to overload the machine, ...
by ray.wurlod
Wed Jun 28, 2006 4:03 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: X-Stages in ETL cycle
Replies: 8
Views: 2963

The third-last paragraph in the previous post describes MetaStage without actually naming it.
by ray.wurlod
Wed Jun 28, 2006 4:01 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Concatination Problem for Tab delimited file
Replies: 9
Views: 3598

You can not sensibly perform comparisons with @NULL (the unknown value); the answer can only be "don't know". I have an object in each of my hands. Please answer the following questions. 1. Are they the same? 2. Are they different? 3. Which one is larger? See what I mean? Use the IsNull() function t...
by ray.wurlod
Wed Jun 28, 2006 3:55 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Moving Persisted Hashed Files from Windows to Unix(AIX)
Replies: 5
Views: 1297

There is a utility called format.conv (or fnuxi - a synonym) that has -import and -export (and other) options for performing exactly this task. Initial information can be obtained by executing the command HELP FORMAT.CONV from a dssh prompt on the server; full information exists only in UniVerse man...
by ray.wurlod
Wed Jun 28, 2006 3:48 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: script to delete jobs
Replies: 21
Views: 4053

Let's await rtan's answer to the "why" question. Sure it can be done by hacking the Repository tables (not sure yet how to do this via the Metadata Delivery Service in Hawk, though). But this is definitely a high risk "solution" in inexperienced hands. What if the wrong piece is accidentally deleted...
by ray.wurlod
Wed Jun 28, 2006 3:41 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: read metedata of DS
Replies: 12
Views: 2749

The HTML generated by Generate Report. There is an option for preserving this when executed from the Designer client; presumably this maps to a command option.
by ray.wurlod
Wed Jun 28, 2006 3:39 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Abnormal termination of stage
Replies: 8
Views: 5273

What kind of stage is it, and to what kinds of stages does it connect?

Without that information your question is in the "my car doesn't work, what's wrong with it?" category.
by ray.wurlod
Wed Jun 28, 2006 3:38 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Date Conversion
Replies: 16
Views: 4057

DateFromTimestamp() and TimeFromTimestamp() functions seem to be the obvious candidates. You will need a format string if your timestamp does not correspond to your project's default format.
by ray.wurlod
Wed Jun 28, 2006 3:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Broadcasting Adminstrator messages to client GUI.
Replies: 2
Views: 664

Yes, but it's not DataStage functionality. Probably the easiest way is to create a small message box app that you can run on other computers via the AT command. You can determine which clients are connected by capturing the output of LIST.READU or SELECT * FROM DS_LICENSE; on the server machine.
by ray.wurlod
Wed Jun 28, 2006 3:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error in Join stage
Replies: 7
Views: 4361

Ignoring the warning for a moment, is the job otherwise working successfully?
by ray.wurlod
Wed Jun 28, 2006 1:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Parallel Routine
Replies: 4
Views: 1064

You can't, only the moderator can. Either wait a day or two until he has done so, or begin a new thread there and close this one (just a message noting that the thread is closed will suffice).
by ray.wurlod
Wed Jun 28, 2006 1:18 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Links are missing in the DataStage Job
Replies: 3
Views: 790

Moderator: please remove duplicate post
by ray.wurlod
Wed Jun 28, 2006 1:17 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Links are missing in the DataStage Job
Replies: 5
Views: 1687

Sounds like the objects in which the design are stored were not saved properly. Without specialist knowledge this will be extremely difficult to repair; it may be impossible to repair.

Do you have the job design exported (best) or backed up (second best)?