Hello
I got a CLLE OVRDBF + OPNQRY file
OVRDBF FILE(FILE) OVRSCOPE(*CALLLVL) SHARE(*YES) SEQONLY(*NO)
OPNQRYF FILE((FILE)) OPTION(*INP) FORMAT(FILE) +
QRYSLT(' FIELD1 < 0 *AND FIELD2 *LT (' +
*CAT &VAR1 *CAT ') +
KEYFLD((FILE3)) OPNSCOPE(*ACTGRP)...
No content found
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: 37
Posts: 125
Last Post:
IBM i Build Tool: OBI (Object Builder for i)
|
37 | 125 |
|
|||
|
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: 274
Posts: 1,024
Last Post:
EHLLAPI in Excel 64-bit
|
274 | 1,024 |
|
|||
|
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: 483
Posts: 3,438
Last Post:
Journal of file lock ?
|
483 | 3,438 |
|
|||
|
RPG/RPGLE
RPG/RPGLE Code Forum
Topics: 4,784
Posts: 30,997
Last Post:
Ovrdbf + opnqry + read(e)
|
4,784 | 30,997 |
|
|||
|
SQL
command line and embedded sql
Topics: 1,977
Posts: 11,927
|
1,977 | 11,927 | ||||
|
CLP/CLLE
CLP/CLLE Code Forum
Topics: 1,194
Posts: 7,145
Last Post:
Sql400
|
1,194 | 7,145 |
|
|||
|
DDS
subfiles,screens, physical files, logicals, print files and menus
Topics: 773
Posts: 4,257
|
773 | 4,257 |
|
|||
|
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: 349
Posts: 1,931
Last Post:
Does CCSID affect Print File Output ?
|
349 | 1,931 |
|
|||
|
ANY THING GOES
Whatever crosses your mind.
Topics: 1,507
Posts: 8,138
Last Post:
Giovanni Perotti
|
1,507 | 8,138 |
|
|||
|
IFS
Anything dealing with IFS
Topics: 356
Posts: 2,065
Last Post:
Copy file to IFS
|
356 | 2,065 |
|
|||
|
Iseries System administration
Anything that deals with system administration.
Topics: 1,044
Posts: 5,254
Last Post:
Install Git on V6R1 system?
|
1,044 | 5,254 |
|
|||
|
Sub-Forums:
| ||||||
|
DB2
general questions about the database.
Topics: 235
Posts: 1,110
Last Post:
Repository Database
|
235 | 1,110 |
|
|||
|
/Free format
Free format examples
Topics: 162
Posts: 1,162
|
162 | 1,162 |
January 17, 2022, 12:45 PM
|
|||
|
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: 198
Posts: 933
Last Post:
Numeric field error reporting in YAJLINTO
|
198 | 933 |
|
|||
|
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 |
June 15, 2023, 03:39 PM
|
|||
| 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: 249
Posts: 1,198
|
249 | 1,198 |
|
|||
| 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: 839
Posts: 6,046
|
839 | 6,046 |
|
|||
-
1 week ago
-
Hello,
My current company has programmation rules. We have been asked to only use LIMIT x and not FETCH FIRST x ROWS. However, no concrete reason was given. Does anyone know if there is a difference ?
Thanks.1 week ago -
I get an error trying to compile this code. The problem is with DAYNUM , but I don't see what's wrong. It is defined a 3,0 in an earlier step.
Field YEARY is an alpha string, and I want to pull out a value at position = DAYNUM
Not allowed to use a variable in SUBSTR ? O/S = V7...2 weeks ago -
We have a 5Mb varying length field that was being appended to by something similar to this:
longField += %trim(field1) + ',' + %editc(amt: 'J') + ',' + %trim(field2) + ...
This took quite a long time to complete.
When we changed it to a single shorter varying...2 weeks ago