DSXchange

Thanks a lot

Hi Siva, Thanks for this suggestion. If my function return some alphanumeric characters then I can do this. But in this scnario the function returns a date value and if I need to use the date value in the where clause then I need to use to_date function. for example select..............where to_date...

Hi, I know that I cant read hash file using oracle oci stage. I think my question is not clear. Dastastage works row by row. So if I use one function in a sql query, then this function will execute once for each row. To avoid that I need to execute the function and store the value somewhere (I cant ...

Hi, I am extracting data from oracle and while extracting data I am using an user defined sql statement. This user defined sql statement contains one function which will generate a date value. I am using the user defined sql which looks like select ..... from ..... where column1 = fungetvalue(parame...

I can able to open the xml file in Internet Explorer without any error. I have selected XML as Dataelement and it is working file. You're right in saying that this will achieve what you want. Basically, you're telling DataStage that this field contains a valid XML chunk so don't bother converting it...

In datastage 7x do we have option like "Multiple Line Output" set to 0 Or any one is having the basic code to replace the carraige return Thanks Hi, what is with the option "Multiple Line Output" in the XML Writer stage? This option turned to "0" will avoid carriage ret...

Hi,
Thanks. It is replacing the carraige return characters now.

chulett wrote:We'll be here!

Hi, I have selected XML as Dataelement and it is working file. Thanks I don't think this is a case of creating 'safe XML' substitutions. There are a number of reserved characters in XML and one of these is '<'. You cannot have one of these appearing in the data because any XML reader will interpret ...

Hi, when I am creating a xml file thru datastage and opening it in notepad it looks like <subtag1> <name>Dilip </name> <idno>1111 </idno> </subtag1> But i want to create the file like <subtag1> <name>Dilip</name> <idno>1111</idno> </subtag1> Can anyone suggest me how to get this output

I ll try it on Monday and let you know.

chulett wrote:Uncheck the 'Generate Formatted Output' option.

Hi, Ihave not selected the DataElements. Let me try byselecting the DataElements as XML. I ll reply to you on Monday. They are equivalent and really shouldn't case a problem. When you generate the XML Output, do you have the 'Data Element' column set to 'XML'? My understanding is that data element t...

Hi, I am creating a xml file thru datastage. For one column I have appended a '<' symbol before the column value When I am opening the file thru internet explorer, I can able to see < symbol before the column value. But When I am opening the xml file in notepad, it is replacing the character as &...

Hi, I am creating a xml file in unix.By default datastage is generating a file as <tag1> value </tag1> But as per the requirement, the tags should appear as <tag1>value</tag1> Can I do it in datastage or I need to use the sed command in unix to replace the carriage return values after creating the f...

Ignore the first comment.
Please refer the 2nd one

Dilip/Sanjeev

HI,
I have done one projetc where we have read 6M records with 420 columns.
I was able to read the data but it was very slow.