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
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
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
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
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
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
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
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
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
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
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
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
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