• Record Lock in Subfile

    Hi all, I am trying to find any keyword which is used to lock the record in Subfile. Please find the scenario: Let assume two users are trying to read the same record on the subfile from different session. Now when the 2nd user was trying to read any record while 1st user is using same record...

    vipin2m55 pointsBadges:
  • Defining a sort variable (ORDER by) in RPG SQL

    I have a file that I would like to sort on a specific column that a user would choose. I sort the file by an imbedded SQL statement: ORDER by PRDNO. Works fine. If I try and make it a variable (ORDER by :Sort_Seq), the statement is ignored. Is there a way to make the ORDER by a variable in RPG SQL?...

    MurrayInfoSys940 pointsBadges:
  • iSeries system resource accounting

    Hi friends, According to example below: http://search400.techtarget.com/tip/1,289483,sid3_gci905274_mem1,00.html and http://search400.techtarget.com/tip/1,289483,sid3_gci911215_mem1,00.html. How can I configure this option´s to accounting journal on my system V5R3M0 ?, cause in my Journal not have...

    RBDSILVA550 pointsBadges:
  • S/36 RPG program using a Data Area

    We enter in vouchers from a variety to locations. All of the voucher entry programs are written in RPG IV and use a Data Area to get the next voucher, update the data area using lock in/out. This all works very well. We have an older S/36 program that populates Employee Expenses into the voucher...

    Superbusy15 pointsBadges:
  • CPYTOIMPF data corruption

    CPYTOIMPF on V5R4 with latest PTF's adds invalid data to the created CSV file for some blank fields in the PF. Is this a Bug?

    JMShmc5 pointsBadges:
  • Variable not defined

    Hi, I'm getting RNF7030 for wierd variables i never used in my program   *RNF7030 30        000200  The name or indicator HDLRREGSTD is not defined.    The name or indicator PCONHDLR is not defined. When i check the statements they are pointing to one of then is a comment line ...simply...

    Nutangujar895 pointsBadges:
  • SQL Mismatch in From Statement

    What need to be done if an error message mentions "Mismatch in From Statesmen"? It seems like I have not done any different then what I have done over the last numerous of queries that I have done. I started with an excel spreadsheet. I had to do some concatenation of the some columns. I then...

    CompEng1,240 pointsBadges:
  • Odd problem (conversion or openquery?) only appearing in a stored procedure but not when running it adhoc

    Here's the code I can run with no problems: declare @AnneeSelectionnee numeric select @AnneeSelectionnee = 2009 declare @DateDernierImport datetime select @DateDernierImport =  'Nov 14 2008 12:00AM' SELECT     LTRIM(RTRIM(T_ASFSTAG0.STANS1)),     LTRIM(RTRIM(T_ASFSTAG0.STHFO1)),...

    LeftForDead20 pointsBadges:
  • Journaling and Commitment Control

    If I have journaled a file with After Update parameter, how will the commit/rollback work??

    Reenasudarshan65 pointsBadges:
  • CRTUSRPRF

    Could you please some one help me to create userprofile.

    VENKYAS40075 pointsBadges:
  • Remote access to QCTL Console

    How can we connect or work with console remotely?

    qmaster1,675 pointsBadges:
  • Activity Levels in AS/400

    What are the Activity Levels in AS/400 Subsystem? How can we take control over the activity levels?

    qmaster1,675 pointsBadges:
  • what is the diffrence beetween v5r3 and v5r4 ?

    what is the diffrence beetween v5r3 and v5r4 ? Could some one list it down for me?

    harisudhan211,005 pointsBadges:
  • RPG/400 Error RNQ1255

    I have a RPGILE (XOP560) program. I am able to compile sucessfully this program. once i call this program i am getting below error. please advice me. Additional Message Information Message ID . . . . . . : RNQ1255 Severity . . . . . . . : 99 Message type . . . . . : Inquiry Date sent . . . . . . :...

    Askt265 pointsBadges:
  • How do I call an API which is in a service program

    I hope somebody can shed some light on the following. I need to call an API "QjoRtvJrnReceiverInformation" which is in service program QJOURNAL. I am not new to ILE but experience of using service programs and using API's within service programs is limited Do I need to code all the 'D' specs and...

    Djb20 pointsBadges:
  • STRSDA

    How do I create standalone fields in SDA,ie fields not coming from a file

    STCA60 pointsBadges:
  • The most-watched IT questions this week: Sept. 15, 2009

    As part of a new feature on the IT Knowledge Exchange Community Blog, we're highlighting the top 10 most-watched questions. Here are the top 5: Virtualization vs. ConsolidationTracing a computer to an IP addressConnect remote Oracle 11g server in VB 6.0How to utlize multiple static IP's when ISP...

    Michael Morisy8,588 pointsBadges:
  • AS400 – DB2 file names

    Given a view name, how will i find its physical file name... e.g. my view name is EMP_TMP_TPL_HDR Thanks, NG

    Nutangujar895 pointsBadges:
  • AS400: copybook or module? …or…other?

    I'm on V6R1, using WDSCi 7 to program in RPG IV.  I've accumulated a number of functions that I use in quite a few of my programs, and I was thinking it might be a good idea to go ahead and place them as subroutines (may be wrong terminology) in a copybook.  But, having done some research, there...

    Koohiisan5,045 pointsBadges:
  • AS/400 User Profile Creation Date & Time

    We can find the user profile creation date and time as, WRKOBJ OBJ(QSYS/USRPRF) OBJTYPE(*USRPRF) Is the anyother way to find it?

    Lsivabe85 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.

Thanks! We'll email you when relevant content is added and updated.

Following