Mainframe, MVS and zOS Discussion

Seema Jain

Thanks all.

WHERE DATE(TIMESTAMP_COLUMN) > CURRENT DATE - 7 YEARS;

has worked.

Seema Jain

Thanks for your help William Collins. This JCL has worked for me

Code: Select all

//STEP1 EXEC PGM=SORT 
//SYSOUT DD SYSOUT=* 
//SORTIN DD DSN=my.tape.dataset,DISP=SHR 
//SORTOUT DD DSN=my.disk.dataset, 
// DISP=(,CATLG,DELETE), 
// UNIT=WORK,SPACE=(CYL,(50,100),RLSE) 
//SYSIN DD * 
OPTION COPY 
STOPAFT=500
/*

Seema Jain

Hello all-

I am using the following query: Please suggest how to correct it ?

Code: Select all

SELECT * FROM TABLEN  
some conditions
WHERE timestamp_column > CURRENT DATE - 7 YEARS;

I am simply trying to get the data of 7 years from current date. But it ends in SQLCODE -401.

Thank you.

Seema Jain

Hi, Some of the files are on tape and have a very huge volume of data. I am trying to bring it on disk to see the records. Could anyone tell me how to limit the display of records on disk while copying from tape. I do not want take copy of al the data, I just want to see some sample data. I am using...

Mainframe, MVS and zOS Discussion

Search found 4 matches

Re: Help needed in SQLCODE -401.

Re: Limit the display of records while copy.

Help needed in SQLCODE -401.

Limit the display of records while copy.