Tags

, , , , , , , , , , ,

I have been using T-SQL for some time now in a project where we are migrating an application from Mainframes (Using DB2) to Azure (SQL Server). Below are few differences that I have noted. I will keep adding to the list as and when I come across new ones.

1. To select data from table without having any locks on it

DB2 SQL – Uses “WITH UR” at the end of the SQL statement

SELECT *
FROM SYSIBM.SYSTABSTATS
WITH UR;

T-SQL – Uses “(NOLOCK)” right after the table name

SELECT *
FROM SYSIBM.SYSTABSTATS (NOLOCK)
;

2. To select only first “n” rows from the returned result set of the query

DB2 SQL – Uses “FETCH FIRST n ROWS ONLY” at the end

SELECT *
FROM SYSIBM.SYSTABSTATS
FETCH FIRST 100 ROWS ONLY
WITH UR;

T-SQL – Uses “Top n” after the SELECT

SELECT TOP 100 *
FROM SYSIBM.SYSTABSTATS (NOLOCK)
;

More coming …

——————————————————————————————————–

If you would like to Earn Free Stocks, Credit card Points and Bank account Bonuses, Please visit My Finance Blog

——————————————————————————————————–

You may also like to look at:

Working on Mainframes – Is Change to a different technology necessary
Important SQL CODES and ABEND CODES
SORT JOIN – TO JOIN TWO FILES BASED ON A KEY
KNOW YOUR MAINFRAME
REXX – INITIAL SETUP
HOW TO SUBMIT A BATCH JOB FROM THE CICS PROGRAM
CICS – EXEC interface block – EIBRESP Values
CICS – EXEC interface block Fields
Flow of control between COBOL programs, run units, and CICS
CICS INTERVIEW QUESTIONS
CICS TIPS
COBOL – COPY and INCLUDE statements
COBOL – PERFORMANCE IMPROVEMENT
COBOL – SIGN STORED IN COMP, COMP-3 AND DISPLAY FORMATS
SHORTEST COBOL PROGRAM
RESTART LOGIC IN COBOL DB2 Program
GOBACK – EXIT PROGRAM – STOP RUN
Continuation lines in COBOL
Computational items – COMP, COMP 1 , COMP 2, COMP 3
COBOL program format
cobol indicator area column-7 and area a and area b
COBOL INTERVIEW QUESTIONS
COBOL TIPS
COBOL COMPILER OPTIONS
The IDENTIFICATION DIVISION