I’m trying to process a RUNDATE = 2009-08-07 into my COBOL code via a PARM-DATE Link. That date comes in… now I try to place it in the following piece of code: EXEC SQL SET :WS-PREV-WK = CHAR(DATE(TMP-DATE)- 7 DAYS) END-EXEC. What am I getting ’0001-01-01′ returned?
I want to optimize my stored procedure in SQL Server, as it takes some time to execute. It uses a temporary table to store some data, and then it uses a dynamic query that we execute using the EXEC statement. How can I remove temporary table or, in general, how can i improve performance of [...]
I’d appreciate some help here. My JCL background is HP3000 / MPEX and HP-UX, but my IBM mainframe JCL experience is over ten (10) years old. So I’m having problems creating a JCL – my brain can’t remember command syntax’s from that long ago. I need to create a JCL that will accept an input [...]
WE are dealing with stored procedures in a PL/SQL program. I am trying to execute the procedure from within the program itself. Is there a need to do it within a cursor or is there a specific manner to do that?!





