• as/400 power5 degrading disk

    The expension disk is degreded,i have replace the cache battery on the 2780 PCI-X Ultra4 RAID disk controller, but every time i power off and power on the expension disk comes degreded.

    megatommy10 pointsBadges:
  • R6V1 iseries Excel Addin to download data from AS400

    On V6R1, how do I install the Excel Addin? The file that is in the shared folder for IBM does not have the cwbtfxla.xll like it did in R5.4

    Lorettarepman10 pointsBadges:
  • Want Query output into Spool file

    Hello Folks I am creating utility CLLE program based on 5 options. Inital 4 options will be RUNQRY (query name and library is fix). Queries I have already created by WRKQRY via joining various (4-5) files. 5th option is for to check spool file. Now I want to make a program that first displays the...

    pankaj2r100 pointsBadges:
  • Regarding message subfile

    I have made a display file containing two subfiles.The first subfile is a load all scroll subfile and the second is a message subfile.The problem is that i am not able to display error message is message subfile while performing validations on data on first Load-all subfile.What could be the...

    Suvzz5 pointsBadges:
  • Error trying to call PRG

    i was try to call a prg, but im getting the error which given as follows ( Job 352272/RPANNEER/QPADEV000R started on 19/04/12 at 17:06:00 in subsystem User library list not set properly. Press Enter or Help(review reason). im having all the authority to access all obj as a secoff and the object...

    Rajasekhar151,395 pointsBadges:
  • Transform rows to files in an SQL statement.

    Hello We hava been able to produce the SQL that returns us a Vertical table with the LABELTEXT  from table CLIENTES (sql against qsys2/syscolumns).   SELECT LABELTEXT FROM QSYS2.SYSCOLUMNS WHERE TABLE_NAME = 'CLIENTES' AND TABLE_SCHEMA = 'MANEL' Observe vertical orientation. Column 1 Column 2...

    I40075 pointsBadges:
  • Query in SQL400

    Hi, I want one query in SQL400, I will give small example? Suppose there are two tables,    TAb1                Tab2 1.CMP                 1.CMP 2.Item NO           2. Item NO 3.Status              3.Warehouse 4.Quantity          ...

    ssssssssssssssss115 pointsBadges:
  • Can I change c0001copybook in RPG?

    in rpg c0001 is a standard copybook.if i want to make a new program then can i use this copybook.and for my program some modification is necessary...so can i change this copybook program

    Rehan8810 pointsBadges:
  • Clearing a subfile screen

    I have a load-all subfile that offers the user an Fkey to only display records that contain a predetermined value in a specific field. Here's the problem; If the user presses the Fkey and there are no records that contain the value required to select the record for display, I present the user with...

    Floyd02320 pointsBadges:
  • Error Msg Clean Tape in AS/400 backup

    Our backup is failing due to an error message that states we need to clean TAP01. We used a tape cleaner, also tried a solvent on swabs, tried a brand new tape and still get the error message. Any suggestions?

    Mapics60 pointsBadges:
  • Compilation issue in AS400

    Hi, I had an issue in Compiling my Files/Programs. When i compile my Files/programs interactively , I am not able to See my Spool file.Then i have checked my OUTQ , it was in *WRKSTN, which is the Printer for my Client.So when i compile it was going to their Printer. I asked them to change it to a...

    22917510 pointsBadges:
  • how to copy column-headings from a PF

    how to get column-heading names copied along with data from a PF to a flat-file? - OR - how to copy column-headings from a PF to another PF?

    svankipu620 pointsBadges:
  • Can we rename QSECOFR user id.(Auditors requirement)

    Can we rename QSECOFR user id.(Auditors requirement)

    JohnsonMumbai1,160 pointsBadges:
  • Encrypting AS400 database file

    I need to encrypt a database file residing on the as400 and FTP to a destination. Can I use QC3ENCDT to do this?

    Jeffm125 pointsBadges:
  • How to print AS/400 using HP5si and specify color paper or custom ‘type’ for tray selection

    How can i setup a AS400 print configuration using HP5si PCL and select a specific paper color and/or paper type when default printer setup is for standard plain white stock. Actually printing to Xerox 5755 Need to someway to make color or type values unique-rather not use PCL tray call code.  ...

    Pkaiser5 pointsBadges:
  • retrieve library list

    how to retrieve library list when i pressed f4 in a field and is field has *all the it fetch all library listed in subfile

    97834441841,355 pointsBadges:
  • AS400 File transfer from AS400

    I transfered the database output into excel file using CPYTOIMP command and attached the excel file using SNDDST command.But i have issue that i didn't received the excel file through email only if the file size more.Anyone kindly tell me, how to write the data into multiple sheets or kindly advise...

    hamsinee130 pointsBadges:
  • Logical file Error.

    i try to create Multiple-format Logical File but i getting compile time error. i have two PF dds is as follow.. A          R RDEPTMST                A            DEPTNAME      15        A            DID            5        A            LNAME      ...

    Nikrajpapa230 pointsBadges:
  • AS400 SNDDST with Dynamic from address

    kindly anyone please tell me, how to change dynamic FROM email address in the SNDDST command.I have task to change the from address in the SNDDST based on parameter user sent.I checked in the internet with option to configure TCP using WRKDIRE.But i want the dynamic from address for the particular...

    hamsinee130 pointsBadges:
  • upload the data into files

    hi, how to upload the data into bpcs files from excel sheet. please anyone help on this.

    421380 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