Yes, DBRM stands for Database Request Module. It’s created after pre-compiling a COBOL-DB2 program and contains SQL statements. It’s used in the binding process to create executable code.

Lets' mainframe!  Do you know what DBRM is?  DBRM is Database Request Module and is a component inside DB2, it is created after the precompilation of COBOLDB2 program. This is a module that consist...

Welcome to IT Company Discussion's Private Community

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

Software Developer

All About mainframes- Grapevine

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

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.

Welcome to Software Engineers's Private Community

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

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!

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?

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

Do anyone of you know or heard about the above languages

AS400/ COBOL

Welcome to Indian Startups's Private Community

Why do Indian startups have many sheets being used for everything?

How much of this can be done on software. Any reason why more of this is not being done. Is this only India problem?

Why so many google sheets?

Founder’s Office

Welcome to Fintech India's Private Community

Hi all,

Is anyone working in DBS bank in C2MA platform (Analytics platform) ? I got an opportunity as business analyst. I wanted to understand about the growth opportunities and work life balance. In my previous company, i worked for extended hours most of the times and was always under pressure to deliver in short period.heard mixed reviews about DBS. Checking here to get more info. Thanks in advance

Dbs bank review

Business Analyst

Infosys is hiring for below Roles in ORC Consulting Stream. Please DM me if any want referral. 

Skill Name	Year of Exp.
Oracle Apps/Fusion Technical	2 To 13
Oracle Fusion/EBS HCM	2 To 13
Workday	2 To 13
Oracle EBS/Cloud/Fusion SCM	1 To 13
Oracle Demantra	2 To 13
Advance Supply Chain Planning (ASCP)/	2 To 13
Value Chain Planning (VCP)	
Oracle Fusion/EBS Finance	2 To 13
Peoplesoft Finance	2 To 13
Oracle Project Portfolio Management/Project Accounting	2 To 13
Oracle SOA/OSB/BPEL	2 To 13
Oracle Integration Cloud 	2 To 13
Oracle VBCS	2 To 13
Kronos	2 To 13
Oracle Retail	2 To 13
Micros Xstore	2 To 13
Hyperion	2 To 13
OBIEE/ODI	2 To 13
JDE Finance	2 To 13
JDE CnC	2 To 13
OTM	2 To 13
Oracle WMS	2 To 13
Oracle Apps DBA and Core DBA	3 To 13
PS Admin	3 To 13
Oracle Cloud Infrastructure Admin	2 To 13
Java Springboot	3 To 13
Infor (Baan/ERP LN ADMIN, Baan/ERP LN technical,	2 To 13
Baan Finance and Distribution, Baan Finance, RPG)	
Kinaxis Rapid Response	2 To 13
Argus	2 To 13
Netsuite	2 To 13
QAD	2 To 13
Siebel	2 To 13
IFS	2 To 13
Oracle Revenue Management & Billing (ORMB)	3 To 13

Infosys ORC Consulting Openings.

Analyst 

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.

I’m working as Mainframe developer for past 2years but I need career change in domain how to do and what to do ?!

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

Welcome to Office Gossip's Private Community

Hi everyone, recently i interviewed for a product position in hdfc bank. I did well and was asked to submit documents for offer release. Everything was going fine. But, a couple of days later, I was told that there's a hiring freeze in hdfc. Can someone confirm this? Thanks in advance.

Hdfc bank hiring freeze

Product Manager

Does product based companies hire Oracle or SQL DBA?

Does product based companies hire DBA's

Database Administrator

Interviewed with Agoda for Lead/Staff Full Stack role and cleared their coding, design, architecture and a special round called coding+architecture. The interview went well as per my assesment. But finally a rejection mail saying they moved with other candidates. They even asked about the ECTC (before coding +architecture round) and also asked details about relocation to Bangkok assuring that I have almost cleared interview for Staff role and final round ie was coding + architecture was meant for deciding  b/w lead and staff role. What could be reason behind this. Preferably would like to hear from someone who had similar experience with Agoda.

Interview - Lead Full Stack Agoda

Staff Engineer

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

All About mainframes

Discover More

IT Company Discussion on

by Aaron Lee

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 Isaiah Carmden

Unemployed

Stack used in banks?

Software Engineers on

by Karilyn Hyrum

Société Générale

Hoe COND code works in Mainframe!

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?

IT Company Discussion on

by Jordon Denver

Société Générale

All About Mainframes

Software Engineers on

by Kendall Everett

HSBC

AS400/ COBOL

Indian Startups on

by Kendall Lee

Stealth

Why so many google sheets?

Fintech India on

by Kendall Carmden

Epsilon

Dbs bank review

Referrals on

by Matilda Everett

EY

Infosys ORC Consulting Openings.

IT Company Discussion on

by Jordon Lee

Société Générale

All About mainframes

Software Engineers on

by Jordon Carmden

Cognizant

I’m working as Mainframe developer for past 2years but I need career change in domain how to do and what to do ?!

IT Company Discussion on

by Blair Carmden

HCL

L2 DBA Interview

Office Gossip on

by Coy Nadeen

IDFC

Hdfc bank hiring freeze

FAANG on

by Jordon Carmden

Accenture

Does product based companies hire DBA's

Software Engineers on

by Blair Lee

Stealth

Interview - Lead Full Stack Agoda

IT Company Discussion on

by Jordon Gabriel

Société Générale

All About mainframes