DCLGEN (Declarations Generator) in DB2 is used in COBOL-DB2 programs to declare tables and views. It generates SQL DECLARE TABLE statements and corresponding host variable structures, saving manual coding effort.

Let's mainframe!  What is DCLGEN in DB2?  DCLGEN (Declarations generator) are used in the COBOLDB2 programs that we write. The program should declare the tables and views that it accesses. DCLGEN p...

Welcome to IT Company Discussion's Private Community

Let's mainframe!

What is DCLGEN in DB2?

DCLGEN (Declarations generator) are used in the COBOL-DB2 programs that we write. The program should declare the tables and views that it accesses. DCLGEN produces these DECLARE statements so that we do not need to code these statements manually. It also generates corresponding host variable structures. When DCLGEN is used to generate a table declaration, the DB2 uses the DB2 catalog to get the relevant information from it. DCLGEN, then uses this information to create an SQL DECLARE TABLE statement for the table/view.
DCLGEN has SQL DECLARE TABLE statement, the Cobol equivalent variables for columns and NULL indicators too.

All About Mainframes

Software Developer

All About Mainframes- Grapevine

Lets' mainframe!

Do you know what DBRM is?

DBRM is Database Request Module and is a component inside DB2, it is created after the pre-compilation of COBOL-DB2 program. This is a module that consists of SQL source statements that get extracted out of the application program. DBRMs form inputs that are used for binding process which creates the executable format of it which is then used during execution of the program

All About mainframes

Welcome to Software Engineers's Private Community

Enjoy the videos and music that you love, upload original content and share it all with friends, family and the world on YouTube.

 - YouTube

Hoe COND code works in Mainframe!

Let's Mainframe!



JOBLIB is a DD statement which is a user defined library (we can code many) at job level where load modules of the programs called in the JCL should reside. The JOBLIB should be coded between the Job card and the first EXEC statement. The statement applies to all the steps of the entire job.



However, STEPLIB is coded in each step of the JCL where the load module of that particular program is expected to be present. 

It always applies to only that step of the JCL where it is coded and not the whole job. 

This can be used at any step in the job and also it can be coded in catalogued procedures.



If both STEPLIB and JOBLIB are coded in a JCL, then STEPLIB gets precedence over JOBLIB.



#jcl #mainframe

Let's mainframe!



Distinction between CHAR and VARCHAR data types -



CHAR data type has a predetermined maximum length, while VARCHAR data type is a varying length character string. 

So, it means, Char will always have the same length to store the text, but VARCHAR alters its length based on the length of the string which has to be stored, which helps in saving memory. 



The CHAR data type in DB2 stores character data in a fixed-length field. It can store letters, numbers, and other characters which are supported. 

However, VARCHAR data type is a varying-length character string that can contain letters, numbers, and special characters.



#mainframe #db2

Let's Mainframe! :)

VB (Variable Blocked) file:

There are two types of control information in a VB file-
 1) Block descriptor Word (BDW) and 2) Record descriptor Word (RDW) with the data in a VB file.

There might be several records in one physical block. Each variable length record has a RECORD DESCRIPTOR WORD(RDW). 

 RDW is of 4 bytes. The first 2 bytes store the length of the record.
Each block has a BLOCK DESCRIPTOR WORD(BDW) at the beginning of the block. The BDW is of 4 bytes. The first 2 bytes contain 
the length of the block.

The representation of a VB block file is below-

BDWRDWRECORDRDWRECORDRDWRECORD

That is why when the logical record length of a Variable blocked file is 80 , it is 4 bytes RDW and 76 bytes data.

Questions asked in Mainframe interviews for a mid level experienced candidate-

1. What is checkpoint restart logic and how will you code it in your program?
2. What is file parallel processing in Cobol programs?
3. What is commit logic in programs?
4. Explain the use of Cursor.
5. Explain these abends- -305, -803,-904,-911.
6. What is real time use of GDG concept?
7. INREC FIELD ,INCLUDE COND Sort examples.
8. What is Array and how is it used, what are subscript and index?
9. What are search and search all and how are they coded?
10.Why is version control tool used? (next is how do you deploy a component from dev to prod?)
11.How do u schedule a job using job scheduling tool?
12.What is your daily task and how do u get requirement?
13.Have u worked on a project from end to end?
14.Challenges you faced while delivering a project.
15.Have you interacted with stakeholders?
16.What is SDLC process?
17.Have u ever done estimation of any requirement?
18.Difference between continue and next sentence.
19.Redefines real time examples.

There are more but these are frequently asked questions-

Hope it helps!

Let's Mainframe! Important Interview questions for a Mainframe developer

As a college student I currently have 2 options. Whether to learn mainframe technologies as a part of the subject very wisely so I can apply in companies like BMC and IBM or shall I stick with DSA practicing. Enlighten me in areas of scope, advancement and salary.

Is learning mainframe technologies good or shall I stick to DSA?

People working in banks - JPMC, HSBC, Morgan Stanley, BoA, etc : 

What tech stack are you using  predominantly for backend?

Are you using on-premise or VPC for storing data? 

What version control are you using?

You might be having custom software for core banking, but what kind of wrapper are you using over it?

I work in a financial services company that makes software for banks so wanted to know if the stack is similar. ( not panning a hack 😂 )

Stack used in banks?

Software Engineer

What is a SUBSCRIPT in Mainframe?

Subscript:

A subscript is an integer value that indicates the position of an element in an Array(table).
It can be defined in working-storage section with PIC S9(4) COMP.
It's an integer that indicates the occurrence number in an array.

Example: If you have a table which is defined as 

01 WS-ARRAY OCCURS 100 TIMES, then the first element can be accessed by using WS-ARRAY (1).

Example:

DATA DIVISION.
WORKING-STORAGE SECTION.
01 WS-SUBSCRPT PIC S9(4) COMP.
01 WS-ARRAY.
02 WS-ELEMENT PIC X(5) OCCURS 10 TIMES.
PROCEDURE DIVISION.
MOVE 5 to WS-SUBSCRPT.
ADD 2 TO WS-SUBSCRPT.
MOVE ‘ABCDE’ TO WS-ELEMENT(WS-SUBSCRPT).

This will move ‘ABCDE’ to element number 7.

Hi all , will IBM agree to change the date of joining if they agree how many days they can wait ? Can anyone help me please.

And my DOJ is October 25 ..will they extend to November 11 ...and one more news I have got November and December is the freezing period they won't give any DOJ in these 2 months ...is this true or false statement can anyone respond please

IBM DOJ Change query

I am preparing for a SDE-2 role in a product based company. There are many online blogs that tells me what to prepare but I am looking out from where I can learn all of these things.

DSA - ?
LLD - ?
HLD - ?

Also let me know in the comments if you are also preparing for a switch in SDE-2 roles. 🥷

Preparing for SDE-2 at a product based company 👨‍💻

I am an early career dev with a few years of experience primarily in the frontend domain. I want to read atleast 2 technical books next year to upskill in general as a software engineer. Please share your recommendations.

Recommend Technical Books

https://www.instagram.com/reel/C4ijkPFInMJ/?igsh=MWtmZDJuejhzbm42Nw==

Gendu generation 🤡

Welcome to Indian Startups's Private Community

As a startup generalist, this has been unsettling, personally. What should all of us be doing to stay ahead of AI curve? What upskilling is required? What will be still relevant in 5-10 years?

How are you coping with the launch of Devin?

Founder

What are the questions that could be asked in an interview for a L2 level MS SQL DBA support engineer?
Anyone!!?

L2 DBA Interview

Technical Support

( Not a big fancy offer, average offer for 4 years of experience in Non FAANG )

Resources I recommend for interview prep

Coding 

- Leetcode 
- GeeksForGeeks (self-paced course by Sandeep Jain is good )
- TechInterviewHandbook ( https://www.techinterviewhandbook.org/ )

System design 

- Grokking the system design 
- Alexxu 
- DDAT ( Currently reading )

Ignore any other famous names like Gaurav Sen and Real Engineering, they are just meh.

Gaurav Sen's course felt like he never really designed any system. Too much useless theory and he himself looks a lot confused in the course. 

Real Engineer is all marketing. Not worth 40k for a course. You can use that to buy a lot of ( books resources + mock interviews ). 

His pricing strategy of course is what to buy next in his house. 


LLD 

- refactoring guru

Cracked an offer > $60k

Welcome to Business Roles's Private Community

I’m a 2022 grad, hit by onboarding delay for 8 months after graduation (during those time I grinded leetcode approx ~400 questions, learnt spring boot ) Recently I joined one of the WITCH companies which I was offered in 2021. I was trained in Java but now they put me into Mainframe project dealing with COBOL programming and DB2 and I’ve never felt this underconfident and worthless in life. I’m planning for MS in CS in 2024. Does this work experience help in anyway? Is a switch needed before I apply to masters? 
I would really appreciate if anyone could suggest me what to do.

Advice needed

System Engineer

Can anyone guide me how to clear coding assessment of IBM. It is for General Software developer. Please help me?
#recent #2024 #ibm.

IBM Coding assessment for experienced

Do anyone of you know or heard about the above languages

All About Mainframes

Discover More

IT Company Discussion on

by Dezi Denver

Société Générale

All About mainframes

Software Engineers on

by Karilyn Hyrum

Société Générale

Hoe COND code works in Mainframe!

IT Company Discussion on

by Jordon Gabriel

Société Générale

All About mainframes

IT Company Discussion on

by Jordon Denver

Société Générale

All About Mainframes

IT Company Discussion on

by Matilda Carmden

Société Générale

All About Mainframes

Software Engineers on

by Karilyn Carmden

Société Générale

Let's Mainframe! Important Interview questions for a Mainframe developer

IT Company Discussion on

by Karilyn Carmden

Student

Is learning mainframe technologies good or shall I stick to DSA?

Software Engineers on

by Isaiah Carmden

Unemployed

Stack used in banks?

IT Company Discussion on

by Jordon Lee

Société Générale

All About mainframes

Software Engineers on

by Jordon Dean

Cognizant

IBM DOJ Change query

Software Engineers on

by Jordon Lee

DotPe

Preparing for SDE-2 at a product based company 👨‍💻

Software Engineers on

by Isaiah Carmden

US Based Startup

Recommend Technical Books

Memes on

by Jordon Carmden

Accenture

Gendu generation 🤡

Indian Startups on

by Kendall Lee

Stealth

How are you coping with the launch of Devin?

IT Company Discussion on

by Blair Carmden

HCL

L2 DBA Interview

Software Engineers on

by Blair Taye

Stealth

Cracked an offer > $60k

Business Roles on

by Kendall Everett

Google

Advice needed

IT Company Discussion on

by Isaiah Denver

QBE Insurance Group

IBM Coding assessment for experienced

Software Engineers on

by Kendall Everett

HSBC

AS400/ COBOL