How to debug an SQL Stored Procedure?
Answer Question | November 16, 2012 1:14 PM
SQL, 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
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
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 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
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
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?
Answer Question | October 7, 2009 2:16 PM
JOIN statement, SQL procedure
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