Problem in AS/400 string
hi i jaust want to put following string in a variable . arsdoc delete -h CSPAY -v -i “WHERE ZHSPCODE= ‘abc’” -f PRYW2E -G PRYW2E here i am picking ‘abc’ part from file .Suppose field is zhsp that contains this part.So string will look something like this : arsdoc delete -h CSPAY -v -i “WHERE [...]

Answer Question   |  November 15, 2011  4:14 PM
AS/400, CL variables, CLLE, String

When will AS/400 record lock?
Hi Guru’s , I am new to RPG . I would like to know when record will be locked ? Example-1 : PGMA, using a PF1(Physical file) in input mode , PGMB using a logical file based on PF1, in input mode. In this case record will be locked or not (using read or chain [...]

Answer Question   |  September 28, 2010  8:58 AM
AS/400 Records, Record lock, RPG Record Locks, RPGLE

Certificate not signed by trusted authority
We have been been communicating with Twitter from our iSeries. Recently Twitter increased their security and now required a digital certificate. We followed all the setup instructions but get this error on the green screen.  gsk_secure_soc_init() failed with rc = 6000 and errno = 0. 8 rc of 6000 means Certificate is not signed by [...]

Answer Question   |  May 6, 2011  11:39 PM
Certificate authorities, Certificate authority, Digital certificates, iSeries, iSeries communication, twitter

Find the Field Name in AS/400
When viewing the screen how can I see what the data field name is?   I am looking at the customer master screen, I see field I enter in cert# how can I find on the screen I am looking at what that field name is and what file it belongs to?

Answer Question   |  November 15, 2011  3:47 PM
AS/400 Fields, AS/400 Windows, AS400 Data Definitions, Field names

Communicate with a RS232 device in my RPG program
I need to retrieve the weight from a scale hooked to my PC with via RS232. I need to send the device a character(P) and which will trigger the scale to send back the weight. Thanks.

Answer Question   |  September 24, 2010  2:17 PM
AS/400, Electronic Data Interchange, RPG Program, RPGLE, V5R4

Can I install V5R3M0?
Hi friends, based on this Hardware I can install the version V5R3M0 on this machine ?:                        Display Processor Information                                                                                System type . . . . . . . . . . . . :   9406                      System model  . . . . . . . . . . . :   525                        System processor feature  [...]

Answer Question   |  September 24, 2010  4:47 AM
AS/400, V5R3, V5R3M0

Change management system for as/400
My client has two as/400 servers( one is for production and one is for development),he is asking me to suggest ‘Change management system for as/400 server. I found these are: TURNOVER ALDON IMPLEMENTER SEE/Change MDCMS PDE/400 i m more confused which is best in lesser cost with higher performance. Please suggest me or mail me [...]

Answer Question   |  October 8, 2010  2:44 PM
AS/400, AS/400 administration, AS/400 Management, Change management, iSeries change management

Apply Journal Change to Object of Different Lib
I got PF obj, in two Libs. I want to apply change into the second obj using the journal entries of first object. How can I do it??

Answer Question   |  September 25, 2010  12:10 PM
AS/400, AS/400 Library, AS400 physical file, Journaling, Physical Files

Users hidden in WRKACTJOB
What would cause a basic user’s job not to show in WRKACTJOB?  Could the Job Description on the User’s profile cause this?

Answer Question   |  September 25, 2010  9:16 AM
AS/400 errors, AS/400 user administration, iSeries User Profiles, WRKACTJOB, WRKACTJOB in AS400

Reorganization of V5R4 while active
We are currently on operating system V5R4. We are a 24/7 shop and as a result, I have not had the opportunity to do a lot of reorgs. I just discovered there is a reorg while active command. Can someone tell me how to use this? Does this come with the operating system or is [...]

Answer Question   |  September 23, 2010  5:22 PM
CL, CLLE, CLP, RPG, RPG ILE, RPG/400, RPGILE, V5R4

SQL RPGLE – How to override data set data structure at run time
I currently have an SQL RPGLE routine that receives a SELECT statement as a parameter and then fetches the data set into a data structure based on the file. This only works over a single file as the datastructure is created at compile time and has to be based on filea. I would like to [...]

Answer Question   |  September 23, 2010  1:43 PM
iSeries, RPGLE, SELECT statement, SQL, SQL Select statement problem, SQLRPGLE

DB2/400 basics
How will I find out total number of records in a DB file without causing any I/O operation?  Also How will I detect the existence of a record in a DB file without causing any I/O operation?  I think I can use INFDS and the field *RECORD but not sure how this works. Thanks, Nutan

Answer Question   |  June 15, 2012  11:33 AM
AS/400 DB2, AS/400 Records, DB2/400, INFDS

Identifying special characters when creating XML output
Hi Everyone, I’m in the process of creating xml files (using RPGLE) to send order details to our clients. One requirement is the need to replace (encode) special characters such as < > ‘”& No problem there, my scan can identify and replace where necessary. The problem arises with characters not native to IBM such [...]

Answer Question   |  September 23, 2010  11:30 AM
iSeries, RPGLE Program, XML, XML development, XML File Creation

RPG/400 Trigger Program
RPG/400 trigger program was suggested to develop a moving average computation. There’s a rule that needs to be followed when posting a record in the computation. One rule is that all credit transactions be first posted in the computation – Is this possible in a trigger program? How could I implement this rule?

Answer Question   |  September 23, 2010  1:02 PM
AS/400, AS/400 triggers, iSeries, RPG/400

CLLE – Openqry Files
Using opnqry files, we create any key field for physical file for temporarily usage.Instead of creating another logical can i create opnqry? Please give code

Answer Question   |  September 22, 2010  9:07 AM
AS/400, CLLE, CLLE - Opnqryf, Open Query, Open Query File, OPNQRY, Physical Files

OVRDBF help
Sir, Im less aware abt OVRDBF concept plz tell me When it is used?, If we Override one file then it is allowed in other program? When it is allowed when not allowed? Like that  , Explain me with Example ….   Thankyou in advance

Answer Question   |  September 21, 2010  5:34 AM
CL Commands, CLLE, Override with Database File, OVRDBF

Without using RCVF command can we retrieve AS/400 physical file
Hi frnds, I have two PF say as PF1 & PF2 and in the both files there are records such as Name, ADDR & PHNO: and now i want fetch data of repeated names in the both PF’s. But without using RCVF command can we fetch records or data… Thanks

Answer Question   |  February 26, 2011  1:25 PM
AS/400, AS400 physical file, CLLE, Physical Files, V5R4

Is there a 3rd party tool (or native option) for retrieving data from DB/2 into an Excel spreadsheet complete with pivot tables?
Is there a 3rd party tool (or native option) for retrieving data from DB/2 into an Excel spreadsheet complete with pivot tables? This would likely be done via a web browser interface such as Joomlah.

Answer Question   |  September 20, 2010  1:27 PM
DB2, DB2 Data Transfer, excel, Excel worksheets, Joomla, Pivot tables

Using SELECT with LIMIT clause on a physical file
Hi – I’m new to PHP & SQL and wanted to know if you can use mysql SELECT with the LIMIT clause on a iseries physical file in order to do pagination. Thanks for the help.

Answer Question   |  September 24, 2010  1:18 PM
iSeries, MySQL, Oracle SQL Pagination, Pagination, SQL Select

Panel Group (PNLGRP) source
Company occasionally lost a couple years ago the sources most of panel groups. Have you any idea how restore these sources even with errors? May be some API or other methods can help solve this problem. Thank you in advance, Yuriy Umanskiy

Answer Question   |  September 16, 2010  8:52 PM
API, AS/400 - DDS, AS/400 API, PNLGRP