Un-Answered Questions { IBM AS400 }

Why we have multiple data types in As400 and why we use numeric, packed, decimal, zoned the basic difference between this?

600


How do u design a physical file, when you have 2 Unique fields like for eg in A student file student ID and student examination no both are unique

539


How to write record if no field or the field are different in physical file in rpgle ?

471


When we have a file with Duplicate records and I want to read the unique record from the file. For example a file containing Emp Name as 'Ram' and there are 3 entries of it. So how to read a unique record from File?

486


Assume 2 users are using the same file and first user updates some record in the file. Will the 2nd user will be able to see the updated record or not?

498


1. If there are two programs using same file and 2 users are using the file at the same time and what can be done to allow them both to access? 2. How can remove lock from the file for accessing it by both users?

473


How do you check object lock

358


How to reverse a string using RPG?

676


1. There is a file called Month. Month has 12 members called Jan, Feb, ..., Dec. How to design a rpg code which can access any member and show its content. (User can ask for any member when required)?

396


Write a CL program which will run a batch job at 1 am every night

665


There is one string as A B C and wanted to display string as Shri A Shri B Shri C, how we can do this in sql? If we have around 100 values in string like this, each value should be displayed with initials as Shri.

720


How to convert a spool file to PDF file in AS400?

726


What is FORMAT keyword and its use?

189


Can we debug the MSGW JOBS?

921


In RPG How to read a records from a file without using read opcodes?

952