RPG

Difference between Record and File locks

I had always thought that record and file locking where terms used interchangeably. I searched the web and couldn't validate my assumpition. Is there anyway in RPG you can lock a specific record (record lock) in a file without locking the entire file (file lock)?

LOOKUP

when lookup is unsuccessful what is the value of array index?

ReadE opcode

Hi can u pl tell me how to use READE opcode without having factor1 field..thanks

I/O device error in AS/400 program

what is I/O device error in AS/400 programs and when it occurs ? pls clarify....thanks

RPGIII to RPGILE Conversion

Someone out there must hae done this conversion. We are planning on doing this conversion to ILE sometime and would like to know some of the issues. We are planning on using the IBM conversion tool, which I believe can do most of the programs, leaving only a few to "hand" code. What we are more...

Is a DB on AS400 always DB2 ?

Please, I want to know if possible : when we speak about a data base on AS400, exactly a data base used by RPG, is it allways a DB2 database ? Is AS400 a database. Is it the same as DB2/400 ? I hope to be clear enough. Sincerely

How to retrieve the current version of AS400 you are working on?

Hi, Does anyone know how to retrieve the current version, release and model number of the AS400 box you are working on. We can view this information in spool files, but I want to retrieve this information through both CL and RPG program. Regards Shruti.

RPG/400 Error RNQ1255

I have a RPGILE (XOP560) program. I am able to compile sucessfully this program. once i call this program i am getting below error. please advice me. Additional Message Information ...

Duplicate object (PF) using SQL with same attributes

I want to create a duplicate object using SQL. I don't want to use CRTDUPOBJ and also do not want to compile my rpg's pgm because of new file level identifier. Please advice

How to create a code using diff colors in RPG & CL

How to create a code using diff colors in RPG & CL

create rpg source from object?

I just accidentally deleted my rpg srce. I have no splf out there and no back up. is it possible to recreate from obj code?

RPG/400 error

i am getting error while moving data from one field to another field. I have two files xodcfp(physical file) xounpr 8 p(2) xodstsf(physical file) xsuprc1 10a while moving data from xounpr to xsuprc1 i am gettig error.... i tried EVAL XSUPRC1 = %EDITC(XOUNPR:'X') but still...

Processing of keyed program described files in RPG

Hi, I am very new to RPG and have a doubt on processing of keyed program described files. I know it's not a good idea to use program described files as externally described files offer many advantages over the former, but I am just exploring the alternatives. How do we tell the system about the...

rpg/400

below program write a records to xodstsf in two times.... i am not sure where i missing... can you advice. FWDRPIK CF E WORKSTN FXODSTSF O E DISK FTFL01 UF E K DISK ...

SETLL

Hi I have a set of records whose key has duplicates. Can SETLL be used to read these set of records.I need this to be done as part of a loop.

Comparing ID and password in an AS/400 login screen

Dear friends iam quite new to this AS/400 . could you please let me know how to compare the id and password in a login screen..how to connect the cl program and display file to perform login operation .Do i need to write rpg code for that ..Pls help me out with this code in detail ...

No Source Showing

When I compile my RPGLE source I do it with the *source for dubugging. I just noticed this was happening. Now when I try to do a display object descrition i do not get where the source was compiled from. ANy Ideas why? I need this ASAP. Thanks Source file . . . . . . . . . . . . : ...

Describing files using Data Description Specifications (DDS)

Describing Files Using Data Description Specifications (DDS)'can u tell me what is the probleme IN PF

Journal Codes

Where can I find a list of Journal Codes? Or do you have one to share. I have all these codes like , DL, CO, OP in my journals. I can figure out some of them but i want to know what they all are. Thanks in advance

what is the max length for an sql cursor name?

what is the max length for an embeded sql cursor name in RPG?