SQL procedure Questions

1

Debug
How to debug an SQL Stored Procedure?

Answer Question   |  November 16, 2012  1:14 PM
SQL, SQL procedure
asked by:
35 pts.

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
asked by:
1,240 pts.

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
asked by:
15 pts.

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
asked by:
15 pts.

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
asked by:
0 pts.

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
asked by:
975 pts.

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
asked by:
55 pts.

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
asked by:
5 pts.

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
485 pts.

1