We have a case where we want to get journal entries for "UPDATES" without actually updating the data. I thought running this would trigger a journal entry, but appears not to.
UPDATE TABLE_A
SET FIELD1 = FIELD1
WHERE STATUS = 'X'
When I run it, it says...
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,790
Posts: 31,014
|
4,790 | 31,014 |
|
|||
|
SQL
command line and embedded sql
Topics: 1,980
Posts: 11,938
|
1,980 | 11,938 |
|
|||
|
CLP/CLLE
CLP/CLLE Code Forum
Topics: 1,196
Posts: 7,149
Last Post:
"Self Update" not Triggering Journal Entry
|
1,196 | 7,149 |
|
|||
|
DDS
subfiles,screens, physical files, logicals, print files and menus
Topics: 774
Posts: 4,258
Last Post:
Ways to condtion FLDCSRPRG ?
|
774 | 4,258 |
|
|||
|
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,509
Posts: 8,141
|
1,509 | 8,141 |
|
|||
|
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,046
Posts: 5,258
Last Post:
Removing Temporary PTFs ?
|
1,046 | 5,258 |
|
|||
|
Sub-Forums:
| ||||||
|
DB2
general questions about the database.
Topics: 236
Posts: 1,112
|
236 | 1,112 |
|
|||
|
/Free format
Free format examples
Topics: 162
Posts: 1,162
|
162 | 1,162 |
January 17, 2022, 12:45 PM
|
|||
|
JAVA
JAVA coding forum
Topics: 251
Posts: 1,149
|
251 | 1,149 |
|
|||
|
HTTP
web development using HTTP on the Iseries
Topics: 199
Posts: 934
Last Post:
Help with HTTP Server config library list
|
199 | 934 |
|
|||
|
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 |
|
|||
-
-
We did a PTF update past weekend, and 1 of the temporary PTFs broke some applications trying to connect. I thought Temp PTFs could be fairly easily removed and without knowing which one, thought all 100 of them could be removed for now. But a consultant said not too, that it's too risky and could cause...1 day ago
-
HTTPAPI does not correctly parse the user and password from a URL, such as "http://user
assword@10.212.66.112:8080/auth/basic/".
The problem is the '@', which is a variant character and which has a different hex code on German systems.
I am not sure whether it is...2 weeks ago