Search found 53125 matches

by ray.wurlod
Tue Jun 30, 2009 10:46 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: create control jobs to get the record count in the target
Replies: 7
Views: 1885

However you like. Simplest is probably a wc -l command on source and target, executed through Execute Command activity in sequence or DSExecute in job control routine.
by ray.wurlod
Tue Jun 30, 2009 10:44 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: job compatibility issues between V7.5.2 and 8.1
Replies: 3
Views: 1505

Slight disagreement with Ernie here. QualityStage is only totally integrated for parallel jobs, and we're in the server forum here. If you want to continue to use QualityStage in server jobs, you must preserve QualityStage version 7.5 and call QualityStage jobs through qsrtmngr from version 8.x serv...
by ray.wurlod
Tue Jun 30, 2009 10:41 pm
Forum: General
Topic: Folder transfer from one server to another server windows
Replies: 5
Views: 2316

Or you could use one of the recursive copy protocols, such as the XCOPY command.
by ray.wurlod
Tue Jun 30, 2009 10:38 pm
Forum: General
Topic: Basic Questions
Replies: 4
Views: 1420

The user-defined stage types are:
  • Build

    Custom

    Wrapped
You have not provided sufficient information for cogent analysis of the problems that might underlie the symptoms you reported in questions 2 and 3.
by ray.wurlod
Tue Jun 30, 2009 10:37 pm
Forum: IBM QualityStage
Topic: QualityStage Job Error
Replies: 12
Views: 12218

... which suggests that the data have changed. Do you still have older data that you can compare?
by ray.wurlod
Tue Jun 30, 2009 6:56 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Strange DataStage problem
Replies: 15
Views: 7921

Verify the internal structure of DS_JOBS, using UVFIXFILE or fixtool (neither running in "fix" mode).

Do the following exist? RT_BP1, RT_CONFIG1, RT_LOG1, RT_STATUS1
by ray.wurlod
Tue Jun 30, 2009 4:52 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Passing Parameter from table
Replies: 16
Views: 4382

There's no need to include a header file if you don't use any of the content of the header file.

Since DSSetUserStatus is a subroutine and is cataloged as DSSetUserStatus then there's no actual need for JOBCONTROL.H.
by ray.wurlod
Tue Jun 30, 2009 4:48 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Null handling for 200 / 300 columns at one go.
Replies: 14
Views: 4159

Research "derivation substitution" here or in the manuals.
by ray.wurlod
Tue Jun 30, 2009 4:43 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Difference between Join and Lookup
Replies: 5
Views: 4387

... but very important subtle differences.
by ray.wurlod
Tue Jun 30, 2009 4:40 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle Enterprise Stage: Converting Blanks to Null
Replies: 3
Views: 1937

Check $APT_STRING_PADCHAR as well.
by ray.wurlod
Tue Jun 30, 2009 4:37 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: not able to create new project
Replies: 27
Views: 8187

Time to involve official support and see if they can repair your UV_SCHEMA table (hashed file) using more "deep" tools; they need someone familiar with UniVerse internals.
by ray.wurlod
Tue Jun 30, 2009 4:34 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DSD.BCIPut call to OCONV failed
Replies: 21
Views: 6378

What NLS map name is being used when extracting from DB2?
Are the data in the DB2 table(s) really encoded using this map?
by ray.wurlod
Tue Jun 30, 2009 4:28 pm
Forum: IBM QualityStage
Topic: QualityStage Job Error
Replies: 12
Views: 12218

If it's fixed length, then any default value must have the same number of characters as the field definition. Thus, for Char(1) - that is, ustring[1] - the default value "" is inappropriate - it must be " ".
by ray.wurlod
Tue Jun 30, 2009 1:10 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Importing Routines.
Replies: 5
Views: 1265

Have you licensed both server and parallel jobs in the new system?

If you have not licensed server jobs, neither server routines nor transforms nor server stage types will be imported.

You've paid for a server license with Enterprise Edition - you may as well use it.
by ray.wurlod
Tue Jun 30, 2009 1:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error invoking Data Stage sequncer calling SFTP script
Replies: 1
Views: 3848

The answer is "no", which a Search would have revealed for you. The answer is also no because there's no way you can invoke a sequencer at all, other than within a job sequence. It's important that you use correct terminology so that your interlocutors can understand unambiguously what you...