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