• move document to AS400 (Iseries) folder

    How do you move (or copy) a document from an IFS directory to an Iseries folder?

    AZL20 pointsBadges:
  • Embedded SQL to process ALL members

    Hi, I'm trying to get an RPG with embedded SQL to read all the members in a file. I know I used to be able to do this with an OVRDBF command with *ALL specified for the member, but this doesn't seem to work anymore. In the joblog I get a CPF4268 message which says the file has no members or is not...

    Gilly40023,730 pointsBadges:
  • SQL Stored Procedure

    I need to create a stored procedure with an input parameter of member name to create an Alias, select all the data in the member then drop the Alias. This procdure wil be called by 3rd party software using an odbc connection.

    Markpg155 pointsBadges:
  • Using the SQL IN clause in SQLRPGLE

    Can I use a variable with the IN clause in an iSeries SQLRPGLE program? Can I use: WHERE CUSTID IN(:CUSTNUMS) Instead of: WHERE CUSTID IN(145,1600,352)

    PWMASI5 pointsBadges:
  • Problem with CCSID ?

    Hi Our iSeries is on V5R4 and hosts a few Lotus Domino Servers... The Domino servers runs scheduled agents which create CSV File stored on the IFS. I can access and open these CSV files under Windows (with this syntax \\SERVER\SHAREDFOLDER)but the content is like this :...

    BruceWayne4,110 pointsBadges:
  • How do I determine the price ranges for an iSeries?

    I am interested in understanding how much an iSeries costs (mid-range and enterprise level systems) and its associated hardware components such as DASD, memory, etc.. I have been browsing the internet, but I have not come across a site that clearly lists the price for a specific iSeries model or...

    Vintagej5 pointsBadges:
  • Tuning DB2/400 queries on iSeries

    We are using lot of DB2/400 queries in our iSeries system. Are there any tools available on the market to tune them?

    AS400 - Ask the Expert485 pointsBadges:
  • calling java function running on websphere from as/400

    How to call a java program running on web sphere application server from System i? We are able to call a java program deployed on System i on IFS directory using RPG ILE.

    Uiiuo50 pointsBadges:
  • RSTLIB and Journaling

    I am doing a SAVLIB of our Production Data Libraries creating SaveFiles on our Production iSeries, then thru FTP, transferring the SaveFiles to our Development iSeries, then doing RSTLIBs. During the RSTLIBs I get a CPF7085 - Journal QSQJRN already exists and CPF3756 - JRN QSQJRN not restored. It...

    wpoulin2,480 pointsBadges:
  • Mapping to IFS from another domain

    Iseries and AD profiles are synch'd for mapping IFS Shares. We now have other users from another domain accessing the shares, If the get the windows Signo window what need to be inputted?

    Rickmcd1,605 pointsBadges:
  • Iseries fails to boot

    I have a v5r4 820 model that failed. Error code in display is 284C3203 which pointed to I/O problem for either system board or Disk controller. I replace both and the only way I can get past this error is by using the new disk card with the new RAID memory. The old RAID memory card seems to have...

    Spadasoe5,130 pointsBadges:
  • create a remote outq which points to an outq on the remote iSeries

    i need to transfer spool files from one iseries server to a remote iseries server.

    Fukuyi5 pointsBadges:
  • AS400 mapped drive locks Windows account

    I have a user that has AS400 mapped drives. When they access the drive, their Windows account gets disabled!?!? This isn't happening to anyone else. We use EIM to control access to the Netserver folders. He can access the AS400 folders just fine, but when he does, that's it for his Windows account....

    ScottWHI25 pointsBadges:
  • import data from excel 2007 to iseries

    how do you import data from excel 2007 to iseries

    JimC11285 pointsBadges:
  • Migration

    I like to migrate a database which is in IBM OS/400 V5R3MO (Source)using iseries navigator to Oracle 10g.In the source database there are few stored procedures and few triggers which I like to migrate from source to oracle too. So I like to know is Oracle migration workbench will able to do so or...

    792755 pointsBadges:
  • Address validation or checking software

    I'm looking for a software that check and/or correct address entry, Is there an application for Iseries based? I've found some windows and Web based applications but not on the AS400.

    Notabol5 pointsBadges:
  • iSeries to Unix FTP problem

    I've a physical file with single field (64 chars long) and want to transfer it across to our Unix system using FTP. When I transfer the file across, I don't get CR/LF characters at the end of each record. All physical file records appear in a single line. If I retrieve the same file from my PC...

    Maverick6925 pointsBadges:
  • iSeries Object Deletion

    Is it possible to track down who deleted an object on the iSeries? (Not a system object). Where should I look?

    Robwes5 pointsBadges:
  • iSeries Emulator works on most 400s

    I am running Vista Home Premium and can connect to 15 of the 16 AS400s I have access to. However, this one lucky one will connect, but will just have a blank screen. I have a colleague that can connect to the same 400 on an XP machine with the I-Series emulator. I have tried to search Google for an...

    AdamRuss5 pointsBadges:
  • iSeries: Accessing src PF member using Java/400

    I am a veteran iSeries programmer but new to Java. We have a requirement of reading src PF member as record (each line) and to be transmitted. Also, incoming streams to be created as a src PF member by adding the recs in it. Which Java/400 class can be used to read from a member (e.g...

    Raju40060 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