Search found 6 matches
- Wed Aug 17, 2011 3:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ABAP extrct stage:Invalid character found converting Unicode
- Replies: 1
- Views: 1891
ABAP extrct stage:Invalid character found converting Unicode
Hi, My job is aborting due to below error. It is extracting data from SAP table using ABAP extract stage. The error message says: " Invalid character(s) ([xDCE1]) found converting Unicode string (code point(s): [xDCE1]) to codepage UTF-8, substituting. " Can someone pls help me ASAP. Regar...
- Sun Apr 25, 2010 5:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: reading xml files through datastage having dtd
- Replies: 3
- Views: 6950
reading xml files through datastage having dtd
Hi,
I have an xml source with corr. dtd file.
Could someone pls let me know the steps I need to read it in datstage.
Is it possible in a server job or parallel?
Regards,
Charu.
I have an xml source with corr. dtd file.
Could someone pls let me know the steps I need to read it in datstage.
Is it possible in a server job or parallel?
Regards,
Charu.
- Fri Jun 26, 2009 12:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Logic needed for this scenario
- Replies: 2
- Views: 1842
Logic needed for this scenario
Hi, Can someone tell me logic for this scenario: From the left link, records are coming in this way: col1 col2 col3 col4 col5 col6 PK a null b c null d V1 null b d e f null V2 v null f null d h V3 b J C null s a V4 Now, what I have to do is, for each record, take all fields which are not null and up...
- Tue Mar 24, 2009 11:56 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to read the attached file using sequential file stage
- Replies: 5
- Views: 3878
Re: import that from sequential file definitions
Hi Suresh, When I did all the steps, you have said, and did view data, it gives error on view data as: <main program> Accept timed out retries=4. Could you pls help. Regards, Sumati. :lol: Hi First import from sequential file definitions,at the time of importing select first line is column names and...
- Tue Mar 24, 2009 12:35 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to read the attached file using sequential file stage
- Replies: 5
- Views: 3878
How to read the attached file using sequential file stage
Hi, A source file is given to me as csv file but when I open it, it looks like a normal excel file. How do I read it using sequential file stage. The file is having extn .csv, but opens normally as a excel file having columns, Bank_id, bank_desc, Bank_Branch_id, Bank_branch_desc,Bank_branch_address ...
- Thu Mar 19, 2009 5:55 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to read excel file in csv format using sequential file?
- Replies: 2
- Views: 1573
How to read excel file in csv format using sequential file?
Hi, I have my input source file in csv format, and I want to read it using sequential file. But, I cannot see any settings or property or format tab where I can select '.csv' so that I can specify that my input file is in csv format? How can I read this file using a sequential file stage? Regards, S...