Search found 6 matches

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