Search found 19 matches
- Thu Jul 18, 2013 8:32 am
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: Multiple Input Cards to Single Out Card
- Replies: 1
- Views: 15364
Multiple Input Cards to Single Out Card
Dear All, I have two different application systems sending message with same format. Requirement is to append Application 2 input to Application 1 input at output. Application 1: <AddressDetails> <Address> <City>chicago</City> <State>illinois</State> <Country>US</Country> </Address> <Address> <City>...
- Tue Oct 12, 2010 4:19 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Numeric to String conversion
- Replies: 3
- Views: 3013
I am having a dataset one of the column names is ID whose values are like 000123, 000124 etc.. This is of DataType numeric. I have a table to which I need to do a lookup using these values.. table has values like 123, 124 etc.. This is of data type VarChar. So from the above dataset input I need to ...
- Tue Oct 12, 2010 4:06 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Numeric to String conversion
- Replies: 3
- Views: 3013
Numeric to String conversion
How can we convert Numeric to VarChar in DataStage?
Please help!!
Thanks, Raj
Please help!!
Thanks, Raj
- Fri Sep 24, 2010 10:27 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to find duplicates in a sequential file
- Replies: 6
- Views: 6193
Hi All, Thanks for the suggestions you gave to resolve this. I followed three approches to make sure all are giving same results. And All gave same results :) 1. Using Sort and Filter stage. In sort stage I had set Create Key Change column to True. In Filter stage using KeyChange attribute i routed ...
- Fri Sep 24, 2010 10:25 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to find duplicates in a sequential file
- Replies: 6
- Views: 6193
Hi All, Thanks for the suggestions you gave to resolve this. I followed three approches to make sure all are giving same results. And All gave same results :) 1. Using Sort and Filter stage. In sort stage I had set Create Key Change column to True. In Filter stage using KeyChange attribute i routed ...
- Wed Sep 22, 2010 4:04 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to find duplicates in a sequential file
- Replies: 6
- Views: 6193
- Wed Sep 22, 2010 3:52 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to find duplicates in a sequential file
- Replies: 6
- Views: 6193
How to find duplicates in a sequential file
Hi I have a CSV file. I need to find if there are any duplicates in the files. If any duplicate records are present I need to reject them and put into a sequential file.
Can any body let me know hoe can i do this in DataStage8.1 version?
Thanks, Raj.
Can any body let me know hoe can i do this in DataStage8.1 version?
Thanks, Raj.
- Mon Sep 20, 2010 6:17 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Missing Key Columns in Update SQL - write method Upsert
- Replies: 3
- Views: 3263
- Mon Sep 20, 2010 5:28 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Missing Key Columns in Update SQL - write method Upsert
- Replies: 3
- Views: 3263
Missing Key Columns in Update SQL - write method Upsert
Hi, I have a table (ORDER_DETAIL) which has only one column (ORDER_NBR) and is not defined as Key in Database. I wanted to do an upsert to the table. when I do so the Update SQL is is showing Missing Key Columns. UPDATE #$SchemaName#ORDER_DETAIL SET ORDER_NBR = ORCHESTRATE.ORDER_NBR WHERE (<<Missing...
- Tue Jul 06, 2010 3:44 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: String to Decimal conversion
- Replies: 1
- Views: 4036
String to Decimal conversion
Hi All,
I am trying to convert string to decimal using transformer stage.
The StringToDecimal() function says to give Rtype as second argument. What is this and how how do we define this?
Please help!!
As I am new to DataStage unable to understand the lingo.
-Thanks!!
Raj
I am trying to convert string to decimal using transformer stage.
The StringToDecimal() function says to give Rtype as second argument. What is this and how how do we define this?
Please help!!
As I am new to DataStage unable to understand the lingo.
-Thanks!!
Raj
- Fri Jul 02, 2010 3:39 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: csv file issue
- Replies: 1
- Views: 1719
csv file issue
In a csv file, I am having a date format as month day, year (for ex: January 14, 1940)
But as this is a csv file it is considering January 14 as one attribute value and 1940 as another attribute value.
How can I resolve this issue?
-Thanks,
But as this is a csv file it is considering January 14 as one attribute value and 1940 as another attribute value.
How can I resolve this issue?
-Thanks,
- Tue Jun 29, 2010 9:27 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DateFunction
- Replies: 3
- Views: 2458
- Tue Jun 29, 2010 8:06 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DateFromString Function
- Replies: 4
- Views: 3947
DateFromString Function
Hi Iam trying to convert String to Date using Modify Stage. And the function which iam using is Date:Date=date_from_string[%mmm %dd, %yyyy](Date) My input format is of string and is like June 14, 2010 when I run this it gives a warning saying Data string 'June 14, 201' does not match format '%mmm %d...
- Tue Jun 29, 2010 6:30 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DateFunction
- Replies: 3
- Views: 2458
DateFunction
What function can I use to convert date from Mon dd,yyyy to YYYY-MM-DD?
-Thanks
Raj
-Thanks
Raj
- Wed Jun 23, 2010 1:32 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Converting Decimal to Integer in Transformer Stage
- Replies: 3
- Views: 14689