Do we need to compile LF when its PF changes
Hi, I have one small query. I have changed one PF, do I need to recompile it’s dependent LF(s) ? For e.g I have earlier a PF say PF1 having 4 fields A,B,C,D (with keys A,B) now I have added a new field E. Do I need to recompile its dependent LFs say LF1,LF2.. Appreciate [...]

Answer Question   |  July 20, 2012  9:21 AM
as400/DB2

physical files……
hello sir,             I have found one problem while update data in source file. I creats one source file after 14 it shows this message “The compile of member JPF1 was submitted to Batch.                          + Job 476274/NITINB/JPF1 submitted to job queue QBATCH in library QGPL” after using of UPDDTA on [...]

Answer Question   |  June 22, 2012  10:25 AM
as400/DB2

AS400 and BOXIR3.1 connectivity
Hi guys, Can anybody tell if Business object can be connected to AS400? Thanks Pranav Sharma

Answer Question   |  June 18, 2012  2:15 PM
as400/DB2, Business Objects XI

AS/400 query
I have one join file and one logical file. It is possible to create logical file on join logical file?

Answer Question   |  May 25, 2012  8:21 AM
AS/400 logical file, as400/DB2

enter SRTSQL Satements AS400
Hi, I have done an index by “create index……” and when I am trying to do aquery with STRSQL on that index I receive the following error: BKPPDAI1 in BKTEST not table, view, or physical file. This is my Statement: select *from bktest/BKPPDAI1 I am trying to fix the syntaxis but I can not make [...]

Answer Question   |  May 7, 2012  3:46 PM
as400/DB2

How to acheive FULL OUTER JOIN on three files in IN SQLRPGLE program.
Hi, I have 3 seperate files called Duty, Freight and Brokerage and i need to process all the records from all the three files into one output file based on key values matching across all the files, if i dont find the match in anyother two files then i need to populate coresponding fields with Zeroes. [...]

Answer Question   |  May 22, 2012  3:50 PM
as400/DB2, SQL/400, SQLRPGLE

how to write more than one sql statement under EXEC SQL in SQLRPGLE.
Hi, Can anyone please help me to write more than one SQL statements under single EXEC SQL and END EXEC as below. Since i have 10 sql statements and wanted to include all those 10 statements under single block of EXEC SQL and END EXEC by using any seperator like below. C/EXEC SQL C+Insert into [...]

Answer Question   |  March 26, 2012  7:52 PM
as400/DB2, SQLRPGLE

FILES
Hi.. i have PF with this format Ex: PF1     R REC        FLD1        FLD2 For the above PF1 file i have records in a text file. For that i need to upload the records without using ISERIES navigator and FTP also..Can anyone guide me??? Regards, Ajmal khan.

Answer Question   |  March 17, 2012  5:27 AM
AS400 iSeries Navigator, as400/DB2

User cannot run a job that another use has access to do
How do I give a user access to run a job?

Answer Question   |  March 17, 2012  10:01 PM
as400/DB2, rights

How to show table Constraints on AS400
Hello masters, I wantto show table constraints on as400 database.I asked somebody people and they are said me; “Do not show (constraints – table relations) on AS400″.I dont belive that.And now asked How to show table constraints – relations on as400 I’m very curious about the answer to this question Thank you for your answers.

Answer Question   |  March 19, 2012  3:06 PM
AS400 Data Definitions, as400/DB2, as400/DB2 - Trigger - Comit

Production support team in AS400
In AS/400 projects in Companies whats the meaning of production support team.what production support involves.also what work does development,maintenance involve what are the other teams or processes that are available for as400 project. 

Answer Question   |  April 18, 2011  5:59 PM
AS/400 Administrator, AS/400 Management, as400/DB2

File Level identifier Vs. Record Format Level Identifier vs. Member level identifier
Hi,   Please let me know the difference b/n File Level identifier, Record Format Level Identifier and Member level identifier with an example

Answer Question   |  May 13, 2010  10:18 AM
as400/DB2, File Level Identifier, member level identifier, Record Format Level Identifier

How to Import Data from a .CSV or .XLSX file to an AS400 file?
I want to import the data of a .CSV or .XLSX file to a AS400 file. How can I accomplish this? Also, the .CSV/.XLSX file has two columns that I would like to keep in the AS400 File. Any inputs would be really appreciated.

Answer Question   |  May 1, 2010  7:12 PM
AS/400 CSV, as400 data import, as400/DB2, XLSX

I need help with DSPF…
Hi everybody, i try explain my need. I have one RPG pgm with several DSPF, and for this work well, i have a OVRDSPF. My problem is when other people make any changes in one DSPF we have a level check, i know that, but because of this i need a idea for make an ALERT [...]

Answer Question   |  April 25, 2010  2:15 PM
as400/DB2, DSPF, DSPF-Format, RPG/400, SDA

Difference between RPGIII RPG IV and RPGLE
1)Can some one tell me the major differences between them? 2)Subprocedures, Built in func etc stuff does come under RPGIV or RPGLE? 3) I beleive Actiation groups, static Binding, modules, Service pgms.. does come under RPGLE? please explain me a bit clear, and it would be thankful if you have explained as per the above [...]

Answer Question   |  February 11, 2010  4:58 PM
as400/DB2

How to check existance of record without using file opcodes
By using INFDS and standard fields *FILE/*RECORD…. how to find out a record existance in Physical File without using any file opcode? Please tell me the RPG code how to use it, not only the I spec definition.

Answer Question   |  October 27, 2009  3:31 PM
as400/DB2

Delete OLD files from Table not having date or timestamp
Hi, In DB2, Is it possible to get the insert date of a record in a table which doesn’t have a seperate field for creation date or timestamp. I have a task where I have to delete record older than 1 year from a table, but the files doesn’t have creation date field. So, like [...]

Answer Question   |  July 30, 2009  10:46 AM
AS/400, as400/DB2, DB/400, DB2, DB2/400, delete sql, DELETE statement, SQL