Search found 53125 matches

by ray.wurlod
Thu Sep 15, 2005 7:58 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: dsenginge won't start
Replies: 5
Views: 1665

Be specific about the error message. Is it that you can't connect (which your text suggests) or that DSEngine won't start (as you specify in your subject)? What diagnostic steps have you taken? Can you telnet to the server machine? Is the dsrpcd process running? Can you connect to another project? C...
by ray.wurlod
Thu Sep 15, 2005 7:55 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: difference stage
Replies: 5
Views: 1722

Have you read Chapter 33 of the Parallel Job Developer's Guide, which describes this stage type? If so, which parts of that weren't clear?
by ray.wurlod
Thu Sep 15, 2005 4:33 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Can't Telnet to D/S server
Replies: 4
Views: 1393

There can be only one service bound to port 23.
For those on 7.5x2 there is also the MKS telnet service with which you need to contend.
by ray.wurlod
Thu Sep 15, 2005 4:32 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Counting the number of records.
Replies: 3
Views: 1202

ReturnValue is the exit status of the command - you don't need to parse the output.
by ray.wurlod
Thu Sep 15, 2005 4:31 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Converting Numbers to Alphabates
Replies: 6
Views: 1248

Dynamic array manipulation?

Code: Select all

Convert(@FM,"",Chars(Adds(Fold(TheString,2),REUSE(64)))
by ray.wurlod
Thu Sep 15, 2005 4:28 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: COnversion
Replies: 5
Views: 1469

Code: Select all

Fmt(Abs(Iconv(TheNumber,"MD2")),"R%13") : (If TheNumber < 0 Then "D" Else "C")
by ray.wurlod
Thu Sep 15, 2005 4:26 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Resetting KeyMgmt Value
Replies: 3
Views: 889

"Do i have to Open the SDKSequence file before issuing an EXECUTE command to peform the UPDATE ?"

Depends what command you use to perform the update. If it's SQL, the answer is no.
by ray.wurlod
Thu Sep 15, 2005 4:25 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datatype Limitation for Complex Flat Files
Replies: 3
Views: 813

That's a standard restriction - originally from the mainframe world - for pretty much anything COBOL-related. Import from you COBOL FD and you will see that this is the case. You could always define the field as a non-numeric type, which will permit more digits.
by ray.wurlod
Thu Sep 15, 2005 4:22 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: [Informix ODBC Driver]Could not position within a table
Replies: 1
Views: 1767

Something went wrong with a cursor in Informix, or there is internal corruption in the Informix table structure (unlikely). Get help from your Informix DBA.
by ray.wurlod
Thu Sep 15, 2005 4:21 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Branching Code without Raising Director Warnings
Replies: 3
Views: 867

Use a custom trigger rather than an unconditional trigger.
by ray.wurlod
Thu Sep 15, 2005 4:20 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DRS stage Where condition being generated automatically
Replies: 5
Views: 1104

You can add WHERE and other clauses on the Selection tab of the Outputs link.
by ray.wurlod
Thu Sep 15, 2005 4:17 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Expression Evaluation
Replies: 17
Views: 4962

If you open a CMD shell, then type in sh you will get a "UNIX" prompt if MKS is installed. This is the easiest test I know. From a TCL prompt, you can use the SH -c "command" technique; if MKS is installed then the SH command is enabled, otherwise you will get a message indicating that it is not sup...
by ray.wurlod
Thu Sep 15, 2005 4:14 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Server Jobs - record processing
Replies: 2
Views: 819

"Wish to know, even in Server Jobs records are not processed row by row but in bunch."

If row buffering is disabled, row by row. If row buffering is enabled and you have active-to-active stage links, then rows are buffered ("bunches"?).
by ray.wurlod
Thu Sep 15, 2005 4:11 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: problems in string formating.
Replies: 12
Views: 3227

You don't get a second line. DataStage is processing rows. It's not a printer driver!
by ray.wurlod
Thu Sep 15, 2005 4:09 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: platforms supported. Unix platforms?
Replies: 3
Views: 911

Your research has been very limited - you have looked only at version 7.5x2 which is the first release of EE in which Windows platforms are supported. Beware though, like all first releases of software, it is VERY flaky!
Other variants of 7.5.n are for UNIX platforms. Including Linux.