Interested to Buy Any Domain ? << Click Here >> for more details...
-
IBM MainFrame (5234) - IBM AS400 (1355)
- IBM PL/1 (31)
How to read and write a single record into a file. I would like to use it to enter a single 8-character piece of information and use it to put it into a variable for processing in JCL. Thank you
1076Why we have multiple data types in As400 and why we use numeric, packed, decimal, zoned the basic difference between this?
1123How 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
1017When 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?
961Assume 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?
9401. 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?
950If I have a file with 5 record and that file has 2 Key field and I want to read the unique record of the file then how can we achieve it?
1 2367write a cobol logic. i have file that has 10 records .1 record go to first output file and second record goes to 2 output and etc
1234
what is message file?
What is cobol?
Is the primary key a clustered index?
What is the purpose of dd * statement in jcl?
how can I tell when to replace the array?
can anybody post me about file-aid and changemen tools pls and give me reference if any mainframe guys are there
SET is the ANSI standard for variable assignment, SELECT is not. SET can only assign one variable at a time, SELECT can make multiple assignments at once. If assigning from a query, SET can only assign a scalar value. If the query returns multiple values/rows then SET will raise an error. SELECT will assign one of the values to the variable and hide the fact that multiple values were returned (so you'd likely never know why something was going wrong elsewhere - have fun troubleshooting that one) When assigning from a query if there is no value returned then SET will assign NULL, where SELECT will not make the assignment at all (so the variable will not be changed from it's previous value) As far as speed differences - there are no direct differences between SET and SELECT. However SELECT's ability to make multiple assignments in one shot does give it a slight speed advantage over SET.
Which is not true about evaluate statement
Define predicate?
is their a difference in cobol400 for the release 5.2 and 6.1 at the as400.
what is the purpose of the verify function of idcams?
What are the processing modes available in ims db?
what is message subfile?
Have you used the sort in your project?for this type of questions any working on real time project give the eg. with real time scenario.
I have one input file and some 40 tables, I want to read input file and compare the input file value with the table value if it is present then we have to update with new value, this should be repeated for all 40 tables and we are reading only one input file, for this is there any REXX program or job or routine to accomplish above requirement. components of the requirements; 1. One input file 2. 40 DB2 tables 3. we have to read from the input file and compare with table value, if present then update with new value (this should be recurssive for all 40 tables for every record of input file). 4. quick help is appreciated.
