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

    aceofdelts1,930 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:
  • Find missing numbers with SQL

    In a large logfile I have records containing the field INVNO (invoice-number). The lowest and highest values are easy to find, BUT it looks like some numbers in between are not there. Anyone got a trick with SQL, which can tell which numbers are missing within the numberrange (step 1) ?

    DanTheDane2,555 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:
  • SQL/400 field editing

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

    DanTheDane2,555 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:
  • UPDATE a year from an ISO date field using SQL

    Dear Sir/Madam, How can I update the year from a date field. For example the date file contains '2008-12-31' and I would like to use I-Series navigator's SQL to update the date field above with '2007-11-31'.But my intention for the update here is to decrease/deduct the year by 1 year and the month...

    Khngkenny5 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