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...
Announcement
Collapse
No announcement yet.
Search Result
Collapse
74 results in 0.0009 seconds.
Keywords
Members
Tags
-
Trying to run big SQL script from IFS, using RUNSQLSTM
-
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...
-
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)
-
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...
-
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...
-
SQL insert into 2 libraries with 1 query
I have the following query in SQLRPGLE for DB2:
I would like this query to be run in 2 libraries as in FIRST/ITEMS2 and...Code:INSERT INTO ITEMS2 (PROGRAM, VLDFILE, VLDFLD, SELFILE, SELFLD) VALUES(:SCAPP , 'CSTMR', 'CYC', 'BYC', 'BYCC');
-
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
...
-
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,...
-
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,...
-
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
-
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...
-
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...
-
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...
-
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...
-
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...
Our Sponsors
Collapse
