Sitemap

Amicuk Programming Answers

Calculate mass data

2015-10-11   Views:0

Advertisement

Hi, i need to do mass data calculation. i have several table in the DB (oracle), and i need to perform some calculation on them. it's about 50,000 rows to modify. i don't want to do this in the DB. what is the best way to get the Data, hold it in the

Hi,
i need to do mass data calculation.
i have several table in the DB (oracle), and i need to perform some calculation on them. it's about 50,000 rows to modify.
i don't want to do this in the DB.
what is the best way to get the Data, hold it in the server, do the calculation, and then send the results back to DB ???

The replay answer
Advertisement
The best way to do it is probably in the DB, but if you're dead set against that, you can create a query and get the info over to you. It should all be returned as a ResultSet, which you can iterate and/or change to meet whatever you need. Then send the data back.
Again, I think you should just handle it all with DB commands.

Go to See the other 5 answers

Calculate mass data

Category:DefaultRelease time:2015-10-11Views:130

Hi, i need to do mass data calculation. i have several table in the DB (oracle), and i need to perform some calculation on them. it's about 50,000 rows to modify. i don't want to do this in the DB. what is the best way to get the Data, hold it in the[More]

Mass data handling in an Enterprise SOA

Category:DefaultRelease time:-0001-11-30Views:130

Hello together, i'm working on my diploma thesis with the title "Design of a service-oriented architecture based on SAP NetWeaver". For this work an enterprise service is designed to calculate a special price matrix (10x5) from a given price for[More]

Parallel processing of mass data : sy-subrc value is not changed

Category:DefaultRelease time:2015-10-11Views:130

Hi, I have used the Parallel processing of mass data using the "Start New Task" . In my function module I am handling the exceptions and finally raise the application specific old exception to be handled in my main report program. Somehow the sy[More]

Report Slow Due to Mass Data , Soln for Performance Tuning

Category:DefaultRelease time:2015-10-11Views:130

Dear All, I am making report with mass data so for this i have to put For All enteries in & Ranges at lodz of places. 1. For all enteries in is making my report works very slow. 2. If i change for all enteries by Ranges then if the no. of records are[More]

How to calculate first date and end date of this year in Query

Category:DefaultRelease time:2015-10-11Views:130

Hi Expert I want to calculate following dates with inputted date in query. I have no knowledge on ABAP and I just can create a query with simple logic. Could you teach me how to calculate following date? (If inputted date is April 12 2009) - First da[More]

Mass data load into SAP R/3 - with XI?

Category:DefaultRelease time:2015-10-11Views:130

Hi guys! I have an issue - mass data migration into SAP R/3. Is XI a good solution? It will be about 60GB of data. Or is there a better way of this data load? Thanx a lot! Olianhi, SAP doesn't recomment using XI for mass data migration and 60 Gb is c[More]

Best way to export mass data from SAP R/3 to non-sap system

Category:DefaultRelease time:2015-10-11Views:130

Hi, I have to transfer mass data from a sap R/3 system to a non-sap system. Any experiences to find the best solution/interface? Requirements: - fast - delta load ability Any help will be appreciated. Thanks, DetlefHI, Using Proxies is also a good op[More]

In AP invoice i need to make "Terms date " field to calculate the date automatically when i select the payment terms

Category:DefaultRelease time:2015-10-11Views:130

In AP invoice i need to make "Terms date " field to calculate the date automatically when i select the payment terms. How can i do this?Hi, You can select the Payment Term at PO Header Level. When you book an invoice, that Payment Term will auto[More]

Standard tcode for (mass) data change of internal orders or ... ??

Category:DefaultRelease time:2015-10-11Views:130

Hi! I really need some info if there by any chance SAP has standard transaction for mass data change of internal orders (more particular, distribution rules in settlement rule section, which can be found in <b>KO02 transaction</b>  ). I am try[More]

Automatic import mass data regional structure -  Program RSADRLSM01

Category:DefaultRelease time:-0001-11-30Views:130

Hello, regarding the automatic import mass data to the regional structure via program RSADRLSM02, we are working in order to replace our third party provider. That is why, we need to deleted all the data imported from the city file and the references[More]

How to calculate start date of the week based on week number ?

Category:DefaultRelease time:-0001-11-30Views:130

i need to get week number of the current date and based on that i need to calculate start date falling in the same week for last year. Eg. today is 31st week of year and 31st july date. so what will be the date on the 31st week of last year. i need t[More]

Hot
I've seen references to others asking similar questions but never a good answer. I have a process that outputs files into daily dated directories. In other words, my Inbound Direct name is dynamic. I would like BPEL to be able to pick up these files [More]
Hi guys, Just started using Indesign cs6 and for the life of me can not work out how to import transparent pngs. All transparent images I import have their background changed to a white background. The image import options has an option to use transp [More]
hi', I am designing work-flow for my application where Sales Manager(Human Task) will get one order and it is up to him to approve or reject. I want to fire different queries for when he approve or reject, please guide me how to achieve this. thanks [More]
the home button of my iphone 4 is not responding? any reason ? how to solve it?Ah, yeah water could be the problem. It depends on where the water went into the phone. Try this, turn the phone off and place in a bag of uncooked rice for a couple of da [More]
Okay, here's my three cents worth, Are you using Forte "Keep Alive" settings? If yes, you may simply have a time-out. While a partition is waiting for a reply from a database, it blocks and won't respond to anything, including pings to check if [More]
Can't get iphone to recognize itunes on my computer. do i have to use the original cord to connect? i can't find the cord. please advise.Do you mean that iTunes doesn't recognize your phone when you plug it into your computer using the usb to dock ca [More]
I would like to fix the 'container' that is light gray. It is not going full width span the way the containerWhite is. This is a very rough mock up of the building blocks, completely stripped down... I examined the code over & over, and in another co [More]
Hello, can anyone tell me the cause ? when i run the code below with -Duser.language=tr JVM environment, it works expected well. But when i run it with -Duser.language=en JVM environment then some words sorted wrongly? I've used collator for correct [More]
We now have 2 iPhones in our household--a 4s and a 5.  Since getting them, my spouse's texts (sent and received) keep showing up on my phone, but not vice versa.  We share an apple id (mine) in order for all of our devices to sync with itunes.  We ha [More]
Dear MII Experts, We are trying to integrate shop floor systems with SAP MII for discrete manufacturing industry. I came across the client has 70+ machines in the plant .the vendor is "DMG" Seimens HMI is installed on each machine . What are the [More]