Can we restrict the fields in OPNQRYF?
Like we select fields in STRSQL, is there a way I can specify the fields I want in OPNQRYF? Say I have 40 fields in my file, but I am interested in 10 fields and wanted to make a CSV out of it. Can I achieve this with OPNQRYF instead of creating another file with [...]

Answer Question   |  February 11, 2013  9:19 AM
AS/400, OPNQRYF, STRSQL

Viewing stored procedure statements in AS/400
Hi, I created many stored procedures using STRSQL. And I called those procedures using SQLRPGLE program. It worked but I need to view those statements. I don’t know how to view stored procedure statements which was created using STRSQL. Can anybody help me?

Answer Question   |  January 22, 2013  10:26 AM
AS/400, SQLRPGLE, STRSQL

Accessing STRSQL
Can granting access to limit capabilities *partial or *no will give user the access to STRSQL?

Answer Question   |  October 23, 2012  9:36 AM
AS/400, STRSQL

RUNSQLSTM command failed
I have a CL program having the following RUNSQLSTM RUNSQLSTM SRCFILE(AMITS/AMITSRC) SRCMBR(LISTMSGF) I am receiving SQL9010 error when running the CL program… Any hint on where is the problem?

Answer Question   |  August 29, 2012  12:29 PM
rpfle, STRSQL

Not able to create procedures using STRSQL on V6R1
While creating a procedure in V6R1, [strong]Not authorized to CREATE PROCEDURE error (Message ID is SQL0552)[/strong] appears. In Additional Message Information cause of the error being — [strong]CREATE PROCEDURE or CREATE FUNCTION requires the *OBJOPR and *ADD authority to the catalog table SYSROUTINES in QSYS2[/strong]. However [strong]PUBLIC[/strong] has [strong]*CHANGE[/strong] Authority on [strong]QSYS2/SYSROUTINE[/strong] Object. Please note my [...]

Answer Question   |  March 31, 2012  7:22 AM
AS/400 DB2, AS/400 SQL, iSeries V6R1, STRSQL

How to Monitor File Changes done thru STRSQL
I need a solution for monitoring file changes done by programmers using the STRSQL from a command line for SOX purposes.

Answer Question   |  June 20, 2011  6:44 PM
AS/400 administration, AS/400 SOX, Command line, SOX, STRSQL

How to get the output of journal data like a physical file data to use in STRSQL?
HI All, Normally DSPJRN is used to display the Journal, but however its not in a understandable way. Can any one suggest how to get the output of journal data like a pfhysical file data to use in STRSQL.

Answer Question   |  October 18, 2010  1:26 AM
AS/400, AS/400 journaling, AS400 physical file, DSPJRN, iSeries, STRSQL

How to use RPGLE function/program as a function in STRSQL
Hi All, I have an RPGLE program which takes as a input value and update it and return the updated value. I want to use this RPGLE program through SQL while executing SQL scripts.  I did not remember the procedure to use it, but I have used in the past.  Any of you have idea [...]

Answer Question   |  February 24, 2010  5:54 AM
RPGLE, RPGLE Stored Procedures, STRSQL

Auditing users of STRSQL
I want to audit the SQL statements of users who use STRSQL. I know if you press F13, you can change the interactive SQL Session Services. If you choose option 4 it will save all SQL statements into a file. But I was wondering if it is possible if we setup this as default when [...]

Answer Question   |  February 18, 2010  9:02 PM
SQL, SQL audit, STRSQL

Different results for embedded SQL
I have embedded SQL in my RPG code and some of the results are different to what I get when I check using STRSQL

Answer Question   |  February 1, 2010  7:08 PM
Embedded SQL, RPG, SQL, STRSQL

Working with STRSQL command in AS/400
How to select a particular member from Physical file through STRSQL. Can anyone give me the sample sql statement to access a particular member from Physical file ? Thanks in advance.    

Answer Question   |  October 3, 2011  5:56 AM
Physical Files, STRSQL

How can I tell if I have SQL loaded.
I am an old as/400 hack.  I used to be able to start a SQL session by typing in the STRSQL command.  This is not working for me.  Is this the wrong comand or is SQL not loaded on this machine?  How do I validate?

Answer Question   |  November 11, 2009  6:29 PM
AS/400 SQL, STRSQL, V4R5

how to block update command when using STRSQL ( db2/400)?
Hi People , I got several analysts that they must only use Select command through STRSQL prompt, I found I can block update command changing the object authority but I have loads and load of tables to change, is there any easier way to do that?

Answer Question   |  July 24, 2009  4:46 PM
AS/400, AS/400 DB2, DB2, STRSQL

DB2/400
I have created one Physical File with 1 key field. After that i added some datas in that file. Records in file are displayed in Arrival order While Viewing the Records using DSPPFM, STRSQL Commands. As per my assumption, it should be ascending order. Why it is not displaying in Ascending order?

Answer Question   |  July 6, 2009  3:51 AM
DB2/400, DSPPFM, STRSQL

strsql
can you use the strsql command within an AS400 cl program?

Answer Question   |  September 9, 2010  2:37 PM
CL, CL Program, STRSQL

SQL/400
Hi friends, I have on my System many Users with the userclass *SECOFR, How can I determine only one user to use the command STRSQL ?,

Answer Question   |  October 17, 2009  12:02 PM
*SECOFR, AS/400 security, AS/400 user profiles, SQL/400, Start Structured Query Language, STRSQL

How to save the output from an SQL select statement to a spool file
Please can someone tell me how I can save the output from an SQL select statement to a spool file. Thanks, Tom

Answer Question   |  June 19, 2011  10:23 AM
SELECT statement, Spool files, Spool to Flat, SQL, SQL statements, Start Structured Query Language, STRSQL

STRCMTCTL
what is compulsory parameter of STRCMTCTL ?

Answer Question   |  July 12, 2011  10:42 AM
SQL/400, Start Commitment Control, Start Structured Query Language, STRCMTCTL, STRSQL