Debug
How to debug an SQL Stored Procedure?

Answer Question   |  November 16, 2012  1:14 PM
SQL, SQL procedure

How to insert data from SQL procedure
How can I insert data from SQL procedure. I am using cursor.

Answer Question   |  October 16, 2012  8:42 AM
AS/400, SQL procedure

CL/QMQRY
i hav code   STRQMQRY QMQRY(SQLPROC) OUTPUT(*OUTFILE) + OUTFILE(QTEMP/SQLDT)   In SQLProc txt file i am callin a sql procedure , developed using i series navigator and return data set using cursor. i want this cursor output in qtemp/sqldt file. in sqlproc if i mentioned SELECT statment , then it will work fine, but i want [...]

Answer Question   |  June 7, 2012  12:16 PM
AS/400, QMQRY, SQL procedure

Can you use variables as input and output when calling a stored procedure in COBOL?
If you move data into your variable before calling your procedure, can the procedure then return a value back, which might be different? The procedure will intially be searching for the variable data, but, according to our .net programmer, will return a blank or null if it does not find the data. So far, that [...]

Answer Question   |  June 27, 2011  5:02 PM
CL variables, COBOL, SQL procedure, SQL variables, Variable fields

Do I need SQL?
DO I need it? I am just a home user anf oerform simole tasks, but have 8 examples of SQL programs in my program list. I have win 7 64 bit O/S

Answer Question   |  November 29, 2010  11:19 AM
SQL, SQL procedure, SQL Server, SQL statements

Documenting stored procedure jobs in SQL 2005 enterprise
Our consultant created several stored procedure jobs within SQL 2005 enterprise. How can we view them to document them? SQL runs on a Windows 2008 box with 32gb of memory.

Answer Question   |  November 1, 2010  2:19 PM
SQL 2005, SQL procedure, SQL Server 2005, SQL Server 2005 Enterprise Edition, Stored Procedures, Windows Server 2008

Getting error when i am trying to insert the record in QTEMP file trough QSH DB2 command
i am trying to insert the record in QTEMP file trough QSH DB2 command but getting an error that file not found in QTEMP eventhough file is available in QTEMP. if i am giving my local libary instead of QTEMP then its working perfectly.

Answer Question   |  July 5, 2011  6:27 AM
DB2, Qshell, QTEMP Library, SQL procedure

Why are naturl JOIN keywords not an option for producing a self-join?
Why are naturl JOIN keywords not an option for producing a self-join?

Answer Question   |  October 7, 2009  2:16 PM
JOIN statement, SQL procedure

SQL proceedure to join header and detail file
I want to know how to set up a SQL procedure that joins a header file and detail file where the status field in header = ‘X’ then updates this header record after selecting the detail records.

Answer Question   |  November 4, 2008  5:48 PM
AS/400, DB2, SQL, SQL procedure