I found the solution.
I check marked the 'Omit Null Elements' option in the format tab of XML Composer and ,now, I don't see the empty elements or associated groups anymore.
Search found 17 matches
- Mon Nov 06, 2017 6:46 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: @@isPresent element in XML Composer step for optional groups
- Replies: 1
- Views: 1876
- Mon Nov 06, 2017 12:30 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: @@isPresent element in XML Composer step for optional groups
- Replies: 1
- Views: 1876
@@isPresent element in XML Composer step for optional groups
Hi, I have to create an XML based on the xsd supplied by the end client. its looks something like the below format. <xs:element name="HealthForm"> <xs:complexT ype> <xs:sequence> <xs:element name="Form-ID" <xs:element name="Insurance-Type" <xs:element name="Health-...
- Tue Jul 31, 2007 12:30 am
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: Simple question : how to do "10 to the power of x"
- Replies: 9
- Views: 7659
- Thu Feb 22, 2007 1:37 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: When to use these Diffrent Oracle stages?
- Replies: 2
- Views: 1555
When to use these Diffrent Oracle stages?
Hi,
Can anybody eloborate on when to use specific stage among the
1. ORACLE OCI 8
2. ORACLE OCI LOAD
3. ORACLE Enterprise stages?
Though all of these stages are similar in functionality, there must be some reasons to use them for particular purpouse.
Appriciate your time.
Can anybody eloborate on when to use specific stage among the
1. ORACLE OCI 8
2. ORACLE OCI LOAD
3. ORACLE Enterprise stages?
Though all of these stages are similar in functionality, there must be some reasons to use them for particular purpouse.
Appriciate your time.
- Thu Aug 31, 2006 11:04 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: exponential formula in a subroutine
- Replies: 1
- Views: 1894
exponential formula in a subroutine
Hi , I have a requirement to calculate a score ,based on an incoming value using some iterations(using a formula) which involves 'exponential' components in the formula. for example, in this formula i have some multiplications to be done with exponential components such as 0.5543e-008, 2.345e-006, 3...
- Tue Aug 08, 2006 6:58 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Using Field function to get final delimeter of a string
- Replies: 16
- Views: 8143
Chulette, The reason I went for a subroutine is to specify an exception, such as how to handle the string if the delimeter(the double space) is not found. we are replacing the result with '00' for now. even though that's not the present situation may be in future we may get data with out this delime...
- Tue Aug 08, 2006 1:02 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Using Field function to get final delimeter of a string
- Replies: 16
- Views: 8143
Hi all, First of all, I really appriciate your help and effort for this solution. I have used 'Dcount' and 'Field' functions to attain this solution. here is the code: mystring=Arg1 d1=dcount(mystring,' ') d2=d1-1 d3=index(mystring,' ',d2) d4=mystring[d3+1,30] d5=left(d4,3) Ans=d5 once again thanks ...
- Mon Aug 07, 2006 11:11 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Using Field function to get final delimeter of a string
- Replies: 16
- Views: 8143
Ray, Chulette Thanks for the replies. I was actually trying to write a routine to solve this problem.If I bring the spaces to a uniform single space delimeter how i am going to know about the last field which is separated by the double spaces?(as in the requirement).Can anybody give me a clue, how t...
- Mon Aug 07, 2006 9:43 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Using Field function to get final delimeter of a string
- Replies: 16
- Views: 8143
Using Field function to get final delimeter of a string
Hi, I have a requirement where the column iam working(froma flat file) with is having single and double spaces betwen some text data. (please note that i have replaced each space with an underscore symbol for convenience) example1: abc_2wer__edr_der__xyz example2: 123__abc_def_rgv_123 the requiremen...
- Wed Jun 28, 2006 8:56 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Unable to open csv file format
- Replies: 22
- Views: 12881
Vijay indukuri, I had the same problem while having source system as MS Access. What I did was i wrote an update statement to eliminate the newline carriage UPDATE OPP_12JUNE SET BAMNOTES = replace(OPP_12JUNE.BAMNOTES,Chr$(10),''); then i have exported to a location(say to the desktop for instance) ...
- Wed Jun 28, 2006 8:35 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Concatination Problem for Tab delimited file
- Replies: 9
- Views: 5196
- Wed Jun 28, 2006 8:25 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Concatination Problem for Tab delimited file
- Replies: 9
- Views: 5196
- Wed Jun 28, 2006 7:56 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Concatination Problem for Tab delimited file
- Replies: 9
- Views: 5196
Concatination Problem for Tab delimited file
Hi All, I have two columns comming from a Tab delimited file.One of them is Reference(Varchar) where the other is Rate( Float.) My requirement is to concatenate them and put in to a Varchar field(Oracle). example data: REFERENCE prime split YRP Nkl rto RATE 20.2 0.5 0.5 etc....... i am able to conca...
- Thu Jun 01, 2006 7:49 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Time stamp issue
- Replies: 1
- Views: 1544
Time stamp issue
Hi , I am trying to convert the date which is in "2006-04-27T12:38:57.000Z " format to Timestamp in oracle. please let me know how iconv , oconv are useful here. In the source the column is Varchar2. In the target the column is timestamp. Both source and target are oracle. thanks in advance.
- Thu Jun 01, 2006 5:41 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Data type from varchar2 to decimal
- Replies: 7
- Views: 3198