Forced Date Routine Processing
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

Optimizing a SQL Server stored procedure
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

Rookie using DSNTEP2 and IBM JCL – Need Help with JCL
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

Running Procedures within the PL/SQL program
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