• 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:
  • AS/400 profile error

    My profile is created few days back and whenever i login i am getting this message:   [strong]Message ID . . . . . . :   CPA0701       Severity . . . . . . . :   99          Message type . . . . . :  ...

    Herbina325 pointsBadges:
  • Is it possible using Embedded SQL or something else in RPG to directly update and MS SQL DB

    I have a need to push data from the AS/400 to an SQL DB on an SQL 2008 server. I was wondering if there was a way to do this natively within RPG on the AS/400 without purchasing something. Was thinking embedded SQL or stored procedures might be able to accomplish this. Has anyone done this?

    Minidach15 pointsBadges:
  • subfile in RPGLE

    i have indicator to show fields in a row red in subfile... when i select some option say 5 - view against this row, it displays necessary details. now affter dispalying this when i return back to existing screen, i update SFL to make the selected option 5 blank, and redisplay the file.....however...

    Nutangujar895 pointsBadges:
  • what is SEQONLY(*YES) property

    [strong]Hi,                                                                                                                                       i have a problem...

    Sreeraj20 pointsBadges:
  • RPG Programming Standards

    I'M LOOKING FOR RPG PROGRAMMING STANDARDS. We have always had standards example if you create a report the report should have the date, title, program name, page numbers.  Does anyone have a stanards document or is there anything on the web?   I appreciate your help!    

    Superbusy15 pointsBadges:
  • display file – window RPGLE

    I have a window for a display file       whenevr i display field level err message the message appears outside the window.... how will i get it inside the window at the bottom? @depnum        11Y 4B 11 18 A 41                                 ...

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