Login Enter your username and password to login. If you do not have a username you can register one. Username:  Password:  Remember Me Forgotten Password? Online 6 members and 14 guests have been online with in the last 10 minutes. Hot Topic No posts have caught fire as of yet.

JD Edwards® Enterprise One / One World Discussions >> JD Edwards® EnterpriseOne Developers Previous   Index   Next   Threaded   Pages: 1 DBohner member Reged: 01/17/01 Last on: 09/01/10 Posts: 1701 Loc: Meridian, ID QTemp for other DataBases?       #155486 - 02/08/10 07:27 PM Edit   Reply   Quote   On the iSeries - there is a memory area called QTemp. Normal uses for Qtemp are creating work files or accessing data that is only specific to the job that is running. For example, an iSeries CL may create an override or table in QTemp, then call a report that access those items in Qtemp. When the job ends - QTemp just vanishes. Is there something like that in Oracle or in MS-SQL? (db) -------------------- Daniel Bohner Independent E1 Developer | Consultant Member - iConsortium www.ExistingLight.Net | drbohner@existinglight.net | Phone 208.991.2595 Worked on EVERYTHING Post Extras:       JMR member Reged: 03/10/02 Last on: 09/08/10 Posts: 475 Loc: Minneapolis, MN Re: QTemp for other DataBases? [Re: DBohner]       #155487 - 02/08/10 09:12 PM Edit   Reply   Quote   DB, Not that I am aware. You've started a couple of threads lately that have me missing some of those nice iSeries features (OVRDBF, QTEMP). I do miss that system sometimes. Quit remindin' us former 400 developers about the love we lost since moving to E1 -------------------- Jeremy E1 Consultant Minneapolis, MN Post Extras:       WhippingBoy member Reged: 06/15/01 Last on: 08/10/10 Posts: 574 Loc: Colorado, USA Re: QTemp for other DataBases? [Re: JMR]       #155570 - 02/10/10 11:30 AM Edit   Reply   Quote   Erg. . . I sure don't miss the 400, or the quirky solutions that IBM came up with. I'm generally happy to be done with the thing. Specialized solutions are always a headache when an iseries is involved. The real hamstringing comes from E1 entirely, unless you're willing to write A LOT of code. Temporary tables and 'what-not' are entirely possible in SQL. You can create tables, with definable columns and whatever, any time you want. The problem is how E1 holds your hands and expects everything to be 'defined elsewhere'. Get hold of a SQL dev guide and marvel at all the things you're 'protected' from in E1. Now, try to find a client that will let you write code that exists outside of E1 that can leverage all that beautiful power. -------------------- Darren Ricciardi - E-One Whipping Boy Senior Director, Technical Development Advanced Logistics Consulting Instructor, Oracle University Home of OCODE: http://www.ocode.net Post Extras:       JMR member Reged: 03/10/02 Last on: 09/08/10 Posts: 475 Loc: Minneapolis, MN Re: QTemp for other DataBases? [Re: WhippingBoy]       #155583 - 02/10/10 01:55 PM Edit   Reply   Quote   D, I hear you and I agree about the limitations that E1 places on us as developers. Maybe that's what I'm truly missing about the 400. The OS and the DB and the developer tools are all transparently connected. JDE objects are just like any other objects in the system. Green screen aside, as a business platform, that machine was nice to work with. -------------------- Jeremy E1 Consultant Minneapolis, MN Post Extras:       Sebastian Sajaroff member Reged: 03/01/05 Last on: 09/08/10 Posts: 1065 Loc: Montreal (QC) Canada Re: QTemp for other DataBases? [Re: DBohner]       #155584 - 02/10/10 02:09 PM Edit   Reply   Quote   Hi, SQL Server offers that same functionality. It's clearly explained here : http://www.programmers-corner.com/article/76 -------------------- Sebastian Sajaroff CNC - B7321 to E812 Post Extras:       DBohner member Reged: 01/17/01 Last on: 09/01/10 Posts: 1701 Loc: Meridian, ID Re: QTemp for other DataBases? [Re: Sebastian Sajaroff]       #155586 - 02/10/10 02:43 PM Edit   Reply   Quote   Thanks, Seb! I needed to be able to see that! (db) -------------------- Daniel Bohner Independent E1 Developer | Consultant Member - iConsortium www.ExistingLight.Net | drbohner@existinglight.net | Phone 208.991.2595 Worked on EVERYTHING Post Extras:       Pages: 1 Previous   Index   Next   Threaded   Extra information 5 registered and 4 anonymous users are browsing this forum. Moderator:  Sef, ekempter, Christian Audet, jdecnc  Print Thread Forum Permissions       You cannot start new topics       You cannot reply to topics       HTML is disabled       UBBCode is enabled Rating: Thread views: 278 Rate this thread 1 star 2 star 3 star 4 star 5 star Jump to *Job Opportunities* -----   Job Opportunities*JD Edwards® Enterprise One / One World Discussions* -----   JD Edwards® EnterpriseOne Applications   JD Edwards® EnterpriseOne   JD Edwards® EnterpriseOne Developers   Downloads*JD Edwards® World™ Discussions* -----   JD Edwards® World™ Applications   JD Edwards® World™*Fusion Discussions* -----   Fusion Apps*JD Edwards Community Forums* -----   User Group Announcements   JD Edwards® EnterpriseOne Applications for French-speaking users*Third Party Application* -----   AS/400 / iSeries / i5   BI Publisher   Citrix   Create!form   Crystal Reports   Everest Software   Formscape   ITera   Optio   Others   Vertex*General Discussion* -----   Off Topic / Help   Site News / Frequently Asked Questions   JD Edwards® EnterpriseOne Tips and Traps

UBB.threads™ 6.4.1

 .: IIP 5.4.5 by David Lozier ©2003 :. 
Distributed by ThreadsDev.com