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
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
Can granting access to limit capabilities *partial or *no will give user the access to STRSQL?
Answer Question | October 23, 2012 9:36 AM
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
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
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
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
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
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
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
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
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
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
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
can you use the strsql command within an AS400 cl program?
Answer Question | September 9, 2010 2:37 PM
CL, CL Program, STRSQL
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
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
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