1
  • SQL Dates JD EDwards World 9.2.1

    Gordonj5 pointsBadges:
  • Variable not found when calling a SQLRPGLE program

    Variable not found when calling a SQLRPGLE program with parameters in CL program CALL PGM(LIBXYZ/TESTRPG1) PARM(&LIBNAM &FILNAM) here LIBNAM AD FILNAM are passed with VALUES to the SQLRPGLE program and at sql statemet ie. insert INTO LIB/FILl( LIB is having the value and FILL is not getting...

    ravula700 pointsBadges:
  • Cursor in SQLRPGLE

    Hi friends, Please explain the difference between the Scrollable, Non-scrollable and Dynamic scrollable cursors in SQLRPGLE with simple example. Thanks in advance.

    shyedajmal285 pointsBadges:
  • AS/400: Fetch data from file

    I need to fetch the data from a file and write into another file. What is the best way to do that? I have an SQL query which has a number of conditions. I need to put this SQL query into a program.

    ravula700 pointsBadges:
  • DSPLY SQL value is zeros

    I am trying to display the 2 result values from this SQL statement and they are zeros: D totdlq S 11 2 inz(0) D totcnt S 5 0 inz(0) * D totdel S 20a D totrec S 10a /Free Exec sql DECLARE C1 CURSOR FOR DynSqlStmt; Exec sql open C1; Exec sql Select sum(utcbal), count(*) INTO :totdlq, :totcnt from...

    a1maida150 pointsBadges:
  • Please help with SQL query

    I have a file which has 6 different account numbers. For each of this account number, I need to check in File1 which has account number, security and Quantity. I need to sum up the qty field for a combination of Acc num and security. Once I get the security, I need to search in another file say...

    RamvishakRamesh2,505 pointsBadges:
  • AS400 – SQLRPGLE

    Hi, We are moving Values to Database Fields using Embedded SQL Concept. In Embedded SQL, We can decide the Variable Names dynamically. Is it possible with Display File? why?

    rajeshece1,215 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:
1

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