No announcement yet.


  • Filter
  • Time
  • Show
  • New Topics
Clear All
new posts
No content found
Show More
  • Filter
  • Time
  • Show
  • New Topics
Clear All
new posts
Please log in to your account to view your subscribed posts.
Directory Topics Posts Last Post
Tips, Techniques, Tools & Announcements
Open forum to post Events
Topics: 26 Posts: 114
26 114
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: 265 Posts: 1,003
265 1,003
Tips for the IBMi
Enter/View Iseries Tips Techniques and Tricks.
Topics: 287 Posts: 1,429
287 1,429
Iseries Programming Languages
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: 467 Posts: 3,338
467 3,338
RPG/RPGLE Code Forum
Topics: 4,581 Posts: 29,786
4,581 29,786
command line and embedded sql
Topics: 1,886 Posts: 11,444
1,886 11,444
CLP/CLLE Code Forum
Topics: 1,156 Posts: 6,963
1,156 6,963
subfiles,screens, physical files, logicals, print files and menus
Topics: 754 Posts: 4,154
754 4,154
COmmon Business-Oriented Language.
Topics: 153 Posts: 670
153 670
by JonBoy
RPG commands and functions show with their PHP equivalents .... A great resource would be directly from the horses mouth...
Topics: 96 Posts: 500
96 500
Anything to do with AS400/Iseries reports.
Topics: 334 Posts: 1,900
334 1,900
Whatever crosses your mind.
Topics: 1,463 Posts: 8,006
1,463 8,006
Anything dealing with IFS
Topics: 343 Posts: 1,995
343 1,995
Iseries System administration
Anything that deals with system administration.
Topics: 1,002 Posts: 5,125
1,002 5,125
V6R1 (8/27)
general questions about the database.
Topics: 225 Posts: 1,074
225 1,074
/Free format
Free format examples
Topics: 161 Posts: 1,146
161 1,146
JAVA coding forum
Topics: 245 Posts: 1,127
Last Post: RUNJVA Output in /
245 1,127
web development using HTTP on the Iseries
Topics: 178 Posts: 855
Last Post: Working with API
178 855
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: 228 Posts: 1,189
228 1,189
ChangefIT/DeployfIT/DeskfIT/XrefIT News
Any news eminating from EcofIT regarding DeskfIT, ChangefIT, or XrefIT. These may be cross-posted to/from
Topics: 70 Posts: 117
70 117
by kitvb1
ChangefIT/DeployfIT/DeskfIT/XrefIT Questions
Any general questions about DeskfIT, ChangefIT, or XrefIT may be posted here. These may be cross-posted to/from
Topics: 14 Posts: 57
14 57
RDP/RDi/WDSC - Tips & Tricks
Show us what youve learned. Teach us old dogs some new tricks..
Topics: 221 Posts: 1,127
221 1,127
Job Postings
Please place all job related posts here. Job posting that are not posted to this forum will be deleted.
Topics: 78 Posts: 230
78 230
OFF Topic
Whatever (not programming related)
Just about anything is game here!
Topics: 833 Posts: 6,026
833 6,026
Ghost +
by Ghost +

Code400 -The Support Alternative Statistics


Topics: 15,217   Posts: 89,868   Members: 9,281   Active Members: 86
Welcome to our newest member,

What's Going On


There are currently 44 users online. 1 members and 43 guests.

Most users ever online was 864 at 09:08 PM on January 21, 2020.

Latest Topics


  • mgarczynski
    Printing Date data types
    by mgarczynski
    I have some fields in my tables defined as Date Data Types. By default, the data types are set to 01/01/0001. On the display, I use keyword MAPVAL(('01/01/0001' *BLANK)) to display the field as blank. There doesn't appear to be a similar keyword for external Print Files. Anyone have any tips on...
    8 hours ago
  • JohnLewis
    UDTF receiving CLOB LOCATOR
    by JohnLewis

    I'm trying to create a User-Defined Table Function (UDTF) which receives 2 parameters: a CLOB_LOCATOR which is, for example, the full content of a UTF-8 text file and a VARCHAR(2) delimiter value which specifies what character(s) (e.g. x'0D0A') indicate a line break within the first...
    1 day ago
  • UserName10
    AJSP server fails to start
    by UserName10
    Tried to move an integrated web server webservice from http to https and received message about certificate not trusted. Eventually decided to revert to http and try again another day. Now I've got another problem, the http version of the webservice now fails. I've recreated it several times without...
    2 days ago
  • Vinoth
    SQL Rpgle - Fetch into Clob file - avoid null
    by Vinoth
    Check below example,

    Exec Sql Declare cursor c1 for
    Select fld1, fld2 from tempfile;

    Exec Sql Open c1

    Dow Sqlcod = 0;
    Exec Sql Fetch c1 into :Outfile; // clob file

    Problem when there are no records, the file is still created...
    2 days ago
  • Alexis.A
    Problem with interactive program and debbug
    by Alexis.A

    I have an interactive program that is not working properly.
    In my program, I fill in a temporary file (via SQL) and then I process the file.

    Here is the SQL :
    EXEC SQL insert into wfictmp1
    (wservic, wimmeub, wnumcop, wdattrt)
    select servic, immeub,
    2 days ago