Search found 53125 matches

by ray.wurlod
Thu Dec 01, 2005 10:55 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Ascential Certification
Replies: 9
Views: 4263

Items will have a range of difficulty and be presented as multiple choice, probably with four choices per item. The only feedback given will be whether the choice selected was correct or not. It is envisaged that a typical exam will contain 75 questions and have a time limit of 90 minutes. There was...
by ray.wurlod
Thu Dec 01, 2005 4:12 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Creation of static hashed file runtime
Replies: 8
Views: 3021

You can not do this with a Hashed File stage. Add "-64bit" to a mkdbfile command executed as a before-job or before-stage subroutine. The Hashed File Calculator will give you the correct command syntax, which you can copy via the Edit menu. Or use a UV stage with its DDL edited to include DATA, DICT...
by ray.wurlod
Thu Dec 01, 2005 4:09 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Creating new users for existing projects
Replies: 5
Views: 1406

It is not enough to add the user ID to /etc/group. The information must also be recorded in shadow files, which means you must use the correct utilities (such as useradd) to create the user ID and assign same to groups.
by ray.wurlod
Thu Dec 01, 2005 4:06 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Filtering End of line characters
Replies: 4
Views: 1162

Check out the extended column properties in the Sequential File stage - you scroll right to find them. One of the properties is "contains line terminator".
by ray.wurlod
Thu Dec 01, 2005 4:05 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: SOX Controls on DataStage Access
Replies: 11
Views: 2684

Make it an SEP.

SOX requires that processes must be documented, and then that an audit proves that the processes are followed.

Surely it's the owner's (or the security people's) responsibility to document security access. Then you simply have to follow what they've documented. :wink:
by ray.wurlod
Thu Dec 01, 2005 4:01 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unable to migrate data from unidata to oracle
Replies: 20
Views: 5254

Try creating a synonym for @ID in the UniData file dictionary, maybe called ID, and use that in the UniData stage.
by ray.wurlod
Thu Dec 01, 2005 3:59 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: wht is DRS stage
Replies: 4
Views: 1628

Seems to me you need to work on your employer to get you some training! Shouldn't be too difficult, since your employer is the vendor!
by ray.wurlod
Thu Dec 01, 2005 3:57 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: difference betwwn clear status file and clear log
Replies: 2
Views: 1124

The status (hashed) file records the status of the job, its active stages and its resources.
The log (hashed) file records events logged by the software.
They are independent of each other.
by ray.wurlod
Thu Dec 01, 2005 3:53 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: varying count of delimiter
Replies: 9
Views: 2250

Use the Field function to extract everything up to the first delimiter. Indeed you could probably use the field function for all four output fields, since you've eliminated redundant delimiter characters using Trim(). svTrimmedLine is defined as Trim(InLink.SourceLine, ",", "A") F1 is defined as Fie...
by ray.wurlod
Thu Dec 01, 2005 3:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Running Parallel Job in a Seq
Replies: 1
Views: 846

This error usually means that the job is not compiled, or is not in a runnable state.
by ray.wurlod
Thu Dec 01, 2005 3:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage on UNIX Installation
Replies: 2
Views: 872

The installation guide is a complete and accurate reference. Follow its guidance precisely. All needed scripts are supplied on the media - you will not need to do any script creation. You may - depending on your UNIX - need to modify some kernel parameters. To do this you need administrative (superu...
by ray.wurlod
Thu Dec 01, 2005 3:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SIGSEGV, SIGBUS
Replies: 6
Views: 7214

The UNIX command man signal will inform you about signals. Here are the most common ones. An asterisk indicates that a core image is dumped. Value Description 1 (SIGHUP) hangup 2 (SIGINT) interrupt 3* (SIGQUIT) quit 4* (SIGILL) illegal instruction 5* (SIGTRAP)...
by ray.wurlod
Thu Dec 01, 2005 3:30 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Wrapped stage
Replies: 12
Views: 4588

You don't need to create a before/after subroutine. Use ExecSH, which is supplied with DataStage. I believe that this is sufficiently generic a solution.
by ray.wurlod
Thu Dec 01, 2005 3:28 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to find stage missing in runtime
Replies: 3
Views: 1075

What do you mean by "missing"?
By "run time" do you mean when running on the development environment or in a test or production environment? If the latter, how do you move your jobs from development through test to production?
by ray.wurlod
Thu Dec 01, 2005 3:23 pm
Forum: IBM QualityStage
Topic: QS Deduplication Job taking 2jrs for 34000 records
Replies: 13
Views: 7405

You CAN run the UNIX commands. Get MKS Toolkit or CygWin. You get MKS Toolkit for free with DataStage EE 7.5x2.