Search found 28 matches
- Fri Sep 11, 2009 3:34 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Datastage 8.0.1 Installation Issue - Please HELP
- Replies: 3
- Views: 2932
Datastage 8.0.1 Installation Issue - Please HELP
Hi chops, I installed Datastage 8.0.1 and unable to start either db2 / web console. 1) When I am doing " Start server " in command prompt it is showing , plz refer to this file for info. "C:\IBM\WebSphere\AppServer\profiles\default\logs\server1\startServer.log" Attached is the fi...
- Thu Aug 13, 2009 1:17 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sequencer - text inside exec command activity
- Replies: 3
- Views: 2043
Thanks for reply. But , I want my job name that is associated to one param only. I have total 30 parameters used in EXEC COMMAND ACTIVITY stage. As you suggested , when we export dsx/ xml, then only #PARAMNAME# will be given but not value of the #PARAMVALUE#. Is there any other way through which we ...
- Thu Aug 13, 2009 9:03 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sequencer - text inside exec command activity
- Replies: 3
- Views: 2043
Sequencer - text inside exec command activity
Hi, I have 100 sequencers in my project. In that 100 sequencers, 1) I need to find those sequencers with "EXEC COMMAND ACTIVITY" used in it. 2) And, I want to search for those sequencers with text "SHELLSCRIPTS" placed inside the EXEC COMMAND ACTIVITY. What are the methods to fin...
- Tue Jul 07, 2009 4:34 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Datastage 8.0.1 optimnization
- Replies: 4
- Views: 2700
Datastage 8.0.1 optimnization
Hi, We have a requirement from the client to fine tune the jobs that are running for long time in production. Environment details in brief: Version : IBM WebSphere Datastage 8.0.1 (Sun OS 5.10) Sources : Teradata,Oracle,Flat files Target : Teradata Transformation rules : Complex Nodes : 1 nodes in p...
- Wed Jul 01, 2009 8:46 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Null handling for 200 / 300 columns at one go.
- Replies: 14
- Views: 6425
- Thu May 28, 2009 3:12 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Null handling for 200 / 300 columns at one go.
- Replies: 14
- Views: 6425
Thanks for replies so far, but still I need a smart method of handling this at one go , may be handling at source side as suggested , or may be a routine which can help on this..... Yet to decide on this implementation. Thanks, friend.kak@gmail.com
- Thu May 28, 2009 2:56 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Null handling for 200 / 300 columns at one go.
- Replies: 14
- Views: 6425
Thanks for replies so far, but still I need a smart method of handling this at one go , may be handling at source side as suggested , or may be a routine which can help on this..... Yet to decide on this implementation. Thanks, friend.kak@gmail.com
- Fri May 15, 2009 5:16 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Null handling for 200 / 300 columns at one go.
- Replies: 14
- Views: 6425
Null handling for 200 / 300 columns at one go.
Hi, I have a table with 400 columns and i may expect 200 columns with null data ( say 10% of cases ) , and my job will get aboret in dev / sit / production if no of warnings > 50 , if i want to handle this at one go instead of writing for each and every column, how to achieve this? Any easier method...
- Wed Feb 11, 2009 5:21 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Null handling
- Replies: 11
- Views: 6775
Output from transformer compilation follows: ##I IIS-DSEE-TFCN-00001 04:19:46(000) <main_program> IBM WebSphere DataStage Enterprise Edition 8.0.1.4760 Copyright (c) 2001, 2005-2007 IBM Corporation. All rights reserved ##I IIS-DSEE-TOSH-00002 04:19:46(001) <main_program> orchgeneral: loaded ##I IIS-...
- Wed Feb 11, 2009 4:34 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Null handling
- Replies: 11
- Views: 6775
- Wed Feb 11, 2009 4:33 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Null handling
- Replies: 11
- Views: 6775
- Wed Feb 11, 2009 2:08 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Null handling
- Replies: 11
- Views: 6775
- Wed Feb 11, 2009 12:39 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Null handling
- Replies: 11
- Views: 6775
Null handling
Hi, I am trying to load a column (varchar). version 8.01 my logic is like this. If this is coming as blank from inputs, then i must put NULL into that target column. How to handle this, when i am tryingto do this in xfm , it is throwing an compilation error, could not compile. Logic is: ------------...
- Thu Jan 15, 2009 3:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: could not compile job - compiler issue
- Replies: 4
- Views: 12694
could not compile job - compiler issue
Hi, I installed Datatstage 8.0.1 in windows xp prof edition. I could not compile even a job when the job is having TRANSFORMER /MODIFY but working when job is used COPY Stage. The following is the error message. ---------- Output from transformer compilation follows: ##I IIS-DSEE-TFCN-00001 14:27:23...
- Thu Jan 15, 2009 2:51 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Can we import Teradata specific ,"FORMAT TEXT " fo
- Replies: 0
- Views: 906
Can we import Teradata specific ,"FORMAT TEXT " fo
Hi, I am trying to import a file which is in the format of "Teradata's FORMAT TEXT" format and i am trying to read that. DO we have some stage / some utility in Sequential file stage where in we can give the properties and get the file imported and taken forward. If yes, plz let me know. T...