Search found 53125 matches

by ray.wurlod
Thu Apr 06, 2006 3:57 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequencer job failing--please help
Replies: 5
Views: 987

Please post the actual command given in the Command activity and any command line arguments supplied to it.
by ray.wurlod
Thu Apr 06, 2006 3:53 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DB2 UDB API Stage
Replies: 17
Views: 4485

DataStage uses the term "phantom" to refer to a background process. All DataStage processes are phantoms. Each directs its output to a file in the &PH& directory. The first part of the file name is the source (DSD.RUN is a server job, DSD.OshMonitor is the parallel job monitor, and so on). T...
by ray.wurlod
Thu Apr 06, 2006 3:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ORACLE ENTERPRISE stage
Replies: 4
Views: 3296

If you've installed Hawk you're part of the beta testing program. You have been given a specific email address for lodging bug reports and the like. Very few here have Hawk, so chances are that answers from us will be sparse at best. We'd appreciate any feedback you get from IBM if it does not breac...
by ray.wurlod
Thu Apr 06, 2006 3:45 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Date Calculation to get the next quarter based on Input Date
Replies: 17
Views: 3841

You CAN use it in PX, via a BASIC Transformer stage.
by ray.wurlod
Thu Apr 06, 2006 3:43 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Getting error in Routine
Replies: 2
Views: 1126

As well as posting formatted code, please also post what the routine is meant to do. Identify line 12 and line 54 (don't forget that the FUNCTION declaration counts as a line) and see if you can spot to what the error messages refer. Find out what the job was doing (that is, the row value) when the ...
by ray.wurlod
Thu Apr 06, 2006 3:36 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to group data and check some constraint
Replies: 9
Views: 2800

Given that I'm fully booked through to the end of June "at my convenience" may be a little long.
Why not play with them? It's a great way to learn. It's how I learn.
by ray.wurlod
Thu Apr 06, 2006 3:31 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Before Routine and parameters passed on the command line
Replies: 10
Views: 2439

You can interrogate the job's parameter values using calls to DSGetParamInfo() using DSJ.ME as the job handle and DSJ.PARAMVALUE as the InfoType argument. Read the online help for DSGetParamInfo() to learn what else you can discover about parameters. As Arnd noted, to set a parameter in the current ...
by ray.wurlod
Thu Apr 06, 2006 3:26 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Regarding oracle enterprise stage
Replies: 8
Views: 3252

Just in case anyone is on Windows, there is a utility shipped with DataStage called uvwalk that performs a similar search task to the find of UNIX. You can, of course, also use the Search capability in Windows Explorer.
by ray.wurlod
Thu Apr 06, 2006 3:22 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: MaKe Subrecord
Replies: 7
Views: 2937

I haven't used Make Subrecord stage, but I definitely can get subrecords out of a Compare stage (7.5.1A and 7.5x2) so the technology exists.
by ray.wurlod
Thu Apr 06, 2006 3:20 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DB2 UDB API Stage
Replies: 17
Views: 4485

A very full &PH& directory can extend the startup time to such an extent that some timeouts begin to come into the picture. The dreaded code -14 (failed to start within one minute) can also occur under this circumstance. Keep your &PH& directories cleaned of old entries.
by ray.wurlod
Thu Apr 06, 2006 3:18 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: vector output
Replies: 1
Views: 857

When you say "the output is showing up" are you referring to a text file or View Data? It is difficult to represent subrecords in text files.

Are you 100% certain that you have vectors available on the input?

How are you specifying the metadata for the subrecords?
by ray.wurlod
Thu Apr 06, 2006 3:09 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Can ProfileStage handle triggers,lobs,user defined data type
Replies: 4
Views: 2952

ProfileStage does not do migrations. The answer to each of your four questions is NO. ProfileStage (formerly MetaRecon) is purely an investigative tool. It tells you what's out there, based purely on the data (though metadata mismatches can be reported). It does not do ETL. You need DataStage (or so...
by ray.wurlod
Thu Apr 06, 2006 12:00 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: vectors
Replies: 4
Views: 877

So?

Code: Select all

Source  --->  MakeVector  -->  MakeVector  --> MakeVector  -->  Target
by ray.wurlod
Wed Apr 05, 2006 11:57 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Cobol data file
Replies: 13
Views: 2927

If you're unfamiliar with COBOL I'm afraid a full explanation would not make any sense. Basically, CFD stands for "COBOL File Definition", which is a file containing metadata - in a particular format - that describe the data in some other, data, file. COBOL uses a concept called "levels" to represen...
by ray.wurlod
Wed Apr 05, 2006 11:53 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequencer
Replies: 14
Views: 4929

You can't set @DATE to anything - it's always the date on which the job started. You can set the job parameter values to any valid value you like. What I was saying is that you could use @DATE to get "today" as an internal format date. It may be easier, depending on how you're invoking the job seque...