The question really asks it all. We have a bunch of really old S/36 programs that need to be moderized. I am more looking for articles or sites that explain what the old method does and how to convert it to RPGLE. ...
I just wanted to know if you know of some projects that can help to decide whether the analyzed Source it is good code or bad RPG code. I'm thinking on the terms of [Software metric], [McCabe Cyclomatic Number] and all those things. I know that those numbers are mere a hunch or two, but if you can present your management a point s...
I need to use the current library name explicitly in a CL program. CHGVAR &LIB *CURLIB doesn't work (after this line &lib = '*curlib'). This should be simple - any ideas? ...
We have a mixture of .Net apps that connect through ODBC and DB2 Connect to an iSeries LPAR that's at V5R4. We also have some batch jobs running natively on the machine (COBOL, RPG, and straight CL mostly). During certain periods of the day, we experience high page faulting and are trying to determine which apps might be causing the prob...
I was wondering what were the hidden performance implications of using the Database object in the Enterprise Library. I have an OleDbCommand (type=stored procedue) that is calling an IBM iSeries stored procedure that is taking anywhere from 1.5 to 4.5 minutes to complete. If I manually run the sproc using the iSeries tools and similar p...
Hi, my main language is vb/c#.net and I'd like to make a console program but with a menu system. If any of you have worked with "dos" like programs or iSeries from IBM then thats the style I am going for. so, was wondering if anyone knows of a "winforms" library that will make my form look like this. I dont mind a "fake winforms look"...
I have a requirement in a SQL environment that under specific circumstances, all references to table (or view) A in a procedure actually use table (or view) B. On the iSeries I would have used the OVRDBF command to override references to table A with table B: OVRDBF FILE(A) TOFILE(B). What would be the equivalent to this in SQL? Is th...
I'm newish to NHibernate, and am attempting to wire up to a DB2 table through the ISeries provider. The table has a BIGINT primary key that is auto generated as an identity. I've tried several values for the generator property of the id in my mapping file, and haven't had any success. The table def looks like so (field names changed):...
I have an application that will reside within a business2business network that will communicate with our AS400 in our internal network environment. The firewall has been configured to allow the data request through to our AS400, but we are seeing a huge lag time in connection speed and response time. For example what takes less than a ...
All of our current ASP.Net web apps access our IBM I Series using an ODBC connection and command object. Should I move to another way of accessing it? How do you current access your I Series when your ASP.Net app needs data from it? There has to be a better way. I recently saw this article about IBM supporting Linq to Entities with a sp...
This is a sample query for a dataset in my Microsoft Reporting Services Report (.rdl) SELECT ORDNO FROM INTERFACET.DOPPRMAH This is connecting to the iSeries via the OLE DB driver from IBM. How do I "parameterize" the 'INTERFACET' part. ...
We're trying to take a PDF file created in a web application and dynamically insert it into an AFP datastream on an IBM iSeries. Does anyone know if this is possible? ...
Hi, I'm trying to connect to the AS400 database DB2 from a Java application hosted in JBoss application server. But, I'm getting the below error when ever I run my application: Apparently wrong driver class specified for URL: class: com.ibm.as400.access.AS400JDBCDriver, url: jdbc:as400://DBSYTEM;driver=toolbox;trace=false;errors=full;p...
Background: iSeries version of DB2. In every environment, there is a table containing positional column information about other tables. As the data in this table is static and has to be re-generated every time a table is altered, problems can occur if it is out of step. All the positional data exists in QSYS2.SYSTABLES and QSYS2.SYSCOLU...
I am using Eclipse and i-series Navigator for database. when I ran my application it is showing: Exception=Exception001{Id=0,Message=java.lang.RuntimeException: Failed to connect to queue manager,Severity=2}], ServiceID=GetCustomerProfile2,Status=2,TransactionID=1} Please suggest what to do? ...
We have a stored procedure written using a CL and RPG program combination. When called locally on the iSeries all is fine. When called externally (for example from a SQL frontend) the RPG program cannot get a hadle on the spool file it produces because the spool file appears under a different (random?) job number and user. The jobs run ...
Hello, I am using the standard .NET OdbcConnection to connect to an AS/400 iSeries database. I am able to query this database. Unfortunately, there are some fields that appear to be encoded. How do I decode these values in C#? I have tried the following: string text = string.Empty; if (bytes.Length > 0) { ASCIIEncoding encoder = ne...
I found http://www.iseriespython.com/, which is a version of Python for the iSeries apparently including some system specific data access classes. I am keen to try this out, but will have to get approval at work to do so. My questions are: Does the port work well, or are there limits to what the interpreter can handle compared with stan...
Can anyone provide any interesting usage examples of these? ...
First, just a bit of background: One of our customers is experiencing CPU usage spikes for WebSphere instances running one of our web apps (other instances with other apps are fine). They have a test environment and a live environment (both iSeries) which both experience the problem - with a single app per instance setup. We have deploy...