CICS Interview Questiona
1:56:04
2 ай бұрын
Ez-Learn Promo Video
0:15
2 ай бұрын
EBCDIC Char Set
13:03
Жыл бұрын
How to use KSDS in CICS Region
12:31
CEDF - Debugging
13:59
Жыл бұрын
Basic Mapping Support (BMS)
1:39:18
Жыл бұрын
LINK & Dynamic Cursor Positioning
21:57
CICS Fundamental Concepts
55:47
Жыл бұрын
Discussion on Abends & SQL Codes
24:12
DB2 Cursors in detail
1:01:16
Жыл бұрын
COBOL DB2 Program Preparation
1:31:19
SQL Subqueries
10:34
Жыл бұрын
SQL   Views
12:02
Жыл бұрын
SQL   Joins
39:48
Жыл бұрын
SQL   Foreign Keys Concepts
30:20
Жыл бұрын
SQL   Using SPUFI
9:33
Жыл бұрын
SQL SELECT and its Clauses
43:36
Жыл бұрын
SQL Create and Maintain Table
11:53
SQL Basics Introduction
50:45
Жыл бұрын
COBOL INTERVIEW QUESTIOS   PART 1
55:26
COBOL Static Vs Dynamic Call
4:06
Пікірлер
@ragothamankrishnamoorthyra863
@ragothamankrishnamoorthyra863 14 күн бұрын
Excellent
@mdshanawaz1312
@mdshanawaz1312 14 күн бұрын
Sir , do you have PDF of this Q&A, can you share the link
@mainframemadeeasy
@mainframemadeeasy 14 күн бұрын
Yes pls email me [email protected]
@ranjithkumar-hl4yo
@ranjithkumar-hl4yo Ай бұрын
Good morning, Sir. I am working on a project where I need to browse all members in a PDS for character 'D' at column 20 and fetch the first 8 bytes from member to output file. I used IEBPTPCH to print members in the temp file and SORT to check for conditions. The output file doesn't have desired results. Kindly correct my understanding. Thanks Sir. JCL: Exec PGM=IEBPTPCH SYSUT1 INPUT PDS SYSUT2 TEMP FILE SYSIN DD* PRINT TYPORG=PO EXEC PGM=SORT SORIN TEMP FILE SORTOUT OUTPUT FILE SYSIN DD * SORT FIELDS=COPY INLCUDE COND=(20,1,CH,EQ,C'D') OUTREC FIELDS=(1,8)
@mainframemadeeasy
@mainframemadeeasy Ай бұрын
@@ranjithkumar-hl4yo Looks fine for me But since you have written OUTREC to fetch first 8 bytes lrecl of file will be 8 Or if file length is say 80 OUTREC fields=(1,8,80:X) will work If you give me SYSOUT of error we can see what went wrong. If you want you can send an email with only error msg in Sysout to [email protected]
@shalinis1465
@shalinis1465 Ай бұрын
Venkatesh, you can use String command. You have given like Delimited by space, so the program will ignore other characters after it encounters a first space in both the fields. That's why you didn't get the expected output. Instead of Delimited by space, try giving Delimited by size. It should work actually.
@mainframemadeeasy
@mainframemadeeasy Ай бұрын
@@shalinis1465 Thanks for letting me know
@pradeepkumar-e5x1d
@pradeepkumar-e5x1d Ай бұрын
Thank you 😊
@sanruth28
@sanruth28 Ай бұрын
Hi, did you upload the full video? I am not able to find it in your channel.
@mainframemadeeasy
@mainframemadeeasy Ай бұрын
@@sanruth28 give me time will upload
@weronpc
@weronpc 2 ай бұрын
That was helpful, thank you for sharing
@ranjithkumar-hl4yo
@ranjithkumar-hl4yo 2 ай бұрын
Good afternoon, Sir. I need clarity from you for the below problem . We have a huge tape file which got split into 7 DASD O/P files based on record type using OUTFIL conditions. Client has shared a requirement that we need to count the number of records from the input tape file and put the count in a new 8th dataset in the same sort step which will be used in the program for further process. I suggested taking count from the 7 DASD files using ICETOOL since reading will be faster and exhibit the results to the Client. But client disagreed. I'm trying other approaches as well, Sir. Kindly help me with this, Sir.
@mainframemadeeasy
@mainframemadeeasy 2 ай бұрын
You can do using SORT or a Program to count and write the count in an O/p file. I will send code for SORT in a few mins. You can try the same.
@ranjithkumar-hl4yo
@ranjithkumar-hl4yo 2 ай бұрын
Thanks for your immediate response, Sir. I'm just explaining the issue I faced. I included TRAILER in OUTFIL and captured the count at the end of the 7 files. But the ask is to capture it in the 8th output file in the same Sort step, Sir.
@mainframemadeeasy
@mainframemadeeasy 2 ай бұрын
@@ranjithkumar-hl4yo I have assumed Output file length as 80 bytes INREC FIELDS=(1:C'COUNTER',8:C'00000001',80:X) SORT FIELDS=(1,7,CH,A) SUM FIELDS=(8,8,ZD) OUTREC FIELDS=(8,8,80:X) 80 - Last column in O/p file
@mainframemadeeasy
@mainframemadeeasy 2 ай бұрын
@@ranjithkumar-hl4yo ohk got it. But how come we can keep SORT fields, SUm fields and INREC fields are common for other 7 Output files Only Outrec and Include/Omit can be written as a Sub parameter of OUTFIL
@mainframemadeeasy
@mainframemadeeasy 2 ай бұрын
We have a COUNT parm to give the number of records in file . I will send the syntax
@swethacherukuri9446
@swethacherukuri9446 2 ай бұрын
Hi sir , what were the spaces that are provided and how did u provide the spaces between those three characters??
@mainframemadeeasy
@mainframemadeeasy 2 ай бұрын
@@swethacherukuri9446 An X denotes 1 Space. If you want to add 3 Spaces in an output file , we can give 3X in OUTREC fields or INREC fields. Alternatively if you mention column numbers for output record , any left over column will automatically will be padded with SPACES.
@swethacherukuri9446
@swethacherukuri9446 2 ай бұрын
@@mainframemadeeasy thanks sir
@harisankarraj
@harisankarraj 2 ай бұрын
background music disturbance a lot
@mainframemadeeasy
@mainframemadeeasy 2 ай бұрын
@@harisankarraj ok will check and remove the music
@ranjithkumar-hl4yo
@ranjithkumar-hl4yo 2 ай бұрын
Hi Sir, the below jcl ended with cc 16. WER268A OUTFIL STATEMENT: SYNTAX ERROR. Im not getting, Sir. Pls help me on this. Is it because I have only syncsort not DFsort //STEP1 EXEC PGM=SORT //SYSOUT DD SYSOUT=* //SORTIN DD DSN=your.flag.file,DISP=SHR //SORTOUT DD SYSOUT=* //SYSIN DD * SORT FIELDS=COPY OUTFIL REMOVECC,NODETAIL, TRAILER1=('NUMBER OF RECORDS: ',COUNT=(M11,LENGTH=8)) /*
@mainframemadeeasy
@mainframemadeeasy 2 ай бұрын
@@ranjithkumar-hl4yo I think after RECORDS comma is missing When you are continuing to next line we need to end with a comma in prev line Pls check and let me know
@ranjithkumar-hl4yo
@ranjithkumar-hl4yo 2 ай бұрын
@@mainframemadeeasy Thanks sir. It's working. ☺️
@shilpa003
@shilpa003 2 ай бұрын
Sir I am unable to understand the Equals usage part!! What if we omit the Equals after the Sort field?
@mainframemadeeasy
@mainframemadeeasy 2 ай бұрын
@@shilpa003 Equals is necessary to pull first record from input to output based on sort fields criteria. Default is no equals . If we mention that, it will go to a separate routine that decide which dup records to be removed and which one to bring it to output file. We don’t have any control over which record will come in Output file. Hope you got it.
@shilpa003
@shilpa003 2 ай бұрын
​Yes understood ​@@mainframemadeeasy thank You Sir!!
@MuraliGanji-b3p
@MuraliGanji-b3p 2 ай бұрын
I am trying to compile my BMS but i am getting return code 12 how to resolve that
@mainframemadeeasy
@mainframemadeeasy 2 ай бұрын
@@MuraliGanji-b3p we need to check for MNOTE or ASMA in the compile listing. It shows Warnings and Errors. You need to see that understand correct and recompile
@SupercopGmaingYT
@SupercopGmaingYT 3 ай бұрын
Valuable information
@fuleiliu-i4b
@fuleiliu-i4b 3 ай бұрын
he's my current lecturer for Mainframe, can vouch a very good instructor!
@mainframemadeeasy
@mainframemadeeasy 3 ай бұрын
@@fuleiliu-i4b Thanks for your feedback Lui
@prathapn01
@prathapn01 3 ай бұрын
When a GN call is issued continuously it will fetch all the occurences of each segment in the hierarchy... If GNP is issued how is it done ? will it fetch data from currently pointed parent and it's child segments or only current segment ?
@mainframemadeeasy
@mainframemadeeasy 3 ай бұрын
@@prathapn01 GNP will read only child occurrences under a parent for a specific segment of you give an SSA. If you don’t give an SSA, it will read all the occurrences under a Parent in all levels below the parent in a hierarchy
@prathapn01
@prathapn01 3 ай бұрын
can you explain exactly what is the scenario we should be using CECI READ file command ?
@mainframemadeeasy
@mainframemadeeasy 3 ай бұрын
@@prathapn01 If you want to test a resource after allocation to make sure it works, you can use CECI. It is easy to test debug and fix rather than testing the transaction. Once it is working as expected you can use it as an embedded command and test the transaction
@chiruaks1
@chiruaks1 4 ай бұрын
Excellent information Sir, thank you.
@chiruaks1
@chiruaks1 4 ай бұрын
Excellent information Sir
@chiruaks1
@chiruaks1 4 ай бұрын
Excellent information Sir
@neeharikamalligunta3021
@neeharikamalligunta3021 5 ай бұрын
Nice questions
@mainframemadeeasy
@mainframemadeeasy 5 ай бұрын
Thanks for the feedback
@neeharikamalligunta3021
@neeharikamalligunta3021 5 ай бұрын
Thank you for sharing questions.. can we get part 3 questions as well??
@dishaagarkar9593
@dishaagarkar9593 6 ай бұрын
i m having doubt in second one 7,11,ZD,EDIT=($III,III,IIT.TTIS) SIGNS=(,,,-) 000 002 000 00 CONVERTED TO $2,000.00 $III,III,IIT.TTI S HOWWWWWWWWWWWWWW??????
@dishaagarkar9593
@dishaagarkar9593 6 ай бұрын
HOW THIS MASKING IS WORKING HERE
@mainframemadeeasy
@mainframemadeeasy 6 ай бұрын
I is an Insignificant digit . If it has a 0 then it masks and do floating
@sandeep7yadav
@sandeep7yadav 6 ай бұрын
This session is very useful for refresh knowledge. Do you have any hard copy detail on this ?
@mainframemadeeasy
@mainframemadeeasy 6 ай бұрын
We are preparing hard copy details this year . Will be live in our website
@poornimasaravanan9389
@poornimasaravanan9389 7 ай бұрын
Is it mandatory to close a cursor?
@mainframemadeeasy
@mainframemadeeasy 7 ай бұрын
It’s not mandatory as the program closes the cursor automatically when it stops but as a good programming standard we need to close
@poornimasaravanan9389
@poornimasaravanan9389 7 ай бұрын
Sir.. how to select commit frequency for a high volume updates to db2 say 5 million records . Do we have a formula? Or standard to follow? Please explain
@mainframemadeeasy
@mainframemadeeasy 7 ай бұрын
No fixed formula You can take a decision based on the following factors 1) Duration of Job 2) Number of Records updated 3) How soon we need to release records for other Transactions or how much time we can hold 4) Chances of Job to Abend Or an average of say 10000 records will be the frequency I chose for 5M records updation
@mainframemadeeasy
@mainframemadeeasy 7 ай бұрын
Or you can choose to commit after every set of record category
@poornimasaravanan9389
@poornimasaravanan9389 7 ай бұрын
Where is it used??.. instead can't we just rename these datasets ..just curious
@mainframemadeeasy
@mainframemadeeasy 7 ай бұрын
Yes. You are correct. It is just an exercise that I used to give it to Freshers after I teach IEBGENER.
@Rachidg123
@Rachidg123 7 ай бұрын
hello sir , when we don't need to declare the cursor ?
@mainframemadeeasy
@mainframemadeeasy 7 ай бұрын
If you want to extract more than 1 row from a DB2 table then we need a cursor Usually if the programs main input is data from a table, then we are going to process almost all rows or many rows. In this case we need a cursor
@Rachidg123
@Rachidg123 7 ай бұрын
@@mainframemadeeasy thank you
@poornimasaravanan9389
@poornimasaravanan9389 7 ай бұрын
Sir please can you upload video on outrec build.. header trailer inclusion and if then multiple condition in sort playlist
@mainframemadeeasy
@mainframemadeeasy 7 ай бұрын
Yes will do by next week
@poornimasaravanan9389
@poornimasaravanan9389 7 ай бұрын
For this can't we use sort fields = copy.. and concatenate files in input if the files are sorted already.. that will also create same output right.. what's the difference.. pls advise
@mainframemadeeasy
@mainframemadeeasy 7 ай бұрын
Yes we can use . But SORT FIELDS willl again SORT the entire data while MERGE FIELDS won’t SORT again but combine or merge the input with a different algorithm and hence MERGE FIELDS will be faster here when compared to SORT FIELDS
@poornimasaravanan9389
@poornimasaravanan9389 7 ай бұрын
@@mainframemadeeasy thank you..
@mainframemadeeasy
@mainframemadeeasy 7 ай бұрын
@@poornimasaravanan9389 Also Sort fields copy will just concatenate the data but don’t keep the output in sequence while merge fields will also sequence the output data
@poornimasaravanan9389
@poornimasaravanan9389 7 ай бұрын
Where are the exercises? Which website should i refer sir
@mainframemadeeasy
@mainframemadeeasy 7 ай бұрын
For training you can logon to www.ez-learn.global If you need additional exercises email us to [email protected]
@rahamathnisha4875
@rahamathnisha4875 8 ай бұрын
Hi Sir, Can you please provide videos for cobol - Files programming (VSAM and PS Files) .
@mainframemadeeasy
@mainframemadeeasy 7 ай бұрын
I will post in before next week
@shyamshinde9567
@shyamshinde9567 8 ай бұрын
Hi can you please share COBOL Code and BMS map code for this example
@mainframemadeeasy
@mainframemadeeasy 8 ай бұрын
Ok will give you by weekend
@shyamshinde9567
@shyamshinde9567 8 ай бұрын
@@mainframemadeeasy thanks
@hussain8301
@hussain8301 8 ай бұрын
How can I print sequence numbers in descending order
@mainframemadeeasy
@mainframemadeeasy 8 ай бұрын
You can give INCR,-1 instead of INCR,1 but there will be a problem if the sequence number goes negative. You can give any incremental or decremented value. We will check whether we have DECR .
@AhileshKrish
@AhileshKrish 8 ай бұрын
very nice
@c.swathychandrasekran4953
@c.swathychandrasekran4953 8 ай бұрын
Hi sir, what would be in input file, sortin??
@mainframemadeeasy
@mainframemadeeasy 8 ай бұрын
It has been given in the first 2 videos. If you start from there you will be able to understand about the data in the input file
@c.swathychandrasekran4953
@c.swathychandrasekran4953 8 ай бұрын
Could you please share the link. Couldn't get
@PochinkiVeteran
@PochinkiVeteran 9 ай бұрын
Nice explanation
@mainframemadeeasy
@mainframemadeeasy 9 ай бұрын
Thanks for your valuable feedback
@saranyaagarwal3559
@saranyaagarwal3559 10 ай бұрын
Hi sir,How can we pass sortin datasets dynamically. For ex first 3 files as one run and then next 3 files as second run. But without hard coding in this job.
@mainframemadeeasy
@mainframemadeeasy 10 ай бұрын
We can override datasets thru Runjcl and have Job step in a Proc. In Runjcl we can override the input files as STEPNAME.SORTIN after EXEC PROC statement
@sriram7488
@sriram7488 10 ай бұрын
Outstanding explanation.... Requesting you to make videos like this...... How to reach out to you?
@mainframemadeeasy
@mainframemadeeasy 10 ай бұрын
You can logon to our Company website www.ez-learn.global
@rohanroy1964
@rohanroy1964 10 ай бұрын
Very good
@mainframemadeeasy
@mainframemadeeasy 10 ай бұрын
Thanks for your comments
@thithinkadya
@thithinkadya 10 ай бұрын
I need some information about microfocus rumba mainframe 😊
@mainframemadeeasy
@mainframemadeeasy 10 ай бұрын
Hi, At present I don’t have any knowledge on what you have asked for however all Mainframe technology is similar irrespective of hardware
@thithinkadya
@thithinkadya 10 ай бұрын
@@mainframemadeeasy thanks for the reply
@fishhobee
@fishhobee 10 ай бұрын
thank you!
@learnartdaily6972
@learnartdaily6972 10 ай бұрын
Thq
@cricketmadness213
@cricketmadness213 11 ай бұрын
Thank you very much, very helpful ❤❤
@PriyaCM-z3e
@PriyaCM-z3e 11 ай бұрын
One of the finest video on COMP Fields.. Thank you so much..
@mainframemadeeasy
@mainframemadeeasy 11 ай бұрын
Thanks you for your valuable comment
@gsssaisravya
@gsssaisravya 11 ай бұрын
Thank you sir
@R_chandrappa_
@R_chandrappa_ 11 ай бұрын
Hi sir Can I open the cursor two times
@mainframemadeeasy
@mainframemadeeasy 11 ай бұрын
Yes any number of times but you need to close first and then open again
@R_chandrappa_
@R_chandrappa_ 11 ай бұрын
Thank you sir Can you help me with in which scenarios we can declare multiple cursor
@Samyakbudh
@Samyakbudh Жыл бұрын
Thank you so much!
@saitejaakkanapelli7973
@saitejaakkanapelli7973 Жыл бұрын
How to install mainframes in our laptops
@mainframemadeeasy
@mainframemadeeasy Жыл бұрын
You can download vista software or mocha or IBM PComm. Search free version in Google . You need ID from a service provider comes at a nominal cost. They will give u Ip and port and user id and password. Email [email protected] they will give you a paid ID from a Server
@Michael-l2d1d
@Michael-l2d1d Жыл бұрын
My hero
@anilpatairiya1867
@anilpatairiya1867 Жыл бұрын
Very nice explanation... Very informative video. Thank you for the video
@mainframemadeeasy
@mainframemadeeasy Жыл бұрын
Thanks