topic Re: Create dynamically a table in Application Development and Automation Discussions

Create dynamically a table

Former Member — Thu, 13 Jul 2006 23:39:25 GMT

Hi,

How easy is it to dynamically create a table for a user to work on when the user is logged in into the system and then delete the processed table the next time the user logs in?

How would I do this?

Thanks,

Re: Create dynamically a table

RichHeilman — Thu, 13 Jul 2006 23:42:32 GMT

Hi Rob. What exactly is the user going to do with this table? Does it have to be written to the database? Can this table be manipulated during program execution only?

Regards,

Rich Heilman

Re: Create dynamically a table

Former Member — Fri, 14 Jul 2006 00:22:25 GMT

Hi Rich,

The table is to store some of the transaction records that have been processed during the time the user is working in a transaction code that uses the Exit FM. In a way yes they have to be a datase table. It is simply a temporary table to store the data and then it is no longer needed once the user exits, not only it is used for storing but also for rerieving data records from it whhile the user is processing this transacion code.

I am using the exit ZXRSAU01 to clear the data from the temporary database table, and it seems to work, but there may be a chance that another user is running the same transaction code and in the middle of processing the same thing, and to have another user to log into the system and then clear the data base table is not the way to design this.

So I am thinking of creating a temporary table dynamically for each user that is logged into the system for processing. I am not sure if this would be efficient.

What other approaches do I have?

Thanks,

Re: Create dynamically a table

RichHeilman — Fri, 14 Jul 2006 00:26:23 GMT

I think that I understand, but don't pretend to know your business process. I think I have an idea, but first, does the data in the db table have to be cleared everytime the user runs the transaction during the business day?

REgards,

Rich Heilman

Re: Create dynamically a table

RichHeilman — Fri, 14 Jul 2006 00:35:46 GMT

Also, are you sure that using an internal table will not work? You can pass it to the shared buffer when coming in/going out of the user exit.

Regards,

Rich Heilman

Re: Create dynamically a table

Former Member — Fri, 14 Jul 2006 00:37:16 GMT

Well... Not really because the data is then retrieved based on the combinations of data selections. I have thought about just clearing the table may be once a week, but I thought it would be efficient to clear it everytime a user uses this transaction code to process their data. To do clear it once a week, I would have to schedule a job, but to do it the other way, it would be user specific and less records that have to be searched by the Exit FM. So to answer your question - it is not required.

Regards,

Re: Create dynamically a table

RichHeilman — Fri, 14 Jul 2006 00:41:01 GMT

I agree, If you can do it without have a background job, then that's the way to go. I still don't full understand the process, but here is my idea.

In your db table, have a field for user id. Then in your function module only delete the records that correspond to the current user, or SY-UNAME. This way the user is only clearing the records that belong to him and not anyone elses. What do ya think?

Regards,

Rich Heilman

Re: Create dynamically a table

Former Member — Fri, 14 Jul 2006 00:49:01 GMT

I also have thought about this, and I think may be I should just to this simply rather than getting creative. Thanks,

Regards,

Re: Create dynamically a table

RichHeilman — Fri, 14 Jul 2006 00:51:04 GMT

Nothing wrong with being creative if you have the time and patience to work thru it. But sometimes I also rely on the KISS concept. Keep It Simple Stupid.

Hope it works out for ya.

Regards,

Rich Heilman

Re: Create dynamically a table

Former Member — Fri, 14 Jul 2006 00:57:50 GMT

By the Way... Is it possible to do what I orginally posted here? I just want to see if it is possible to create a Database table dynamically if the fields are known ahead of time. Have never done this before. It's not urgent. I am just wondering. Thanks

Regards,

Re: Create dynamically a table

RichHeilman — Fri, 14 Jul 2006 01:05:40 GMT

Yes, it is possible to create a database table at runtime, of course, it would be using the same code as SE11, but the problem is, that most(if not all) production systems are locked down to repository changes. So if you coded this in your DEV system and it works good, it will not work in a production environment where the system is locked down.

I have a test program which creates a structure in the data dictionary at runtime, but I did this only for personal knowledge, of course this code is not being used in any production program because of the reason above. I was not able to get the program to create a transparent table.

This is why we have internal tables.

REgards,

Rich Heilman