ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

Search Result

Collapse
74 results in 0.0009 seconds.
Keywords
Members
Tags
  •  

  • inigo.redin
    started a topic Trying to run big SQL script from IFS, using RUNSQLSTM
    in SQL

    Trying to run big SQL script from IFS, using RUNSQLSTM

    Hi!


    First time publishing here. Thanks for your ideas!

    I'm trying to run a big SQL script.
    It is composed by INSERT sentences. About 500.000.
    Just to try one way to migrate one file into iSeries, from another DB.

    It's ok, if the file...
    See more | Go to post

  • Daniel Thompson
    started a topic SQLState 57007 using commit control
    in SQL

    SQLState 57007 using commit control

    Hi all, I've got a problem that no one here in the office can figure out.

    I'm using statement level commitment control (compiled with commit = none but several consecutive statements in one procedure are qualified "WITH CS") in an update procedure in a new service program that...
    See more | Go to post

  • Jerry G
    started a topic RNF0655 Error referencing SQL table columns

    RNF0655 Error referencing SQL table columns

    I'm getting error RNF0655 ("Item ... was defined with TEMPLATE and cannot be used in this context.") trying to reference columns of an SQL result table. Here's a simplified example:

    Code:
    RNS9308: Compilation stopped. Severity 30 errors found in program.   
         H dftactgrp(*no)
    ...
    See more | Go to post

  • umpireprgmr
    started a topic query multiple databases on multiple servers
    in SQL

    query multiple databases on multiple servers

    My select attempts to return all records from the QA system which are not in the Dev system.

    SELECT QA.updated3,QA.acctid,QA.timestamp,QA.postingseq
    FROM AS400.ABODATA.d3p004 PR
    LEFT OUTER JOIN as400dev.abolib.d3p004 DV ON
    QA.updated3 = DV.updated3 AND...
    See more | Go to post

  • Gary B
    started a topic SQL Update First Occurrence only?
    in SQL

    SQL Update First Occurrence only?

    Hi Everyone,

    Please forgive me and let me know if this is posted twice, my first post didn't seem to work.

    I have an sql command that seems to be taking a long time to process. My RPG program processes ~ 500k records and runs in less than 1 minute, love my i.

    However...
    See more | Go to post

  • techas400
    started a topic SQL insert into 2 libraries with 1 query
    in SQL

    SQL insert into 2 libraries with 1 query

    I have the following query in SQLRPGLE for DB2:

    Code:
      INSERT INTO ITEMS2 (PROGRAM, VLDFILE, VLDFLD, 
        SELFILE, SELFLD) VALUES(:SCAPP   , 'CSTMR', 'CYC',
        'BYC', 'BYCC');
    I would like this query to be run in 2 libraries as in FIRST/ITEMS2 and...
    See more | Go to post

  • lpowell7
    started a topic SQL SELECT to retrieve last transaction Row per Customer
    in SQL

    SQL SELECT to retrieve last transaction Row per Customer

    I need a SELECT statement that will return the latest transaction row per Customer.
    Below is a test database, with test data, followed by 3 select statements. None of the SELECT statements are quite what I need.
    Any help would be much appreciated.

    CREATE TABLE CUST
    ...
    See more | Go to post

  • Mukund
    started a topic Triggers in RPGLE

    Triggers in RPGLE

    Hi All,

    I have a Physical File to which I have added a Trigger for *INSERT operation. I am calling 1 program for that Trigger. In that Program, I am updating a File which is just like an audit file having a message that the Record is Added and the Timestamp field.

    Now,...
    See more | Go to post

  • tomliotta
    started a topic SQL/CL sample

    SQL/CL sample

    A week or so ago, a thread around QShell and SQL got me thinking that I've never run across examples of SQL in CL posted anywhere; so I thought I'd put one together. I used a bunch of code I had from other things and built the following. It's thinned down quite a bit just to highlight the API calls,...
    See more | Go to post

  • GPEICM
    started a topic Sql statement to invoke sql function
    in SQL

    Sql statement to invoke sql function

    Hi,

    I created a sql function to calculate the difference between two dates (age = age + 1 if month of birth >= 6 than age = age +1), in
    datef = today date
    datei = date of birth

    PHP Code:
    CREATE FUNCTION QGPL/DIFDATA ( DATEI CHAR , DATEF CHAR ) 
    RETURNS INT 
    ...
    See more | Go to post

  • Jason Burgess
    started a topic Problems Deleting Records in Embedded SQL (V4R3)
    in SQL

    Problems Deleting Records in Embedded SQL (V4R3)

    I've got a program that's supposed to clear it's records when a job is complete. I added the following procedure into the code. It never returns an error, but the records don't actually get removed. The same SQL statement works if I use it directly from STRSQL. I'm at a loss. Any help would be...
    See more | Go to post

  • Adein
    started a topic Embedded SQL fetch into DS - Data Conversion issues
    in SQL

    Embedded SQL fetch into DS - Data Conversion issues

    I knew I had embedded sql issues before our conversion to v7r1. The log files that are coming out of the error on v7r1 are a lot more verbose that they were previously, so now I am going through and 'cleaning' up these issue.

    I am stuck on one though.

    I have a simple select...
    See more | Go to post

  • WarrenN
    started a topic RUNSQL in CLP REQUEST too long

    RUNSQL in CLP REQUEST too long

    I'm trying to run some SQL commands from within a CLP using RUNSQL REQUEST('.....'), but am running into a problem that this method seems to allow a maximum of 550 characters in a REQUEST call. Does anyone have any suggestions on other ways I might be able to do this where the length of the query won't...
    See more | Go to post

  • Poddys
    started a topic SQL Full Text Search on AS400 Database
    in SQL

    SQL Full Text Search on AS400 Database

    I have to rewrite the search box on our corporate website, and want to use something similar to what the search engines use to find records that "best" match a string.

    The existing version of the program (written in Websmart ILE) uses more than 20 SQL statements to try and match...
    See more | Go to post

  • abercrombieande
    started a topic Procedure Library List & User
    in SQL

    Procedure Library List & User

    So I create a simple procedure that calls a CL. I can see the job running when I start it. I have a few questions though.

    1. Is there anyway to get it to run under the user that submits it rather than Quser?
    2. Is there anyway to get it to run under a different job name rather...
    See more | Go to post

Our Sponsors

Collapse
Working...
X