• How to retrieve current date and time in SQL/400

    How can I retrieve current date and time in SQL/400?

    pdsathishkumar3,790 pointsBadges:
  • How to get nth highest salary using SQL/400 query

    Hi, How can I get nth highest salary from a PF named EMP having two columns EMPID and ESAL need to retrieve nth highest salary using SQL/400 query. Here N may be first, second,third any no.  Thanks!

    6r1,850 pointsBadges:
  • Duplicate record deletion using SQL/400

    Hi, How do I delete duplicate records using SQL/400 with SQL query please? Thanks!

    6r1,850 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:
  • SQL/400 field editing

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

    DanTheDane2,555 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:
  • Duplicate object (PF) using SQL with same attributes

    I want to create a duplicate object using SQL. I don't want to use CRTDUPOBJ and also do not want to compile my rpg's pgm because of new file level identifier. Please advice

    Anwer5 pointsBadges:
  • Stored procedures in RPGLE

    I'm new to stored procedures. I learned how to create and now I want to learn, how to debug the stored procedure when called from java client application. On which AS/400 job can I start the debug, so that if some action is being performed on the client application, I can have the break point...

    Varun123190 pointsBadges:
  • Join between two tables in SQL/400

    ** Table 1 ** fld1 is 2A, fld2 is 3,0 & fld3 is 2A... ** Table2 ** fld1 is 7A and which is a combined result of fld1, fld2, fld3 from Table 1..... My requirement is, I would like to join the above tables using any join method and would like to list the records from table1 where all fields in...

    Varun123190 pointsBadges:
  • SQL/400: STRSQL command

    Hi friends, I have on my system many users with the userclass *SECOFR. How can I determine only one user to use the command STRSQL?

    RBDSILVA550 pointsBadges:
  • How to insert Hex values through SQL/400

    Hi, I'm creating a table querying the data from 3 different tables through joins. I need to insert a Hex value ‘3F’ at the end of the last record in the Output file (Table) I create to know the end of file for another system reading the file. I do not know whether this can be possible to insert...

    color10 pointsBadges:
  • sql/400 convert 9,0 to 4,0 getting cast argument not valid

    we have full ss# in our employee master and now HR is wanting to stip the first 5 digits off. Trying: update clocfilemh/ckempeff set eessno = decimal(substr(char(eessno),6,4),4,0) getting "Character in CAST argument not valid." When I try select eessno, decimal(substr(char(eessno),6,4),4,0) getting...

    shumatev40 pointsBadges:
  • How to acheive FULL OUTER JOIN on three files in IN SQLRPGLE program.

    Hi, I have 3 seperate files called Duty, Freight and Brokerage and i need to process all the records from all the three files into one output file based on key values matching across all the files, if i dont find the match in anyother two files then i need to populate coresponding fields with...

    Mohan K695 pointsBadges:
  • Query in SQL400

    Hi, I want one query in SQL400, I will give small example? Suppose there are two tables,    TAb1                Tab2 1.CMP                 1.CMP 2.Item NO           2. Item NO 3.Status              3.Warehouse 4.Quantity          ...

    ssssssssssssssss115 pointsBadges:
  • SQL/400 commands

    Hi friends, How can I see or get the SQL/400 commands executed from another user ? Regards, Roberto

    SILVARB440 pointsBadges:
  • SQL400 Strip non-numeric from a column

    Hello everyone, Is there a way to strip non-numeric characters from a char column? Example: I have a Clients file, with column "Telephone Number" (CLPhone, 20, A). The thing is, phone number for many clients is filled with different formats. Example1: (123-12345) Example2: 123 12345...

    Builder40060 pointsBadges:
  • Create Alias

    How can you use "create alias" to return all members of the primary file? I understand how this is done with one member. but how can you build the file using all member via a wildcard function

    StefanH5 pointsBadges:
  • read PF member records using SQL400

    How to Read PF member records using SQL400.... PF1 contain 3 members like (mbr1, mbr2, mbr3), now i want to read all records from mbr2 using SQL400... please share me the Query... 

    pdsathishkumar3,790 pointsBadges:

    i'm trying to run SQl statment in batch job to alter Table CCSID to 420 but i have error Reason code 10  Hani 

    Hanisadeq120 pointsBadges:

    what is compulsory parameter of STRCMTCTL ?

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