Star Insurance Case Study ( Mainframe)

₹ 600.00 — 1,500.00 INR

2.
Using JCL, create Vsam KSDS file ‘USERID.
POLSTAT.
KSDS’ and copy the data from input PS file into Vsam KSDS file.

3.
Using SPUFI, create a table POLICYTB with the below columns, to keep track of the details of all policies.

Column name

Data type & length

Constraints

POLNO

Char 6

Not null

HOLNAME

Char 20

Null

POLSTAT

Char 10

Not null

POLTYPE

Char 9

Not null

POLPREM

Decimal (7,2)

Null

4.
Using SPUFI, insert the following data into POLICYTB.

POLNO X(06)

HOLNAME A(20)

POLSTAT A(10)

POLTYPE X(09)

000210

NARESH

EXPIRED

CAUSALITY

000230

KUMAR

EXPIRED

ANNUITY

000250

RAJU

EXPIRED

LIFE

000270

RANI

EXPIRED

TERM

000290

CHANDHU

EXPIRED

CAUSALITY

IBM MAINFRAMES: CASE STUDY

5.
Using COBOL Program,

a.
Use the Vsam KSDS as an input and table as Output.

b.
Read each record from the Vsam KSDS file

c.
And insert each record from the Vsam KSDS file into the table POLICYTB created with the below condition

i.
If POLSTAT = ‘NEW’ then update the table with the value as ‘ACTIVE’ in the field ‘POLSTAT’.

d.
Handle Null indicators for the same.

e.
For all Active policies update the policy premium depending on policy type as below: i.
Life -> 5000

ii.
Annuity -> 1000

iii.
Term -> 500

iv.
Causality -> 1500

v.
Medical -> 2500

f.
For all Expired policies update policy premium as ZERO.

6.
Write the below output in the respective files,

a.
Total record count inserted into table in the output file

‘USERID.
POLCNT.
OUT’.

b.
Total record count of active policies in the output file

‘USERID.
ACTPOL.
OUT’.

c.
Total record count of expired policies in the output file

‘USERID.
ACTPOL.
OUT’.

7.
Create a BMS screen to display/fetch data from the table ‘POLICYTB’. a.
BMS map fields are same as POLICYTB.

Field names

POLNO

HOLNAME

POLSTAT

POLTYPE

POLPREM

COBOLIBM Db2

Similar Freelance jobs:

Required:- Ibm Maximo Installation

IBM BPMIBM Db2IBM MQIBM DatapowerIBM Cloud Place Bid

Having a requirement to Install/configure ibm maximo with sample db. Thanks

Full Description of Required:- ibm maximo installation

Cobol Coders Required

COBOLCodingProgramming Place Bid

There are some simple programming questions related to cobol you need to solve.

Full Description of COBOL Coders Required

Ibm Db2 Reporting Application

SQLMySQLDatabase AdministrationDatabase ProgrammingIBM Db2 Place Bid

We need a web application to run queries for retrieving reports from IBM DB2 database. we will provide the queries for that purpose. the client application will consist of this as below 1- Each button for different query when they press it. it will export the report based on that query in Excel 2- User can select the data range that are available in the SQL query

Full Description of IBM DB2 Reporting application

Ibm Db2 Data Export/import And Docker Setup

Database AdministrationDockerIBM Db2 Place Bid

This project entails exporting data from an existing AS400 machine and importing the data into a a db2 docker image (ibmcom/db2 on dockerhub). we will want to include not just the tables but also the stored procedures, etc. Using DB2 export/restore would be preferred as there are a several schemas and over 200 tables in each schema.

Full Description of IBM Db2 data export/import and docker setup

Jdbc Ibm Db2 Project

Engineering & ScienceJavaSQLAS400 & iSeriesIBM Db2 Place Bid

i need a simple website that connects to IBM DB2 database using JDBC. the website contains login then after login it consists of some buttons . each button runs SQL query and exports the output in excel

Full Description of JDBC IBM DB2 Project

Microfocus Cobol Project

COBOLOracle Database Place Bid

Currently I am working in Microfocus COBOL project. Which is existing project we need to do the enhancements in the project. Required skills- Microfocus COBOL, Oracle database

Full Description of Microfocus COBOL project

Micro Focus Cobol

COBOLOracle Database Place Bid

currently I am working on a Micro focus cobol project. which is exisisting project we need to do the enhancements in the project by requirements. required skills: Micro focus cobol, oracle database

Full Description of Micro Focus COBOL

Need Consultant For Db2 Managed Services

IBM Db2 Place Bid

We need consultant for DB2 managed services and need support for pure scale environment . Attaching details about requirement This is long term requirement and will have contract for 1 year

Full Description of Need consultant for DB2 managed services

Cobol Project

COBOL Place Bid

My project is based on reading student records and course records from external files, producing a student report for each student using the data on each student record and producing the audit trail for the process (records read and records written).

Full Description of COBOL Project

Cobol Mainframe Developer

COBOL Place Bid

Urgently need COBOL mainframe developer

Full Description of COBOL mainframe developer

Claims Edit Optimization

COBOL Place Bid

Its a claims project , in that we are working on EDIT OPTIMIZATION project to Automate the claims to the systems through this process

Full Description of Claims Edit optimization

Cercasi Programmatore As400 Ibm

JavaSQLItalianIBM Db2RPG Development Place Bid

Cerchiamo programmatori AS400 che parlino italiano

Full Description of Cercasi programmatore AS400 IBM

Need Trainers For As400 Erp

AS400 & iSeriesIBM Db2RPG Development Place Bid

we are looking for trainer for AS 400 ERP Mandatory: • RPGLE/SQLRPGLE/RPG/CLP programming • Basic DB2 (understanding of physical file/logical file/key field/Access path/SQL/level check) • Basic AS400 commands (For eg. DSPFD, DSPFFD, WRKOBJLCK,CHGPF etc. – what are they and when to use) • Basic OS/400 level (Batch job, Interactive job, Data-queue, Data-area, QTEMP etc) Good to have: • ILE concepts (Service programs, procedures, binding directory) • Issue resolution (MSGW analysis, understanding of different errors and resolution like decimal data error,…

Full Description of Need Trainers for AS400 ERP

Db2 Express C V10 Image Mount Permission Issue In Docker

LinuxDockerIBM Db2 Place Bid

Hi, I am trying to deploy db2 image using docker. I am using below command to start db2 engine from dockerfile. RUN su - db2inst1-c "abc.sh" #####abc.sh###### #!bin/bash db2start ------------------------------------------------------------------------------------- I am trying to modify the above command like below, USER db2inst1 RUN abc.sh #####abc.sh###### #!bin/bash ~db2inst1/sqllib/adm/db2start the db2start cmd failed because one or more db2 db manager program files was prevented from executing with root privileges by file system mount settings. Please help to fix this.

Full Description of Db2 express c v10 image mount permission issue…

Etl Informatica Support

SQLUNIXDatabase AdministrationInformatica Powercenter ETLIBM Db2 Place Bid

Coordinate with IT Stakeholders and IT Services on the outlined ETL Support Scope of Work for Data Warehousing. · Perform batch job monitoring on scheduler, handover and takeover of support functions with the offshore support team. · Communicate proactively on job status, delays and other support dependent updates to the IT stakeholders and end consumers. · Engage on recovering the production failures and get the pipelines on BAU mode as required by joining the Severity calls and bridges. · Update…

Full Description of ETL Informatica Support