DSXchange

It failed even If I leave empty..I tried all different characters..but no Use
to be perfect, It works only for '0'.

Hi,
In merge stage,
In InputFileProperties, If I put Escape character '\', it fails,giving the following error (Function 'get_next_output_row' failed)
but If i put '0' it works, but In the data, It removes '0' which is no good.
any clue..

Hi, When I do ftp some files from Windows to UNIX, Sometimes It carries some carriage returns sometimes not... I am using Auto Transfer type..Is there any extra care do I need to take to suppress these carriage returns..? Or Is there any tip I can use to eliminate them..? some files as they are big ...

Hello, Does IsNullStr() and IsNull really have any difference.. I am anxious to know If IsNullStr() treates 10 bytes of spaces and a null and a blank equally as null.. If not, Is there anyother function or Transform that treats all the above scenarios as Null..bacause In my scenario I may get differ...

Hi, I am trying to do a lookup using a hash file.. I have ColA in seq file and ColA in Hash file(both files same structures)...I wanted to know how can I get a ColA data from hashfile if there is no match found in seq file but we have in hash file...(basically a outer Join).. I tried to use merge st...

Sai, I have to look for some set (around 40) of words/strings like "REHAB" and so on in a field of 50 bytes.. If I find these strings "REHAB" some where in the field, Then I have to map some thing in field1, field2, filed3, field4..If I dont find any of those set of words, i need...

Thanks Kim and Ray...
I was littlebit curious, if a specific function exists that can find a substring anywhere in the whole field and if found, I need to concatenate 4 other fields...
but I can use Index() in a stage variable and work it out..

Thanks again...

Can we use Index function even If we dont know where exactly the string in the field is ..?

ex: I am looking for a string 'CARE' in "THE HEART CARE CENTER INC"

Thanks

Hi,

What function can I use to find a string in a field..The specific string may be anywhere in the whole field.. I am trying to find the string..If it is found, I have to do something If not something else.

Thanks

I am trying to do left outer join on two files using merge stage...
I am getting the following error...
"Function 'construct_hash_table' failed
Unbalanced or unescaped quote character"..Any clue what I am missing here..?

Thanks

only some Nulls are not readable and inturn they are written as "?" in the tgt fil.....but not always all nulls are written as "?".
How to handle this NLS mapping warnings..? :(

Any help pls...

Thanks in Advance

Nulls are not read properly and write as nulls...
how to handle nulls properly..?

Hi, I am trying to read a Seq file and dedupe it using remduplicates stage and write to a seq file...I am getting following error... When checking operator: When validating export schema: At field "FIELD1": Exporting nullable field without null handling properties What is this warning mess...

Ray, Yes as u said, I could see "?" in the record...where I get nulls. In my source file which is a comman delimited..doesn't have quotes..so, for nulls It is wrriten as "?"...And I get lot of such warnings... but in the log, the warning is shown as : nls_map_buffer_out() - NLS m...

Mahesh,

What does this function do..?
Does this enclose the column in quotes ?...