DSXchange

HI Check your DS lib file and the Oracle lib file ,make sure they are same in the bit num.If your ds lib file are ELF-64 shared object file,i think the oracle lib must be.You can use the file command to get the info. Hi, I'm installing and DS EE 7.5.3 on HP Itanium with OOSS HP-UX 11.31, before the ...

You are right.But if the sql has a where clause,when you use the partiton,the result will have repeated records.Maybe it is a bug. Ray, I think your statement is incorrect. When you have an Oracle stage in a parallel job there is an option for 'partition table'. By using this you can read in paralle...

Try to set the dataset to the sequence mode,then check if there are any rows. Hi, We are trying to read data from a dataset in one project which gets created in other project and the "update policy" property is "Append". When we read this dataset in our job, there are no records ...

Hi,maybe this can help you: Oracle direct path load compatibility It is not possible to perform an Oracle direct path load using an Oracle 10.2 client to an Oracle 9 server. Starting with Oracle 9i, the client version must be the same as or earlier than the server version. If you upgrade from an ear...

I think you can use a store procedure stage to resolve this

Apotluri wrote:I have a date from the inout source and I have to calculate the last date of the next month, Is there a function or a way to get this done?

Thanks, as always

in the unix platform,there is some command you can invoke directly to transfer a latin1 file to uat-8 file Hi, Our requirement is to ocnvert data from LATIN1 to UTF8 format? How can it be implemented throgh DataSage? Please let me know if we have any other way to approach this problem? Thanks, Nasim...

Do you set the invocation id? I have added a job in the scheduler two times,one i set the invocation id to 1,another is 2, so in the scheduler,i have two instance:jobname.1 and jobname.2 I added a job to the scheduler. Then I want to add another instance of that job to the scheduler but nothing happ...

i install the datastage in the windows platform,so it can not run the parallel job


maybe someone can help me,thanks

Hi all,

When i use the filter stage,can i use the bracket in the where clause?

for example,the where clause maybe like this: a = 3 or (b = 2 and c = 4) or (d=5 and e =6)

can this be ok?? thanks!