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?
Answer Question | August 10, 2009 8:08 PM
COBOL, EXEC, Programming, SELECT
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 [...]
Answer Question | April 2, 2009 4:47 PM
EXEC, SQL Server stored procedures, SQL Server tables
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 [...]
Answer Question | June 11, 2008 1:08 PM
DB2, DSNTEP2, EXEC, JCL, SQL
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?!
Answer Question | April 28, 2008 10:53 AM
EXEC, PL/SQL, SQL Server stored procedures, Stored Procedures