• SQL/400 field editing

    What is the best (easiest!!) way to add editing to fields in an SQL-created table?

    DanTheDane2,555 pointsBadges:
  • Can I write a program in CL to update a record on a database file?

    Hi, I am not familiar with RPG. Is it possible to write a program in CL to update records in a database file? I have thought about SQL, however I do not have any SQL front end installed on the AS/400.

    Alanyegambaram15 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 command or is SQL not loaded on this machine?  How do I validate?

    BreisJ10 pointsBadges:
  • How to read multi member Physical file through SQL?

    How to read multi member Physical file through SQL?

    rajeshece1,215 pointsBadges:
  • Documenting column in SQL table in QADBIFLD (AS400)

    When a table is created with SQL, several fields in the system cross-reference file QADBIFLD gets content (headings, defults a.o). I noticed that the QADBIFLD table contains a column named DBIREM (length 2000 bytes..). I also noticed that the old S36 IDDU actually put some documentation into this...

    DanTheDane2,555 pointsBadges:
  • Fetching Duplicate records from a file

    Hi,I have file EMP: with ID,name,Department columns. Id as key field. There are more than a billion records with 50,000 duplicate records .I just want to fetch only those duplicate records on a single query. Thanks

    HABBIE845 pointsBadges:
  • Visual Basic ODBS connectivity to the AS/400

    Hi, we have just migrated from an old 530 AS400 to a smaller 170 model with a view to winding down the systems as thet get migrated to other platforms. We have an issue with one system which is a VB 6 front end and utilises the AS400 as a database. Since the migration this application is extremely...

    Aliw10 pointsBadges:
  • Using AS/400 SQL to replace a variable string

    I need to do a scan and replace in a flat file. File has one field 80 characters long. Possibly one or more of the records in the file contain a specific value, such as '%ABC%' and I want to update the record replace ABC with XYZ. This value could be anywhere within the record. I do not want to...

    CharlieBrowne41,380 pointsBadges:
  • Update Data SQL Server From AS400

    Hi, some help me. I want to write data to SQL Server from AS400 in RPGLE. Some have code for make this. Thanks for advance.

    JLH10 pointsBadges:
  • What is wrong with the blanks in SQL/400 code?

    What is wrong in the *BLANKS in the following code WHERE (EMPID=:*BLANKS OR EMPID=:EMPID)

    ankit2002770 pointsBadges:
  • File Update

    Hi, I have a customized file which has 1Lakh records. We are using an ERP tool. We created an object in that tool using this customized file. So when we open that object in the view, it will list out all 1 Lakh records. Now I am updating only 10 records. So it will update in my file. At the end of...

    22917515 pointsBadges:
  • SQL sum() with where

    AS/400 SQL: How can I use a sum() to search for records in a file? I am trying to use the SQL statement to sum up a total and use the total to compare to another record in the same file. My SQL statement is: select w1styl,sum(w1actc) from fileA where w1actc > 0 and sum(w1actc) <= (select...

    PietaKit35 pointsBadges:
  • DB2 SQL

    Hello Sir,             I am creating a table through SQL in AS/400. CREATE TABLE ANUP41/EMPL4 (NAME CHARACTER ( 10) NOT NULL, ADDRESS CHARACTER ( 25) NOT NULL, PROFILE CHARACTER ( 10) NOT NULL, UNIQUE (NAME))                                                      ...

    anupsshelke420 pointsBadges:
  • SQL Update not Working using two files

    I have attempted to update one file with data from another but I am getting two different errors depending on how I enter my statements. I used information from this site as a reference for these statements but I must be doing something wrong. UPDATE DABCON2/ACTPHY01 A SET A.B1N4CD = (SELECT...

    dab77780 pointsBadges:
  • QUERY on V6R1

    I am buying a 520 w V6R1. I need to have the following features on it. STRQRY WRKQRY STRSQL What is the lic pgm on 6.1? On V5R4 it was 5722QU1 or 5722qu2 & 5722st1? What is the difference between the 3?Would like to know what to order for the 6.1 box  Thxs Stephen

    Svocal120 pointsBadges:
  • SQL REPLACE with pointer

    I need to manipulate xml-files larger than char-field max-length allowed with RPG.   [strong]Background info:[/strong] My current solution uses a char-field... My app stores XML-files in CLOB-fields. I copy the xml-file from CLOB-field to a char-field: I then use %scan to find relative position of...

    DanTheDane2,555 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:
  • Link SQL Server 2008 to AS400

    How to set up a ODBC for SQL 2008 to the AS400

    Jaymz69765 pointsBadges:
  • iSeries SQL case on AS/400

    Is there an equivalent to case when exists on the as/400?

    Alanlev5 pointsBadges:
  • AS/400 (Retail) Banking application

    Hi, I'm looking for some details and materials on any AS/400 retail banking application. Information in design level.. You may ask what exact requirement is but as of now I need a model which uses technology RPG, CL, SQL, menu screens, display files etc pls.. Thanks

    itkr125 pointsBadges:

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