I have our AS/400 setup, TCPIP services are running, I created user profiles and I can Telnet into the AS/400 without any probs.
However...
We are supposed to use the IBM AS400 Client Ac...
Hi,
Our AS400 system was unplugged for almost 1 year before we decided to put it back on the network. While doing the IPL we got following error code
Front Panel shows this number
27...
Hello,
I would like to know how to export data returned from a sql query to something that I can work with, such as a text file or anything I can bring over to my windows environment.
...
I need to create a md5 fingerprint from within a RPGLE app. I found some good sample code at http://bb.blackrobes.net/viewtopic.php?t=9 .
The only problem is that the example is coded to us...
I've replaced the DASD from a model 820 AS400 and want to restore from fullsysbk. I switched the panel to 02 D in manual mode. But the external tape drive is not booting.
How can I load ...
Can anybody tell me what object type *SQLPKG is ??
Background.
We have a server full of Item Drawing pdf files. (This is an NT server. NOT the IIS on the AS/400)
On our AS/400 we have an "Item Master" file, which has a field that contains t...
Hi Everyone,
I'm looking for an example of a script used in AS400. I use the macros all the time, but I'd love to figure out the scripting capabilities, as it would save me quite a bit of ...
Hello,
I understand that this questions is not directly related to the AS400, however as it is to do with JDE (which runs on AS400) I was unsure of which topic to place the question under. ...
We have a new network Sharp Copier, printer, fax and would like to have it as our main printer because the cost is a lot cheaper to print from. Has anyone had any experience connecting a Shar...
I want to add a month to my date field in sql like:
select curdate+ 1 months from ...
In SQL server, I can use DateAdd() function, how to do it in SQL/400?
How can I manage to create *.PDF files from a spoolfile.
(without upgrading to OS/400 V5R1)
Hi All,
This isn't a programming question, but I figure the AS/400 topic is my best bet.
I'm looking to compare the run time of a job on my machine with the same job running on a custome...
I am creating a device description for a HP printer using the CRTDEVPRT command. My question is on the PORT NUMBER parameter, what do I fill in? How can I find out the port number? Here is ...
Hi
Does anyone know how to read DBF directly from VB script, similar to RCVF in CL.
The idea is, I want to read file from PC, without have to create any program in the as400.
condition is,...
HELP. I am trying to use MGET to transfer files from a PC to an AS400. There are multiple files in a folder on the PC, and I can transfer to the AS400 using MGET. But they come over as indi...
I have a windows Vista box that i can RDP into. It's running as a MySQL server. I have a webserver too with PHP installed and the dlls for PHP. So i put a script on the PHP server to input ...
Our AS/400 IPL everynight. It does backup first, then system cleaning and IPL. I'm just trying to find out where those jobs get defined?
I am not an AS400 expert and I am not confident my "expert" has all the answers.
Our AS400 has exceeded the capacity of our tape unit as our 400 has had its hard drives maxed out.
We ...
On our AS/400 IFS there is a /home directory and within it each user has their own folder that they have their word & excel documents. When I look in the I-Series Navagator the home dir is un...
Hi Guys,
Is it at all possible to create a Single-on to an AS400. The platform i have is AS400/WINDOWS 2000. As things are at the moment, my staff have to first sign-on to their PCs then ...
I need an ILE-RPG routine to take a character string (i.e. 'bbbbb0.123' and change it to be (i.e. 000000123)
for numeric zoned decimal use. (b = blanks)
If I have 'b000', I need to end up...
I really need to stop Windows type programming and get back to RPG....
That being said, we are a JDE shop and my boss told me he wants me to put a "Trigger" on a file to log inserts and chang...
Work with TCP/IP Routes
Type options, press Enter. ...
I need to be able to call an RPG program from an iSeries Stored Procedure. The program that we have is that when the procedure is called an error is returned that the program cannot be found ...
