I am fighting to keep the use of stored procedures in our company. There are a few people who say they are bad and we should not use them. We are using DB2 on the i-series. Please help in my argument to keep stored procedures alive in my company. ...
i am running a rpg program recursively it is giving an error like this Application Error. RNX8888 unmonitored by PGM1 at statement *N, instruction X'0000'. Trigger program or external routine detected an error.....what can be the resolution ...its urgent..thanks ...
my code goes like this femp uf e k disk dvar1 s 5p 0 c *loval setll emp c read emp c dow not %eof(emp) C eval ecode = ecode + 10 c eval var1=ecode c update recemp ...
We are connecting to a multi-member AS400 iSeries table via HIT OLEDB and HIT ODBC. You connect to this table via an alias to access a specific multi-member. We create the alias on the AS400 this way: CREATE ALIAS aliasname FOR table(membername) We can then query each member of the table this way: SELECT * FROM aliasname We are t...
Ok So I have an AS400/iSeries running v5r4. I have an application that was using classic NHibernate to connect and do some basic crud. Now I have pulled that app (which sat for 2 years) off the shelf of TFS and onto a new PC and cannot seem to get it running. Here is my Hibernate Config: <hibernate-configuration xmlns="urn:nhibernate-...
Hello what is AS/400 and where we use such systems? Which Programming language is using? where can i get the detail information about as400. ...
i want to write the output of a qshell command to local data area so that it could be globally used by programs.is there some way to write from stdout file to local data area .I want it to be done through CL..its urgent thanks ...
I have a client running an AS/400. I have to ftp a flat file over to them. They tell me their return charaters are RN. I don't recognize this, could not find anything on it, and their tech guy is Nick Burns so he refuses to give me any dirtection. Is there a standard return code for AS/400? I should have mentioned that I have a c# .NET ...
How do you perform a Select top N * from as400table type query against an as400/db2 database ...
I have written a delphi application that allows a user to define a query and run it over a DB2 database on an IBM System i using a TADOQuery component with the IBM DB2 OLE DB Provider. We now have a requirement that the user be allowed to secure the connection using SSL if they so wish. I know that I can pass a value of "SSL=TRUE" into ...
I have a DECIMAL field which contains a date in the AS400 format : 1100614 I have tried : cast (MYDATE as DATE) : can't cast DECIMAL to DATE, DATE(MYDATE) returns null. How do I cast this field in a DATE field ? ...
Since Java 7 is comming I was wondering how much time it would take to have the IBM JVM running Java 7 on IBM i systems? (AS400) I was searching IBM's site to find some roadmap but didn't find anything yet. Do you have past experience on the older java release? ...
Hello all, I am a newbie to AS400-Java programming. I am trying to create my first program to test the implementation of Message Authentication Code (MAC). I am trying to use the HMACSHA1 hash function. My (Java 1.4) program runs fine on a dev box (V5R4).But fails terribly on the QA box (V5R3). My program is as below: =================...
Hey all, First off, I am not an AS 400 guy - at all. So please forgive me for asking any noobish questions here. Basically, I am working on a .Net application that needs to access the AS400 for some real-time data. Although I have the system working, I am getting very different performance results between queries. Typically, when ...
We are calling a Java program on a iseries machine and the first call to the program is quiet slow. The following calls are fast but if we wait a certain time the call is slow again. How can I keep the JVM up and running or is there another way to solve this problem? Thanks ...
Hi, Whenever I am trying to click either the "Send files to host" or "Receive files from host" on client Access Emulator, it is not working. I dont know what is the problem. I have installed the full version on Client Access on my PC Can anyone help me in this? I would appreciate your help. Regards Arpit Srivastava ...
i am new to as/400 OS and i Series from IBM. i want to start learning using remote as/400 server. Can you recommend me some server ? thanks ...
hi i have string type abc_01, abcd_01 or 02 now i want the substring upto _ ie abc_,abcd_ etc. I am using db2 as400 .Please suggest the processing through RIGHT or LEFT function ...
I have PHP on running on an AS400. Can Git be also be installed on an AS400? I'd like to use it to maintain version control. ...
I was trying to delete a record from a table in AS/400 database. I got an error message saying that there is a referential integrity to another table XYZ in the same Schema ABC. To my wonder, that table was not in the list of the tables shown by my DbVisualizer database client. Then I decided to do a select on that table (ABC.XYZ) - bu...