f



Why use an AS400?

I work with a company that really pushes the AS/400.  My big question
is why?  What does the AS/400 offer that you can't get on a
conventional server?  I know our code is written in RPG and uses a SQL
database.

Any input would be apprecaited.  Thank you for your help.
0
lawentzel (13)
3/24/2008 12:39:53 PM
comp.sys.ibm.as400.misc 9219 articles. 3 followers. Post Follow

12 Replies
1310 Views

Similar Articles

[PageSpeed] 59

There are 4 main reasons

1. Reliability - almost never goes down.
2. Security   - no known virus.
3. Usually, a lower TCO (total cost of ownership)
4. Keep the investment in existing code (who else runs RPG?)

Numbers 1 & 2 are why you see most casinos, banks, insurance
companies, and the like running this system.
0
graybeard (174)
3/24/2008 2:46:52 PM
Lee wrote:
> I work with a company that really pushes the AS/400.  My big question
> is why?  What does the AS/400 offer that you can't get on a
> conventional server?  I know our code is written in RPG and uses a SQL
> database.
> 
> Any input would be apprecaited.  Thank you for your help.

Maybe the question should be, what would you rather do?
0
bvstone1 (373)
3/25/2008 5:36:23 AM
On Mon, 24 Mar 2008 05:39:53 -0700 (PDT), Lee wrote:

>I work with a company that really pushes the AS/400.  My big question
>is why?  What does the AS/400 offer that you can't get on a
>conventional server?  I know our code is written in RPG and uses a SQL
>database.

Why not? 
I mean write on a paper *all* the things you (or your company) do with the black
box (the most important to me are):
- identity management 
- terminal server (not windows style)
- development framework 
- application server (not in the jee terms, but you can run RPG code AND COBOL,
JAVA, C, PHP, PYTHON, PERL)
- web server
- database server
- printer server
- file server (using ifs the right way).

all of this (and more, now it works also as a voip switchboard) with the best
reliability, scalability and security available on the market.

Put all this function in a windows or *nix box and then see how much it will
cost you the different solution. I bet it will cost you THE SAME if not a little
bit more. 
So why not use an iSeries solution?




0
suarez (8)
3/25/2008 1:29:19 PM
On Tue, 25 Mar 2008 14:29:19 +0100, "Suarez (from work)" <suarez@despammed.com>
wrote:

>switchboard)
pbx, sorry 
0
suarez (8)
3/25/2008 3:47:16 PM
On Mar 25, 1:39 am, Lee <lawent...@gmail.com> wrote:
> I work with a company that really pushes the AS/400.  My big question
> is why?  What does the AS/400 offer that you can't get on a
> conventional server?  I know our code is written in RPG and uses a SQL
> database.
>
> Any input would be apprecaited.  Thank you for your help.

Until now, I've always thought there was no such thing as a stupid
question.  I'm guessing you come from a windows/unix background and
these machines are strange to you.  Think of that as a challenge to
learn something new rather than trying to prove they are not
necessary.
0
jsev99 (187)
3/25/2008 7:22:14 PM
"Lee" <lawentzel@gmail.com> wrote in message 
news:b79ba869-e902-4faf-b6f4-83f15f23ce84@d45g2000hsc.googlegroups.com...
>I work with a company that really pushes the AS/400.  My big question
> is why?  What does the AS/400 offer that you can't get on a
> conventional server?  I know our code is written in RPG and uses a SQL
> database.
>
> Any input would be apprecaited.  Thank you for your help.

Simple answer:
If your code is written in RPG then the AS/400 is the only system that 
can run it. 


0
scott1328 (345)
3/26/2008 4:20:52 AM
Lee wrote:
> I work with a company that really pushes the AS/400.  My big question
> is why?  What does the AS/400 offer that you can't get on a
> conventional server?  I know our code is written in RPG and uses a SQL
> database.
> 
> Any input would be apprecaited.  Thank you for your help.

There are numerous hardware and software architectural features not 
available on any other platform including the IBM mainframe.  Some of 
these features (single level storage, user and system domain storage, 
hardware storage protection, objects) are both a blessing and a curse.

The blessing part is much better protection from a virus/worm/spoofing 
point of view.

The curse is that it is much more work and effort to port applications 
to i5/OS.

-- 
Rodney A Johnson
Former Technical Team Lead for i5/OS (AS/400) Spool (working on new 
project now)
Dept GJC
IBM   Rochester, Minnesota

The contents of this message express only the sender's opinion.
This message does not necessarily reflect the policy or views of
my employer, IBM.  All responsibility for the statements
made in this Usenet posting resides solely and completely with the
sender.
0
rodjohns (130)
3/27/2008 9:37:12 PM
On Mon, 24 Mar 2008 05:39:53 -0700, Lee wrote:

> I work with a company that really pushes the AS/400.  My big question is
> why?  What does the AS/400 offer that you can't get on a conventional
> server?  I know our code is written in RPG and uses a SQL database.
> 
> Any input would be apprecaited.  Thank you for your help.

Because it is the most reliable hardware and software platform on this 
planet! 

In 10 years of working with the System i I have never had a system 
failure. NEVER have I had unscheduled downtime for system problems. Can 
you really say that on a Linux/Windows/Unix system? Not at the places I 
worked. We also have a very rich development environment not found on 
other platforms. Not to mention that you don't need to pay a DBA 500,000 
dollars a year to manage your platform. All it takes is some training and 
you are set to go.

One of the best features is that the OS and the DB2 product are not 
separate. We are the only platform on the planet that I know of that does 
this. I would LOVE to see Oracle try to do something like this. I bet the 
folks who would manage it would make 900,000 a year!

Jason

 Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
    ** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------        
                http://www.usenet.com
0
shoe7285 (34)
3/29/2008 5:31:26 AM
On Mar 27, 5:37=A0pm, "Rodney A. Johnson" <rodjo...@gmail.com> wrote:
> Lee wrote:
> > I work with a company that really pushes the AS/400. =A0My big question
> > is why? =A0What does the AS/400 offer that you can't get on a
> > conventional server? =A0I know our code is written in RPG and uses a SQL=

> > database.
>
> > Any input would be apprecaited. =A0Thank you for your help.
>
> There are numerous hardware and software architectural features not
> available on any other platform including the IBM mainframe. =A0Some of
> these features (single level storage, user and system domain storage,
> hardware storage protection, objects) are both a blessing and a curse.

curious to know if  single level store is a blessing or not. My guess
is the 16meg space limit makes for very diffcult to maintain operating
system code. Pointers from one associated space to another have to be
rebuilt when an object is restored. Are pointers actually used much in
system objects like spooled files, output queues and programs?

>
> The blessing part is much better protection from a virus/worm/spoofing
> point of view.

I dont know the specifics of this, but are not managed code languages
like C# and Java inherently secure?

-Steve


0
3/31/2008 4:24:10 PM
On Mar 24, 8:39=A0am, Lee <lawent...@gmail.com> wrote:
> I work with a company that really pushes the AS/400. =A0My big question
> is why? =A0What does the AS/400 offer that you can't get on a
> conventional server? =A0I know our code is written in RPG and uses a SQL
> database.
>
> Any input would be apprecaited. =A0Thank you for your help.

the facilities for problem determination in i5/OS are very good.
joblogs, journals, the program call stack,. The abilitiy to place a
running job in debug mode, halt it and examine program variables up
and down the call stack.  With journaling you can get very fine
grained information on which programs in what jobs are updating your
database tables.

-Steve


0
3/31/2008 4:29:58 PM
"Steve Richter" <StephenRichter@gmail.com> wrote in message 
news:1fa2eb50-5e95-4a3e-abb2-85c8a6eb200e@m36g2000hse.googlegroups.com...
On Mar 27, 5:37 pm, "Rodney A. Johnson" <rodjo...@gmail.com> wrote:
> Lee wrote:
> > I work with a company that really pushes the AS/400. My big 
> > question
> > is why? What does the AS/400 offer that you can't get on a
> > conventional server? I know our code is written in RPG and uses a 
> > SQL
> > database.
>
> > Any input would be apprecaited. Thank you for your help.
>
> There are numerous hardware and software architectural features not
> available on any other platform including the IBM mainframe. Some of
> these features (single level storage, user and system domain 
> storage,
> hardware storage protection, objects) are both a blessing and a 
> curse.

curious to know if  single level store is a blessing or not. My guess
is the 16meg space limit makes for very diffcult to maintain operating
system code. Pointers from one associated space to another have to be
rebuilt when an object is restored. Are pointers actually used much in
system objects like spooled files, output queues and programs?

>
> The blessing part is much better protection from a 
> virus/worm/spoofing
> point of view.

I dont know the specifics of this, but are not managed code languages
like C# and Java inherently secure?

-Steve




The concepts of managed code like C# and Java were originated in the 
S/38 and then the AS/400 from the very beginning in 1980.  Everything 
above the "technology independent machine interface" or TIMI, which 
includes most of the OS and all user programs are "managed code". 
This is true of all languages and is a fundamental part of the /400's 
famous reputation for security.

In Windows, Unix, Linux, Z/OS and just about every other system there 
is no real difference between pointers and integers.  This is why 
hackers can manipulate a pointer and then access memory with great 
freedom.  Pointers on the /400 are a special object type that is 
protected by the OS.  They carry not only an address to storage but 
also the users rights to the object and the valid capabilities (modes 
of access usage) of the referenced object.  This is why a buffer 
overflow attack will not work on the /400 and why both the system and 
user programs tend to be more reliable.

The one problem with /400 type pointers is that many programs from 
other OSs are sloppy in their use of pointers which is why it can be 
difficult to port code from these systems to the /400.  The primary 
purpose of  TeraSpaces in the PASE environment on the /400 is to allow 
a block of storage for application programs to manipulate pointers in 
the Unix stile and still protect the rest of the system.

One last point.  If you were to try to convert C programs to Java or 
C# you would run into all the same problems with porting the code.

Mike Sicilian







0
mike51 (101)
3/31/2008 10:43:09 PM
Steve Richter wrote:
> On Mar 27, 5:37 pm, "Rodney A. Johnson" <rodjo...@gmail.com> wrote:
> 
>>Lee wrote:
>>
>>>I work with a company that really pushes the AS/400.  My big question
>>>is why?  What does the AS/400 offer that you can't get on a
>>>conventional server?  I know our code is written in RPG and uses a SQL
>>>database.
>>
>>>Any input would be apprecaited.  Thank you for your help.
>>
>>There are numerous hardware and software architectural features not
>>available on any other platform including the IBM mainframe.  Some of
>>these features (single level storage, user and system domain storage,
>>hardware storage protection, objects) are both a blessing and a curse.
> 
> 
> curious to know if  single level store is a blessing or not. My guess
> is the 16meg space limit makes for very diffcult to maintain operating
> system code. Pointers from one associated space to another have to be
> rebuilt when an object is restored. Are pointers actually used much in
> system objects like spooled files, output queues and programs?
> 

Yes pointers are used heavily.  Performance and security main reasons 
for spool.  Sadly with rewrite of spool internals in V6R1, some pointer 
usage had to be replaced resulting in some performance degradation. 
This was due to the implementation needed to improve IPL performance and 
concurrent access performance within spool.  Additional checking logic 
had to be put in place to prevent spoofing and usage of stale references.

16 meg limited spaces has caused some problems for development, hence 
teraspaces and mapped memory objects are used when contiguous storage 
beyond 16 meg is required.

I suspect that more problems are now coming up with teraspaces and 4 
byte integers.  One can only reference 2 or 4 gig of memory with 4 bytes.

> 
>>The blessing part is much better protection from a virus/worm/spoofing
>>point of view.
> 
> 
> I dont know the specifics of this, but are not managed code languages
> like C# and Java inherently secure?
> 
> -Steve
> 
> 


-- 
Rodney A Johnson
Working on a new project.  Former technical team Lead for i5/OS (AS/400) 
Spool
Dept 33A
IBM   Rochester, Minnesota

The contents of this message express only the sender's opinion.
This message does not necessarily reflect the policy or views of
my employer, IBM.  All responsibility for the statements
made in this Usenet posting resides solely and completely with the
sender.
0
rodjohns (130)
4/1/2008 4:05:49 PM
Reply:

Similar Artilces:

Printing on AS400 via IBM AS400 Java Toolkit
Hello all, I'm working on a program that needs to send a print job to a printer connected to an AS/400. I've tried using the SpooledFileOutputStream and I've also tried using one of the SCS Writer classes. Neither solution is working. With the SpooledFileOutputStream I am at least able to create my print file, but when my program ends, the file is still not being printed. This program does not run on the AS400, it runs on a PC and connects to the AS400 via the toolkit classes. I know this part works as I am able to use the toolkit to access Data Queues, Files and Data Areas without a problem. Is there anyplace anyone can point me to see some examples of how to print a file using the AS400 Java Toolkit? Thanks in advance, Chuck Chuck, What printer data stream is used? or how was the printer data generated? I am wondering if the data stream being generated matches the data stream of the printer connected to the iSeries? What printer is attached to the iSeries and how is it configured? The iSeries info center has some Toolbox examples: Programming>Java>IBM Toolbox for Java>IBM Toolbox for Java Classes> Access Classes>Print>Creating... Dave Chuck wrote: > Hello all, > > I'm working on a program that needs to send a print job to a printer > connected to an AS/400. I've tried using the SpooledFileOutputStream > and I've also tried using one of the SCS Writer classes. Neither > solution is working. With the Sp...

AS400 to AS400 connection
Hi. What`s the rocommended method of copyting data beetween two AS400 (both on V5R1) ? Regards, Tom tom wrote: > Hi. > What`s the rocommended method of copyting data beetween two AS400 (both on > V5R1) ? Probably FTP. "tom" <tomeks@comp.pl> wrote in message news:c8c9u5$fb4$1@nemesis.news.tpi.pl... > Hi. > What`s the rocommended method of copyting data beetween two AS400 (both on > V5R1) ? > > Regards, > Tom > > It depends how often you are doing the copying & how much there is. If you want say one record but every 3 seconds then you can either store them up for a few hours days or weeks & use FTP, snads or a tape. Or you can do it realtime & use DDMF to zap each record to the other machine as its written. I actually save the data I want sending this way into a file which is read & deleted by a daemon style of job so that if comms or the other machine fails only the daemon is affected. FTP has its upside in that the target is easily resettable for say a unix machine but SNADS has an easy to use & understand message sent to the sender & recipient to verify arrival of the data. -- Jonathan Bailey. You could install the No Charge SW "Object Connect" from the OS CDs. Once setup you can issue cmds line SAVRSTLIB and SAVRSTOBJ. Give these cmds the LIB or OBJ list and the target system. It then saves/transfers/restores to the target system all with just the 1 SAVRSTxxx cmd. tom wro...

Microsoft uses IBM AS400's for development.
Not well known but Microsoft uses IBM AS400 machines with the Windows server card option to develop programs. This option is really a PC on a card but offers significant advantages over a stand alone pc in that it can support virtual sessions of Windows each of which can be rebooted as required without bringing down the other seesions or worse the rest of the machine. Microsoft is a huge IBM AS400 customer. Most people assume developers are using PC's sitting next to their work space. Fadl Ullah Jonnalagadda wrote: > Not well known but Microsoft uses IBM AS400 machines with the Windows > server card option to develop programs. This option is really a PC on > a card but offers significant advantages over a stand alone pc in that > it can support virtual sessions of Windows each of which can be > rebooted as required without bringing down the other seesions or worse > the rest of the machine. Microsoft is a huge IBM AS400 customer. Most > people assume developers are using PC's sitting next to their work > space. MS developers are using Win 2k3 and Win 2k8 servers as development machines too and not PC(s), with VMware. Fadl Ullah Jonnalagadda wrote: Plonk "Fadl Ullah Jonnalagadda" <fadlullah.jonnalagadda@gmail.com> wrote in message news:60deb8d3-5599-48d8-8667-6734e37a756b@31g2000vbf.googlegroups.com... > Not well known but Microsoft uses IBM AS400 machines with the Windows > server card option to develop programs. ...

* use in As400
I have been using as400 for agbout a month at work and i cannot figure out what the * means..... I understand wild card astericks perfectly like dir *.txt. However what does it mean before a word... the best I can figure out is that it means any... as in *DEV, *LIB. But what about *YES, *NO, etc.... Is there a good explanation or is it just an "AS400 thing" as a co-worker told me. Hi - On 10 Nov 2006 23:08:11 -0800, "greggiefen" <greggieFEN@gmail.com> wrote: >Is there a good explanation or is it just an "AS400 thing" as a >co-worker told me. It's just an OS/400 thing (actually it predates OS/400 back to CPF on the S/38) as a way to specify special values. For some things it could go either way. If a parameter only accepts a yes/no value, *YES/*NO or YES/NO or Y/N would work equally well. But for something like an object name, *ALL and ALL are _not_ the same thing. *ALL is all objects. ALL is an object called ALL. -- Ken http://www.kensims.net/ Opinions expressed are my own and do not necessarily represent the views of my employer or anyone in their right mind. Greg, The * in front of a parameter is a way to designate a reserved keyword without actually using up a real word. So, for example *YES is a reserved keyword but YES is not reserved. Many operating systems have reserved words that prohibit their use elsewhere. The AS/400 mitigates this by putting a * in front of the actual word to create a completel...

IBM AS400
Does anyone have some notes, documentation or helful pointers about navigating, command language and DB2 on an AS400 for a guy who has done HP3000, Windows 2k/2k3, MS SQL, HP9000, IBM ES9000/UNIX, SCO UNIX? Ideally a commands cross reference qaulivalent would be terrific - I.E. HP3000 to AS400. Thanks much. P.S. I'm taking a role in a shop that runs its ERP system on this platform. Jim. ____________________________________________________________________________________ Get easy, one-click access to your favorites. Make Yahoo! your homepage. http://www.y...

AS400 to AS400 data transfer
Hi I need to place a trigger on a set of tables on an AS400 to fire off whenever new records are added to these tables. This trigger program will then transfer the data to another AS400 across a WAN. This will allow us to transfer orders from one system to another. Can anyone tell me how I would achieve this. Normally if it had been a PC I would have used an ODBC type application but I am not sure what is available to me for AS400 to AS400 data transfer. I know that we can transfer a SAVF by FTP but this is not a route I would like to go down. I would prefer to populate tables directly if possible. Thanks for any help offered Iain Iain wrote: > Hi > > I need to place a trigger on a set of tables on an AS400 to fire off > whenever new records are added to these tables. This trigger program > will then transfer the data to another AS400 across a WAN. This will > allow us to transfer orders from one system to another. Even if there may be multiple way, I think the best would be using a remote journal, on the target system a journal entry exit program will be evoked at event time, so it can apply new records to the target tables, then it can fire a new event if necessary. -- Dr.Ugo Gagliardelli,Modena,ItalyCertifiedUindoscrasherA�ejoAlcoolInside Spaccamaroni andate a cagare/Spammers not welcome/Spammers v�o � merda Spamers iros a la mierda/Spamers allez vous faire foutre/Spammers loop schijten/Spammers macht Euch vom Acker/Spamerzy wypierdalac' ...

AS400 to AS400 connection issues
Hi All, We have two AS400's at different locations, and were able to passthrough and send files between both no problems. Last week one of our AS400's was moved to another location, with an IP change. We have updated the IP addresses on the other AS400 and can passthrough fine....however we can no longer send files from the new location. When I look at the distribution queue I see the following status: RTY-FAIL Any idea's as to what may be causing this? Thanks, Mike mot98@yahoo.com wrote: > Hi All, > > We have two AS400's at different locations, and were able to > passthrough and send files between both no problems. > > Last week one of our AS400's was moved to another location, with an IP > change. > > We have updated the IP addresses on the other AS400 and can passthrough > fine....however we can no longer send files from the new location. > > When I look at the distribution queue I see the following status: > RTY-FAIL > > Any idea's as to what may be causing this? run the CFGDSTSRV command and then look at all the menu options. Another command to look at is CFGTCP. -Steve Steve Richter wrote: > mot98@yahoo.com wrote: > > Hi All, > > > > We have two AS400's at different locations, and were able to > > passthrough and send files between both no problems. > > > > Last week one of our AS400's was moved to another location, with an IP > > chan...

AS400 to AS400 data transfer #2
Hi I need to place a trigger on a set of tables on an AS400 to fire off whenever new records are added to these tables. This trigger program will then transfer the data to another AS400 across a WAN. This will allow us to transfer orders from one system to another. Can anyone tell me how I would achieve this. Normally if it had been a PC I would have used an ODBC type application but I am not sure what is available to me for AS400 to AS400 data transfer. I know that we can transfer a SAVF by FTP but this is not a route I would like to go down. I would prefer to populate tables directly if possible. We are using 2 model 820's with OS400 V5 R2 Thanks for any help offered Iain ...

Migrating to a new system which uses AS400. Sites which have useful info?
Our company is in the process of installing a new ERP system called Frontier made by Friedman which runs on an AS400. We have a small I.T department and at present none of us have any AS400 / OS400 experience. What sites have good technical information that can be downloaded (preferably for free) regarding system admin of the iSeries hardware and software. On another topic as anyone here got personal experience of Frontier and what do they think of it? Cheers. There are a number of good books available. Check both: http://www.mcpressonline.com/ http://www.pentontech.com/education/ Check iSeries Network for an iSeries specific site: http://www.iseriesnetwork.com/ Sorry, never heard of Frontier. Sam "Nexus" <nexus@nospam.com> wrote in message news:ASScf.8047$c66.5600@newsfe3-gui.ntli.net... > Our company is in the process of installing a new ERP system called > Frontier made by Friedman which runs on an AS400. > > We have a small I.T department and at present none of us have any AS400 / > OS400 experience. > > What sites have good technical information that can be downloaded > (preferably for free) regarding system admin of the iSeries hardware and > software. > > On another topic as anyone here got personal experience of Frontier and > what do they think of it? > > Cheers. > Nexus - Frontier is very strong for volume custom configured products such as doors, windows, blinds and ...

How to use AS400 journaling?
Hi, I am using V5R4. Is there any way to see a table journal in the form of SQL that was actually run on it? Can I see that at some date and some time, someone did an UPDATE, or INSERT or DELETE? Can I see the full SQL query that was executed (sort of like what is saved with interactive SQL sessions, but for all users)? The output of DSPJRN is very criptic, I'm looking for something simpler. On Oct 9, 5:59 am, simun.se...@gmail.com wrote: > Hi, > > I am using V5R4. Is there any way to see a table journal in the form > of SQL that was actually run on it? Can I see that at some date and > some time, someone did an UPDATE, or INSERT or DELETE? Can I see the > full SQL query that was executed (sort of like what is saved with > interactive SQL sessions, but for all users)? > > The output of DSPJRN is very criptic, I'm looking for something > simpler. You'll have to start a database monitor job to see this but there's no way to limit it to a particular table. You can limit it by job and I think user (this option is new to V5R4) or you can start one for the entire system but you'll need lots of free DASD to store all of the information it produces and it will slow the system down. Matt SQL is not the only way to delete or insert rows. The program name and job attributed to the action defines the where, the user defines the who, and of course the date/time defines the when; what the identified program does, defines the ...

AS400 for Home Use
Hi all, I've been considering picking up a used as/400 and would appreciate any comments on the feasibility of purchasing a low end machine for development use at home. I have a background in rpg/cobol development but am unsure of hardware, processor and licensing issues involved. There seem to be many 170s and older interactive boxes with V4R4 available but can anyone comment on licensing, the availability of PDM, compilers and other LPPs in the used marketplace, etc? V4R4 with RPG, Cobol, etc would satisfy my initial requirements, but upgradeability to V5R1 with WDStudio tools would be an eventual concern. I would appreciate any advice on the minimum processor, memory requirements for any WAS development, webfacing etc for a single user in a non production environment. Thanks in advance. Allan Smallest current model is 800, but that's probably still a little too pricey for at home. You might be able to pick up a used 250. Either way, software has to be licensed from IBM. Another option is Baby/400, from California Software. I've never seen or used it, but they have a long history. (First product of theirs I heard of was Baby/36.) It runs on a PC, so hardware is inexpensive. It includes editor (like SEU), compilers, and database that mimics PF/LFs. If you only need to do some development and testing, this might be enough. But it is not OS/400. I'm pretty sure it won't have support for OS functions such as communications (SNA, TCP/IP), security, and...

Buying used AS400
In 2001 I lost my job as an RPG/COBOL programmer of several years and ended up with jobs in the last 6 years that were not involved with AS400 at all. So now as a consultant of a few months have a client that needs data migrated off of their AS400 that had no PC's attached and have to work on getting a workstation set up with emulation card to download the data. As a result of this, I have decided to look into buying a used AS400 that I can used to download client data from tape as well as have RPG & QUERY400 compilers as a part of it. I think I need to look for a 170 or 270 but not sure what the difference between the 2 is? And I have found alot of places to buy the CPU with the OS but where do I find the other software to install on it. Also, has anyone had any experience in using the Nlynx 3xtwin PCI card to connect and download data using PCSupoort? Thanks MP 1st a home i5 (AS/400) is expensive to maintain. It's not just the hardware but the software licenses and hardware upkeep. I have had to barter for replacement features several time to keep my machine alive. 2nd to deal with client tapes you need compatible drives. Since there are so many formats this too can get expensive. I have had to FTP some very large files around because of not having the right tape drive. This may not be a problem if you have the kind of bandwidth I have. 3rd no one uses a PC emulation card anymore. Just setup your home network to work with iSeries Access via TC...

From a AS400 with a CCSID to another AS400 with different CCSID
Hi all, I've the following issue: - I have to move data from a AS400 with CCSID 65535 (no conversion) to another AS400 with CCSID 37 I'm using DDM files on the second AS400 linked to the first AS400, but reading DDM files I have the problem that data are different in the special characters... So I changed my job session CCSID to 65535 with CHGJOB; with that I can see correctly DDM files data, but not the local files... What do you suggest to do? Many thanks in advance. Fabrizio On 09-Jun-2011 05:47 , Fabrizio wrote: > > I've the following issue: > > - I have to move data from a AS400 with CCSID 65535 (no conversion) > to another AS400 with CCSID 37 > > I'm using DDM files on the second AS400 linked to the first AS400, > but reading DDM files I have the problem that data are different in > the special characters... > > So I changed my job session CCSID to 65535 with CHGJOB; with that I > can see correctly DDM files data, but not the local files... > > What do you suggest to do? > The system CCSID QCCSID is effectively moot in that scenario as far as I can recall. What do matter are the CCSID of the job opening the file and then reading the data, and the CCSID of the columns of the file being opened. When the job is set to a proper CCSID, then whenever the data is also "tagged" properly with a CCSID [e.g. column of a table with a non-hex (non-65535) CCSID], the database will convert the dat...

how to use and as400 9401-150
hello i just go and as400 ibm server model 9401-150 without instructions. and i dont understand how do you connect to it. some people tell me i need and 100 serial to twinax cable in a ibm page that i dont recall says that i can connect using the MI port on the back. but i am not sure how can i connect to this ports. was thinging if any of you guys can point me to and manual for this server as in the ibm page i cannot find the instruction manual and what programs do i need to connect to it. and thanks for ur help guys. There are basically 3 ways to connect. 1. With twinax cable to a "dumb" 5250 terminal (if twinax card installed) 2. With a special serial cable to a PC with special software installed (console) 3. With ethernet to a PC with 5250 emulation installed. Prob the most common, but does not support "console" mode, and requires TCP services be running. Maybe the 150 has other options? I'm not very familiar with that model. The IBM infocenter web site might help. http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp Change the V5R4 to the version of the o/s you have. the as400 has in the back 2 cards installed 1 that have like 2 printer ports that are flat and on that have 1 of those connector and a serial conector. also it have 2 more serial conector one that says MI (management Interface) and another one that says UPS(uniterruptible power suppy) also idk what os this is running as this was a gift so its there a way i can ...

Upload to AS400 using VB
I've got a little program written in VBA, which takes some data from an Excel file and uploads to a physical file on our AS400. The program works fine, except that the user is obliged to complete the login screen in order to carry out the upload request. I thus amended the prompt properties and hardcoded the id and password into the code. As far as I can tell this works, and I'm logged into the sytem as should be, but now I get the following error, when running the final "upload" method. "A conversion error has occurred during the tretament of the transfer demand". The only differnce between my program working and not working is this lack of user id/ password prompt. Anbody have any thoughts on why this is occurring? Note that the error I've displayed is a translation from French, since I am using French software. Thanks Mohsen Maybe it's your auditors blocking the hard coding of the password. -- Doug "mo_in_france" <qureshi.mohsen@gmail.com> wrote in message news:fca54c4e-6968-4a14-a5bd-389dbd592d3a@w34g2000hsg.googlegroups.com... > I've got a little program written in VBA, which takes some data from > an Excel file and uploads to a physical file on our AS400. > > The program works fine, except that the user is obliged to complete > the login screen in order to carry out the upload request. I thus > amended the prompt properties and hardcoded the id and password into > the code. As far a...

A basic question about AS400 using
Bonjour, (1) What is the link between AS400 and iSeries? Sorry, I didn't understand that on the IBM site. (2) A collegue told me that an AS400 was used by a customer for transmitting IP datagrams (coming from a LAN) on a X.25 dedicated line. I don't understand why an application server has been used for that translation. For me, IP and X.25 protocols are just level 1, 2, 3 services. Am I wrong? Can somebody give me a few words? Thanks, Angelot (1) iSeries is just a "rebranding" (ie renaming) of the AS400 under the larger eServer family of IBM servers. (2) It is doubtful the AS400 is being used just to "translate IP datagrams on an X.25 dedicated line". There must be some other application the AS400 is being used for. "Angelot" <NoSpam@NoSpam.fr> wrote in message news:c0tvrp$pto$1@news-reader4.wanadoo.fr... > Bonjour, > > (1) What is the link between AS400 and iSeries? Sorry, I didn't understand > that on the IBM site. > > > (2) A collegue told me that an AS400 was used by a customer for transmitting > IP datagrams (coming from a LAN) on a X.25 dedicated line. > I don't understand why an application server has been used for that > translation. For me, IP and X.25 protocols are just level 1, 2, 3 services. > Am I wrong? > > Can somebody give me a few words? > Thanks, > Angelot > > Thanks Jim for these remarks. Regards ...

Position with company using AS400
I'm currently representing a company that is running on AS400 and they're using BPCS for their ERP system. They're looking for someone to come in and head up their IT management. The position is a direct staff position in Milwaukee, WI. Please let me know your thoughts on that. Thanks, Dan Nischke Director of IT Business Development dnischke@sitepersonnel.com (262) 345-9933 x200 ...

using AS400 SMTP server
I'm trying to use the SMTP server from our AS400, which has outbound access= to the internet but is blocked from inbound ports. The purpose is to have our custom AS400 software email customer invoices, s= tatements, and ocasional reports. I've added an SFP TXT record to the DNS and that seems to be accepted as a = "pass" by many servers. However certain servers like aol.com and rcn.com w= ill not accept email from us. The reason given is usually some kind of tim= eout that doesn't give the reason that the server won't accept email from u= s: NOT ABLE TO DELIVER MAIL TO SOME/ALL RECIPIENTS. REPLY CODES WITH FIRST DIGIT =3D '4' OR '5' ARE ERROR REPLIES. ERRORS THAT DO NOT HAVE ERROR REPLY CODES MAY EXIST. HOST PNNK00 NOT ABLE TO DELIVER MAIL TO FOLLOWING RECIPIENT(S): <xxxxxxx@yyyyyyy.NET> RETRIES EXHAUSTED WHILE ATTEMPTING TO CONNECT TO REMOTE HOST yyyyyyyy. In looking into this more, I see that while we now have an SPF that seems O= K, we don't have domain keys, DKIM or sender id Does anyone know the best way to get an AS400 internal SMTP server to be tr= usted where the AS400 is being used for Send Only and not open to public in= ternet pings on any port? Thanks Can't you bounce/relay it off a real internal SMTP server rather than trying to let the AS/400 do the sending ? The mail server framework has always been fraught with issues and it may be better to bou...

PowerPC extensions for IBM AS400
Looking for an explanation or documentation on the as400 specific extensions to the PowerPC instruction set. Pointers on the as400 are stored as 16 byte values. The LQ ( load quad word ) and STQ ( store quad word ) instructions are used to load and store those pointers. Here is PPC assembler code that loads a pointer from an EA into a register: LQ 24, 0x1e50(30), 6 SELRI 26, 25, 0, 41 LQ loads the 16 bytes stored at EA reg30 + 0x1e50 into reg24 and reg25. The next SELRI stmt does something to reg25 and places the result in reg26. Does anyone know what the 3rd opera...

link table IBM AS400
Hi. Sorry for my english but I have MS Access in italian. My problem is by link a table from IBM As400 (with > 100.000 rows). The output of the table is many #ELIMINATO (in english "delete" / "erase".. I dont't know the exact message). I have tried with "requery" or recreating the link without results. If I *import* the table from AS400 it works perfectly without problems. Here an abstract txt BOLAZI;BOLCLI;BOLDBO;BOLNBO;BOLCAU;BOLNPR;BOLTRE;BOLMAT;BOLDES [........] [........] ;;;;;;;#Eliminato;#Eliminato ;;;;;;;#Eliminato;#Eliminato ;;;;;;;#Eliminato;#Eliminato 0;474;990204;354;10;1;1; 936;PC Intel Pentium II 400 Miditower 0;474;990204;354;10;4;1; 1890;CD-ROM drive 36X 0;474;990204;354;10;5;1; 1692;HD-SCSI 4.5 Gb IBM Ultrastar WIDE 7200 0;474;990204;354;10;6;1; 1497;HD-SCSI 9.1 Gb IBM DDRS-39130 UWIDE [........] Thanks in advance M. "Mire" <mary@hotmail.com> wrote in message news:buo9eo$k39dq$1@ID-57790.news.uni-berlin.de... > Hi. > Sorry for my english but I have MS Access in italian. > My problem is by link a table from IBM As400 (with > 100.000 rows). > > The output of the table is many #ELIMINATO (in english "delete" / "erase".. > I dont't know the exact message). > I have tried with "requery" or recreating the link without results. > > If I *import* the table from AS400 it works perfectly without problems. > &...

connect to AS400 using ADO...
Can someonne please tell me an ADO connection string to use to link an AS400 table to Access WITHOUT using a DSN? Thanks. Matthew Wells MWells@FirstByte.net Matthew Wells wrote: > Can someonne please tell me an ADO connection string to use to link an AS400 > table to Access WITHOUT using a DSN? > > Thanks. > > Matthew Wells > MWells@FirstByte.net Have a look at Carl Prothman's website. He has examples of ADO/.NET connections on his website http://www.carlprothman.net/Default.aspx?tabid=87#OLEDBProviderForAS400FromIBM Matthew Wells wrote: > Can someonne please tell me an ADO connection string to use to link > an AS400 table to Access WITHOUT using a DSN? > > Thanks. > > Matthew Wells > MWells@FirstByte.net I don't know about ADO specifically, but I have never been able to do any sort of connection to our AS400 (ISeries) without using a DSN. The problem I run into is that I can find no entry in the connect string for the "System" argument that works, and yet it also doesn't work if I leave that argument out. -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com I've been able to open an ADO connection without a DSN, but not refresh a table link. "Rick Brandt" <rickbrandt2@hotmail.com> wrote in message news:Zkz5e.8887$c76.8335@newssvr11.news.prodigy.com... > Matthew Wells wrote: > > Can s...

Printing to as400 using cups
Hi all, Has anyone been able to print to an as/400 from linux using cups? If so, what format did you use for the name, location, and device uri? I'm using: name: nameofprinter location: //nameofas400 device: 'windows printer via SAMBA' device uri: smb://Workgroup/nameofas400/nameofprinteronas400 Problem is, this doesn't work and I think my "device uri" is wrong, but don't know what to change it to. Using the old linux box, I added this to my printcap and it worked (still does actually): nameofprinter:\ :sd=/var/spool/lpd/nameofprinter:\ :rm=amoroso3:\ :rp=QUSRSYS/nameofprinter:\ :lp=/dev/null:\ :sh: -- Julien Mills Amoroso's Baking Company Tel: (215) 471-4740 IS Dept email: julien@amorosobaking.com www.amorosobaking.com I'm not sure why you'd do this - almost everyone use tcp/ip attached printers with as400 now, so why wouldn't you just go directly to the printer itself? julien mills wrote: > Hi all, > > Has anyone been able to print to an as/400 from linux using > cups? > If so, what format did you use for the name, location, > and device uri? > > I'm using: > > name: nameofprinter > location: //nameofas400 > device: 'windows printer via SAMBA' > device uri: smb://Workgroup/nameofas400/nameofprinteronas400 &g...

Has anyone used .NET with the AS400
Has anyone used .NET with the AS400, or know of any good jump start books? The only training course that i can find to see how to gain access to DB2 is a $495 casette based course. "Darth Ferret" <noneavailable@hotmail.com> wrote in message news:Pi98g.9401$ba.4314@tornado.tampabay.rr.com... > Has anyone used .NET with the AS400, or know of any good jump start books? > The only training course that i can find to see how to gain access to DB2 > is a $495 casette based course. > This is the redbook: http://www.redbooks.ibm.com/abstracts/sg246440.html. It requires v5r3. You probably intend to program against the ISeries using the .NET framework on a thick client (eg. VB/C#) or from a web server (eg. ASP.NET)? The ISeries doesn't run the .NET framework natively so you will always need a Windows host (excepting the Linux Mono project of course). Your access to the ISeries is via ADO.NET / OleDB and, if set correctly, it should result in almost identical program code only with the DB2 provider. So any introductory VB/C#/ASP.NET programming guide would work only with the DB2 provider. Rj. "DBDriver" <DBD@swifttel.com.au> wrote in message news:4461365f$0$499$61c65585@uq-127creek-reader-03.brisbane.pipenetworks.com.au... > > "Darth Ferret" <noneavailable@hotmail.com> wrote in message > news:Pi98g.9401$ba.4314@tornado.tampabay.rr.com... >> Has anyone used .NET with the AS400, or k...

Crystal Reports
Hi all Is anyone using Crystal Reports on the AS400 and if so, is it an end-user solution? Some of the tables that I want to access have an embedded period, is that a problem? (AR.CUST) Thanks, in advance Neil Nope - I'm not using it. "Newbie_Neil" <neil@village-street.co.uk> wrote in message news:c8951894.0411260857.7a27673e@posting.google.com... > Hi all > > Is anyone using Crystal Reports on the AS400 and if so, is it an > end-user solution? > > Some of the tables that I want to access have an embedded period, is > that a problem? (AR.CUST) > > Thanks, in advance > > Neil Newbie_Neil wrote: > Hi all > > Is anyone using Crystal Reports on the AS400 and if so, is it an > end-user solution? > > Some of the tables that I want to access have an embedded period, is > that a problem? (AR.CUST) > > Thanks, in advance > > Neil I've used it, and it worked fine; connects through Client Access's ODBC link. You can specify either SQL naming (uses dots, as in libname.filename) or system naming (slashes - libname/filename) in your ODBC setup. I don't think Crystal Reports would be a very good end-user solution. It's not impossible to learn, and for certain it would easier than teaching end users to do printer file DDS and RPG or COBOL programs, but it probably makes much more sense to let end users do what they do best - accounting, finance, marketing, etc. - ...

Web resources about - Why use an AS400? - comp.sys.ibm.as400.misc

AS400 Iseries
If you are looking to create jobs that you need to run at specified days or times on a regular basis on your as400 then your need to be using ...

India Jobs Network
Job Posts Search Hire Recruit Candidates Profile Resume CV HeadHunters HR Sourcing Recruitment Consultants Recruiters requirements Jobs firm ...

Operating system - Wikipedia, the free encyclopedia
An operating system ( OS ) is a set of software that manages computer hardware resources and provides common services for computer programs . ...

Software industry - Wikipedia, the free encyclopedia
The software industry includes businesses for development , maintenance and publication of software that are using any business model. The industry ...


摄影器材资料馆 - Leica中文摄影论坛 专业中文摄影社区
Leica 关于 Leica 中文站 论坛首页 最新主题列表 最新回复列表 专业认证版块 认证会员摄影作品展专区 认证会员器材交流专区 认证会员摄影讨论专区 中文摄影论坛 摄影器材资料馆 技术互助讨论区 摄影器材专卖店 中文站办公室 注册 找回密码 登录 在线会员总数 注册会员总数 ...

Manager Business Process Support / CT8225
Manager Business Process Support / CT8225 job in Valley Forge, Pennsylvania, US. Read the Manager Business Process Support / CT8225 job description ...

Attunity Integration Technology Forum
Attunity Integration Technology Forum. To find out about Attunity, go to http://www.attunity.com/ .

AS400, iSeries, IBM Free BCD Software Download Trials for Web App Development and BI
The IBM i and PC software products you will download are fully functioning versions of our software, complete with manuals. Free Trials, purchased ...

iDevelop: Cloud
The thoughts and musings of Jon Paris and Susan Gantner, two traveling System i application development evangelists. Topics include RPG, PHP ...

Resources last updated: 3/24/2016 12:34:03 PM