• AS/400 QUERY ; how can I calculate the month and year of 3 months ago in define result fields?

    I am using an AS/400 query in which I need the month and year of 3 months ago based on today's date. To get today's date I use current(date) but I need to know the month/year 3 month ago and the month/year of previous month undepending which day of the current month it is. Is that possible? I...

    Chrisjegoderie30 pointsBadges:
  • Oracle LIKE statement on SQL Server 2005

    I'm trying to execute the LIKE statement but it's not displaying  any values SELECT R_NAME FROM LAWSON.DEPTCODE WHERE (R_NAME LIKE :r_name)

    Huhemp5 pointsBadges:
  • How to use edtcde &edtwrd in o spec?

    Dear all, Actually I want to learn the use of edtcde and edtwrd keywords in O spec. how can i use these keywords suppose if  i have a field sellprice which consists 7 length with 2 decimal position i want to put $ sign for the values of this field in fixed and floating format how can i code it in...

    6r1,640 pointsBadges:
  • RPGIV – numeric field to character field

    Experience shows you cannot move a numeric field to a character field using EVAL - so what is the best method? Is Movel the only way? Thanks.

    NeilD545 pointsBadges:
  • AS/400 spool file transfer to server

    Any best way to trasfer the generated spool file and store in a server - is it good to covert the spool to PF and ftp the file to server? Thanks in advance for any input.

    CLCL25 pointsBadges:
  • AS/400 IFS accessing shares

    A strange issue came up. When trying to access the IFS shares from a windows machine, a user gets prompted for a username and password, but when he enters his AS400 username and password it re-prompts him as if the password was wrong. It also adds DOMAIN\ before the username when re-prompting. All...

    mshen27,385 pointsBadges:
  • Cal I load a record SET into a work file using SQL within RPGLE?

    ALL - I have to process a set of Inventory Transactions based on W/H, Product, From Date, and To Date. Normally, I would jump into a Do Loop; read the SQL cursor; write the record to a work file; process until EOF. Can an SQL statement do all of that for me in one statement? I have not been able to...

    MurrayInfoSys940 pointsBadges:

    Hello all, My company purchased an operations software (called [strong]darwin[/strong]) that works with SQL 2005 Server. I need to extract some data and save it in my Own Database, which is located in the same SQL Server. On the darwin software there is a screen that updates a field X in a table,...

    LUISCGG5 pointsBadges:
  • 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,323 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.

    LBurkett99830 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:

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.