Suppose if a physical file is having 1000 records, but i deleted 500 records from it. Here the concern is can the size of the file changes or it remains the same... kindly help me out with thorough xplanation.... Thanks in-advance...
6 10454Hello, I want to extend a length of field in my Display file(Subfile). Please suggest the possible steps. Thanks
3 5489hi guys i am new for sqlrpgle, please suggest me good websites and theory and coding. plz plz its very urgent.
2132i hav 2 logical files(L1,L2) both r derived from one physical file(P1). how can i use both the logical files in one RPG program? if yes what i have to d.
TCS,
5 10010Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
1899How can we know that a trigger has been added on a PF? and what is the purpose of adding a trigger?
3 6672Our issue is there seems to be a disconnect, or no link, between our SELECT statement and our SD. We had SELECT SORT-FILE and SELECT SORT-FILE ASSIGN TO SORTWRK. ASSIGN TO SORTWRK1 SORTWRK2 SORTWRK3 SORTWRK4. with SD SORT_FILE RECORD CONTAINS 7833 CHARACTERS. In either case, at run time, the system ignored our SORTWRK# DD statements and allocated 16 sort works with the SORTWK## naming convention. Any ideas why the system does not recognize the connection? We do not even need the SORTWRK DD statements. Thanks
2338
what is a non-join logical file?
Can you explain communication area?
name the utility program closely associated with vsam?
What are the types of the dfhmdf present in the cics?
Explain packages.
In RPG How to read a records from a file without using read opcodes?
Explain the difference between and exec cics xctl and exec cics start command?
What is db2 plan table?
What are concurrency issues?
What do you understand by psb and acb?
what is eib, how is can be used?
Explain delete-connected tables?
Explain the function of job statement in jcl?
Explain in brief how does db2 determine what lock-size to use?
Is the primary key a clustered index?