I am searching for some documentation on the steps of how to...

[Kristi Carter]

I am searching for some documentation on the steps of how to set up a WebFOCUS report to export into an Oracle table. I am not having much success.

Anyone have any links to documentation they can provide

Thanks,

Kristi Carter

[Kristi Carter]

Basic question around this as well. From what I can find so far on this topic, it looks like the process of this will always DROP the table and recreate with new information. There is not an option to Insert into and keep existing records

Thanks,

Kristi

[Toby Mills]

Hi Kristi

There are a few ways for you to go here. One way, thats kind of heavy handed is to use MODIFY or MAINTAIN to insert a bunch of records youve got in a HOLD file.

You can also try to use bulk loading and other things in Data Migrator to help you.

Can you tell me if your report reads data from Oracle as well Like maybe youre building a summary report from some Oracle Tables - and youd like to hold that set of records (the summary report info) in an Oracle database table

If you can tell us the flow of what you want to do, itll help us get you some answers.

For those of you reading this - Im wondering if ON TABLE HOLD FORMAT SAMEDB might be an option

Also how many rows are we talking about inserting This might help us decide whether youd be better off doing a bulk load or not for efficiencys sake. What do you plan to use this data for (other reports I guess)

Thanks!

Toby

[Pawan Vuppala]

This will only work if its a new table

 

 

 

toby.mills:

 

ON TABLE HOLD FORMAT SAMEDB

 

 

MODIFY would be a better approach to INSERT/UPDATE based on some logic. Also, if you can handle everything in SQL PASS THRU thats another way.

[Kristi Carter]

Toby,

Thanks so much for you reply.

What I am looking to do is the following:

 

 

Run a Query/Fex file and insert the results into an Oracle Table including columns with no data, that will be used later for manual updates.

 

 

Create a form or option that will allow the end user to pull the data based on a date selected, and be able to modify and add values to the fields we included.

 

 

Once this is completed. then final reports and review will be developed and calculations will be added using the manually updated fields.

 

 

Note: We dont currently have MAINTAIN in our licenses to be able to use. I am hoping that we can still do these options without that.

We do have Data Migrator as an option, and I know I can at least get Stepp 1 completed through that, however this option is currently only done by another department so I am looking to see if I can do this maybe through MODIFY as you stated.

Any suggestions would be great.

Thanks,

Kristi

[NYCBabak .]

Without Maintain, thisll have to be an Oracle Form or some kind of an application youll have to write to collect the values from the user and update the rows. You need logic to deal with ADD UPDATE and DELETE. What kind of transaction processing volume are we talking about How many users, rows, et cetra.

[Kristi Carter]

Thanks for the clarification on being able to update using a form. I am going to need to go to a different direction and see if our Web Application team can possibly create something for us since we dont have MAINTAIN.

We should still be able to create a hold file and send to an Oracle Database using MODIFY or the functions within the User Interface though right

Thanks,

Kristi

[NYCBabak .]

Yes. If you create a MODIFY, depending on how complex your data structure is, you can INSERT, UPDATE and DELETE. You can also create HOLD files that can then be used by Oracle to load data. It all depends on the use case.

[Kristi Carter]

Great - at this point that is what I am looking to do. Do you happen to have any links to documentation or videos on how to get a MODIFY option to work to do this

Thanks,

Kristi Carter

[NYCBabak .]

http://documentation.informationbuilders.com/masterindex/html/legacy/ufp/xarc_modifyref.pdf

[Toby Mills]

Wow @nycbabak - what a find for the Modify manual!

[Kristi Carter]

YES!! Thank you so much NYCBabak.