DSXchange

just you can change the datatype for the field var2 is decimal(16,2) where 2 is scale, i hope it might works in your situation.

sorry it was 7.5.1, i know how to install client components,but iam having a bit of confusion to install server components on sunos console.

Hi, could you please any one explain me the steps to install datastage on my pc. i have installed windows 2003 server and sun o.s operating systems on my pc, i just planned to install datastage server components on sun os operating system and client components on my windows machine, any one explain ...

No specific syntax I believe. As the manual suggests, you can type in the delete command sql you want to run in the Open command option. You should enclose the sql in single quotes. Try and let us know. HI, I tried the sql statement in single codes but its throwing error like Oracle_Enterprise_25,0...

h thanks,

could you please tell me is there any syntax to follow with open command

Hi, One advice. Instead of 2 jobs and a sequence, you can use the Open command Option in the Oracle Entreprise stage to delete the rows before inserting them. There are lot of posts in this forum about Open Command Option. thanks for responding , could you please tell me where can i use this open c...

hi all, ihave an reqirement with some destructive tables(data which is not incremental),so each and every time i need to truncate the data in table and then it should be loaded.i dont have replace privilages wit in the datastage,so far i create three jobs 1)delete data into table 2)load data as per ...

hi all,

any one give me the way of creating DSN through unix console.

thanks in advance

No ray,

my job is having the parameter NLS_MAP ,i set default value for that one is ISO8859-1,earlier it works fine,now i got a new data,which is not working with the new data.

HI all, in my ds job i have a source file with delemited pipe,when i view the data in sequential file stage which is throwing the follwing error message. FATAL ERROR (APT_CharsetConverterRep::initConv()): #NLS_MAP# is not a valid codepage. i used NLS_MAP as ISO8859-1 . could ypu please any body sugg...

No. Have them justify their assertion with evidence and do share it with us. ... hi ray, even if i tried outer join with joiner stage for four tablesand also i specified partitoning method auto,which is not giving all the records from left table its throwing some additional records out. basically D...

thanks fro respond, i tried with join,but basically what happen when i join four tables with join stage as left outer which is not giving adequate records to target.some one told "we are not supposed to use joiner stage while doing outer join with more than one reference is this true? i dont th...

hi , i have an one reqirement to join 5 tables based on a same field,i have to use 5 different oracle stages and one join stage in these tables the main table having around 1.5lac records remaining tables having more than 4 lac ,i tried with joiner stage as left outer join where main table is left t...

yes, we can call the datastage jobs through java/.net. once you deploy the code into web services through information server,then you need to create a java/.net screen by using that WSDL link/WEB SERVICE and then converted it into JSP. what ever the parameters you have used in your datastage job,you...

Use a sequence generator stage