Search found 53125 matches

by ray.wurlod
Mon Aug 28, 2006 3:31 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: XML Stage
Replies: 3
Views: 1176

Welcome aboard. :D

It seems this question is "flavor of the month".

But none of the experts would assay such an approach. There's a perfectly good GUI tool for effecting modifications; it's called DataStage Designer.
by ray.wurlod
Mon Aug 28, 2006 3:30 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: xml input stage
Replies: 10
Views: 2648

Yes. Stop trying to process metadata with a data processing tool.
by ray.wurlod
Mon Aug 28, 2006 3:29 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: the way to import and export XML file
Replies: 5
Views: 1377

Re: the way to import and export XML file

Hi... I want to export a job in an XML format . And then i want to get each and every property of the job (including meta data information) used in the job in XML inputstage.. After that i want to send it to XML output stage with some modifications. in the transformer stage. when i import the chang...
by ray.wurlod
Mon Aug 28, 2006 3:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Getting UNIX Signal KILL....
Replies: 7
Views: 2112

Your UNIX administrator will be able to tell you whether that is a device that you are not supposed to be using, or part of the file system. To me the name "fstst" suggests "file system test" which in turn suggests that you may not be supposed to be there.
by ray.wurlod
Mon Aug 28, 2006 3:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: U_TRUNCATED_CHAR_FOUND encountered
Replies: 4
Views: 2592

Welcome aboard. :D

This message is being generated by/in the ABAP code. Enlist the help of your SAP R/3 administrators to trace and track what might be causing it.

I presume that you have the GB18030 NLS map built and installed for DataStage.
by ray.wurlod
Mon Aug 28, 2006 3:18 am
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: Problems with RTI
Replies: 7
Views: 5971

I am not certain that you need to use the RTI components for DataStage TX, which is what you appear to be doing. If I understand correctly, the RTI components allow you to expose server or parallel jobs as services, thereby implementing a service-oriented architecture. May I suggest posting the same...
by ray.wurlod
Sun Aug 27, 2006 11:27 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Lookup on Dates columns is Failing
Replies: 5
Views: 1520

Also read the documentation for the DateGeneric... functions in the SDK. The SDK "generic" timestamp lacks delimiters in the date portion - it would not be accepted directly for ODBC. ODBC standards differentiate between date, time and timestamp; if you are loading a timestamp it must have compilant...
by ray.wurlod
Sun Aug 27, 2006 11:24 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Fetching records from a Db2 API Stage
Replies: 5
Views: 1326

No. But it does mean that it has something to do with execution of the join query.

Get your DBA to put a trace on the query and see whether it is being assisted by indexes, etc. If this is a regular requirement there may be scope to index the joining columns.
by ray.wurlod
Sun Aug 27, 2006 11:22 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Invalid UsreID/Password when login DataStage Client
Replies: 9
Views: 5831

It's a strange artifact with Windows XP; even though you're using loopback (127.0.0.1), the operating system still requires that the network card be active for TCP activities to succeed. All you have to do is be connected in a network that can serve an address - even though you're not using it! (All...
by ray.wurlod
Sun Aug 27, 2006 11:17 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage Enterprise Edition Certification [ Test 415 ]
Replies: 9
Views: 2493

IBM is offering a one day certification preparation class (US$300) on the registration day at Information on Demand. If you're going this might prove fruitful.
by ray.wurlod
Sun Aug 27, 2006 11:16 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Trapping Oracle error message
Replies: 8
Views: 1953

My bad. External_Filter_113 was the name of your External Filter stage. (Do you really have than many stages in a job?!!) Exit status 255 is fairly meaningless. Please describe precisely how you set up the External Filter stage - what you mean by "a sequential file" doesn't make much sense. The outp...
by ray.wurlod
Sun Aug 27, 2006 5:01 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Date format problem
Replies: 17
Views: 5644

The error message mentioned "convert to timestamp".
by ray.wurlod
Sun Aug 27, 2006 4:59 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Stop Datastage Job
Replies: 4
Views: 1947

Sage words. Heed them.
by ray.wurlod
Sun Aug 27, 2006 4:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Getting UNIX Signal KILL....
Replies: 7
Views: 2112

Technically, of course, every UNIX signal can be generated by a kill command. In this case a process has - as you noted - been forcefully terminated with a SIGKILL signal (kill -9). Yes, the Lookup stage does use scratch space if it needs to. The Lookup stage in normal mode is (generates) a composit...
by ray.wurlod
Sun Aug 27, 2006 4:53 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage Enterprise Edition Certification [ Test 415 ]
Replies: 9
Views: 2493

The only way you can get that is by attempting the exam itself. You can attempt the exam not more than twice in a month and not more than three times in 90 days. You are not permitted to take notes (other than mental notes) during the exam. There is no guarantee that you will get the same questions ...