Midrange News for the IBM i Community


Posted by: Jeff Masak
IT Developer
The Boldt Co
Appleton, WI
Alternative to Display files
has no ratings.
Published: 17 Apr 2014
Revised: 21 Apr 2014 - 1314 days ago
Last viewed on: 24 Nov 2017 (2329 views) 

Using IBM i? Need to create Excel, CSV, HTML, JSON, PDF, SPOOL reports? Learn more about the fastest and least expensive tool for the job: SQL iQuery.

Alternative to Display files Published by: Jeff Masak on 17 Apr 2014 view comments(7)

Are there any alternatives to using Display files to show users DB2 records?

Any help appreciated

 

Thanks Jeff

Return to midrangenews.com home page.
Sort Ascend | Descend

COMMENTS

(Sign in to Post a Comment)
Posted by: bobcozzi
Site Admin ****
Chicagoland
Comment on: Alternative to Display files
Posted: 3 years 7 months 9 days 13 hours 44 minutes ago

You mean something like SQL?

Posted by: jmasak
Premium member *
Appleton, WI
Comment on: Alternative to Display files
Posted: 3 years 7 months 9 days 13 hours 37 minutes ago

Have not worked to much with SQL, I need to replace this type of view for users

SQR001 SAMPLE SYSTEMS
Work With Prompt Codes

Type options press Enter
Options: 2=Edit 4=Delete 5=Display


Opt Type  ID      De!--script--ion
__  AGEG 0012 Ages Newborn thru 12
__  AGEG 1317 Ages 13 thru 17
__  AGEG 1820 Ages 18 thru 20
__  AGEG 2229 Ages 22 thru 29
__  AGEG 3039 Ages 30 thru 39
__  AGEG 4049 Ages 40 thru 49
__  AGEG 5059 Ages 50 thru 59
__  AGEG 6069 Ages 60 thru 69
__  AGEG 7199 Ages 71 and older
DEPT ACCT Accounting Department
DEPT HR Human Resources Department


F3=Exit F6=Add New

 

Posted by: Bret
Premium member *
Comment on: Alternative to Display files
Posted: 3 years 7 months 9 days 13 hours 9 minutes ago
Edited: Thu, 17 Apr, 2014 at 16:03:55 (1318 days ago)

it appears that you want the user to be able to make a selection, based on my interpetation of the screen shot.

if so, why is DDS NOT the ideal solution?

even with CLLE these days, you can use DDS to accept the User Action, then act on it.

you could use UIM and create a panel group, but it's been many years since i played with that.

another option would be to create a CMD GetKidAge, with the proper keywords passed to a CLLE. This is more elegant than DDS menus in CLLE and is easier to generate and maintain (in my opinion) than a panel group.

from any of the above, you could call an SQL or a Query/400 report that gives the results.

-bret

Posted by: bobcozzi
Site Admin ****
Chicagoland
Comment on: Alternative to Display files
Posted: 3 years 7 months 9 days 12 hours 11 minutes ago

You say " show users DB2 records" but the work with panel is a standard View/Edit/Delete one. You need those options? If not, there may be a solution. If so, then besides UIM (panel groups) or DSM (Dynamic Screen Manager) you're going to need a code generator or write it yourself.

Posted by: Viking
Premium member *
CA
Comment on: Alternative to Display files
Posted: 3 years 7 months 8 days 15 hours 59 minutes ago

Are you saying you want to replace a DDS-based green "work-with" screen with something else?  What about using something like CGIDEV2 to show them the screen in a browser instead?  Why do you need to "replace" the current screen?  A bit more background and details on the requirements would be helpful in order to give more meaningful answers.

Posted by: Paulster
Premium member *
Sweden and The Netherlands
Comment on: Alternative to Display files
Posted: 3 years 7 months 7 days 2 hours 38 minutes ago

Viking nailes it! Go learn php for the front end, sql embedded rpg accessing db2 tables for the back end and arrive in a place the community should have been many years ago.

Posted by: clbirk
Premium member *
Comment on: Alternative to Display files
Posted: 3 years 7 months 5 days 11 hours ago

Can't agree more of using php and doing all of it against your db2 files. Of course you could look at jwow which while I haven't installed, I saw some pretty neat "query" sort of stuff being done with the free version.

 

chris