Srini

COBOL – SQLCA is Not Mandatory- Why

SQLCA – Also called SQL communication is area, is not mandatory in COBOL Program. 01 SQLCA. 05 SQLCAID PIC X(8). 05 SQLCABC PIC S9(9) BINARY. 05 SQLCODE PIC S9(9) BINARY. 05 SQLERRM. 49 SQLERRML PIC S9(4) BINARY. 49 SQLERRMC PIC X(70). 05 SQLERRP PIC X(8). 05 SQLERRD OCCURS 6 TIMES PIC S9(9) BINARY. 05 SQLWARN.…

List of Mainframe User Companies Worldwide

http://www.sysed.com/tech_assessments/leader/mainframe_legacy_systems.asp

How to Rank the Output Using Over Partition By DB2 SQL

How to rank the data in the output using partition by statement in DB2 SQL query

Best JCL Interview Questions – Splitting Input File

Sample JCL for SORT and more interview questions.

DB2 Functions POSSTR Alternative to LOCATE

LOCATE and POSSTR string functions in DB2

Here is The Permissible Length of DB2-Object-Names

The maximum limits that can be used in DB2 database a quick reference.

How to Use Micro Focus COBOL on UNIX

The complete information and download free e-book on micro focus COBOL. Given all the key details about different flavours of micro focus COBOL. Read more.

SQL: What Is An Index

SQL why you need Index and its complete tutorial

IMS DB – User (System) Abend Codes

In the IMS database, you will get errors(abends). This complete list provides you the reason for abend(error) and resolution.

Srinimf.Jobthread | India,USA,World IT Jobs

http://srinimf.jobthread.com

COMMIT Vs ROLLBACK top differences to manage data

COMMIT and ROLLBACK are two popular statement in SQL. What is COMMIT and ROLLBACK explained in a way that any layman can understand the concepts and apply to their projects.

SQL NULLs Complete Tutorial

NULL BASICS: An arithmetic operation involving a NULL returns NULL. For example, NULL minus NULL yields NULL, not zero. A boolean comparison between two values involving a NULL returns neither true nor false, but unknown in SQL’s three-valued logic. For example, neither NULL equals NULL nor NULL not-equals NULL is true. Testing whether a value…