Mainframe, MVS and zOS Discussion

Hi,

I am using a query for date calculation in my COBOL Program. The query is like this:


SELECT * FROM TABLENAME
WHERE AKSTAMP >= CURRENT DATE - 3 YEARS;

where AKSTAP has the format like: 2015-09-15-01.13.32.563275

Could any one suggest how to correct the query, as I get SQLCODE -401 with ...

Hi,

I also live in India.

Hi,

I found this website on google and LinkedIn.

Hi,

What is SCADA in mainframes?

Hi,

I've data in IMAGE copies, they are full imagecopies. Could anyone help me in how to load the data into the tables using IMAGE copies? Can this be done using DSNTIAUL or any alternative method is preferred usually? Please advise.