• How to search a record in sequential order in V5R1 with two input parameters

    I am new to AS/400 and RPG. I want to search a record not on a single key field but with multiply search arguments. how can I do this. One thing in my mind is to create a DataStructure and in Read or Chain operation populate that DS and match field values, but in my version I didn't find LIKEREC...

    hunshabbir71,555 pointsBadges:
  • Finding COBOL career opportunities in Canada

    I've been working in Canada as a COBOL progrtammer analysr for the past 4 years and am looking at moving from the company I currently am with for better opportunites. I have a lot of the mainframe skills, JCL,COBOL, DB2 but cannot seem to find anything out there? Is it that hard to find comapnies...

    Rsfoo5 pointsBadges:
  • iSeries Access Error when accessing a file in output queues

    When trying to access a particular file in Output Queues in System i Navigator gets error message "An unexpected error occurred. Check the system I Access Java Trace Log for additional information Exit Program denied request" How to fix this error?

    intripidfish5 pointsBadges:
  • Debug SQLCBLLE pgm.

    Can anyone please explain the steps involved in the debugging of SQLCBLLE pgm.

    mvrkrishna555 pointsBadges:
  • Documenting column in SQL table in QADBIFLD (AS400)

    When a table is created with SQL, several fields in the system cross-reference file QADBIFLD gets content (headings, defults a.o). I noticed that the QADBIFLD table contains a column named DBIREM (length 2000 bytes..). I also noticed that the old S36 IDDU actually put some documentation into this...

    DanTheDane2,555 pointsBadges:
  • Update join logical file

    I have seen one topic here before which saying that join logical file can be updated and it has been many years. But I have tried to update a join logical file either using DFU or STRSQL.Neither succeed. Could someone help on this? Thanks a a lot.

    Gaoshen10035 pointsBadges:
  • How to write Multiple format for physical file using QDDSSRC create PF

    FOUNDATION PHYSICAL FILE USING QDDSSRC  CREATE F6 UNIQUE R FORMAT01 FNO 5S TEXT('FOUNDATION NUMBER') NAME 50A TEXT('FOUNDATION NAM') ADD1 25A TEXT('ADDRESS 1') ADD2 25A TEXT('ADDRESS 2') CITY 30A TEXT('CITY') STATE 2A TEXT('STATE') ZIP 12A TEXT('ZIP CODE') COUNTRY 25A TEXT('COUNTRY') TEL 20A...

    sothonod45 pointsBadges:
  • CL program calling a RPG36 program

    Can a CL program call a RPG36 program? I'll just try it if no quick answer, but maybe you know this one.

    aceofdelts1,930 pointsBadges:
  • CPYF in arrival sequence

    Anyone know a quick and dirty to copy data from a keyed physical file to another physical in arrival sequence in a CLP program? I can't find a native os/400 command that will do it.

    Dasturg0 pointsBadges:
  • How to keep whitespace in datagrid

    I have a simple .NET app. You key a SQL statement into a text box. It then connects to any one of 5 i-Series and returns a datagrid. I am curious as to how I can preserve the whitespace in the columns. These columns have some fields with data right and left justified. Other fields a large field...

    ToddN200011,245 pointsBadges:
  • SQLRPGLE program results nothing

    Hi,  I am new to SQLRPGLE. I have coded something, which finally shows nothing.Please have a look on my code & kindly help me to get the output. This is my program         *************** Beginning of data ************************************ 0001.00 HDEBUG(*YES)                  ...

    HABBIE820 pointsBadges:
  • AS/400 CL to submit a Jobscheduler entry wont loop

    I have created a command which simply calls a CL called Booking which is below. It submits a program PC832U and re-adds itself to the job scheduler. So basically it is running every 5 minutes until 2pm. First call runs great. It runs the program and adds itself in the scheduler for 5 mins later....

    adamkm35 pointsBadges:
  • AS/400 Compilation

    I am a beginner in AS/400. I have a question to ask. When we are compiling a Physical File, it will generate a unique code something like identifier right? So I will compile the program with this PF. Now my question is, if I have two libraries which contain this PF with same identifier, when I...

    yeepiyaya90 pointsBadges:
  • AS/400 Query taking time to execute

    I am having a query which is having 7 inner join One table having record around ==>4770290 And second table with ==>50681241 And other tables have comparatively less records.

    jayshree185 pointsBadges:
  • SQLRPGLE Cursor not open error

    Hi, I have written some thing on SQLRPGLE. I am facing few issues.I request you to kindly look at the code & let me know the mistakes.Please forgive me ,If I made any blunders on this.   This is my file. 0001.00                 R EMP                             0002.00  ...

    HABBIE820 pointsBadges:
  • How to use OVRDBF to find specific field in my physical file data.

    So right now im trying to make a CLfile that prints out the fields on the SDA fields when i input the field number. For example, i have a customer database which has the fields EMPNO,EMPNAME,COMPNAME ,etc. so by typing the empno (lets say 'A00001' ) in the input field, i want to able to pull the...

    rootlocus5 pointsBadges:
  • AS/400 Data Queues

    Hi all I am new to RPG and AS/400. I want to know, Does data queues are maintained session wise? if yes then if we have allocated memory of e.g. 2GB, then each session will reserve 2GB? if no then (it is like common shared data) how can we manage data queue. If one user wants to clear data queue...

    hunshabbir71,555 pointsBadges:
  • Break message with batch job

    Hi all, When I submit a job in batch. I don't get any break message that job was completed successfully or not. I read somewhere that this attribute is set against message queue to send break message or notify etc. I just call my program with SBMJOB CMD(CALL PGM(xxxxx)) it initiated job QBATCH. How...

    hunshabbir71,555 pointsBadges:
  • CPYF Command in AS/400

    Hi, I have two files (A,B) with different definitions (Column names,data type,length etc) are different. Both are on same AS/400 system. Now I want to copy all the records from FILEA to FILEB. What I want to say is, COPY data from one file to another file, where nothing is common in between them....

    HABBIE820 pointsBadges:
  • Learning SQLRPGLE in AS/400

    Hi, I am looking for something where I can learn SQLRPGLE & Stored procedures in AS/400. I tried with few few sites, but none of them are clear. Kindly let me know, where I can get some programming knowledge on SQLRPGLE procedures.

    HABBIE820 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following