DSXchange

Kim - Many thanks for picking my post. As per suggested, I've created an alias with a Q-pointers in VOC using TCL and now I can access both DsJobs and DsJobObjects tables. dsadm> cd $DSHOME dsadm> . ./dsenv dsadm> ./bin/uvsh DataStage Command Language 8.1 Licensed Materials - Property of IBM (c) Cop...

Hi - Data Architect is an Eclipse based GUI which you need to install to the client machine and hook up it to your repository and data sources to build Data Model. And then InfoSphere Rapid Generator for SAP Applications is a wizard that generates DataStage jobs that extract and load data from and t...

Hi there, Following the rule of thumb "Never re-invent the wheel unnecessarily" I am using Kim's ETL Stats package to gather job run details. @Kim Duke thanks for sharing the ETL Stats package in the past. Found ETL Stats (EtlStats_20060704) in my personal datastage archive. Wanted to re-u...

Hi there - have a look at this APAR..

JR49593: INFORMATION SERVER 9.1 PARALLEL JOBS HAVE LONG STARTUP TIMES DURING SCHEMA SETUP

Hope it helps..

Alternatively, Re: Extract an embedded pdf file from xml 1) load the xml files into db 2) extract the clob data from xml and store them in a clob 3) convert the clob data from base64 to binary and store result in blob 4) write the blob data to o/s file using UTL_FILE writing in raw mode 5) use java,...

Hi - After pulling out PDF document from XML, then you may to convert the file to text using one of PDF2TEXT and then read the text and filter the content as you like.

Hope this will help you out in high level.

Regards,
Ozgur

Hi - It sounds like it is only presentation issue (since the right codepage is chosen) If I were you, on my textpad (v7.4.0) editor after I open the file I would have right-clicked and double-checked the properties of the doc at the document tab and verified that code set is correct. In addition to ...

@Ray - Thanks very much. Folks - I reckon I found an easy way to identify the name of the job just by looking at the local handlers' file (RT_SCNNNN/Local.msh). Apperantly there is an "example of message text" recorded once you save the local handler file. http://i50.tinypic.com/2dlus5s.pn...

Hi all, I know that I can go through Director logs for a particular job to see any message handler is invoked or not. Yet, I have over 200 jobs in a project. It would be tiresome exercise to finalize list of jobs using local handler. Besides, I know that local handlers are also residing in the proje...