• The IT Blog Top 10: Oct. 1, 2009

    10. Choosing a block size when creating VMFS datastores Eric Siebert provides a guide detailing how to choose a block size for VMFS datastores. 9. Using VRDP to view VirtualBox virtual machines remotely Rick Vanover walks through Sun’s xVM VirtualBox’s ability to tap into VRDP remote viewing....

    Michael Morisy8,598 pointsBadges:
  • Getting error when converting file to csv format using CPYTOIMPF

    I am trying to convert a data file to csv format using command CPYTOIMPF. The data file cotains fields with type "O" (DBCS-Open data) and I received an error. Error id CPF2845 Code 1. How to resolve this problem? command used: CPYTOIMPF  FROMFILE(&LIB/&FILE &MBR) TOSTMF(&STMF) +...

    MayraPR5 pointsBadges:
  • Connection to Iseries for multiple users V5R4

    Have shared computer and need to make connection to iseries that works for each user that logs onto the system without having to make same connection manually for each user.

    Computerchiksc5 pointsBadges:
  • system storage

    Can anybody say if i make one pf with following DDs R RECORD    ENAME           20A    ESAL               5S0    EDOB                L        DATFMT(*MDY)                                     DATSEP('/') NOW I AM...

    Anky10 pointsBadges:
  • iSeries Navigator printed output

    I can view my spool files on the iSeries using the wrksplf command, but not thru iSeriece Navigator. When I click on Printed Output the panel is blank. When I right-click on Printed Output and select Customize this view, all options except Auto Refresh are grayed-out.

    LBurkett99850 pointsBadges:
  • SQL Query Issues with date math

    Table with partial sample data would appear as follows: EQUIPNO  ASSEMBLY  START_TIME  END_TIME 150          0              24-MAY-09   25-MAY-09 150          0              25-MAY-09   25-MAY-09 150          0             ...

    Phoenix210 pointsBadges:
  • Backflush Raw material from 2 or more stockroom locations

    If a subassembly is setup in JBA system 21, can it "backflush" raw materials from 2 different stockrooms? How? Appreciate the replies

    Jetones5 pointsBadges:
  • Embedded SQL

    In SQL RPGLE program, I declare a cursor using a view.. The view has name Emp_Pat_Dept_Data(EMPdata) the empdata is the AS400 name. In my cursor def which name I should use. Also for the fields referenced do I need to use the renamed field names in the view definition or I can use the field names...

    Nutangujar895 pointsBadges:
  • How to remove duplicate row in multi joined table?

    My qurey is below. SELECT [5000Phantoms79w/VNos&othersFromAna].ID, [5000Phantoms79w/VNos&othersFromAna].PhtomNo, [5000Phantoms79w/VNos&othersFromAna].[New No], [5000Phantoms79w/VNos&othersFromAna].[dB OE tied to Phantom], [5000Phantoms79w/VNos&othersFromAna].dB2ndSetNewNo,...

    CompEng1,240 pointsBadges:
  • Menua Option change

    Opt  Object      Type      Library     Attribute   Text                             OBRPT       *MSGF     LIb1                     Report Trackin      OBRPT       *FILE      ...

    Nutangujar895 pointsBadges:
  • AS/400 user password complexity

    How can I force system users to keep their password with special character, I have been assigned this to do, is it possible in AS/400?

    Vinay40055 pointsBadges:
  • Damaged Object unable to remove

    Hi anyone else come across this problem. I have a damaged object which is causing the full system save backup to skip whe whole library with the damaged object in. The library is a user one with a object type of DSPF  Normaly a delete and create a damaged object fixes all, but I can not...

    Mell0rman270 pointsBadges:
  • SQL error

    I've a cursor to fetch date from DB2/400...When date is stored as 0001-01-01, I get error - Year portion of the Date not in correct range. This is the default date my update program stores when user doesnt enter anything for date field. How can I bypass this error while fetching SQL cursor in my...

    Nutangujar895 pointsBadges:
  • Using combo box to populate a sub form which is used to create a new record

    Using Access 2003 I have a table called POTable which contains 4 fields. PONOID (primary Key and AutoNumber), PONO (text), VENDOR (text), GENDESCRIP (text). I have another table called MRRTable. This table contains several fields with one of them being PONOID (number). What I want to do is the...

    Gbullo70 pointsBadges:
  • Access for Windows 5.4

    On one of my PC that uses Access for Windows when I start the Display I also start the printer and it seems to blink the printer screen when starting. So times it just blinks and blinks and bli.nks. I loaded the latest fix, but it only happens on this one machine.

    plaporte55 pointsBadges:
  • ending a savsys if tape is bad

    our tape is not advancing in the backup operation - how to end the job? so we can restart the backup with a new tape?

    Dsterba5 pointsBadges:
  • Program Object Comparison

    We have 7 As400 Servers in our shop all having same program, due to poor maintenance As400 Program objects (include CLP, CLLE, OPM & ILE) in all the servers are not the same, Now I need to find out the objects that are not the latest one by comparing the object with program's in Development...

    RJES45 pointsBadges:
  • Notes email attachment to IFS Agent?

    Is there a class, or function of some kind that can be used to authenticate against an AS400 IFS using lotus Script.

    Hdwest61120 pointsBadges:
  • ASC type Office issues downloading to AS400 system

    We are upgrading from Office 2000 to Office 2007 and it appears that the type ASC is missing. (think it was gone in Office 2004) We need the ASC type to download a large file to the AS/400 without this format the file comes over incomplete on unreadable Does anyone have a converter or any...

    Superbusy15 pointsBadges:
  • Spooled files not saved after printing when migrating to V5R4

    We migrated from V5R3 to V5R4.  A user tells us that spooled files that used to change to SAV after printing are 'disappearing'.  What could have changed?

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

Thanks! We'll email you when relevant content is added and updated.

Following