1
  • Constant variable in SQL cursor

    select  gthamcode as hamcode, gtnumber as item, 'G' from testlib/gtinl01 where (gtnumber between 08000000000000 and 08999999999999) union all select modkey as hamcode, modndcnum as item, 'M' from testlib/hammodel where (modndcnum between 08000000000 and 08999999999) This works with interactive SQL...

    lalaabs5 pointsBadges:
  • SQLRPGLE Cursors and Recursion

    I'm trying to recursively call a PI in my SQLRPGLE program. Problem is, I get an SQLCODE error of -519 and I'm sure it has to do with cursors and the prepare statement in my PI. Here's the code: pprintPrograms    b      dprintPrograms    PI      d...

    Dcantwell465 pointsBadges:
  • Can two separate cursors update the same SQL table when executed together?

    I have three tables. Table One is a master table which contains rows which need to be updated with data from the other two tables (I'll call them Table Two and Table Three). I have created a cursor which updates existing rows in Table One with data from Table Two. This works fine, and following the...

    MrRussellWebb5 pointsBadges:
  • Alternatives to cursors in SQL Server

    What are the alternatives to cursors? I can’t find any other method to move through record sets one at a time.

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQLRPGLE – Prepare – Declare Cursor

    I'm using Prepare, Declare SQL cursor in my SQLRPGLE program After Declare statement I receive SQL -312 - Which indicates to me that the SQL statement is not declared correctly. Is it something wrong with my query. I ran this query in SQL editor and went fine. I dun understand why not in the...

    Nutangujar895 pointsBadges:
  • SQL cursor question

    hi, i've SQLRPGLe program in which i'm writing a cursor to select all records, order them by a field A (suppose employee number). And once all the rows fetched for an employee and printed, print the count at the bottom. Repeat this for all the subsequent employees.... i'm not sure how to...

    Nutangujar895 pointsBadges:
  • what is the max length for an sql cursor name?

    what is the max length for an embeded sql cursor name in RPG?

    TheMarkWTaylor5 pointsBadges:
  • SQL Cursor to use or not to use

    Hi, I've been told to never use cursor in SQL, because of possibility of memory leak, etc. But I have no idea of how to implement my script without them. My script doesn't execute anything on the database, it simply use cursor to create another TSQL script that does the execution. EG. open cursor...

    Db23290 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