• 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:
  • Free SQL examples for V5R2

    where can I find Free SQL examples for V5R2

    Bob165215 pointsBadges:
  • How to speed up AS/400 SQL?

    We have SQL on our Data Warehouse written using SHOWCASE. The SQL could be better, it is not SO bad for something writen with a drag and drop gui, but the execution is far too slow - 12 minutes to extract data from the main 3.5 million record file, with several left outer joins. So, we created...

    Sloopy2,195 pointsBadges:
  • How to handle record lock using embedded SQL?

    I am using SQLRPGLE program,need to handle record lock in sql statement ..plz suggest?

    Samule400160 pointsBadges:
  • CPF5032 and SQL RPG

    How do I unlock the data file to avoid halt ? CL used to sort file and call an RPG that cleared a field (followed by further processing). When I switch to an SQLRPG to clear the field, I get CPF5032 in the next program. Yes, I tried the UNLOCK op code in the SQLRPG but same result. No halt using...

    aceofdelts2,340 pointsBadges:
  • AS400 – SQL

    I want to use Functions in Update Queries Set operation Update File Set FName = Substring(Name,1,10) Where EmpNo = 99 How to perform this one using SQL Queries    

    rajeshece1,215 pointsBadges:
  • Check IF Field is Numeric in AS/400 SQL

    is there a function to check if field is numeric (like ISNUMERIC in standard SQL)?

    Jaggerdude60 pointsBadges:
  • Using a variable in the LABEL ON SQL statement

    Is it possible to use a variable in the label-string of the LABEL ON sql statement so that the variable can be changed dynamically in an SQLRPGLE program ?

    aderene180 pointsBadges:
  • Can’t Set different Activation group in ILE SQL COBOL.

    Does anyone know why when I compile an ILE SQL COBOL program it shows it going to Activation Group QILE but in the COMPILE prompts I don't see any option to change the group to something else like our company name?  In a Cobol ILE program the option is there but not in COBOL SQL ILE program?...

    BeanBaggs220 pointsBadges:
  • Using CTE with Update on the iSeries

    Anyone have examples of using a common table expression with an update of fields in a file?

    Dhascuba15 pointsBadges:
  • Problems running AS400 stored procedure from SQLServer 2005 SSIS execute SQL task

    I need to run a stored procedure (with two input parameters ) that has no output, on an AS400. When I try using the IBM DB2 UDB for iSeries IBMDA400 OLE DB provider, I get the following error [Execute SQL Task] Error: Executing the query "CALL TPSDTA50GQ.PMCTESTTP('PETER', 4)" failed with the...

    PeterJC15 pointsBadges:
  • Unable to use delete statement How can I delete multiple duplicates in a PF leaving only one in SQLRPG

    Background... I use OCL and SQLRPG. I am having an issue after I have built a file of records from my Select. This file contains duplicates that I need to remove. I have a EXEC SQL DELETE clause in the RPG after my "DO" loop ends. The command does nothing, however, when I drop the command into a...

    Kingcarrera5 pointsBadges:
  • My as/400 SQL is getting a ‘ Value for column too long.’ error msg

    Value for column or variable SPDESC too long. UPDATE mbmtest01/wbmscur set spdesc = (Select itdsc FROM amflib7/itemasa WHERE itnbr = spptno)  WHERE EXISTS (SELECT DISTINCT itdsc FROM amflib7/itemasa WHERE itnbr = spptno)  How do I make the field truncate the larger input field. The input field is...

    nitzinger385 pointsBadges:
  • AS/400 SQL for two file compare and update

    Need a update in SQL comparing two tables check description and if equal to blank then match keys on master update blank desc. field with master desc field. UPDATE mbmtest01/wbmscur  set spdesc = itdsc  from amflib7/itemasa  where spdesc = ' ' and itnbr = spptno Keyword FROM not expected. Valid...

    nitzinger385 pointsBadges:
  • Querying multiple member PF with SQL

    I would need to SQL on a multiple member PF and I need to query the 2nd or nth member in the PF.  Is this possible just with an SQL query without using OVRDBF etc.?

    Rajgoaj280 pointsBadges:
  • File overrides within interactive SQL sessions – how are they applied?

    I have an issue where, in an interactive SQL on an iSeries (V5r4) despite specifying the library and file name for a delete statement, the action deletes from a file listed in the overrides. Is there a way to prevent this from happening?

    Nephilim5 pointsBadges:
  • as400 sql – non numeric data in numeric field

    is there a function I can use to avoid and abend when sql hits a numeric field that contains non-numeric data. sql: select * from LPDtst/ARCOMB WHERE ACAOF# <0 Error: Selection error involving field ACAOF#.

    oldpgmr75 pointsBadges:
  • text data to packed

    i have comp-3 data in a text field. i need to extract the info and convert it back to numerics to download to a pc. i want to use sql ...

    matis75 pointsBadges:
  • SQL Communication Area

    Hello, Can anyone explain the fucntionality of the program QSYS/QSQROUTE in AS400. Thnaks in advance

    Sris198655 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.

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

Following