//**********************************************************************
//* *
//* CHECK IF FILE IS EMPTY *
//* *
//**********************************************************************
//SCHKEMP EXEC PGM IDCAMS
// COND (4 LT)
//SYSIN DD *
REPRO IFILE(IT01) OFILE(OT11) COUNT(1)
//IT01 DD DSN dsnname
// DISP OLD
//OT11 DD DUMMY
// DCB (RECFM VB LRECL 2034)
// IF SCHKEMP.RC 4 THEN

//FILE1 DD *
THE FILE IS EMPTY
/*

//SYSPRINT DD SYSOUT *
//SYSABEND DD SYSOUT X
// HOLD YES
//*

Hi

i want to know to check the newly added record in dataset in vb.net

Return codes can be set to 12 if the dataset is empty and 0 if not empty using ICETOOL. Subsequent processing can follow based on the return code in the ICETOOL step as required.

In this below example Return code of STEP1 will be set to 12 if dataset USERNAME.FILE1 is empty. STEP2 will run if return code is 0 i.e if dataset is not empty.

//STEP1 EXEC PGM ICETOOL
//TOOLMSG DD SYSOUT *
//DFSMSG DD SYSOUT *
//INFILE DD DSN USERNAME.FILE1 DISP SHR
//TOOLIN DD *
COUNT FROM(INFILE) EMPTY
/*
//IF STEP1.RC 0 THEN
//STEP2 EXEC PGM *****
...
//ENDIF