• Query Xref to file

    The other day I added a field to the DDS of a file. I recompiled all of the RPG programs and display files that use the physical file. But I got burned when I found that I neglected to include all of the queries that used the file. Is there a way to query all of the query definitions to find if my...

    Abbey120 pointsBadges:
  • How to differentiate between newly added records and previously added records in Physical file

    i have physical file in which records are added on daily basis. i have to copy record to another Flate file. How can i recognise the block of newly added records? There is no date field in Physical File sothat i can copy records on date basis.

    Kapiltiwari350 pointsBadges:
  • How to execute an exe in windows from AS400

    How to execute an exe in windows from AS400

    dinvit5 pointsBadges:
  • Difference between RMTCMD and REXEC

    What are the major difference between RMTCMD and REXEC? I installed iSeries navigator in my PC and I am able to access both these commands.

    Rajgoaj280 pointsBadges:
  • Materials for BPCS

    Can anyone let me know if there are any functional documets available on bpcs.If so can you please provide me the link.

    Flint20 pointsBadges:
  • File Status 90

    Can anyone help me why I'm getting status 90 when I try to write to a logical file.

    Arnelr45 pointsBadges:
  • Saving production libraries on AS/400 – Best practices

    When defining an order to save production libraries is it a recommendation or best practice to saved in alpha-numeric order?

    AS400 - Ask the Expert485 pointsBadges:
  • Join Logical files and SQL views

    I hear Join Logical files are not supported in SQL DDL. But you have the SQL view instead. The shop I work for wants to use SQL DDL. But they have numerous interactive programs that use join logical files. If views cannot have keys, how on earth are they going to replace the join logical files in...

    bogeybetsy560 pointsBadges:
  • Uploading an image for use in Optio

    I need to upload a signature file onto our AS400 for use in an Optio layout. Does anyone know what steps I need to do to get the image file into a usable format on the AS400 so Optio can use it? Thanks in advance.

    SteveLin5 pointsBadges:
  • AS400 Flat files

    Hi, I have a flat files which contains address, phone numbers, etc.. i want to update the address (ABC..) and phone numbers (1234..) for all the records commenly which is placed in some position in the file. Can any one suggest me that how it can be done (any qry or program)? - Jack Spenzer

    Spenzer25 pointsBadges:
  • Learning SQL Part 2

    Is there anything out there that would teach help me to learn SQL dealing with communicating with an AS400 system and using MS Access passthrough query system to bring it into Access but using the SQL system as the communicator? What books or Web sight is available?

    CompEng1,240 pointsBadges:
  • data base files

    How are the negative values in the packed fields are stored in the PF? How to enter negative data in those fields?

    ten20081,150 pointsBadges:
  • Automated backup of IFS to tape

    What command would I use to write an IFS file to tape and delete it on a daily basis?

    AS400 - Ask the Expert485 pointsBadges:
  • Sharing user profiles between AS/400 systems without overwriting

    I tried to restore system user profiles to another systems but have all the user profiles in *SAVF but I dont want the existing profiles in the system to over-write i tried to restore my id on the system but it got over-write can you please give me a solution how do i restore user profles without...

    AS400 - Ask the Expert485 pointsBadges:
  • how do I cancel printing of a user-open AS/400 print file?

    I'm on V6R1 and I have a printed report that I need to suppress if it contains no data. Currently it prints out a heading section and then a notice that '0 records were modified.' Unfortunately, the program logic behind the report is not simple enough for me just to do a record count and see if...

    Koohiisan5,020 pointsBadges:
  • Delete OLD files from Table not having date or timestamp

    Hi, In DB2, Is it possible to get the insert date of a record in a table which doesn't have a seperate field for creation date or timestamp. I have a task where I have to delete record older than 1 year from a table, but the files doesn't have creation date field. So, like RRN does DB2 have any...

    RJES45 pointsBadges:
  • where to find correct source for XREF (as400)

    I located a series of as400 source for the tool XREF but is has a few missing references causing compile failures. References are: xreflib, MMenuoL4 and &LibLib. Please help.

    Gbssvcs5 pointsBadges:
  • Cursor position after EXFMT

    Hi all.I have a subfile over which a small window is shown.Both SFL and the window are shown simultaneously upon giving an i/p in SFLCTL.But the cursor has to be retained in the SFLCTL part after the SFL/WINDOW is displayed.If I write the window and EXFMT the SFLCTL,the window is not being...

    Eternal30 pointsBadges:
  • iSeries performance question

    Hello everybody, I'm trying to figure out the best way to count the number of records matching specified criteria in large PF. (The file has over 50 million records currently and with some purging we hope to bring it down to around 20 mil.) Anyway, I created the (SQL) view: create view largePF99 (...

    Dushan0 pointsBadges:
  • Changing Defaults QEZSNDMG Command

    Can you change the interupt user defaul to "Y" for program QEZSNDMG. Thanks

    RonKoontz1,780 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