I am working with a Windows based server and an AS-400 datasource. I am wanting to create a databse stored procedure on the 400 with which I can A) Pass in a series of approx 25k account #'s,...
Hi I have a web application that uses a stored procedure to send an email. I get the error message: "The client connection security context could not be impersonated. Attaching files require ...
Recently we bought three new HP laptops for our outside sales people at work. I installed the AS/400 Iseries Access for Windows version 6.1 and everything was groovy for a couple of weeks. T...
This is all to assist my work across DB2 on Windows/Linux/AS400.
Are there any file transfer tools Windows/Linux side that can transfer files to and fro between Windows/Linux & AS400 OR can...
We are using Zabbix at my work to monitor our systems. I would like to use Zabbix to monitor our i5 machines. The Zabbix manual says that SNMP can be used to get values from an AS400 system....
I just need to know the command (s) to display the Processor and Processor Type on an AS400??
For example, processor type: IBM RISC
the command to display this information as well as ho...
We have an old AS/400 that we pulled out of storage to access historical data but it is not responding on the network. Cables are connected correctly and but there are no lights showing on th...
I need to find out if: "Shared Access Path" set to *YES on an AS400.
I'm not savvy on the 400 so I need some assistance on what command to use to obtain this information. Thanks!
Running V4R5M0. Have been through the problem handling and corrected the problems that were there, but the light remains on. The only other problem i can find is this message:
Job 018784/...
How to Install an IBM 4247/Z03 printer with Ethernet Lan card on iSeries As400?
Thank you very much.
Hi experts,
Ususally when we want to print an as400 report on a printer, we print it to its ip address directly.
if a printer is attached to a windows workstation, is there a way to print v...
I am running the night cycle, seeing the job on MSGW, i want to check the contant of some file in QTEMP How can i check this, SInce it is the night cycle i cannot debug this PGM.
Thanks
OR
I have a spreadsheet which will have variable number of columns depending on addition or deletion of new models. This needs to be loaded to AS400 table. I saved the spreadsheet as csv. Then wh...
I need a script (cl) to obtain a report of all files with deleted records, then run the command RGZPFM. The manual process to know that file requires reorganization is long, I need an autom...
I have an HP ColorLJ 3600 connected to a single port JetDirect box via USB. Printer is visible on our network and am able to print from Windows applications. Setup a *LAN *IP device on the ...
Hi,
Is there any process in which I can monitor performance of a JDE Dreamwriter Job and determine if there are any issues? E.g. is the data transferring from the Interface Files to JDE files...
Hello,
I have a requirement of creating a .NET web service that will interact with the AS/400 db.
I have the following questions:
1: How will I set up the database access?Will I use a ODB...
Hello,
I'm working with data from an AS400 database and writing a report in Crystal using SQL in a Command Window as my datasource. I'm in a non-IT department and unfortunately do not have ...
I want to transfer Greek data which is in Excel file to AS/400 physical file
SELECT date('01/12/2009')
FROM sysibm/sysdummy1
returns: 01/12/09
I need: 01/12/2009
Experts,
When printing from windows to a printer share (iSeries NetServer)
We need to achieve one of the following:
Get the spooled file attributes (number etc . . .) that was created...
How can I copy an AS/400 externally described physical file to the IFS, to a direcory that is accessible using the wrklnk command, into a format that is readable by PC programs such as Notepad...
AM IMPLEMENTING WINDOW SUBFILE HELP SCREEN.
THERE IS WINDOW SUBFILE FOR HELP IN SCREEN.AGAIN THERE IS ANOTHER WINDOW SUBFILE HELP
FOR SOME FIELD OF FIRST WINDOW SUBFILE.
OVERLAYED ON TH...
I had raised a question a few days back regarding the drivers and installables needed for accessing the AS 400 DB from .NET.I was suggested many good responses in the link :
Please refer the ...
I need to join multiple files with sql. I am getting way to may records and do on see the problem. I have tried inner and left outer joins.... help! In both cause it seems to be join each l...
