i friends greetings to the day...!!! I face a quation
like"while runnig the programe every day i have to access
the previous day updates only...!! Ex:- Let last day 100
customers took bank account i have to select those
customers only.."

Answer Posted / sa

If the database is getting updated daily with the records,
next day you can write the query which will have records
only for the current day.

Select * from Lib/Database
where WS-Date > Give the date when the database is last updated

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

If you are current on the owner of a set, what is the difference between an obtain next and obtain first? Actually in which topic will we use dis???Plz explain it clearly

2656


What is the local-storage section?

681


Write a program to enter and display the names of students in a class using the occurs clause.

647


Which is the default, TEST BEFORE or TEST AFTER for a PERFORM statement?

816


What is the difference between external and global variables in COBOL?

810






What is amode(24), amode(31), rmode(24) and rmode(any) (applicable to only mvsesa enterprise server) ?

670


What is the difference between perform … with test after and perform … with test before?

877


How you can characterize tables in cobol?

710


what is difference bt COND, REGION & TIME parameters at JOB & EXEC. give an exp.

8155


) how do u code after getting data?

1578


here is my requirement A1 is alphanumeric with value 'A1B2C3D4' as defined below 05 A1 PIC X(8) VALUE IS 'A1B2C3D4' but i need to have A2,A3 as ABCD & 1234 repectively...... A2 = ABCD A3 = 1234 Can you please explain me what are the different ways to do it?

6805


How do u write test cases?

1633


How do you code cobol to access a parameter that has been defined in jcl? And do you code the parm parameter on the exec line in jcl?

695


How to fetch 1000 error records from VSAM file(Eg: 1000000 records present) while getting SOC7 abend ?

1924


If you are current on the owner of a set, what is the difference between obtain next and obtain first?

639