1
  • iSeries Catalog Tables

    Hi, What are the privileges required to access all the Catalog tables as (SYSCOLUMNS,SYSCST,SYSFUNCS,SYSCST,SYSKEYS,SYSPROCS,SYSTRIGGERS,SYSVIEWS) from STRSQL.

    HABBIE820 pointsBadges:
  • Display records in ascending order in DB2/400 physical file

    I have created one physical file with 1 key field. After that I added some data in that file. Records in the 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?

    rajeshece1,215 pointsBadges:
  • SQL/400: STRSQL command

    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?

    RBDSILVA550 pointsBadges:
  • STRSQL command

    Can you use the STRSQL command within an AS/400 CL program?

    Pb5410 pointsBadges:
  • 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 the 10 fields?

    RamvishakRamesh2,505 pointsBadges:
  • 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?

    LakNar270 pointsBadges:
  • Accessing STRSQL

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

    100282145 pointsBadges:
  • 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?

    97834441841,355 pointsBadges:
  • 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...

    Haaiderali215 pointsBadges:
  • 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.    

    AmuthaTPT30 pointsBadges:
  • STRCMTCTL

    what is compulsory parameter of STRCMTCTL ?

    Aum15 pointsBadges:
  • 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.

    poorboy01105 pointsBadges:
  • 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

    Tomotsk75 pointsBadges:
  • 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.

    Kar425 pointsBadges:
  • 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 that, how to use RPGLE...

    Iamsubbarao60 pointsBadges:
  • 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 starting up STRSQL? So...

    AS400 - Ask the Expert485 pointsBadges:
  • 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

    Macitmich20 pointsBadges:
  • 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?

    BreisJ10 pointsBadges:
  • 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?

    Altino20 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following