• How to create a WSCST Object to Print to Output tray 2?

    I have a printer *DEVD created with 'Manufacturer type and model  *HP5SI' and it's a Canon IR-ADV C5235 printer. We have two output trays on that printer and need to send all iSeries reports to Tray 2. I can't make any changes to PRTF as same printer file is being used for reports which...

    Chamika20 pointsBadges:
  • Rounding values in AS/400

    Hi, Why the result is 164.20 and not 164.19? The statement: MULTIPLY W-AMOUNT BY 0.06 GIVING W-GSTAMT ROUNDED The definition; W-AMOUNT PIC S9(014)V9(002). W-GSTAMT PIC S9(014)V9(002). Where the value of W-AMOUNT is 2736.57. Thanks, Azman

    Azmanh5 pointsBadges:
  • AS400 backups using BRMS running over allocated time

    Good Day. I am sys admin for a Iseries 520 9406 System ASP . . . . . . . : 773.0 G % system ASP used . . . : 55.0899 Total aux stg . . . . . : 773.0 G I am using Brms to do my backups initially i was doing a full sys save everyday to a LT03 tape 400g compressed 800 uncompressed, due to business...

    Justin88330 pointsBadges:
  • Extract start date and end date from a file field

    I have a requirement like this. I need to generate a report which has 2 fields start date and maturity date. I have FileA which has a date field and has some values say 12/31/2012, 01/05/2013, 10/01/2013,25/01/2013 and so on. I need to generate a report which has a field start date and maturity...

    RamvishakRamesh2,505 pointsBadges:
  • what is field reference file

    hi, all i m working on RPGILE ,please tell me what is field reference file , what is use of it, please give any example.. thanks Ambrish

    Ambrish 82310 pointsBadges:
  • C4040-129 IBM i 7.1 Administration

    Hi everyone, Just wanna ask if someone here took the IBM i 7.1 Administration certification. How was the exam? I am about to take it 3 days from now and looking around the web about the exam.

    excellentrandy1,275 pointsBadges:
  • Does WRKDG access the remote LPARs?

    We are using WRKDG to an outfile to check for errors. Our engineers believe that the command access the remote LPAR to gather the data. I think that it gets all of it's data from the LPAR where the command is running. Who is right?

    jon9toes5 pointsBadges:
  • Write the value of a variable in RPGLE

    I have a variable which its value is the name of other variable. I need to write a log with the value of that instead its name. Is there a way to do that with RPGLE? Example: Var name1: Field1 Value Field = 'XXXXXX' Var name2: Field2 Value Field2 = 'Field1' I need write the value XXXXXX of field2...

    Luissimon50 pointsBadges:
  • Determine memory of AS/400

    How can I determine the memory of a AS/400?

    jmgmail5 pointsBadges:
  • Logical file changes and SQL

    I need to make a change to a logical file. I have a program that is accessing this logical via an SQL statement. If I recompile the logical, do I have to recompile the program as well? (the file is not listed in the 'F' specs, it's only referenced in the SQL statement.

    NJSTATEBOB25 pointsBadges:
  • Block Crystal Reports from iSeries access

    We have a user who wants to use Crystal Reports to access data on an MS SQL server. She also has access to view limited data on the iSeries using an iSeries application with built-in security. How can we prevent her from accessing data on the iSeries using Crystal Reports. Is there a service we can...

    WoodEngineer6,955 pointsBadges:

    I have a RUNSQLSTM that updates a table. When it hits a duplicate, it quits and returns SQL9010. What I want it to do is just skip the step that got a duplicate and move on. Is there a way to do this?

    khalon25 pointsBadges:
  • RPG: Determine which field changed in a file

    I need to get which field changed in a file, instead of writing multiple (IF this field changed THEN DO...) for each field in each file, I was wondering if I could use some tool in RPG for doing that?

    Luissimon50 pointsBadges:
  • How to retrieve all the records using CL program?

    How do I retrieve all the records using CL program?

    vishwaraj60 pointsBadges:
  • Turnover form IN-USE Status

    I was trying to promote a form over AS/400 turnover and my session got disconnected meanwhile. Its approved but not run yet. Due to the disconnection, I am not able to run the form now because the form is IN-USE status. What am I supposed to do now?

    yaazhisai260 pointsBadges:
  • Text string gets SQL0406 via AS/400 RUNSQLSTM but works interactively

    I am doing an insert into a table and it works perfectly when run interactively on the iSeries but gets "SQL0406 229 Position 1 Conversion error on assignment to column BUDSPERSON". The field is Character, length 35.  The query is: insert into slsbudter ( SELECT ALLNUMS.BU, ALLNUMS.BUSUNIT,...

    randycoxclemson5 pointsBadges:
  • Excel add-in data transfer error CWBTF0012

    I'm having a data transfer issue. I get the CWBTF0012 general error. Looking it up it say reached max records. Here is the strange thing, I'm still under that number of records. According to what I have seen it relates to Excel 2007. I am currently using Excel 2010. I do have the client access...

    ToddN200027,265 pointsBadges:
  • Only one session can be used in Client Access

    In Client Access software, there are two sessions should be opened always. Once is the user session and another one is printer session. Is there any other way or software that only one session can be used? Why AS/400 session can not print documents in the default printer in the computer without a...

    Sureyz2,655 pointsBadges:
  • Problem with Client Access emulation with a telnet connection

    I try to connect from remote pc to i-series with client access, but it give me a cwbco1003 and a cwbco1048 error, but when i try to connect with tn5250j emulation all things go well why ? I need use the client access, thanks for help.Ps. that is the trace of the problem....

    Peppelan5 pointsBadges:
  • How to display files from a directory in RPGLE?

    I want to get a list of excel files and displayed them a subfille but for some reason it doesn't work. Here is the RPG code: MyDir = '/home/testdir '; dirh = opendir(%trimr(MyDir)); if (dirh = *null); p_errno = sys_errno(); Endif; What am I doing wrong? Please help!

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