• 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:
  • how to retrieve current date and time in SQL400

    how to retrieve current date and time in sql/400

    pdsathishkumar3,790 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:
  • RUNSQLSTM ALTER TABLE

    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:
  • STRCMTCTL

    what is compulsory parameter of STRCMTCTL ?

    Aum15 pointsBadges:
  • Purpose of QSQJRN

    Could someone tell me the purpose of the journal QSQJRN ? I don't journal any files on my system, so I don't know why this journal is active. It's now up to 200Mb. Thanks

    MBERIC120 pointsBadges:
  • Embedded SQL in RPGILE

    For a SELECT Query in RPG program if we get -811 SQL error, it means we have got multiple selections in our query. Is it possible to know how many records are selected from the SELECT statement from any field of SQLCA or in some other way?

    TNKR130 pointsBadges:
  • THREADSAFE parameter on DSPCMD STRSQL

    Can i get the help on this parameter whose values are *YES and *NO. The value is currently *NO, when should and how can i change it to *YES. Will this improve the performance of my SQL procedures?

    JohnsonMumbai1,160 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