• Change the language for a user

    How to change the language for user in iSeries?

    MayurRastogi390 pointsBadges:
  • How to write a CL program if SQL query is giving some record

    Hi, How can a CL program can be written based on some SQL query which gives some records. If SQL query is giving some records as output then using SNDEMLMSG command, how can that CL program be written? SNDEMLMSG command will send an email to specific user based on SQL query's output if any thing...

    6r1,485 pointsBadges:
  • QBatch subsystem Monitoring

    Hi Guys, I have requirements, I need the Job details like( Job Number, name , user) of any job as soon as they entered in Qbatch Subsystem. Do we have any API or some commands to fetch that... The only solution i m thinking is of take the *Print of WRKACTJOB command for QBATCH every minute and...

    ddaswani170 pointsBadges:
  • RPG / free command to movel 6 digit field to 8 character field

    I am using RPG /free -- I need to move a 6 digit numeric field to 8 character field and it needs to be left justified. How can I do this?

    Manyquestions65 pointsBadges:
  • Twinax to LAN

    Hi there experts, in need of your help once more. I have an old 800, which has been turned off a long time ago. Now, I can´t get to operations console because, I believe, the console configured is Twinax. How can I force the system to LAN console? Thank you very much.

    Aringarosa295 pointsBadges:
  • Replace failed disk

    Hi guys, need your help once more. I need to replace a failed disk (RAID 5). I'm not shore how to do it, should I use navigator or DST? Need to stop RAID first? I already have the document with the steps to rebuild data on the new disk, just don't know what to do before that. Tanks in advance,...

    Aringarosa295 pointsBadges:
  • Using 2 different display sizes in a display file

    I am trying to create a display file in which the subfile uses display size 27 132 and a window uses the display size of 24 80. I thought I could declare them both in the dspsiz as DSPSIZ(27 132 *DS4 - 24 80 *DS3) and use dspmod(*ds4) after the SFLPAG command and DSPMOD(*ds3) on the window display....

    GHENDER190 pointsBadges:
  • 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:
  • Creating physical files

    What command would I use to create a physical file?

    Marbri20 pointsBadges:
  • Reading XML file from RPGLE program by using XML-INTO opcode

    How can I move data from XML to Data structure if data is more than 9999 in XML? The problem is I can declare the data structure with array max size 9999 where as using XML-INTO (ex: XML-INTO OrderList %XML('/home/orderlist.xml') : ' doc=file case=any') ). I can load first 9999 set of data but then...

    harith170 pointsBadges:
  • Printing from AS/400 to Canon iR3235

    Hi, I am having problems printing from AS/400 running v5r4 to a Canon iR3235. Prints seem to be coming off out of order. But only happening half way through each batch of around 100 prints. The first half is fine, but then all comes off wrong. IBM have recommended setting up printer over LPR and...

    jha15855 pointsBadges:
  • About EVAL-CORR opcode

    Could any one let me know what is the use of this EVAL-CORR opcode with a sample program

    JSDHFKJHA335 pointsBadges:
  • Block access of Operational ASSIST Menu

    Hi ! How can I block the users for the use of Operational Assistance Menu(Esc Key)?

    Sureyz2,375 pointsBadges:
  • How to easily perform date conversions in RPGLE (Including Substringing!)

    Over the years I have had to modify my fair share of outdated code, especially when it comes to Date Conversions. Not every system uses an 8 position numeric date field. The place I'm currently at still has a number of files with a 6 position numeric date field. I was wondering if anyone else had...

    Eric Witham690 pointsBadges:
  • AS/400 – User Profile

    Hi; What is the name of the file that stores the value for the "Password verification not valid" field on the User Profile. I created the User Profile file using the DSPUSRPRF command but it shows only a value. I need this information for auditing purpose. Thanks, Ruth.

    villaflora25 pointsBadges:
  • Error in position while printing variable

    I have a variable xyz as7P 2.This variable is defined in a file. I am using this in my program to be populated on printed on report defined in O spec. Problem is - I am just using edit code 'L' and mentioned ending position as 71. but when printed or spooled, it's being generated with an ending...

    fsddfsdfsd60 pointsBadges:
  • Subfile with scroll bar.

    I'm creating a simple program for subfile with scroll bar. I am able to see the scroll bar in the display file but the scroll bar is not working. It isn't scrolling up or scrolling down. Please suggest what can be the solution.

    ankit2002770 pointsBadges:
  • Window keyword in display file

    I have a program that displays a list of items and when one is selected it pops a window with detailed information. When I select an item, my window will not display. Is there a configuration/setting somewhere on the AS/400 that would keep the window from displaying ?

    Dcarney115 pointsBadges:
  • Why limit CLI access on AS/400?

    A little background... I am new to the compliance and auditing field and recently introduced to the AS/400 system and I am constantly seeing in best practice environments that the CLI be restricted from most users and or at least limited capabilities set to *YES. To the point... The system...

    Avelino45 pointsBadges:
  • Query in subfile with SFLNXTCHG

    I have a subfile with an option F8 to clear all the records. When F8 is taken, I will clear all the fields and will update the SFL record format. After F8, if an enter is taken, I want to update the file with the blank values. But the problem is since am not typing anything on to the subfile, the...

    RamvishakRamesh2,505 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