• Trimming just one leading zero (if present) in SQLRPGLE

    I have a SQLRPGLE program and have 6A character field. How to I trim just one leading zero(if present) Eg- if 001300 then I should insert 01300. Thanks!

    Anjita5 pointsBadges:
  • Activation Groups, RPGLE, and Open Files

    Hello Everyone, We have a couple question regarding activation groups, RPGLE, and Open files. In our H specs for RPGLE and SQLRPGLE programs, some of our programs use dftactgrp(*yes), some use dftactgrp(*no), and some use dftactgrp(*no) actgrp(*caller). What are the differences? And, should all of...

    Dcantwell470 pointsBadges:
  • SELECTION OF UNIQUE RECORDS FROM FILE USING SQLRPGILE CODE

    I HAVE TO DO THE BELOW STEPS USING SQLRPG,PLZ HELP TO HANDLE THE UNIQUE RECORDS : 1. Delete records from Production LFPRIPMH/D file and those policy numbers are available in LFPS402S (unique policy number) 2. Insert into Production LFPRIPMH/D files from Before migration image (LFPRIPMH/D), where...

    AS400RAHUL5 pointsBadges:
  • Very simple SQLRPGLE not working

    I must be missing something simple. Any ideas ? Here's the code. C/exec sql C+ Update MFLLIB/ITMAST C+ Set IM_ITEMID = 'ST150EML' C+ Where IM_ITEMID = 'ST150E ' C/end-exec C Eval *inlr = *on   I simplified the update for test purposes.  No halts but no update.  Of course I can do the update via...

    aceofdelts1,870 pointsBadges:
  • AS/400 and Oracle Access Manager

    I have a strange behavior in an SQLRPGLE program accessing iSeries DB2 and Oracle via Oracle Access Manager. The program is very simple and reads values from two Oracle Tables in this way : a. SELECT .... into ..... FROM Table1 WHERE ..... return OK : 1 row as expected with my two fields filled. b....

    Technet30 pointsBadges:
  • SQLRPGLE Prepare

    When using the prepare statement I'm creating a string that contains my select statement... I want to compare a numeric field within my string. For example I have batch# which is numeric, how can I say where batch# = 21

    Bzito10 pointsBadges:
  • SQLRPGLE – Result Set

    I have an SQLRPGLE program [PGMA] containing the following: D ResultSet       DS                                 D                                     Qualified     ...

    Riccam30 pointsBadges:
  • Compiling Eval-Corr in SQLRPGLE

    I'm attempting to use Eval-Corr for the first time.  But, when I compile a Srcmbr as a SQLRPGLE type, I get compile error: "RNF5014 30 Operation code is not valid; specification is ignored.", but when I change the srcmbr to RPGLE, no compile errors occur. Any idea why and how I can get the...

    GVincen5 pointsBadges:
  • Problem Running SQLRPGLE program with one parameter in Batch: Works Fine Interactively

    Hi, i have problems with calling an SQLRPGLE program with only one parameter. an alphanumeric field length 40. the SQLRPGLE is running fine interactively but in batch mode, the parameter is right filled with packed caracters and it causes problems in my procedure. i’ve verified calling program,...

    Laurentjudic55 pointsBadges:
  • Page at a time subfile

    I want to code loading a single page subfile in SQLRPGLE. How do I handle the page up and page down key, posotion to in that program? thanks, NG

    Nutangujar895 pointsBadges:
  • Synon – Compilation

    Hello Everybody, I would like to know whether it is possible to use “SQLRPGLE“ source types in Synon, I am currently using Synon “8.1SP1” version.  Can anyone explain the procedure to compile “SQLRPGLE” source type in Synon? Thanks & Regards Bibin George

    BibinGeorge130 pointsBadges:
  • Using SRCDBG with an SQLRPGLE module

    I'm trying to debug a RPGLE module created with CRTSQLRPGI. The STRDBG program returns an error message stating the program "cannot be accessed". There is no DBGVIEW option on the CRTSQLRPGI command, so even if I get the debug to work. will I see any source data? Thanks.

    Grp5 pointsBadges:
  • file user open exceptions for printer file

    i'm opening a program defined printer file in SQLRPGLE.. i get error file is already open.... if that is the case, then i'm trying to write in that file but now this gives me exception that attempting to write in closed file...   Please help

    Nutangujar895 pointsBadges:
  • progam change date updated for SQLRPGLE program

    Can anyone tell me where I can fird the reason that the 'program last change date' is updated in an SQLRPGLE program when it is run?  It showed up on an audit and the auditors say it is unacceptable.  I am looking for proof that this the way it is from some kind of official source, or a way to...

    Sodafountain25 pointsBadges:
  • Embedded SQL

    In SQL RPGLE program, I declare a cursor using a view.. The view has name Emp_Pat_Dept_Data(EMPdata) the empdata is the AS400 name. In my cursor def which name I should use. Also for the fields referenced do I need to use the renamed field names in the view definition or I can use the field names...

    Nutangujar895 pointsBadges:
  • SQL error

    I've a cursor to fetch date from DB2/400...When date is stored as 0001-01-01, I get error - Year portion of the Date not in correct range. This is the default date my update program stores when user doesnt enter anything for date field. How can I bypass this error while fetching SQL cursor in my...

    Nutangujar895 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:
  • Fetching one cousor within DO loop of another cursor

    Is the below scenerio possible, if yes then how? CREATE C1 CURSOR OPEN CURSOR C1 FETCH C1 CURSOR DOW SQLCOD = 0 (For Cursor C1) CREATE C2 CURSOR OPEN CURSOR C2 FETCH C2 CURSOR DOW SQLCOD = 0 (For Cursor C2) CLOSE CURSOR C2 FETCH CURSOR C2 ENDDO FETCH CURSOR C1 ENDDO CLOSE CURSOR C1

    Soniswadesh5 pointsBadges:
  • Is SQL Commitment level extended to non SQL programs called

    I have an SQLRPGLE program that calls an RPG program. I know that the SQLRPGLE program has an internal commitment control engine activated, but will it extend onto the RPG program I call from here?

    Ragenrags10 pointsBadges:
  • RPGLE Stored Proc to Reporting Services

    Have SQLRPGLE program set-up to use cursor to return result set, want to use this to return table to MS Reporting Services get error message "low-order nibble of byte array offset 2451 is not valid. Byte Value OO. What does this mean and why not data back to client?

    Oldmickey65 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