Search found 53125 matches

by ray.wurlod
Wed Jun 07, 2006 3:20 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Multiple file in different format to ODBS using 1 DS job
Replies: 4
Views: 1376

You can design multiple independent streams in the one job, but a more modular approach (separate jobs, perhaps run by a job sequences) is to be preferred because it is easier to maintain.
by ray.wurlod
Wed Jun 07, 2006 3:18 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem with SAP IDOC Extract
Replies: 4
Views: 1255

It seems to be failing to find (a DataStage job?) called SAP_IDG_ALEAUD01_IDOC_corrupted - have you moved this to your test environment? (It seems an odd name to have other than in a development environment.)
by ray.wurlod
Wed Jun 07, 2006 3:14 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DSR_RECORD (Action=2); check DataStage is set up correctly i
Replies: 9
Views: 3763

Are you running on multiple machines (MPP)? The conductor, section leader and player processes communicate via TCP, and with 16 jobs x N stages chances are you have overloaded the capacity of the processes all to communicate simultaneously. For example all processes must relay warnings and errors to...
by ray.wurlod
Wed Jun 07, 2006 3:06 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: conversion of integer to timestamp
Replies: 7
Views: 3418

If you want to use a Transfomer stage the function is DateToString(). You really should have looked that up. Appendix B of Parallel Job Developer's Guide lists all the Transformer stage functions.
by ray.wurlod
Wed Jun 07, 2006 2:28 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Not able to connect to the server
Replies: 5
Views: 1509

Read the error message again. Check that the DataStage RPC service is running (use the DataStage or Services applet in Control Panel). If the services aren't running, start them. How are you logging in - using user ID and password (TCP/IP) or checking the Omit box (LAN Manager)? Try the other method...
by ray.wurlod
Wed Jun 07, 2006 2:24 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: initialize a hash file using a parameter
Replies: 13
Views: 2544

There's no real best way. A job that consists of a Transformer stage followed by a Hashed File stage would do it. Use a stage variable to "calculate" the initial value, and the job parameter (List type, values 0 or 1, default 0) used to constrain the output, along with @OUTROWNUM = 1. On the output ...
by ray.wurlod
Wed Jun 07, 2006 2:17 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Audit Control
Replies: 2
Views: 763

There's nothing out of the box. You will need to design it yourself. Unless you're competent with managing metadata within jobs (and, probably, rigid link naming standards), you won't even be able to use a shared container. A generic after-job subroutine ought to be able to do most of it, again assu...
by ray.wurlod
Wed Jun 07, 2006 2:13 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: after-stage subroutine to abort job
Replies: 15
Views: 4441

That's not what I was suggesting, but it would work for the correct test command. It would need to be a compound test for non-existence or zero-length. I note, however, that you are on a Windows platform so that, unless you have a UNIX shell of some kind available, then you will not have the test co...
by ray.wurlod
Wed Jun 07, 2006 2:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Cannot edit any stages within a Job Sequence
Replies: 11
Views: 3491

It is available from the eServices web site. If you search the forum you will find a direct link to it.
by ray.wurlod
Wed Jun 07, 2006 1:15 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reading Sequential file Error
Replies: 4
Views: 1176

Etiquette Note
We share here. What was the problem and what was its resolution? This knowledge may help someone else with the same problem in the future.
by ray.wurlod
Wed Jun 07, 2006 1:10 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to call stored Procedure in Data stage
Replies: 2
Views: 907

OK, here's one "ASAP" for you, as requested.

Etiquette Note
We don't do "urgent" or "ASAP" here. This is an all-volunteer site. None of the posters is paid. If you want "urgent" sign up with your support provider for premium service, and learn the true cost of urgent.
by ray.wurlod
Wed Jun 07, 2006 1:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: conversion of integer to timestamp
Replies: 7
Views: 3418

You only have the date part. However, you could convert the integer to string (StringFromInteger), concatenate an all-zero time part, and convert the string to a timestamp (TimestampFromString). Or you could convert a date and time to a timestamp by converting the integer to a string thence to a dat...
by ray.wurlod
Wed Jun 07, 2006 1:04 am
Forum: Site/Forum
Topic: Video Tech Tip Series - FEEDBACK
Replies: 49
Views: 73519

Can anyone prepare subtitles? Do you mean to translate Texan to English? Or other languages? Because of the language structures, Hebrew and Arabic would be really tough to do. Nor would Japanese be easy, again because of the verb-last sentence structure preceded by as many conditional clauses as you...
by ray.wurlod
Wed Jun 07, 2006 12:36 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: conversion of integer to timestamp
Replies: 7
Views: 3418

Welcome aboard. :D You first need to document the rules that can take an integer to a timestamp. Since an integer can have at most 10 digits, you can not encode sufficient information in an integer to represent a timestamp using the digits. So, does the integer represent a certain number of seconds ...
by ray.wurlod
Wed Jun 07, 2006 12:15 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: after-stage subroutine to abort job
Replies: 15
Views: 4441

Call DSExecute to invoke the UNIX command test with appropriate options to test for existence and/or zero length. Use that result to set ErrorCode. You do NOT need to call DSLogFatal explicitly: it is better to allow the subroutine to return (unwinding the stack by one level) and have the caller (th...