SQL Precompiled Failed
In SQLRPG program, when a compile a program it is showing the error SQL Precompiled Failed. I have given the sql syntax correctly. but I cant able to find the error. What may be reason for it? Please clarify.   Jayashree V.

Answer Question   |  March 19, 2012  1:17 PM
AS/400, AS/400 and SQL, SQLRPG

Embedded SQL using SUM or some other method to total up qty and display 1 unique record
I have an sqlrpgle pgm setup, I want to add another sql select statement. I have a file that contains barcode label data, where multiple records can be assigned to the same Master serial #. My sqlrpg pgm is display various sorts in a screen inquiry. I want to setup my select, to display one [...]

Answer Question   |  June 10, 2011  11:30 AM
Embedded SQL, SQL, SQL Select, SQL Select statement problem, SQLRPG

Help needed for connect statement using sqlrpg
Hi All, I need to do some checking in 2 different AS400 servers. I will read the data from one server(say local) then using connect type 2, connect to the other server(say remote), check the data and then returns back to my local server. I’m using sqlrpg for this and created 2 pgms for this. One will [...]

Answer Question   |  October 21, 2010  9:39 AM
AS/400, AS/400 Server, RPG, SQL, SQLRPG

SQL and RPG 400 (SQLRPG) Variable lengths help required.
Please could someone help me with the following, I am new to SQL and have been tasked with the following:- I am writing an RPG program where the user will be able to do a search by entering up to 15 characters to find part numbers. I know how to do this using SQL but [...]

Answer Question   |  July 8, 2010  8:00 PM
SQL, SQLRPG

SQLRPGLE – Result Set
I have an SQLRPGLE program [PGMA] containing the following: D ResultSet       DS                                 D                                     Qualified      D                                     Occurs( 9999 ) D  AAuUserId                   10 D  AAuValFr                      10     C/EXEC SQL                                              C+ CALL XXDLIB/PGMB (:##BegNo, :##EndNo, :##UserID)   C/END-EXEC                                              PGMB has the same DS structure defined as in PGMA and successfully populates the DS ResultSet in PGMB How do I get SQLRPGLE [...]

Answer Question   |  February 26, 2010  2:37 PM
AS400 Data Definitions, Data structures, Programming, RPGLE, SQLRPG, SQLRPGLE

SQL-RPG
Hi Every body ! I have been working on V4R4M0, Now have to work on SQL-RPG Programs. I don’t know, how to write queries and other things . Can some one help me to learn SQL-RPG with good meterial ?

Answer Question   |  February 11, 2010  11:54 AM
SQLRPG, V4R4, V4R4M0

AS/400 stored procedures
Is there a way to list the existing stored procedures on our box ? Those that wrote them are gone and documentation is sketchy. We found some by using any SQLRPG source as a clue but none of these were “create” routines (some were actual procedures). Seems like there ought to be an easier way.

Answer Question   |  August 26, 2009  7:13 PM
AS/400, SQLRPG, Stored Procedures

Delete variable file in SQLRPG
How can I use any variable file in an instruction SQL of DELETE in SQLRPG?

Answer Question   |  June 4, 2009  9:01 AM
DELETE statement, SQL, SQL variables, SQLRPG

SQLRPG MaTERIAL
I got a task to work on SQLRPG programmes , but I am very new to this environment . Can any one send me any link about : SQL-RPG . I need from scratch. Thanks in Advance.

Answer Question   |  April 20, 2009  9:24 AM
SQL, SQLRPG

redord retrieval in SQLRPG
Hi, can anybody tell me how to retrieve a record randomly using cursors…(say 8th record) using SQLRPG(Embedded sql)

Answer Question   |  February 10, 2009  8:11 PM
Embedded SQL, SQLRPG

Unable to use delete statement in SQLRPG
Hi I want to use this query delete from abc a where rrn(a) between 1 and 10 in an sqlrpg prog.I was getting error messages saying rrn keyword not allowed.Am not sure how to execute this in an embeddd sql program.

Answer Question   |  January 22, 2009  11:43 AM
DELETE statement, Embedded SQL, RPG, SQL, SQLRPG

OPNQRY and WRKQRY
In wrkqry there is an option to save the selected records to an output file.Similarly is there a way to use OPNQRY in a CL or in an SQLRPG to directly move the selected records to another file?

Answer Question   |  December 18, 2008  1:11 PM
CL, Open Query, OPNQRY, Query/400, SQLRPG, Work with Query, WRKQRY

RPQSQL / SQLRPG
Any body please help Wanted to know the advantage and disadvantage using RPGSQL / SQLRPG I’ve heard that this is the new one its not only RPG but become one with SQL. Thanks in advance

Answer Question   |  April 29, 2010  12:31 AM
RPG, RPG ILE, RPG IV, RPG/400, RPGILE, RPGLE, RPGSQL, SQLRPG