Search found 2288 matches

by roy
Wed Jun 25, 2003 7:34 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: SendMail by Using DataStage
Replies: 2
Views: 1344

hi,
on DS 5.2 using sequencer job send the successfull job finish to a sequncer stage then you can put as many output links from it as you need 1 will continue the overall job if needed, 1 will go to a notification (mail) activity etc... same applies to the case you got errors

enjoy

Roy R.
by roy
Wed Jun 25, 2003 7:27 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage Architecture
Replies: 6
Views: 1731

Hi,
try Ascential's site (search on the web) for staters



Roy R.
by roy
Wed Jun 25, 2003 5:47 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: USE OF ORABULK STAGE
Replies: 2
Views: 954

Hi,
in every client installation there is, under DS install directory, a docs folder.
in it there are several pdf help files among them you'll find hte info you need.

Roy R.
by roy
Wed Jun 25, 2003 5:43 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job Hangs When Running
Replies: 3
Views: 1842

Hi, few ideas you might wana check out, in case your problem happens whenever you run your job: 1. is there any long checkpoint or rollback on hte DB server @ the time your job was stuck? 2. are you using a routine you wrote that might contain an infinite loop? 3. are you locking something and tryin...
by roy
Wed Jun 25, 2003 3:34 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Universe datatype
Replies: 8
Views: 2712

Hi, before you try anything I would recomend you first check if any "regional settings" apply to your connection method. (i.e. odbc may specify a "use regional settings" which could cause an integer value to be fetched like this: 2,333.00 when actual value is 2333) so check if an...
by roy
Tue Jun 24, 2003 7:35 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Performance of jobs
Replies: 8
Views: 1608

Hi, you might want to try the following: first unload the lookup tables to hash files and check the preload file to memory option in the output of the lookups that will speed things up. also concider the network configuration between the DB server and the DS server (you didn't mention this configura...
by roy
Tue Jun 24, 2003 3:44 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Remove timepart in Date field
Replies: 6
Views: 1852

p.s. (on my post)

u can use any Oconv() manipulation on the internal date number to format the date in your flavour in case you don't need to load it back to a db table.

( in case you are not familiour with Oconv search it in the DS help )

Roy R.
by roy
Tue Jun 24, 2003 3:39 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Remove timepart in Date field
Replies: 6
Views: 1852

Hi, Another idea is, in case you are using native DB stages: you can define the datetime column as a date type in the source table's scheme. this will result in getting the internal date representation of DS, which is an integer value, thus truncating the time part from the result set. if you use th...