Search found 1099 matches
- Wed Nov 03, 2010 4:54 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DataSet rejecting null records
- Replies: 7
- Views: 7394
When you use NullToValue function you have to give some default value. Usually NullToValue(Column,'') if you want to default it to empty string. As far as your original error message, are you doing any transformation on the field HENCL like using a Trim function etc without null handling. APT_Combin...
- Fri Sep 24, 2010 2:21 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Run the job mutliple times untill the condition is met
- Replies: 3
- Views: 3433
- Thu Sep 23, 2010 9:55 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Illegal date/time value warning
- Replies: 4
- Views: 4620
- Thu Sep 23, 2010 3:13 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Extraction
- Replies: 13
- Views: 7606
first field is like as I sent in the example..next are fields with tabs Again, if you can provide an example for people to you help you correctly, you will get an answer fast. As Craig had asked, provide a sample record for all the 20 fields that are coming in so that we can chip in with our sugges...
- Thu Sep 23, 2010 2:54 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Extraction
- Replies: 13
- Views: 7606
Not sure how you will end up with 5 fields if you read it as a fixed width file :? If you know the layout of the file, it should work just fine. Are you expecting blanks within your data where you intend to just add commas? You can read it as a single column and split them in a transformer stage as ...
- Thu Sep 23, 2010 11:05 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: hash partioning problem in remove duplicate stage
- Replies: 3
- Views: 4844
- Wed Sep 22, 2010 4:13 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to find duplicates in a sequential file
- Replies: 6
- Views: 6249
You would need to use StageVariables to do what Andy suggested. Another way to do is to use a Sort stage and set Create Key Change Column Property to True and Allow duplicates property to True. Then after the Sort stage, put a filter stage and filter on the key change column to grab the duplicates a...
- Thu Sep 16, 2010 8:47 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Add header and trailer to a file
- Replies: 3
- Views: 6683
Yes. you need to use UNIX commands. But you don't have to create a header file separately. You can create the header and write it to the output file. In the parallel job, set your Update to Append rather overwrite within the sequential file and in the after job, create your trailer record and append...
- Thu Sep 16, 2010 8:01 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Add header and trailer to a file
- Replies: 3
- Views: 6683
Couple of ways: 1. Create your header as part of before job subroutine, append the data to the flat file in your job and create the trailer in the after job subroutine. 2. Have a Transformer with three output links going into a Funnel Stage. Select sequential operation within your funnel stage. Crea...
- Thu Sep 16, 2010 7:55 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Datastage Transformer Null handling
- Replies: 1
- Views: 18581
Code: Select all
If IsNull(InputValue) or Trim(InputValue) = '' Then SetNull() Else Trim(InputValue)
- Tue Sep 14, 2010 4:37 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Converting string to date!!
- Replies: 23
- Views: 10677
Try to capture all the distinct values from the source by using a Remove Duplicates stage and try scanning them through to see if there are any data quality issues. We had a similar issue where business users started manually entering dates into the field and used their own formats such as 2010/03/1...
- Tue Sep 14, 2010 12:18 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Converting a nullable source to a non-nullable result;
- Replies: 3
- Views: 3266
It is telling you to handle NULL values that might come from the source. Because you are mapping a nullable field from the source table to a not nullable field on target there is every possibility that you might get NULL values from source. You need to define a default value for NULL's that are comi...
- Tue Sep 14, 2010 12:13 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Null Warning.
- Replies: 2
- Views: 2356
- Thu Sep 09, 2010 4:28 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parameters in a lookup stage
- Replies: 2
- Views: 2532
- Thu Sep 09, 2010 4:21 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Input record sequence number
- Replies: 21
- Views: 10067