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
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
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
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
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
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
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
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
How do I give a user access to run a job?
Answer Question | March 17, 2012 10:01 PM
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
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
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
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
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
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
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
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