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)...
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: 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 | ||||
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 | ||||
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 |
Code400 -The Support Alternative Statistics
Collapse
Topics: 15,796
Posts: 92,617
Members: 9,465
Active Members: 11
Welcome to our newest member, smarianakis.
What's Going On
Collapse
There are currently 17 users online. 0 members and 17 guests.
Most users ever online was 1,863 at 12:34 AM on November 5, 2023.
Latest Topics
Collapse
-
by JustPassingHello,
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.-
Channel: SQL
1 week ago -
-
by MFisherI 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...-
Channel: SQL
2 weeks ago -
-
by mlopez01We 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...-
Channel: RPG/RPGLE
2 weeks ago -