RPGSQL

SQLCODE = 1077952576

All- I'm getting the above error code from an RPGSQL program. This is just after a DECLARE statement. Other fields in the SQLCA are blank. I can run the statement in Interactive SQL w/o errors. I should be getting a small subset. I get 0 records. Any Ideas?  It's not in the SQLCODE finder. Phil ...

Defining a sort variable (ORDER by) in RPG SQL

I have a file that I would like to sort on a specific column that a user would choose. I sort the file by an imbedded SQL statement: ORDER by PRDNO. Works fine. If I try and make it a variable (ORDER by :Sort_Seq), the statement is ignored. Is there a way to make the ORDER by a variable in RPG...

How do I populate an SQL table created on the fly in RPGLE?

I am writing a report program where I create a table that is then converted to an Excel spreadsheet using SQL2JXL. I am able to dynamically create a table with Execute Immediate but I have been unable to populate it. The problem is the table name is stored in a variable within the program and I...

Embedded SQL in RPG ILE

I want to write a program that will retrieve any field(s)from any file on the iSeries. The only part I haven't figured out is how to code the fetch statement to populate variables that aren't known until execution time

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