DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 17 matches
Author Message
Resolved
 Topic: @@isPresent element in XML Composer step for optional groups
vivek

Replies: 1
Views: 542

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Nov 06, 2017 6:46 pm   Subject: @@isPresent element in XML Composer step for optional groups
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.

Smile
Resolved
 Topic: @@isPresent element in XML Composer step for optional groups
vivek

Replies: 1
Views: 542

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Nov 06, 2017 12:30 pm   Subject: @@isPresent element in XML Composer step for optional groups
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
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> ...
 Topic: Simple question : how to do "10 to the power of x"
vivek

Replies: 10
Views: 3829

PostForum: IBM® DataStage TX   Posted: Tue Jul 31, 2007 12:30 am   Subject: Simple question : how to do "10 to the power of x"
you could use something like 10eX.
 Topic: When to use these Diffrent Oracle stages?
vivek

Replies: 2
Views: 680

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Feb 22, 2007 1:37 pm   Subject: When to use these Diffrent Oracle stages?
DataStage® Release: 7x
Job Type: Parallel
OS: Unix
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, ther ...
 Topic: exponential formula in a subroutine
vivek

Replies: 1
Views: 1235

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Thu Aug 31, 2006 11:04 am   Subject: exponential formula in a subroutine
DataStage® Release: 7x
Job Type: Server
OS: Unix
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 form ...
 Topic: Using Field function to get final delimeter of a string
vivek

Replies: 16
Views: 4813

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Tue Aug 08, 2006 6:58 pm   Subject: Using Field function to get final delimeter of a string
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 ...
 Topic: Using Field function to get final delimeter of a string
vivek

Replies: 16
Views: 4813

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Tue Aug 08, 2006 1:02 pm   Subject: Using Field function to get final delimeter of a string
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=dc ...
 Topic: Using Field function to get final delimeter of a string
vivek

Replies: 16
Views: 4813

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Mon Aug 07, 2006 11:11 pm   Subject: Using Field function to get final delimeter of a string
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 fi ...
 Topic: Using Field function to get final delimeter of a string
vivek

Replies: 16
Views: 4813

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Mon Aug 07, 2006 9:43 pm   Subject: Using Field function to get final delimeter of a string
DataStage® Release: 7x
Job Type: Server
OS: Unix
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 underscor ...
 Topic: Unable to open csv file format
vivek

Replies: 24
Views: 7901

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Wed Jun 28, 2006 8:56 am   Subject: Unable to open csv file format
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 = repla ...
 Topic: Concatination Problem for Tab delimited file
vivek

Replies: 9
Views: 2742

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Wed Jun 28, 2006 8:35 am   Subject: Concatination Problem for Tab delimited file
But My question is can't we use the term"@null" and why?
Folks any idea on that??
 Topic: Concatination Problem for Tab delimited file
vivek

Replies: 9
Views: 2742

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Wed Jun 28, 2006 8:25 am   Subject: Concatination Problem for Tab delimited file
Kumar and Loveojha
Thanks for your fast replies.
I have already tried "" but it wasn't working.
just now itried to make as IF len(column)=0
and it's just working fine.


If any one can throug ...
 Topic: Concatination Problem for Tab delimited file
vivek

Replies: 9
Views: 2742

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Wed Jun 28, 2006 7:56 am   Subject: Concatination Problem for Tab delimited file
DataStage® Release: 7x
Job Type: Server
OS: Unix
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 f ...
 Topic: Time stamp issue
vivek

Replies: 1
Views: 793

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Thu Jun 01, 2006 7:49 am   Subject: Time stamp issue
DataStage® Release: 7x
Job Type: Server
OS: Unix
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 Var ...
 Topic: Data type from varchar2 to decimal
vivek

Replies: 7
Views: 1675

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Thu Jun 01, 2006 5:41 am   Subject: Data type from varchar2 to decimal
Kumar,
You are right. In the target The True or False becomes 1 AND 0. Can you explain me how to achieve this in the tarnsformer?
 

 Jump to:   



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours