Search found 53125 matches

by ray.wurlod
Thu Apr 01, 2010 4:11 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Lookup on column with variable number of strings
Replies: 32
Views: 5965

I have decided to write a C++ routine for a parallel routine and see if that does the trick. I have no idea on how to start about it. If your knowledge level is zero, hire someone who has the knowledge. Learning C++ is a non-trivial process, particularly if all your programming skills are in proced...
by ray.wurlod
Thu Apr 01, 2010 4:07 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Transformer Compilation error
Replies: 6
Views: 4990

Is your C++ compiler properly licensed?
by ray.wurlod
Thu Apr 01, 2010 4:04 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle Connection Error: TNS:Connect timeout occurred
Replies: 3
Views: 3390

Check that DataStage is using precisely the same TNS name as your sqlplus connection. Does the sqlplus connection also seem slow, but gets there? As far as I am aware, sqlplus can wait indefinitely for the connection to be made, while DataStage abandons the attempt after a timeout period (60 seconds...
by ray.wurlod
Thu Apr 01, 2010 4:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Download Director Failed to load
Replies: 1
Views: 5496

You need to enable the running of Java scripts for your browser.
by ray.wurlod
Thu Apr 01, 2010 4:00 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Projects are not visible through dsjob -lprojects
Replies: 20
Views: 6912

Are you on the correct server when you issue the dsjobs -lprojects command?
by ray.wurlod
Thu Apr 01, 2010 3:58 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage v8.2 - when is the release date?
Replies: 5
Views: 2937

Gleaned from the roadmap session at IOD 2009: (a) in (the first half of?) 2010, but it may not be called 8.2 (it might be 8.5) (b) links from ISM to ClearCase and CVS are in the plan for this version Links to other source code control tools are to be possible through an API or an Eclipse plug-in. Th...
by ray.wurlod
Thu Apr 01, 2010 3:54 pm
Forum: General
Topic: DS7 vs DS8 and dsexport vs dscmdexport
Replies: 11
Views: 10396

All syntax is to be found in the manuals.

You can also type the command alone or with a --HELP option (in most cases) to get a usage summary.
by ray.wurlod
Thu Apr 01, 2010 3:52 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Round Robin collection
Replies: 5
Views: 1761

It would if running sequentially, but I meant to use the collector in a Sequential File stage. You don't really need the Funnel - which keeps each partition of data separate.

As they teach in the DataStage Essentials class, a Funnel is not the same as a collector.
by ray.wurlod
Thu Apr 01, 2010 3:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How To Give Read Only Access for Datastage Job
Replies: 8
Views: 8078

You can only revoke the DataStage Administrator role in the Web Console for Information Server. Until you do so that user will have full access to anything in the project. And to do that you need to be an Information Server Suite Administrator.
by ray.wurlod
Thu Apr 01, 2010 3:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Performance in Left Outer Join
Replies: 9
Views: 2612

Agreed. 50MiB at least, 100MiB if you can afford it.
by ray.wurlod
Thu Apr 01, 2010 3:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage Derivations
Replies: 2
Views: 1860

Welcome aboard. You could create a script that loops through the output of dsjob -ljobs for the project and, for each, uses dsjob to generate the job report. Sure this contains more information than the derivations but, at least, they're in there. If you generate an XML format report you can use any...
by ray.wurlod
Thu Apr 01, 2010 3:40 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Loop Implementation
Replies: 12
Views: 4191

Looks like you need to source a Cartesian product of A and B.

How is Status determined?
by ray.wurlod
Thu Apr 01, 2010 3:34 pm
Forum: General
Topic: convert date from "03-NOV-2008" to "2008-11-0
Replies: 1
Views: 1323

Oconv(Iconv(InLink.TheDMYDate, "DDMY"), "D-YMD[4,2,2]") The Iconv() function converts the incoming date to internal format, provided its elements are in day, month, year order. The Oconv() function converts that internal format into the desired external format, explicitly specif...
by ray.wurlod
Thu Apr 01, 2010 3:32 pm
Forum: General
Topic: FTP Complex file from one unix server to another
Replies: 10
Views: 3995

You can carry out these checks in the "telnet command" executed prior to the transfer.
by ray.wurlod
Thu Apr 01, 2010 3:30 pm
Forum: IBM QualityStage
Topic: How to hande addresses with Puerto Rican token
Replies: 10
Views: 4800

Not really, but a user override (or two) may be easier than removing anything from the classification table.