Search found 4 matches

by waseem
Fri Nov 19, 2010 3:52 pm
Forum: CICS
Topic: ceci set prog(progname) newcopy - CICS NEWCOPY
Replies: 1
Views: 3777

ceci set prog(progname) newcopy - CICS NEWCOPY

iam getting an error PGMIDERR
when i want to modify my existing program to have a new copy
where iam giving the command in cics as


ceci set prog(progname) ne

................
where progname is my program name

plz ssomeone suggest me any solution
by waseem
Sat Nov 13, 2010 6:44 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: how to use year function in db2 - date difference
Replies: 4
Views: 7049

i tried the functions like count() year() in cobol-db2 they are not working



i think it might be that we cannot use such functions of sql in cobol-db2.....


and its not a foolish thing that i did'nt use the proper datatypes mr.dbzTHEdinosauer!!!
by waseem
Wed Nov 10, 2010 9:20 am
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: how to use year function in db2 - date difference
Replies: 4
Views: 7049

yes iam getting an unsuccesful binding error....with spufi the same query is working... even in cobol-db2 select current_date into :ws-date from sysibm.sysdummy1 is working but select year(current_date) into :ws-date from sysibm.sysdummy1 both for ws-date pic x(10) and pic 9(10) is not giving any er...
by waseem
Tue Nov 09, 2010 8:11 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: how to use year function in db2 - date difference
Replies: 4
Views: 7049

how to use year function in db2 - date difference

in my program i have to calculate the no. of years between two dates ie.,current date and a another date stored in a working storage variable but wn iam using exec sql select year( current_date - :ws-date ) into :ws-year from sysibm.sysdummy1 end-exec *01 ws-date pic x(10) value '1990-10-13' 01 ws-y...