DSXchange

Hi All, Why do we need DRS stage? Can't we use the existing native stages for their respective databases? Is there any specific on using DRS? Does it effec any kind of extraction or loading process? If my DB is DB2 on EPM, do i have to use DRS only or can i go with DB2UDB stage? Are the OraOci, OraB...

Hi vmcburney,

It worked !! Thats why, information is more valuable

Thanks Chulett,

Let me reinstall server with new Auth code. I will update you once i done with that.

chulett wrote:Are you trying to do it as the dsadm user?

At worst case, you can do a 'reinstall' of the server with the new auth code.

I am using admin user only.
Is there any way we can chage through command prompt?

If i reinstall, will i loose my exixting projects?

Hi We are trying to update keys of DataStage V 7.1 But for some reason, we cann't able to open general tab, where we used to change key settings.(change the old key):shock: Is there any way :idea: we can update it. Please help me :arrow: :!: Errors :!: serial number 'xxx' license expired on '09 Jan ...

Hi ArndW, srinivasulu and Chulett, Ur ideas are really appriciated but the situation here is different :( . If i drop the table, i will be loosing all references :!: and constraints on it. I believe, srinivasalu suggestion looks better here, but to my feeling, this is not the all time solution. What...

Hi ArndW,

Its have searched and found some kind of mechanism to invoke unix script from SP, but it is really sloopy...

Is there any other way i can achieve the same thing with in dataStage.

Hi Chullet

chulett wrote:Truncate. Or drop and recreate. Or ask your friendly neighborhood DBA to do it for you.

once the table is emptied - will you be loading the records back?

There is arround 20 million records and i need to delete all records older than 2005 march.

Hi, Is ther any way i can delete 18 million records with without using trancate. I can't use trancate as my DBA was like that. The delete statement will definetly squaze our DB. Is there any other way to accomplish this task.. I can drop the table, but there are many referential integrities over the...

Hi, I have one questions :shock: . Please don't ignore it. :cry: If DataStage is on one server and Oracle DB is on one server, I want to run unix script from oracle by using DataStage. Either the script on Oracle or DataStage server. Please give me some idea :idea: .... If you didn't understand my q...

The size you choose for your array is dependant upon your allocated DB/2 buffer size. I think that this is 4096 Bytes, the array size should be computed by the following formula INT(<DB Buffer Size>/<record width>) . Choosing your array sizes of 100,000 is guaranteed to provide some incredibly slow...

Hi All, I would like to know about arrays in DataStage. ( source and targets stages). Is there any limit depends on system config, or it depends on configuring DataStage? If it is the case, where can i configure these settings. Every time i am running out of memory if i use array size over 100000 - ...

Hi thanks for ur quick response... but still i have one doubt that ..in that scenario if u have duplicate records it will work..as u explained in the example what happens to first record itself..the condition will not satisfy..right....for the second record it is ok... please clarify me .... thanks...

Restarting the server won't help at all. If you use an array of 24000 and the database server generates 24000 warnings, then DataStage will log all 24000 warnings. That's the DataStage philosophy; if you need to know about it, it will be logged. The way to remedy the situation is to prevent the war...

Hello friends, Is it possible to execute a Stored Procedure from DataStage which does not return any rows by calling it from either ODBC Stage or ORA 9I Stage? Any thoughts would be highly appreciated Yamini I believe, you can do it by ODBC stage. One of the advantage of ODBC is... can work with St...