DSXchange

Hi All,
Can anyone tell me the difference between @OUTROWNUM and @INROWNUM? I have used both variables for sequence number generation and I dont find any difference between them. Can anyone help me on this?

Thanks,
Bala

Hi All, We are using DataStage 4.2 running on UNIX machine. I want to execute a Script on UV database as before job Subrouting using ExecTcl option. Say for example, I want the before job subroutine as ExecTCL : LIST DS_JOBS I know that we can do the samething in job control using DSExecute function...

Thanks Klaus. Again I need one more help. I knew that the following are the various Types of hashed File. But can you please explain little further? most variant on right means ??? Is it based on key column values??? Numeric, most variant on right Numeric & Seperators, most variant on right 64 c...

I have found that each hashedfile contains two files in server

1) DATA.30
2) OVER.30

Can anyone explain about this? Is OVER.30 something related the OVERFLOW of Hashed file?

Thanks,
Bala


God is an Infinite Circle whose Centre is Everywhere but Circumference is Nowhere

I heard that ActiveX dll can be used in custom Routines. I have gone thro the document but there is not enough information about that. Can anyone please explain me about the usage of DLLs in DataStage? Also, if possible give me an example/sample DLL and its usage? Thanks, Bala God is an Infinite Cir...

Hi, I have created a simple job which contains 2 OCI plugins and one Transformer. The job is very simple: Populate the record from table A to Table B thro Transformer. I am using DataStage V4.2. I have tried to run the job but I have got the following error: HistDelIwSoLine.DWDB_IW_SO_LINE: ORA-0140...

Hi All, I have used Hashed file plugin in DataStage jobs. But I dont have any idea about CREATE.FILE <hash_file_name>. If i create a hashed file using the above syntax in Job Control, then is it possible to access the same file using plugin (HashedFile Plugin)? What is modulo? Since I have used only...

Is it possible to develop new metabrokers in MetaStage for tools not currently supported by MetaStage? If yes how?

Bala

Is it possible to develop new metabrokers in MetaStage for tools not currently supported by MetaStage? If yes how?

Thanks for ur response.

Is there any precautionary measure to avoid such thing in future?

Bala

God is an Infinite Circle whose Centre is Everywhere but Circumference is Nowhere

Hi
Can anyone explain me about the packager wizard in DataStage and where to use that package and what is the purpose/advantage?

Bala

God is an Infinite Circle whose Centre is Everywhere but Circumference is Nowhere

Hi All, We are using DataStage V4.1 on UNIX. There is one job called ControlJobTgtSvcConfig which is missing in DataStage Director and it throws an message box saying "ControlJobTgtSvcConfig: RT_STATUS Record for wave 20 not found". But the same job is present in DataStage Manager. I tried...

Hi All, We are upgrading DataStage 4.0 to DataStage 4.2 . Can anyone send me the steps & Precautionary measures to be followed while upgradation? Also, will there be any compatibility issue? Our DataStage server is UNIX. God is an Infinite Circle whose Centre is Everywhere but Circumference is N...

Does Datastage provide Adapters to talk to Middleware EAI tools - TIBCO, SEEBEYOND, IBM MQSeries ?

Can I get any documents for that???

Thanks in Advance



God is an Infinite Circle whose Centre is Everywhere but Circumference is Nowhere