Basics of OVRDBF, OPNQRYF & Level check error in RPGLE

  Рет қаралды 30,047

Yusy4Code

Yusy4Code

Күн бұрын

Пікірлер: 41
@orlandodeabreu9167
@orlandodeabreu9167 3 жыл бұрын
Thanks a lot Yusef for your great contribution. I want to share with you and your audience a problem I had: If the key field (STUDNO) of the STUDPF physical file is packed type, then the *KEY-key value parameter of the OVRDBF commad must be an hexadecimal value. 17:43 In your example ' 20' is equivalent to x'020F'. OVRDBF FILE(STUDPF) POSITION(*KEYAE 1 STUDFMT X'020F')
@dougmcintosh9290
@dougmcintosh9290 5 жыл бұрын
You're awesome Yusuf! I've been watching all of your videos in the last couple of weeks. I just started a job that requires some RPG knowledge. Can't believe I didn't take an RPG course 20 years ago when I was taking COBOL classes. At the time I was convinced that RPG was stupid and a waste of time(lol). They hired me because of my COBOL experience. Last time I did mainframe COBOL stuff was 20 years ago, and until I saw your RPG videos it just looked like a bunch of random stuff to me. it makes a lot more sense to me now. never worked on an AS400, but even that makes a lot more sense to me. You go so quick between all of the screens, but it's great because it makes me concentrate. I still don't know a lot of the keystrokes you're doing to access the different screens(file formats/etc), but it's coming to me slowly. Your videos are way cooler than a recent mainframe COBOL video I watched where the guy was going so slow and took so long to fix his simple mistakes(I felt like shouting at the screen, "You mis-spelled that, and you didn't declare it in WS!!"). I've watched some of your videos 2 or three times already.
@dougmcintosh9290
@dougmcintosh9290 5 жыл бұрын
I'm just scared of what the RPG code is going to look like that I have to support in production. I remember feeling so smart when I got my straight A's in computer programming classes, but then felt like I was being thrown into an ocean when I actually had to support the stuff in the real world. so I'm paying attention to every small detail that you're doing.
@niyu8402
@niyu8402 4 жыл бұрын
Are you working at somewhere in USA?
@dougmcintosh9290
@dougmcintosh9290 4 жыл бұрын
@@niyu8402 Seattle. I actually moved to a group dealing with unix/oracle applications. The rug stuff made a lot more sense to me after watching these videos and looking at the code at my new job, but the as/400 OS was still a nightmare for me and it was hard to get all of my questions answered when I went for training with the production support team. sucks, I was really looking forward to getting some real-world RPG experience.
@niyu8402
@niyu8402 4 жыл бұрын
@@dougmcintosh9290 Really wish I can work in Seattle. I am in Vancouver with more than 10 years real-world RPG experience, but not many RPG work here. OS/400 is not difficult, just need to spend time practice. anyway, It's good to work with unix/oracle. it is easier than OS/400.
@avihearsay6956
@avihearsay6956 4 жыл бұрын
@Doug , Do you have any links for AS400 COBOL
@kkNari-fd9cw
@kkNari-fd9cw 4 жыл бұрын
Thanks for the video. There may be many use cases but I hope you covered the Primary and the main advantages of OVRDBF file, in real time.
@jayeshthakur7789
@jayeshthakur7789 3 жыл бұрын
Great work sir, providing valuable information Thank you so much
@habeel55
@habeel55 6 жыл бұрын
Valuable information for everyone....thanks very much.
@mansi1894
@mansi1894 6 жыл бұрын
Hi for OVRDBF i am getting below error: Message ID . . . . . . : CEE9901 Severity . . . . . . . : 30 Message type . . . . . : Information Date sent . . . . . . : 03/20/18 Time sent . . . . . . : 03:46:17 Message . . . . : Application error. CPF4137 unmonitored by TESTCL at statement 0000000106, instruction X'0000'. Cause . . . . . : The application ended abnormally because an exception occurred and was not handled. The name of the program to which the unhandled exception is sent is TESTCL TESTCL TESTCL. The program was stopped at the high-level language statement number(s) 0000000106 at the time the message was sent. If more than one statement number is shown, the program is an optimized ILE program. Optimization does not allow a single statement number to be determined. If *N is shown as a value, it means the real value was not available. Recovery . . . : See the low level messages previously listed to locate the cause of the exception. Correct any errors, and then try the request again. could you help me with that ?
@yusy4code
@yusy4code 6 жыл бұрын
Need more details. Can you share the code.
@charithadevara1175
@charithadevara1175 Жыл бұрын
How to read previous records in CL [i.e. Read in reverse order as like in RPG we use READP ] ? Can we do it or its nt posible in CL
@skidoosbc501
@skidoosbc501 7 жыл бұрын
Thank you, I know now how to use OVRDBF cmd :)
@geethikaganesula1502
@geethikaganesula1502 5 жыл бұрын
Hello Sir, How can I use OPNQRYF and OVRDBF on command line? Why it is not affecting the database file when using OVRDBF on command line. For suppose I executed command OVRDBF FILE(OPN1) POSITION(*RRN 5) on my command line and while fetching it in SQL, it is displaying all the records in data base file. My question is why it is not displaying from record 5. Please reply sir. Thank You.
@kishorgopal7113
@kishorgopal7113 5 жыл бұрын
what if we add a new fields b/w two fields..... what type of value that field holds
@abinayajayarajan6695
@abinayajayarajan6695 5 жыл бұрын
I tried changing a field length and use chgpf command but thechanges are not affecting . SO how to change a file fields and retain the records?
@abinayajayarajan6695
@abinayajayarajan6695 5 жыл бұрын
Sorry, as per my understanding we should use CHGPF only to change the attributes without loosing records. But if we want to change the fields then we need to compile the PF and its dependents? SO,if we have so many records in a file what are the steps done to retain the records and update the field changes?
@yusy4code
@yusy4code 5 жыл бұрын
Hi, What do you mean by change attribute and change fields? Can you give some examples.
@rizk323
@rizk323 6 жыл бұрын
Hey Yusuf, How do you get command line if you are viewing a source code but dont want to exist. Instead bring the command line access?
@yusy4code
@yusy4code 6 жыл бұрын
Riz K shift + f9
@banothuhari3420
@banothuhari3420 5 жыл бұрын
For the second scenario in the video where we fetch only the IT records using OPNQRYF., can we achieve that using *KEYAE also? When we could fetch the student records from 20 and above using *KEYAE, I wonder we can't fetch the records with IT using *KEYAE !
@bluelingen
@bluelingen 2 жыл бұрын
Shortcut: 14:10 OVRDBF
@aishnadev2173
@aishnadev2173 6 жыл бұрын
Can opnqry work without ovrdbf command ?
@habeel55
@habeel55 6 жыл бұрын
Aishna Dev yes it will
@rizk323
@rizk323 6 жыл бұрын
Hey Yusuf, do you have any video to explain about ALCOBJ?
@yusy4code
@yusy4code 6 жыл бұрын
Sorry I think I have not made one for this.
@saikumar-sp7un
@saikumar-sp7un 4 жыл бұрын
Can you please let us know, how to schedule jobs in as400
@niyu8402
@niyu8402 4 жыл бұрын
==> sbmjob + F4 "Submit Job" press F4 , then F10, Page Down you will see "Schedule date" & "Schedule Time".
@alaaanboi
@alaaanboi 5 жыл бұрын
Hai Yusuf, can you teach about writing SQL in CLLE?
@yusy4code
@yusy4code 5 жыл бұрын
Ya sure. This is a good topic. I will do it soon.
@alaaanboi
@alaaanboi 5 жыл бұрын
@@yusy4code Do you have any source i can learn SQL in CLLE?.. Supervisor is stressing me as i do not know how to do..
@yusy4code
@yusy4code 5 жыл бұрын
Alan Boy RUNSQL command QMQRY and WRKQRY are few things to work with sql in CL
@alaaanboi
@alaaanboi 5 жыл бұрын
@@yusy4code some good sites that i can read pls..?
@yusy4code
@yusy4code 5 жыл бұрын
Alan Boy go4as400.com for basics and rpgpgm.com for advanced topics . More than that you can use office IBM knowledge center for up to date info.
@avihearsay6956
@avihearsay6956 4 жыл бұрын
Nice One Please let me know anyone working on AS400 Cobol
@premkumardasari8629
@premkumardasari8629 7 жыл бұрын
thaks sir
@Mr.100NU
@Mr.100NU 6 жыл бұрын
Please make wrkqry command
@yusy4code
@yusy4code 6 жыл бұрын
Will do it in coming videos....
@Mr.100NU
@Mr.100NU 6 жыл бұрын
Please fast forward
Understanding Activation Groups in IBM I RPGLE | yusy4code
16:04
Production support tips in IBM i server
19:39
Yusy4Code
Рет қаралды 25 М.
Don’t Choose The Wrong Box 😱
00:41
Topper Guild
Рет қаралды 60 МЛН
路飞做的坏事被拆穿了 #路飞#海贼王
00:41
路飞与唐舞桐
Рет қаралды 27 МЛН
Arrays, Data Structures & Data Areas in RPG Programming
22:01
Yusy4Code
Рет қаралды 20 М.
Adding record into PF using Sub File - IBM i (AS400)
15:34
Yusy4Code
Рет қаралды 25 М.
Introduction of Data Queue - DTAQ in IBM i (AS400) | yusy4code
15:14
Using Open Query File (OPNQRYF)
16:24
AS400 and SQL Tricks
Рет қаралды 246
Running QSH command in CL program | yusy4code
15:26
Yusy4Code
Рет қаралды 8 М.
Commit & Roll Back in RPGLE - Example | yusy4code
7:03
Yusy4Code
Рет қаралды 7 М.
Improve SQL Server performance using profiler and tuning advisor
13:12
.NET Interview Preparation videos
Рет қаралды 354 М.
Code for IBM i: rpgle is modern
22:58
Lj
Рет қаралды 5 М.