DSXchange

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...

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 ...

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...

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...

Hi Sreeni, Thanks for info, Do you mean to say to create schema file like this and try. col1: nullable timestamp {null_field=""} ; col2: nullable timestamp {null_field=""} ; ... col400: nullable timestamp {null_field=""} Do you mean the same? if this is the same , then ...

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

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

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...

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-...

Was there sometghing wrong in this?


if (len(TrimLeadingTrailing(Trn_Track_Out_Dttm.MASK_SET_ID))=0) then SetNull() else (Trn_Track_Out_Dttm.MASK_SET_ID)

showing compilation errors.l Thanks.

Was there sometghing wrong in this?


if (len(TrimLeadingTrailing(Trn_Track_Out_Dttm.MASK_SET_ID))=0) then SetNull() else (Trn_Track_Out_Dttm.MASK_SET_ID)

showing compilation errors.l Thanks.

yes, its been done......

if Not(IsNull(DSLink3.a_char) or DSLink3.a_char = "") then '' else DSLink3.a_char
DSLink4.col2

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: ------------...

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...

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...