Search found 53125 matches

by ray.wurlod
Fri Nov 11, 2005 9:52 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Loading Extra Rows in target table than source
Replies: 7
Views: 1490

N nullable VarChar columns would do it.
by ray.wurlod
Fri Nov 11, 2005 9:27 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: uv command to create ds project
Replies: 27
Views: 11697

That's another phase. There are many verbs (references to routines) that have to be cataloged. Do you wish to proceed with this? Get into another, "proper", account and execute the LISTV command. That shows all the verbs in the VOC file. Then switch to your newly-created project and LISTV again. A s...
by ray.wurlod
Fri Nov 11, 2005 9:17 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Loading Extra Rows in target table than source
Replies: 7
Views: 1490

Another possibility. The Sequential File contains line termination characters within data and - you have to have extreme luck here - both portions of that line generated valid records.
by ray.wurlod
Fri Nov 11, 2005 9:13 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Can a single project have server and enterprise jobs
Replies: 3
Views: 822

The vendor does not currently provide any tool for migrating server jobs to become parallel jobs.

As noted elsewhere, the only tool for that task is to be found between the keyboard and the chair.
by ray.wurlod
Fri Nov 11, 2005 9:10 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DSJob command giving error
Replies: 2
Views: 1257

Is "ABC" (all upper case) a project name? Does it show up in dsjob -lprojects?

Try using the authentication options -host, -user and -password.
by ray.wurlod
Fri Nov 11, 2005 9:05 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error writing to Teradata Enterprise Stage
Replies: 11
Views: 6431

Software Development LifeCycle

    UAT fails.
    Job goes back to developers.
    Structural changes are possible (necessary?).
by ray.wurlod
Fri Nov 11, 2005 8:58 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Update existing rows only
Replies: 4
Views: 1097

Are you using the Oracle Enterprise stage?
by ray.wurlod
Fri Nov 11, 2005 8:56 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Error loading Metadata.
Replies: 9
Views: 7073

Curious. I would have expected "unable to resolve service name" if someone had trashed tnsnames.ora. We live and learn. ProfileStage has its own handler, which intercepts the message generated by the Oracle client. The good news is that that fact is now posted here and can be found via the Search fa...
by ray.wurlod
Fri Nov 11, 2005 3:22 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: warning while using join stage
Replies: 2
Views: 1151

The Join stage requires input to be sorted on join key(s). You have an upstream sort that does not sort on the join keys, or violates the requirements of the Join stage in some other way. You have to figure it out. Inspecting the OSH is a good starting point.
by ray.wurlod
Fri Nov 11, 2005 3:20 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Update existing rows only
Replies: 4
Views: 1097

Once you've chosen upsert, there is another property (Upsert Method, from memory) where you can choose update existing rows only and other possibilities.
by ray.wurlod
Fri Nov 11, 2005 3:19 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Orchestrate
Replies: 3
Views: 1058

You also get them on the student CD when you attend Ascential/IBM training classes in EE.
by ray.wurlod
Fri Nov 11, 2005 3:11 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: What is mutex_lock()
Replies: 2
Views: 1010

You already have a thread open with this question. Please don't double-post - it thwarts the efficacy of the Search engine.

Have you asked your support provider? What did they say?
by ray.wurlod
Fri Nov 11, 2005 3:11 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: What is mutex_lock()
Replies: 2
Views: 1010

You already have a thread open with this question. Please don't double-post - it thwarts the efficacy of the Search engine.
by ray.wurlod
Fri Nov 11, 2005 3:09 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to implement between logic
Replies: 1
Views: 760

That's the whole point - you don't need the min and max as keys because you have already pre-selected for those.
by ray.wurlod
Fri Nov 11, 2005 6:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Generating Multiple rows in output from single row in input
Replies: 16
Views: 4276

How do you feel about a row with 10003 columns? The last 10000 will have very similar derivations: If x > F1 Then @NULL Else x (for x running from 1 to 10000). Not pretty, I think the custom stage is for you.