Mainframe, MVS and zOS Discussion

Seema Jain

zum13
The alternative is to substring the field in a MOVE statement:

MOVE WA-INPUT-FIELD (5:4) TO WA-OUTPUT-FIELD

which will copy four characters from WA-INPUT-FIELD starting at position five to WA-OUTPUT-FIELD.

Thank you zum13. I've used this, will this work for Variable records also?

Seema Jain

If I have an input file containing data like 12345578, and I want the output to include only 5578, what would the logic for this be in COBOL?

Seema Jain

Thanks all.

Code: Select 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 ...

Mainframe, MVS and zOS Discussion

Search found 6 matches

Re: Include only part of input in output.

Include only part of input in output.

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.