Search found 53125 matches

by ray.wurlod
Tue Oct 11, 2005 3:13 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: upgradation from 6 to 7.5
Replies: 3
Views: 855

You hire an experienced, competent consultant. It's safest. Such a consultant will mentor you so that you will acquire the skills for next time.
by ray.wurlod
Tue Oct 11, 2005 3:11 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: hash file
Replies: 6
Views: 1573

Plus you need to lock for updates so that no lost updates will occur to the hashed file.

Did you search for answers to this question? I posted exactly this advice in the past week.
by ray.wurlod
Tue Oct 11, 2005 3:09 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hardware requirements
Replies: 2
Views: 817

In a word, "more".

The vendor publishes recommended and minimum specifications for different platforms. More is better, because - over time - the volume of data you process grows and grows.

In general it is cheaper to over-configure now than to increment later.
by ray.wurlod
Tue Oct 11, 2005 3:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Difference between Sort stage and inline Sort
Replies: 5
Views: 5066

They both sort data if configured correctly. "Performance issue" is, more than anything, a matter of expectations. To determine which completes more quickly you can create jobs that use both methods, but remember to be fair - allow for cache effects (ideally re-boot server between tests), and sort m...
by ray.wurlod
Tue Oct 11, 2005 2:57 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Running DS Jobs from DOS Batchfile
Replies: 6
Views: 2537

I suspect that the problem is not with dsjob itself - which has exactly the same syntax - but with all the other things you can do with a UNIX shell script. BAT files are much more limited. If you have MKS toolkit or cygwin or one of the other UNIX-on-Windows tools, you can continue to use shell scr...
by ray.wurlod
Tue Oct 11, 2005 2:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Creating a dummy dataset using orchadmin
Replies: 4
Views: 3965

Was it created as a read-only routine by Version Control? If so, you can happily overwrite it with Version Control.

Otherwise, do a search here for READONLY (the name of the column in the repository table DS_ROUTINES that you will need to update in the production environment).
by ray.wurlod
Mon Oct 10, 2005 2:57 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DS commands
Replies: 4
Views: 986

DSWaitForFile is a function, not a subroutine, so you would not use Call. Instead, you need a DEFFUN declaration. This is in the JOBCONTROL.H header file, so put at the top of your routine $IFNDEF JOBCONTROL.H $INCLUDE DSINCLUDE JOBCONTROL.H $ENDIF You should be able to find a routine called CommonI...
by ray.wurlod
Mon Oct 10, 2005 2:54 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: downloading data from multiple tables
Replies: 3
Views: 781

Do you need to combine these data in any way? That will radically affect any answer to the question.
by ray.wurlod
Mon Oct 10, 2005 2:53 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: What is new in Hawk release?
Replies: 4
Views: 1211

Hawk still has server jobs (BASIC based), parallel jobs (osh based) and mainframe jobs (COBOL based). As Roy posted, the main thrust of Hawk is the common repository - and better integration (at least according to the marketing folks) - of the whole range of products. There's also an fully customiza...
by ray.wurlod
Mon Oct 10, 2005 2:46 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Country Codes Extraction
Replies: 9
Views: 1720

Summary of Technique In a before-stage routine initialize a string to Str("0",100000) then populate any position in the string with 1 if that position corresponds with a valid country code. For example ValidCodes[966,1] = "1". (You could also do this with a DataStage job that reads the table and ass...
by ray.wurlod
Mon Oct 10, 2005 2:38 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Julian date conversion to yyyy-mm-dd : hh-mm-ss
Replies: 19
Views: 9503

This exact question has been answered in the past.

It's true that Oconv() and Iconv() are not available in parallel jobs, unless you use a BASIC Transformer stage.

Include "century" in your search terms. :wink:
by ray.wurlod
Mon Oct 10, 2005 2:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Creating a dummy dataset using orchadmin
Replies: 4
Views: 3965

Explicitly handle the error in a job sequence. If you explicitly handle the error, then the automatic handling does not kick in.
by ray.wurlod
Mon Oct 10, 2005 2:00 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: dynamic type-30 hash file
Replies: 3
Views: 1335

Use dynamic because the "table space management" is automatic.
by ray.wurlod
Mon Oct 10, 2005 1:59 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Creating a Email script and running it
Replies: 1
Views: 793

Search is your friend. At least two have been posted.
by ray.wurlod
Mon Oct 10, 2005 1:57 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Country Codes Extraction
Replies: 9
Views: 1720

Time zones! I like to sleep occasionally.