Can’t Set different Activation group in ILE SQL COBOL.
Does anyone know why when I compile an ILE SQL COBOL program it shows it going to Activation Group QILE but in the COMPILE prompts I don’t see any option to change the group to something else like our company name?  In a Cobol ILE program the option is there but not in COBOL SQL ILE program? [...]

Answer Question   |  December 8, 2010  3:45 PM
AS/400, AS/400 SQL, COBOL ILE, SQLCBLLE, V5R4

Need a sample code for Sql fetching multiple rows
In Native cobol we use read PF file in a loop until EOF to fetch all records.Now i need to do the same by using Sql in cobol,eg: select * from File and show it in subfile.Can anyone help me how to do this. How to move recods from curson to screen.Thankx in advance for [...]

Answer Question   |  April 19, 2010  8:55 AM
SQL, SQLCBLLE

“GET DIAGNOSTICS” SQL Procedure
I am currently writing an SQLCBLLE Program on a V5R2 box. I would like to use the SQL Procedure “GET DIAGNOSTICS”, however each time I enter it into my code the both SEU and the compiler complain about it. I receive the message GET was not expected. I know the procedure was supported in V5R2 [...]

Answer Question   |  May 13, 2008  2:37 PM
COBOL, GET DIAGNOSTICS, SQL, SQLCBLLE

Need a COBOL QMHRTVM Example
Does anyone have a code snippet they would be willing to share that demonstrates the parameter setup and the call for the API QMHRTVM? I am lousy with API’s but I need to incorporate this one into two of my SQLCBLLE Programs.

Answer Question   |  May 14, 2008  2:32 PM
COBOL, COBOL stored procedures, QMHRTVM, SQLCBLLE