select qurey explanation

[jayakummar]

hai experts,

i need the explanations of this select qurey becose i not able to understand to do my work........please reply me asap.......

reward will be avail....

SELECT * FROM TBTCP WHERE JOBNAME = P_0111 AND PROGNAME = 'ZKRM_GATECNT_122_SEND_PEND' AND

LISTIDENT <> 0

order by sdldate.

MOVE TBTCP-LISTIDENT TO LL.

ENDSELECT.

thanks in advance,

jai.m

[jayakummar]

Hi,

TBTCP stores all the spool related data of Batch jobs.

The select query is retrieving Spool No. for Background jobname = p_0111 & given program name.

LISTIDENT is nothing but spool no. of the background job.

The job is sorted by date as there wud be multiple spools available for the same job. Latest job spool is retrieved.

Best regards,

Prashant

[Former Member]

Hi,

TBTCP stores all the spool related data of Batch jobs.

The select query is retrieving Spool No. for Background jobname = p_0111 & given program name.

LISTIDENT is nothing but spool no. of the background job.

The job is sorted by date as there wud be multiple spools available for the same job. Latest job spool is retrieved.

Best regards,

Prashant

[Former Member]

Hi,

this select query is for fetching the record from the table TBTCP(Background job step), in which its jobname is p_0111 and its program name is zkrm_..... and id tof the Job is 0 and then display it in the order of date of Job schecduling(sdldate).

Afte that move the value of id to the variable LL . You have not mentioned the variable LL..

Reg,

Prabakaran.S