Search found 48 matches
- Fri Jul 13, 2007 4:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Close statement in oracle enterprise edition stage
- Replies: 5
- Views: 2087
Have you tried to and, if so, with what result? What does the manual or on-line help suggest? ... Ray, It did'nt allow to do so, I belive it is possible to us multiple close statements when we use DB2 Enterprise Edition, and there has been no reference abt how many close statements can be used in t...
- Thu Jul 12, 2007 2:04 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Close statement in oracle enterprise edition stage
- Replies: 5
- Views: 2087
Close statement in oracle enterprise edition stage
Hi All,
I would like to know if we can use multiple close statements, where we run muliple select statement per close statement in the Oracle Enterprise Edition Stage.
regards,
varsha
I would like to know if we can use multiple close statements, where we run muliple select statement per close statement in the Oracle Enterprise Edition Stage.
regards,
varsha
- Tue Jun 26, 2007 4:53 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Fatal Error when trying to read data in Db2
- Replies: 0
- Views: 1311
Fatal Error when trying to read data in Db2
Hi All, A particular customer is getting following error, when he tries to view data from a DB2 Enterprise Edtion Stage, the Db2 db is present on a remote machine. The Db2 client is installed on the machine where datastage server is installed. They are able to successfully import the metadata from D...
- Mon Jun 25, 2007 6:02 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Problem in Loading an Oracle Table using Load Option in Data
- Replies: 4
- Views: 2037
What is your job design, I'm guessing just the two Oracle stages? :? If so, you'll need something between them to map the columns. For example, to map 'a' to 'd' (etc) in your second example. Do u mean that we need to give an alias for column a as d using a transformer and then map it to the so tha...
- Mon Jun 25, 2007 5:45 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Problem in Loading an Oracle Table using Load Option in Data
- Replies: 4
- Views: 2037
Problem in Loading an Oracle Table using Load Option in Data
Hi, There is a particular problem which we have encountered. When we try to load data from Oracle Table A(Using Oracle Enterprise Stage) To Oracle Table B(Oracle Enterprise Stage) Using the Write Method= Load, When the column names in both the tables are same then there is no error say Table A Table...
- Fri Jan 13, 2006 11:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Replacing a substr with a single value
- Replies: 3
- Views: 2353
Re: Replacing a substr with a single value
Try Convert('%3D',':',Input.String). that should work to replace your first string. Use stage variables and convert once for the %3D value and again for the next value. You might try nesting the function, but I like using stage variables instead makes it easier to read later. Let me know if this wo...
- Fri Jan 13, 2006 7:04 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Replacing a substr with a single value
- Replies: 3
- Views: 2353
Replacing a substr with a single value
Hi, I need to do the following in datastage input string lmundada%3Dabc%3Dlmno%2D I need to replace all '%3D' with ':' and all %2D with ',' output string lmundada:abc:lmno, I used convert function but convert function converts all occurances of % to :. I need to do something similar to replace funct...
- Fri Sep 23, 2005 3:57 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Equivalent of first and last functions in sql in datastage
- Replies: 6
- Views: 3755
Hi, What I am trying to do is the equivalent of select event_session_id, first(ref_qry_strng_text), first(agent), first(page_id), first(start_dt_tm), last(start_dt_tm), first(timediff), web_site_id, first(clnt_ipa_num), sum(page_cnt), first(link_key), sum(tot_file_size_num), last(nav_path) from sess...
- Wed Sep 21, 2005 7:59 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Equivalent of first and last functions in sql in datastage
- Replies: 6
- Views: 3755
The job I have developed using transformer and remove duplicates stage has a strange behavior, the aggregated values are obtained if I take fewer records, but when I run the job for bulk of records, the result obtained is not accurate. I have not used any partitioning or parallelism in the jobs. And...
- Mon Aug 29, 2005 8:54 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Date manipulation
- Replies: 5
- Views: 2277
- Sun Aug 28, 2005 6:03 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Date manipulation
- Replies: 5
- Views: 2277
Date manipulation
Hi,
I have input value for date as follows
28/Aug/2005:17:00:07
I need to obtain the following string
2005-08-28 17:00:07
I have used many stage variables to get the above value.
what is the best way to get the above mentioned value.
regards,
varsha
I have input value for date as follows
28/Aug/2005:17:00:07
I need to obtain the following string
2005-08-28 17:00:07
I have used many stage variables to get the above value.
what is the best way to get the above mentioned value.
regards,
varsha
- Sun Aug 28, 2005 11:28 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Multiple Instance of a job
- Replies: 6
- Views: 4008
Explain WHY you have this doubt. Have you run the job? Does it work? Do your Lookup stages have reject capturing or do your jobs have downstream null handling on the looked-up column(s), so you can determine whether the lookups failed? The job works fine, I am in the process of running the job with...
- Fri Aug 26, 2005 3:46 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Multiple Instance of a job
- Replies: 6
- Views: 4008
- Fri Aug 26, 2005 3:41 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Change Capture Stage Problem
- Replies: 2
- Views: 1750
Change Capture Stage Problem
Hi, I am in the process of using a change capture stage as a replacement for checking if data being processed every day if it is present in the database, if it is present then we update a set of fields, otherwise we need to insert the data. But I have 2 categories of updates for which I need the val...
- Fri Aug 26, 2005 1:24 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Insert/Update Job Design: Comments?
- Replies: 10
- Views: 5818