Search results for query: *

Thanks Hitechuser I appreciate the good thoughts and upgrade warnings. When I mentioned in a prior thread that "stay-linked" looked resaonably priced I looked a little further and found that the prices quoted were license fees, not purchase prices. I don't know as of now if these are annual...

Hi: Its Warren again. Has anyone used a product called "Stay-Linked"? I found out about it via a google search (its mentioned everwhere) and the code seems to run on the 400 treating the hand held wireless scanners like dumb terminals. Looks interesting and cheap, but does it work well...

Good day: Management has decided to use two wireless scanners to log items from manufacturing into the warehouse and also to verify that the correct items ordered are being packed into the shipping containers. The scanners must interface with a legacy inventory system on the as400. Has anyone...

I have a situation where a windows web server, via ODBC/SQL, accesses an inventory database on the AS/400 via a SELECT statement issued by the server. It reads each record in the file, no such thing as a SETLL, CHAIN. I couldn't believe it. I've been told that, if I built a logical over the...

Someone told me that a website used by a company I know was developed via Sphere software. I can't find anything about it. Does anyone know where I can get information? Thanks.

talkturkey Thanks for your "RGZPFM Physical KEYFILE(Logical)" reply, but I don't know what you mean. Would you please elaborate? Thanks Warren

talkturkey/iseriescodepoet I've looked (wrkactjob) when the server connected to the 400 but could never find any trace of it. As far as the logical is concerned I did not change the SQL on the server to go after the logical instead of the physical. What really seems strange is that the...

Iseriescodepoet SQL on the 400 expired months ago so I can't STRSQL. The SQL SELECT statement is executed on the remote webserver. I haven't any idea how the 400 interprets what it gets from the internet. Any ideas? Thanks Warren

Talkturkey: I inserted an error in a product record not assocated with the product in the SELECT statement and got an error message. I removed the error and everything was OK. This lead me to believe that records for products not mentioned in SELECT were being accessed. Warren

Thanks arrow483 for the reply. I built a logical over the physical as you suggested and came up with the same result. It read each record in the file. Any suggestions? Warren

Good day all: For starters, I’m not an SQL programmer. I have an inventory database file on a client’s as400 that is accessed within the building via an old RPGII program from the System/34 days. It is also accessed externally via a SELECT SQL statement on a web server via ODBC. It is...

Hi: The IBM Data Description Specifications Reference manual that I have says that "The number of fields that make up a key is restricted to 120. The total key length cannot exceed 2000 bytes". I can only assume that you are thinking about an internally described file. You don't need to...

Good day all: Has anyone had any experience installing and using the PC under the covers of the AS/400 for web serving? We have a model 620, V4R5 and have had a suggestion that hosting our website internally using this approach would be to our benefit. Any thoughts, experiences, etc. would be...

Good day all Even after reading the CL manual I don't really understand if, when, or why these commands should be run. Does anyone have an opinion on the subject? Should I include this in some kind of periodic process? If so; How often and why? Thank you Warren

Good day all: What steps do I have to go through to find what the IP address of the AS/400 is on the network? I'm at V4R5. Thank you. Warren

Good day: I have a need to set up a fixed length field to hold an email address. How big can they be? I've seen some AS/400 programs that used 50 characters. Is this the maximum, or was someone just guessing? Any advice would be appreciated. Thank you Warren

good day all - Several weeks ago I installed a cable modem to speed internet access. I also went to AOL 9.0 at about the same time. They had a trial download of Mcafee firewall that I downloaded. It slowed down my PC to a point where it was almost usless and I uninstalled it. I went and...

This may be a little late (Feb thru Apr) but I thought I'd add a comment. Wullie has given some really good advice. I'm an IBM midrange programmer (AS/400) and have a client that wanted a website built that would interact with the inventory on the 400 along with inside people. I advised that...

AFCJACK could you not, using PDM, call up all DSPF members in a source file. Select option PRINT, then do a CPYSPLF to a physical file, and write a program to extract the variables? Warren

arrow483 Thank you. CHGPRTF worked great. I didn't know it existed. Warren