• 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,270 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:
  • Need help on the prompt override program

    Hello, I have command which when prompted asks for a confirmation and if a 'Y' is given then 2 more parameters appear retrieving data from a data area. I have setup the program override program and the confirm parameter on the command as a 'key parameter', the parms that retrieve data from the data...

    yaazhisai155 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,945 pointsBadges:
  • Trap SQLCODE from RUNSQLSTM

    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?

    vishwaraj25 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?

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

    ToddN200017,960 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,505 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:
  • Automatic AS/400 User Profile re-enable

    How do I re-enable an AS/400 User ID with a WATCH program? I would like it to change the password and set the new password to expire upom entry.

    HPW10 pointsBadges:
  • How to work with BPCS

    How can I do a project on BPCS?

    hyndavi5 pointsBadges:
  • AS/400 MIMIX, IFS objects present only on target

    My DG for IFS did not had OBJONTGT set as *delete due to which older logs that were automatically deleted on source were not deleted on target. I changed it to *delete but after that the objects and DB in error increased exponentially. The DG is in threshold that is why audit cannot run. Any...

    Ateeshsharma5 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