Search found 53125 matches

by ray.wurlod
Mon Nov 28, 2005 5:30 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: What is the difference between type 1 and type 19 file
Replies: 3
Views: 1085

File types are not actually defined in the VOC file. The VOC file records the name and locations of data and dictionary portions; the file type is an inherent quality of a file, accessible when the file is opened.
by ray.wurlod
Mon Nov 28, 2005 5:27 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Informitica Jobs to DataStage
Replies: 2
Views: 1021

The only reliable tool is the brain, imho.
by ray.wurlod
Mon Nov 28, 2005 5:26 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Help on dsexport
Replies: 40
Views: 15946

The export is done without any problem, But the dsx doesnt contain the job executables. I think we'll just have to agree that such is the current state of the technology. You might like to lodge an enhancement request. It's not a big problem - just means that you will need to re-compile jobs after ...
by ray.wurlod
Mon Nov 28, 2005 5:23 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequencer problem
Replies: 2
Views: 1212

These are in a frame called "compilation options" which is a less-than-subtle hint that you need to re-compile the job sequence after changing these settings.
by ray.wurlod
Mon Nov 28, 2005 5:20 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Compare 76 inbound fields with 76 fields of table
Replies: 7
Views: 2997

If you need to be able to report specific differences, the best approach is to use 74 stage variables. Plus a few more stage variables to assemble the diagnostic message(s).
by ray.wurlod
Mon Nov 28, 2005 5:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: APT_BadAlloc: Heap allocation failed.
Replies: 8
Views: 4650

"Heap" always refers to memory, but it's virtual memory so can be exhausted by running out of spill space (scratch disk resource) or of swap space, depending on what's actually occurring. So I think you are on the right track suspecting memory, but probably need to do some more detective work. There...
by ray.wurlod
Mon Nov 28, 2005 5:15 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Log for Multiple instance
Replies: 14
Views: 3662

Override the default for a particular job by choosing Clear Log from the Job menu in Director and selecting Auto-Purge. This enables the frame at the bottom of the window so that you can override the defaults.
by ray.wurlod
Mon Nov 28, 2005 5:11 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: XML Validation using XSD
Replies: 2
Views: 1138

Welcome aboard. :D

I suspect that this question has nothing to do with DataStage TX (the former Mercator product). Correct me if I'm wrong. Otherwise can you please post this kind of question on the server forum?
by ray.wurlod
Sun Nov 27, 2005 11:00 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DSR_LICENSE GET PROTECT
Replies: 4
Views: 1821

Welcome aboard! :D (Kapiti as in Kapiti coast?) DSR_LICENSE is a "helper subroutine" that retrieves license information for a connected client. GETPROTECT is one of the tasks that it can be given. DSD.UVOpen is a lower-level function that opens a hashed file - in this case probably the hashed file D...
by ray.wurlod
Sun Nov 27, 2005 10:50 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: 'fix_zero' for decimal values
Replies: 5
Views: 6301

Right now I am in an airport lounge and cannot check, but I believe you can read about this in the Orchestrate Operators manual.
by ray.wurlod
Sun Nov 27, 2005 1:53 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: filter records
Replies: 8
Views: 1517

Only if the data are stored in fixed-width format. In that case, you must import or create a table definition in which those widths are recorded. Handling the missing c5 and c6 in the first row will differ depending on whether the job is a server job or a parallel job. The good news is that it can b...
by ray.wurlod
Sat Nov 26, 2005 7:31 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: 'fix_zero' for decimal values
Replies: 5
Views: 6301

Are you doing this function in a Modify stage or in a Transformer stage?

The leading space is for the sign.
by ray.wurlod
Sat Nov 26, 2005 7:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Log for Multiple instance
Replies: 14
Views: 3662

The job log is a table, not a file, and the row has a column that identifies the instance number, so to display just the entries for one instance is a simple WHERE clause. You will find, in Director, separate entries in Status view for each instance. Select one of those and switch to log view from t...
by ray.wurlod
Sat Nov 26, 2005 7:27 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: sequencer--issue
Replies: 2
Views: 2467

Welcome aboard! :D

You stand a better chance of an answer if you post in the correct forum. This one is for DataStage TX, which is not really about sequences.

The answer to your question is Yes.
by ray.wurlod
Sat Nov 26, 2005 12:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Non-pipe (or non-virtual data set) with .v in its name
Replies: 5
Views: 3412

The RT_CONFIGnnn table contains the runtime version of the job design. I suggest you solve that first, as per the other thread. The error that is the subject of this thread may then magically vanish.