How to find number of bytes read/written in RPGLE?
Dear AS/400 Lovers! In a program, I need to find the number of bytes read from a file(FILE1) & written to another file(FILE2) in RPGLE. I need to maintain this in an Audit-file for Audit purposes. Has anybody done this earlier? any help would be of great value. Thanks in Advance, Svanky

Answer Question   |  November 10, 2010  11:55 AM
AS/400, AS400 RPGLE, DB2/400, RPG/400, RPGLE

How do I INSERT records into AS400 DB2 file from SQL server?
I can pull data from AS400 to SQL but cannot get my command on the SQL server to push the data back.  This is a very small process, I only need an item number and date. Also, the date on the SQL db is “datetime”.  I’ll need to convert that to a more recognizable date field [...]

Answer Question   |  November 3, 2010  3:52 PM
AS/400, DB2/400, SQL Server, SQL Server 2005

Reading all AS/400 records
i want to read all the records in a file.. and there are no locks on the file during this process.. how will i read the records in fastest possible manner in AS400

Answer Question   |  October 21, 2010  10:26 AM
AS/400 File Lock, AS/400 Records, DB2/400

Responsibilities of DB2/400
Hi, Being an AS/400 development/admin guy what are the roles and responsibilites of DB2/400(DB/400 ?) on daily basis.  What could be the  maintenance activities. I’m just curious about to know…waiting for your valuable comments..    

Answer Question   |  October 14, 2010  2:58 AM
AS/400 database, AS/400 DB2, DB2/400, iSeries, RPG ILEclile

DB2 physical file
how we can create View with Key to more than one PF in Diffrance Lib exsample LIB                         PF File Name ============================= Lib1                         Custom             (( for HeadOffice )) Lib2                        Custom              (( for Branch 1 )) Lib3                         Custom             (( for Branch 2 )) the above 3 PF have same Fields and Keys we want to create LF [...]

Answer Question   |  October 6, 2010  2:11 PM
AS/400 DB2, AS400 physical file, DB2/400, Physical Files

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

db2/400
Hi, Please give the answer to this question? I have Phisical file with 100 records,there is no any duplicate records in this pf.Based on this pf one Logical file i have used.But this lf is viewing only 80 records only of that pf?What is the reason for this?Please give me answer?

Answer Question   |  July 22, 2010  4:43 AM
AS400 physical file, DB2, DB2/400, Physical File

Converting from RPGLE to DB2/400 SQL
My shop just announced that it intends to convert from RPGLE on the ISeries 400 platform, to SQL, such that the procedures will be portable to other hardware platforms. What documentation to I need to acquire to train on writing SQL procedures; initially within DB2/400?

Answer Question   |  June 22, 2010  8:30 PM
DB2/400, RPGLE, SQL, SQL migration

Improve performance on Insert rows into DB2 400 table from SQL server
Using INSERT OPENQUERY and a linked server on SQL Svr 2005, to insert rows to DB2 table on AS400. To a local AS400 runs very quickly. Performance on a remote 400 is very slow, and seems to be out of proportion to the change in line speed. Is there anyway to improve the performance for [...]

Answer Question   |  October 29, 2010  2:58 PM
AS/400, DB2/400, Linked servers, SQL Server, SQL Server 2005

Converting Data in Excel to PF on DB2/400
Hi All, I have data in the excel where each column equal to the field of a physical file. I want load this data into the PF on AS/400. Could any one let me know the process on how to do it. Thanks in advance

Answer Question   |  February 26, 2010  10:57 AM
Data in Excel To PF, DB2/400, Microsoft Excel, Physical Files

DB2/400 Error Trapping
how to trap error in dds ie.., db2400 

Answer Question   |  January 29, 2010  7:55 PM
DB2/400

can anybody tell me how to know max sal in db2/400 means in pf
can anybody tell me how to know max sal in db2/400 means in pf

Answer Question   |  January 20, 2010  1:07 PM
DB2, DB2/400, PF

Logical files – V5R4
HI we all know DSPDBR command on a PF will fetch all the dependent logical files. Can anybody tell me with a logical file’s name only known is it possible to fetch the Physical files’s name on whom it is dependent?   happy new year n best wishes to all Ram

Answer Question   |  January 13, 2010  12:53 PM
DB2/400, Logical Files, V5R4

Convert as400 file to Excel and Pdf
I would like to transfer a PF data into Excel , my add ins not working. Can u provide me any other ways to do that.

Answer Question   |  July 28, 2011  6:48 AM
AS/400 to PDF, DB2/400, Exporting AS/400 to Excel, PDF, Physical File

db2 to excel
i was tryin to import from db2/400 into excel but when i did. the description came up in a different language…in db2/400 the description was in araic then when i imported in excel it came up a different language?? any idea plz help  thank you

Answer Question   |  February 1, 2010  10:38 AM
DB2/400, Exporting AS/400 to Excel, Microsoft Excel

AS/400 : DB2/400 file override
I have following scenario:- - in CL, override on PF to share ODP - Calling PGMx where above PF will be open using OPEN operation. – In PGMx,once file is open,calling another pgm(PGMy) to read the same file ( PF ) for specific record using READ operation (without SETLL ). Question : Record pointer in PGMy will be first [...]

Answer Question   |  December 19, 2009  9:51 AM
DB2/400, OVRDBF

JDBC connection to DB2/400
Hi, We have application which runs on Java Server connects DB2/400 using JDBC connection. would like to know what is the maximumnumber of database connections supported on DB2/400 and how can I adjust this connection activity so that it is not impacting our application running on as/400 i.e. how to imrpove the performance of as/400 [...]

Answer Question   |  June 30, 2010  11:32 AM
DB/400, DB2/400, JDBC

how to copy column-headings from a PF
how to get column-heading names copied along with data from a PF to a flat-file? - OR - how to copy column-headings from a PF to another PF?

Answer Question   |  April 19, 2012  10:52 AM
DB2/400, Physical Files

content of source physical
hi all, can any one plese tell ,how can we see the content of any source physical

Answer Question   |  November 11, 2009  9:44 AM
DB2/400, Source physical files

how to access any particular menber of any pf
Hi, if i have a pf having 5 members..how can i access 3rd member of it through in rpgile.. regards Ambrish

Answer Question   |  November 11, 2009  4:47 AM
DB2/400, PF, RPGLE