Search found 210 matches

by suryadev
Fri Jul 23, 2010 2:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: parsing a field
Replies: 15
Views: 5176

I used the first code in the derivation of svfield2.

and the second code in the derivation of the column.


but I see that the output is NULL in all the records.


please suggest any change in the code?
by suryadev
Fri Jul 23, 2010 10:34 am
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: Error in the response of a webservice
Replies: 9
Views: 7262

where can I find the display editor?

will that allow me to send perfect response with out spaces
I mean "Name " to "Name"
by suryadev
Fri Jul 23, 2010 10:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: parsing a field
Replies: 15
Views: 5176

The name of stage variable is svField2

and in the description svfield2 = the code with change in column name and use the svfield2 as description of that column.

I see a red color in the description field.
by suryadev
Fri Jul 23, 2010 10:18 am
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: Error in the response of a webservice
Replies: 9
Views: 7262

output now is "Name(emptyspace)"
by suryadev
Fri Jul 23, 2010 9:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: parsing a field
Replies: 15
Views: 5176

ray,
I can see the code now,
Do I need to change anything other then the column name in the code..

or same as it is to get the output.
by suryadev
Fri Jul 23, 2010 8:55 am
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: Error in the response of a webservice
Replies: 9
Views: 7262

Thanks,

I can see the output now

but it appears as NAME@@@@@@@@

any other change for only NAME

I used apt_string_padchar as job parameter and made it 0x40...
by suryadev
Thu Jul 22, 2010 10:09 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: parsing a field
Replies: 15
Views: 5176

The source contains NULL also sometimes,
also I cannot see any solution in the post...

could you please send the solution again.
by suryadev
Thu Jul 22, 2010 9:32 pm
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: Error in the response of a webservice
Replies: 9
Views: 7262

where can I change the environment variable?apt_string_padchar....
I can see the output properly in a sequential file but when I change the target as WISD output.....I see the data....in that manner with an error also.
by suryadev
Thu Jul 22, 2010 9:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: parsing a field
Replies: 15
Views: 5176

If the record has different parts they are divided by pipe delimiter If there is only one part then there will be no pipe delimiter. each part has 2 commas and I need the 10 digits after AB. Yes AB occurs only in first delimited field. can you please let me know what condition do I need to use in st...
by suryadev
Thu Jul 22, 2010 8:38 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: parsing a field
Replies: 15
Views: 5176

parsing a field

the records in the field are in this way.......... field_name:-person_info -->1234567,AB,1234567890|4567123,CD,5678234456| -->124325,AB,7923499786 -->12795578,AB,9939433456|7999478,CD,8674538956 these are the records The conditions are... the field should have AB otherwise Null. If it has AB parse t...
by suryadev
Thu Jul 22, 2010 6:57 pm
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: Error in the response of a webservice
Replies: 9
Views: 7262

Error in the response of a webservice

I see the output in this way..... nique_row_id><reason>Name,&#0;&#0;&#0;&#0;&#0;&#0;&#0;&#0;&#0;&#0;&#0;&#0;</reason><first_nm xsi:nil=" and the below error java.io.IOException: Character reference "&#0" is an invalid XML character t...
by suryadev
Wed Jul 21, 2010 11:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Transformer concatenate
Replies: 3
Views: 4218

There are 4 fields and I want them to be as a single field so I used concatenate only to my new Field derivation because that is the only field available...now in the output
and I did not use any constraint in the transformer as I used concatenate in my New single field.
by suryadev
Wed Jul 21, 2010 10:00 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Transformer concatenate
Replies: 3
Views: 4218

Transformer concatenate

While using concatenate in transformer, first create a field...by any NAME in the columns in the bottom of properties of transformer and then...in the output field use..the empty space on the left of the new field. in that..empty space called derivation.right click and select a column and concatenat...
by suryadev
Mon Jul 19, 2010 9:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: which stage?
Replies: 3
Views: 1591

Thanks,
where do I need to put these conditions ?

In the constraints or in the stage variable?

1.do I need to have single output in the transformer with all these conditions in the constraint.
or
2.do I need to have 4 outputs from the transformer with these conditions in constraint.
by suryadev
Mon Jul 19, 2010 7:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: which stage?
Replies: 3
Views: 1591

which stage?

hi, Unique dead NOR frgn heth 1 N N N Y 2 N Y N N 3 Y N N N 4 N N Y N this is a table in which unique,dead,NOR,frgn,heth are fields and below are the rows ,input from source will be unique so check with this table and send output like....if input unique is 1 the output should be Heth unique is 2 the...