AS400 files

[cschwobe]

Hi

We are in the process of converting our legacy COBOL/CICS programs that used DL/I to run on the AS400 using COBOL and KIKS. By just creating these tables on the AS400 should we now able to access them thru JDE or do we have to create these tables differently if we want to access them thru JDE.

Any help?

thanks

 

[eydeak]

JDE only knows about tables created using the JDE toolset. I'm not sure
what you want to do with these tables within JDE. If you are going to be
writing a JDE application or UBE, the table needs to be a JDE table. If
you are wanting to import data into JDE, you can write a JDE table
conversion which can access data in foreign non-JDE tables.



Ellen Deak

Senior Analyst/Programmer

Cooper Standard Automotive

OneWorld Xe Update 7 SP22_T, AS400 DB2 V5R2M0

 

[DBohner-(db)]

Re: RE: AS400 files

Ellen - JDE can learn about tables that are created outside the JDE Toolset... I call these 'Virtual Tables' and have used them in the past.

If the external table follows the JDE Naming Conventions for Field/Column Names and Field Types(DD) - you can create table specs in JDE that match/mock the structure of the table created outside of JDE. Once the table spec is created in JDE - DO NOT CREATE THE TABLE AND INDEXES - you don't want to overwrite the externally created table. I call this a Virtual Table. Make sure the OCM matches the location of the Externally Created table.

Another way - create a SQL View over the table. Create #55 Data Discriptions for the columns - and match those column names to the 'real' data column within the externally created table. Follow the process above - and it works...

Holler if you need more!

(db)

 

[eydeak]

RE: RE: AS400 files

Good Point. I wanted to find out more about what the questioner was
trying to accomplish before getting into too much detail.



Ellen

 

[cschwobe]

Re: RE: RE: AS400 files

thanks for your help.

Basically my question is this. We will have our warehouse system running on the AS400. One of the sequel tables in this system is our inventory by bins. I am wondering if I can write a JDE application to display this bin inventory. I would like this application to be in JDE because that is the system our customer service people use.

Can I do this?

 

[eydeak]

RE: RE: RE: AS400 files

Daniel's post gives you a good explanation of what you need to do to
make a foreign table seem like a JDE table.



Is your custom program only going to be doing inventory lookups? Do you
have an existing program that does the lookups already? You can call
non-JDE programs from JDE task views. If you already have a program that
does the inquiry function, you might want to call that program from the
JDE task view. It wouldn't have the look and feel of a JDE application,
but it would be simpler than doing the table trickery and writing a
custom application.



You've got a couple of paths you can follow, depending on what you want
to do with the data from inside JDE.



Good Luck,



Ellen Deak

Senior Analyst/Programmer

Cooper Standard Automotive

OneWorld Xe Update 7 SP22_T, AS400 DB2 V5R2M0, Citrix Clients

 

[cschwobe]

Re: RE: RE: RE: AS400 files

thank you very much we have gotten this to work. Now I have another question. Should we be able to update these tables from a UBE written in JDE?

It doesn't seem to be working

any ideas

thanks

 

[Loslo]

Re: RE: RE: RE: AS400 files

Hi,
You should use a table conversion to acces/insert data in a foreign table. Look at the documentation, that explains you how to do it.

 

[mkendrick]

Re: RE: AS400 files

I'm trying to use the 'virtual table' method in 8.10 and having no luck..

see this thread for an explanation

http://www.jdelist.com/ubb/showthreaded.php?Cat=0&Number=97516&page=0&view=collapsed&sb=5&o=&fpart=1