SYSIN concatenation is mostly used when you are running DB2 queries in batch. 
You have all the query ready except the input that USER provides, 
which needs to be used in the WHERE condition.

The USER data can be put in a dataset (HLQ.USER.DATA) and can be concatenated 
with rest of the query in SYSIN as shown below.

//SYSIN    DD *
  SELECT COL1, COL2, COL3
    FROM TABLE1
   WHERE COL0 =
//         DD DSN=HLQ.USER.DATA,DISP=SHR
//         DD *
     AND COL9 > 0
  ;

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

In United States, 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:

Important SQL CODES and ABEND CODES

SORT JOIN – TO JOIN TWO FILES BASED ON A KEY

KNOW YOUR MAINFRAME

REXX – INITIAL SETUP

IDCAMS – Define VSAM ESDS

IDCAMS – Define VSAM RRDS

IDCAMS – Define VSAM KSDS

IDCAMS – Define Alternate Index (AIX)

IDCAMS – Define PATH for Alternate Index

IDCAMS – Define GDG

IDCAMS – Alter GDG, VSAM or PS File

IDCAMS – Delete GDG, VSAM or PS File

IDCAMS – Print VSAM File

IDCAMS

Recovery of Deleted Tape data set (Using Volume Serial)

JCL – SYSIN CONCATENATION

JCL – RUN ONLY ONE MIDDLE STEP (RESTART)

GDG – Delete Just Versions Not BASE

JCL – COPY DCB OF INPUT FILE TO OUTPUT FILE

HOW TO SUBMIT A JOB AUTOMATICALLY AFTER A JOB FINISHES

DELETE ALL GDG VERSIONS WITHOUT DELETING BASE

LISTCAT – BATCH JOB

IEBCOPY Examples

IEBGENER – INTERNAL READER TO SUBMIT

Delete Multiple datasets with same HLQ

JCL INTERVIEW QUESTIONS

JCL TIPS