Search found 53125 matches
- 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
- 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
- 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...
- 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
- 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...
- 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 ...
- 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...
- 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...
- 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
- 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
- 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
- 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...
- 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...
- 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 ...
- 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...