DSXchange

Hi,

Currently we are connectiong to Oracle 11g database via Datastsge 7.5.x version. Our oracle client version installed in 10g.

Now we want to replace oracle 10g client with 11g client. Do we need to change anything from Datastage side for this.

Hi,
I have also tried adding to_timestamp function in SQL query

insert into table X columns ( prorcess_date_time) value to_timestamp ( :process_date_time) but is have not correctd the result.

Hi All, I am on Datastge 7.5 and I have file from which I load process_date time coumn In Input file I have value as 23-MAY-11 02.50.21.689000 In datastge job at target stage the column is defined as timestamp 26 with extended propert set to Microseconds when my job run and loads data into oracle 11...

dsscholar wrote:No it not working...
because because datastage will not recognize the column in double quotes ...and double quotes value is considered as hardcoded value in DS plz try at ur end.

Try to use // for / in datastage.. Like/

Select bytereceived//sec...

Hope this helps..

Are you reading any Oracle CLOB field?? where CLOB needs to transforms to XML..

Hi Is there is any way I can get the stage type and stage names used in Datastage job.

I know the command which goves stage names used in job but is there is any command to get stage type in job.

Hi,

I have target as sequention file stage, fixed width, now I need to wite data in UTF-8 format. so How can I do it.

Congratulations and Thanks for your help from the years.

Hi Ray,
Thanks for your response.

You mean \n ?

Thank you.

Hi everyone I have a requirement. My source file contain 3 types records Header follows with Item and Control records. Every file contain N number of these record sets. My requirement is after every set of these records I have to generate an empty line. Below is the example. Can anyone help me on th...

Hello, Iam Trying to Convert a Decimal 13,5 Field to Decimal 9,5 in Data stage 7.5 Transformer stage. I have used DecimalToDecimal Function , Converted to String then back to decimal etc ., but the output is coming with all zero values in it . Also tried using Modify Stage . No +ve result :( Some on...