• One doubt on SQL command “Like”.

     Hi One doubt on SQL command \"Like\". File 1 File Name:- A1 Filed(A1F):- 10 0  Zoned File 2 File Name:- A2 Filed(A2F):-  30 Character Please help me to search the data from file 1(A1) field data(A1F) value is present or not on file 2(A2) filed (A2F). I need to search multiple data from the pf...

    amalrajvs20 pointsBadges:
  • list all printer for each query

    Which file contain the prtdfn for queries?

    umperrau5 pointsBadges:
  • SQL – Select record using MAX over date in 3 fields mm dd yy

    I have a file that contains PART#, Price, EFFMM, EFFDD, EFFYY. There can be multiple records for a PART#. I want to use SQL to join to this file by PART# and select the PRICE for the record that has the most current date. Simple in RPG, but I would like to do with SQL.

    CharlieBrowne62,100 pointsBadges:
  • Improve performance for SQL query reading file having milions of recods (AS/400 – SQLRPGLE program)

    I am fetching only 14 records each time from a customer file(physical file)  having milions of records. This file has 46 fields. Fetch is done in the follwoing manner, but it takes longer time - SELECT * FROM  CUSTOMER A WHERE A.CLINM1 LIKE 'B%' AND (CLINM1 <> '' OR  CLIPR1 <> '')...

    AnjaliR65 pointsBadges:
  • AS400 error

    Hi I have cpy the fiel to csv file using command Cpytoimpf.. CPYTOIMPF FROMFILE(ARCPGM/&QFLENM) TOSTMF(&CSVDIR) + MBROPT(*ADD) STMFCODPAG(*PCASCII) + RCDDLM(*CRLF) DTAFMT(*DLM) NULLIND(*YES). As this file when we are loading in oracle server...it is not loading few bad records,bad records are...

    iiiiiiiiiiiii335 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:

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.