• How to use the SQL update statement with a join to another file to get the correct selection

    select count(op140m.pfpn) from prdat/op140m join cgoderi/op140mup ON op140m.PFCORP = op140mup.PFCORP and op140m.PFSTCN = op140mup.PFSTCN and op140m.PFPN = op140mup.PFPN and op140m.PFSTCN = p140mup.PFSTCN and op140m.PFEFDT = op140mup.PFEFDT I have 1 table op140mup with 8088 records and op140m with...

    Chrisjegoderie30 pointsBadges:
  • STORED PROCEDURE

    Hi All i search to make procedure in strsql please can anybody help me and search code open text file from the procedure and put data on  it  

    AS400SQL25 pointsBadges:
  • SQL/400 Query to update one field in File1 with other field in File2

    Hi All, I want to update one field(PCUSR6) in NBSPCNTR file for all records with MCUSR6 field from CASCNTRM file. I tried below combinations, but i couldn't do it. Can any one please help to update whole file with another file field. Please find below queries i tried: i have to update NBSPCNTR file...

    Mohan K695 pointsBadges:
  • SQL/400 Call Level Interface

    The option set thru the SQLSetConnectionAttr call persists until the next SQLSetConnectAttr call. If I need to set another option, how do I know that the effect of the previously set option is no longer required? Can I set connection attributes after I have connected to the database? Thank you for...

    LBurkett99830 pointsBadges:
  • SQL in an SQLRPGLE program

    I want to use embedded SQL in an SQLRPGLE program to search a file for a field entered in a screen to select data using the LIKE operand. This is my code C/EXEC SQL C+ DECLARE C1 CURSOR FOR SELECT * FROM F0101JN WHERE ALADDZ = :SZIP C+ AND ABALPH LIKE :SINNME ORDER BY ABAN8 C/END-EXEC * I entered...

    Alpfalpf25 pointsBadges:
  • AS/400 SQL Update for matching records

    I have a file of five fields containing a number of records. I want to update the value of field 5 on a second record where the second record matches the first record for the first three fields, but where field 4 is the opposite (negative) value of field 4 on the first record.EG: Record 1 12345678,...

    Marshphil5 pointsBadges:
  • AS/400 Navigator

    Hi , Can anyone tell me what is this problem when i try to click on the database tab in AS/400 navigator. Navigation: -> login to machine id->click on the machine-id->click on the database tab-> ERROR reported Function did not complete successfully. AS/400 Message ID: PWS0001 Cause . ....

    Sangay635 pointsBadges:
  • How to run SQL script with parameters in CL

    I have to call an sql script with parameters from an existing cl program that runs daily (in batch). If I call it from the cl program, it is giving me this error "Pointer not set for referenced location referenced".

    Ara5 pointsBadges:
  • CMPPFM, Space offset error.

    Hello, I'm using the IBM CMPPFM utility for a file comparision process. I monitor for msg SPC5010 (file is too big ), if this occurs I submit an SQL EXCEPT to compare the files. This has been working fine until recently, now I'm getting the following error on one file, Space offset X'00FFF026' or...

    Xtreme1145 pointsBadges:
  • SQL View on 1 AS/400 using data from another AS/400

    We have 2 AS400 machines connected with a 1g pipe. I need to create a SQL view on one of the machines using data that is in DDS physical files on the other machine. How can I accomplish this?

    Oldtonew135 pointsBadges:
  • Ignoring fields in SQL Where Statement

    Can fields in a where statment be ingnored. Such as Where name = :name and date = :date, but if I just pass in a name I'd like the where to select only on the name and ignore the date.

    Charrdzc5 pointsBadges:
  • Grouping the records in RPG

    How to I group the records in the database based on one particular field?? When i try using a group by clause in the embedded SQL, it give me a 'SQL precompile failed' error. How do I handle this?? And i have to display the employee records grouped by their locations... how can this be done??

    Shwesmile20 pointsBadges:
  • How to display the SQL query results on SDA screen?

    I got an answer for how to embed the SQL statements in RPG program. Can you please help me with how to use these values in the program, or display them on the SDA screen??? Thank you. :)

    Shwesmile20 pointsBadges:
  • iSeries Access For Web – Run SQL Function

    Hi Has anyone had the problem where iSeries Access For Web does not run some SQL features consistently? I have a customer that is using this to provide reports from the iSeries to his customers. Customers can log onto the iSeries from the web and get to run reports already created. The customer can...

    Riccardo95 pointsBadges:
  • Update in SQL

    I have a flat file which I want to update starting from position 2 to 4. I used below UPDATE statement: UPDATE FLAT_FILE SET SUBSTR(FLAT_FILE,2,2)= 'AA' WHERE SUBSTR(FLAT_FILE,1,2) = 'HH' The above SQL Query is throwing an error SQL0104 for missing token. Can anybody suggest me on the above. Thank...

    Vids295 pointsBadges:
  • There is a way to order one SQL union file?

    I have to conect 2 files, the current and the historic. Both has the same structure but the fields names are diferent. This is the complete command but i can not order to put the records in a subfile in the order that i need: C/EXEC SQL C+ DECLARE S1 CURSOR FOR SELECT IQUSER, IQFMOV, IQNUME, IQANO,...

    Riper5 pointsBadges:
  • Suffix a record using SQL

    Hi guys, any ideas how to suffix a record (as400 flat file) using SQL? thanks

    Rockleadme385 pointsBadges:
  • I can create a SQL procedure using i series navigator but do not have any authority on the procedure.

    I can create a SQL procedure using i series navigator but do not have any authority on the procedure. When i view the procedure on i series navigatore it show that iam the Definer, however when i try to change the permissions on the procedure i get following message CPFA09C Not authorized to...

    JohnsonMumbai1,160 pointsBadges:
  • Journey from SQL/400 to SQL Server Development

    I'm fairly comptent with SQL/400 , scripting, etc. - - how difficult would it be to applying this to learning something like "SQL Server" ?

    Tsmith7155315 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