This crosses over a couple of areas and I'm not sure if my problem is within the VIEW, the FUNCTION or the way we have Lmi set up.
We use Rocket DevOps core for IBM i Rel 10.2 - green screen version for our coding and implementation.
I've been asked to create an SQL VIEW that uses...
Collapse
Please log in to your account to view your subscribed posts.
Directory | Topics | Posts | Last Post | |||
---|---|---|---|---|---|---|
Tips, Techniques, Tools & Announcements | ||||||
Announcements
Open forum to post Events
Topics: 35
Posts: 123
|
35 | 123 | ||||
Other useful websites
Lists of other websites related to coding on the Iseries.
Topics: 88
Posts: 344
|
88 | 344 | ||||
Iseries Tools
Links/Reviews of products on the AS400
market. Some may contain free trial versions. If you see something you have worked with please post your thoughts.
Topics: 273
Posts: 1,021
Last Post:
Unwanted breakpoints
|
273 | 1,021 | ||||
Tips for the IBMi
Enter/View Iseries Tips Techniques and Tricks.
Topics: 290
Posts: 1,442
Last Post:
Examples SFTP transfer on ISeries
|
290 | 1,442 | ||||
Iseries Programming Languages | ||||||
Freshers
We enjoy helping NEWBIES learn what has been so good to us over the past ..Oh 100 years or so... So feel free to post any/all BASIC questions to this forum.
Topics: 482
Posts: 3,428
Last Post:
RPGLE not returning results
|
482 | 3,428 | ||||
RPG/RPGLE
RPG/RPGLE Code Forum
Topics: 4,756
Posts: 30,860
Last Post:
Using on-excp with diagnostic message
|
4,756 | 30,860 | ||||
SQL
command line and embedded sql
Topics: 1,964
Posts: 11,889
Last Post:
Convert iAccess SQL Script to a program
|
1,964 | 11,889 | ||||
CLP/CLLE
CLP/CLLE Code Forum
Topics: 1,186
Posts: 7,113
Last Post:
Submit job with different user
|
1,186 | 7,113 | ||||
DDS
subfiles,screens, physical files, logicals, print files and menus
Topics: 770
Posts: 4,250
Last Post:
Recover PRTF DDS ?
|
770 | 4,250 | ||||
COBOL
COmmon Business-Oriented Language.
Topics: 156
Posts: 688
|
156 | 688 |
by Brian Rusch
September 6, 2022, 11:14 AM
|
|||
PHP
RPG commands and functions show with
their PHP equivalents ....
A great resource would be
directly from the horses mouth...
http://php.net/
Topics: 96
Posts: 500
Last Post:
Zend Server 2020 V7R4. also is still free ?
|
96 | 500 | ||||
AS400 REPORTS
Anything to do with AS400/Iseries reports.
Topics: 346
Posts: 1,926
Last Post:
Printee file problem
|
346 | 1,926 | ||||
ANY THING GOES
Whatever crosses your mind.
Topics: 1,504
Posts: 8,122
|
1,504 | 8,122 | ||||
IFS
Anything dealing with IFS
Topics: 355
Posts: 2,061
Last Post:
File names in IFS folder
|
355 | 2,061 | ||||
Iseries System administration
Anything that deals with system administration.
Topics: 1,038
Posts: 5,238
Last Post:
Retrieve IP address of connected device?
|
1,038 | 5,238 | ||||
Sub-Forums:
| ||||||
DB2
general questions about the database.
Topics: 233
Posts: 1,106
Last Post:
TM - trademark on database
|
233 | 1,106 | ||||
/Free format
Free format examples
Topics: 162
Posts: 1,162
|
162 | 1,162 | ||||
JAVA
JAVA coding forum
Topics: 249
Posts: 1,139
Last Post:
How set libray list in runjava
|
249 | 1,139 | ||||
HTTP
web development using HTTP on the Iseries
Topics: 197
Posts: 928
Last Post:
Write YAJL docNode to IFS
|
197 | 928 | ||||
PC programming as it relates to Iseries
Any questions relating more to a PC type environment. This could be PC, Servers (both LINUX and WINDOWS)
Topics: 229
Posts: 1,194
|
229 | 1,194 | ||||
ChangefIT/DeployfIT/DeskfIT/XrefIT | ||||||
ChangefIT/DeployfIT/DeskfIT/XrefIT News
Any news eminating from EcofIT regarding DeskfIT, ChangefIT, or XrefIT. These may be cross-posted to/from support.changefit.com
Topics: 70
Posts: 117
Last Post:
DeskfIT v2.02 released
|
70 | 117 | ||||
ChangefIT/DeployfIT/DeskfIT/XrefIT Questions
Any general questions about DeskfIT, ChangefIT, or XrefIT may be posted here. These may be cross-posted to/from support.changefit.com
Topics: 14
Posts: 57
|
14 | 57 |
by DeadManWalks
June 10, 2015, 01:43 PM
|
|||
RDP/RDi/WDSC | ||||||
RDP/RDi/WDSC - Tips & Tricks
Show us what youve learned. Teach us old dogs some new tricks..
Topics: 244
Posts: 1,184
Last Post:
Printing a source compare
|
244 | 1,184 | ||||
Job Postings | ||||||
Opportunities
Please place all job related posts here. Job posting that are not posted to this forum will be deleted.
Topics: 80
Posts: 232
|
80 | 232 |
by pnrperera
December 25, 2022, 03:08 PM
|
|||
OFF Topic | ||||||
Whatever (not programming related)
Just about anything is game here!
Topics: 838
Posts: 6,045
Last Post:
Hackers Took Over ?
|
838 | 6,045 |
Code400 -The Support Alternative Statistics
Collapse
Topics: 15,718
Posts: 92,323
Members: 9,461
Active Members: 29
Welcome to our newest member, riki3123.
What's Going On
Collapse
There are currently 70 users online. 0 members and 70 guests.
Most users ever online was 1,863 at 12:34 AM on November 5, 2023.
Latest Topics
Collapse
-
by mgarczynskiWe have audit journaling turned on and recently encountered an issue with an error writing to the log. The message stopped all DB operations until it was answered. We purged our journal receivers using a SQL script provided by IBM. They suggested we run this periodically so I wanted to create a pro...
-
Channel: SQL
4 days ago -
-
Programmers.io Team have composed a new eBook to help professionals access essential resources to navigate the rising challenges. “Our ‘A Developer’s Guide to Mastering IBMi Concepts’ eBook combines practical and theoretical knowledge in one place to help professionals gain hands-on...
-
Channel: Announcements
5 days ago -
-
by VikingI have a view and would like an index (key) on it, but we can't create an index on a view.
I was reading about materialized views where you create a table from an SQL statement and you can create an index on that.
So, can I create a (materialized view) table with a select of...-
Channel: SQL
1 week ago -