E9.2 Create a table dinamically is possible in jde?

brenao

Member
I'm thinking of a solution that parses a .txt file, creates a table and inserts values into it. But I don't know if there's a way.
I kind want to make it generic. Is there any BSFN that create tables dinamically?
 

Rauf

VIP Member
You can do as follows:

1. Create a table using OMW (F55TMP01)
2. Generate it.
3. Parse the .txt file to the table.
4. Once completed your logic, delete the records from the table.

So this table acts as a temporary table.
 

MarcSant

Active Member
In JDE, a table is a fixed entity: you need design, put the columns and indexes BEFORE using it. For that your requirement, maybe you can use cache. It's like a table, but, only in memory.
 

Rauf

VIP Member
In JDE, a table is a fixed entity: you need design, put the columns and indexes BEFORE using it. For that your requirement, maybe you can use cache. It's like a table, but, only in memory.
Can we use cache with NER ( not C ?).
I need to try caching. I have never tried it.

If there is any documents which you used before, kindly share the document ID so that I can get it and start learning.
 

BOster

Legendary Poster
JDECACHE APIs are C only. You can create some very simple reusable general use BSFNs that use JDE cache that can be called from ER (I have a couple of general purpose ones) but for the most part most JDECACHE implementations are going to be purpose specific.

To the original poster I believe there are C APIs to create a table - how extensive they are I don't know since I have never used them... only seen them in passing. Regardless if there are or are not APIs to dynamically create a JDE table, if the do in fact exist they almost certainly should not be used as they are probably meant strictly for tools level type code.

As Scott Beebe asked, maybe post the use case for some alternate ideas on potential design.
 

Kim Schmidt

Well Known Member
Brian is correct - the tools programs are used specifically for ESU and Special Instructions where it can populate tables for you , such as UDCs. As I undestand, the source text is in XML format. It would likely be a very deep dive into the workings of JDE tools to repurpose this code for other uses.
 

MarcSant

Active Member
Can we use cache with NER ( not C ?).
I need to try caching. I have never tried it.

If there is any documents which you used before, kindly share the document ID so that I can get it and start learning.
Sorry for delay in answer. I don't know why I never got an email in response...

Anyway, a Cache is a C only program.

It's not hard do develop, once you know what you're doing.
 
Top