DSXchange

You can define isolation levels for transactions in ansi standards. But before that, you need to check whether your job locks the table within itself. i.e. even if no other job is running which can lock them against yours. If that is the case, you may have to change your design. Sai, because of som...

You can define isolation levels for transactions in ansi standards. But before that, you need to check whether your job locks the table within itself. i.e. even if no other job is running which can lock them against yours. If that is the case, you may have to change your design. Sai, because of som...

Try resetting the job after it aborts. You may have to reconsider your job design to avoid locking. Hi Sai, Thanks for quick response. While running my job some are locking the table while updating,how can i tell with datastage hey wait some time like that. are there any transaction handling techin...

Hello sirs,

My Job failed beacuse of Locking table please advise me how to set the job
means i have to set some properties,i am using ODBC Stages.

Please advise me.

Thanks in advance.

Thanks
Narasa

Since the sequential file stage only allows one delimiter you can't do it in just one step. I would write a job that defines this sequential file as having one column and no field delimiters at all. Run this stream through a transform that does a REPLACE of all pipe and single-quote characters into...

Hello Sirs,

I have a Sequential file with some fields delimiter vertical bar and few fields with vertical and double quotes,How to handle it.

Please advice me.

Thanks
Narasa

Hello Sirs, Currently my Client having 7 projects For each mart they created one project even for Misc also...........Now they want me to do Version control for all these projects.What i observed is they don't have dev/test environment for each project. Can you guys give me ideas how to set up versi...

A hash file is just like a database/table - if different developer point to the same file they will share it's contents; and by importing the column metadata into manager and using that definition it's description can also be shared. Arndw, I created a hashfile with Account named as sales but some ...

Hello sir,

How to make hash files reusable means i am created one hash file it can be used by other developers also,please provide me steps.

Thanks in advance.

Thanks
Narasa

Ah. I missed the 'only have a Production environment' part for some reason. :( So Ray is right that you'd need to use the Production project to seed the development project. The default project name for Version Control is VERSION , however it can be pretty much anything you like nowadays. I'd sugge...

Sir, In my Client place rightnow we have only one common environment (Production),now we need to make it as Dev/Test/Prod environments we have only one Server box license,i need to version the production jobs also.we are using 7.5 on windows.i have to install version control also. 7.5 comes with ve...

Sir, In my Client place rightnow we have only one common environment (Production),now we need to make it as Dev/Test/Prod environments we have only one Server box license,i need to version the production jobs also.we are using 7.5 on windows.i have to install version control also. 7.5 comes with ve...

Sir, In my Client place rightnow we have only one common environment (Production),now we need to make it as Dev/Test/Prod environments we have only one Server box license,i need to version the production jobs also.we are using 7.5 on windows.i have to install version control also. 7.5 comes with ver...

Hi Guys,

How can i use Oracle Sequences in Datastage jobs????

I am new to datastage.

I would appreciate your help.

Thanks
Narasa

Hi Sai, Can u please let me know what did u mean by sharing this work area across would be best for large volumes. Hello Sirs, Some households will have 100 records also then how rowproc will work. Please don't consider there is only 2 records per householdid. Please give details how to deal with 6...