problem about ibm-midrange-Collection of common programming errors
Jimmy Engtröm
.net ibm-midrange data-access
I’m trying to connect to a AS400 server using the .net classes. I have added a reference to IBM.Data.DB.iSeries and I use the following code:var conn = new iDB2Connection(“DataSource=111.111.111.111;UserID=xxx;Password=xxx; DataCompression=True;”);conn.Open();But I get the following exceptions Running 64 bit: “The provider cannot run in 64-bit mode.” Running 32 bit: An unexpected exception occurred. Type: System.DllNotFoundException, Message: Unable to load DLL ‘cwbdc.dll’: The operating system
Ben Thurley
java spring osgi ibm-midrange osgi-bundle
I’m trying to integrate spring DI into an existing jaxws project. I’ve got this working locally on tomcat but when I deploy to the remote container it doesn’t appear to do the classpath scanning. I can see in the logs that on tomcat it registers my @Components as beans but on the remote server they’re not mentioned at all.What I do see is the stacktrace below. It looks like it’s down to the quirky web container I have to use. It’s the “integrated application server for IBM i”. http://www-03.ibm.
Charles Martin
c++ regex ibm ibm-midrange
I am looking for a way to use Regex Replace functions on IBM iseries.As far as i know, i can use C++ librairies (regex.h) (source) With this, i can only match regex, but not replace. (using regcomp() to compile and regexec() to match the regex)Does anyone know a way to do it ?
AkD
java encoding ibm-midrange cobol
I am trying to invoke a simple Hello World Cobol program through java. The java code is in IFS file structure and the cobol object is parked in a library. I am facing multiple problems:The error stream returned by process execution is not in readable format. I am getting error stream result even if the termination of cobol code returns 0. I cannot see the cobol output result in the inputstream of the process.(May be I can solve this if i understand the error stream )The cobol code works whe
hewhocutsdown
ibm-midrange gcc
I’m trying to compile ghostpdl 9.07 on V5R4 in QP2TERM (the AIX-like PASE environment).After downloading and untarring the package to /QOpenSys, I ran:CALL QP2TERMand then in QP2TERM:./configure –build=”powerpc-ibmaix5.3.0.0″ gmakeThis ended with the error:In file included from ../gs/base/gp_psync.c:20: /usr/include/pthread.h:582: error: parse error before ‘*’ token /usr/include/pthread.h:585: error: parse error before ‘*’ token /usr/include/pthread.h:589: error: parse error bef
starblue
eclipse exception ibm-midrange iseries-navigator
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?
Patrick Grimard
jpa eclipselink ibm-midrange
I’m using JPA with EclipseLink provider in my application to connect to an AS400. I have one entity WebRequest which has a @OneToOne relationship to my RateQuote entity. A WebRequest life cycle starts off with it’s RateQuote property being null until the user processes the WebRequest and generates a RateQuote. What I’m trying to achieve is rather than insert null, insert 0 since the underlying field is DECIMAL(7,0) in the WebRequest table.On our AS400 (V6R1), we have the WRKDBF utility for vi
Tarquila
ibm-midrange rpgle rpg
I’m looking for a numeric type in ILE RPG which will “wrap round” when it overflows, in a similar way to how a C int would. Is there such a thing?
jax
java ibm-midrange rpgle rpg
I have made a java program that creates PDF files based to GnuPdf. It runs perfectly when run using native java code (on windows or iSeries QSH), however, when run through an RPGLE interface, the program crashes (at what seems like random intervals) when processing images. I tracked down one of these down to loading an image from a .jar file and removed the call from the code. It worked for a while but is now crashing for images loaded from IFS. Maybe RPGLE is locking the files somehow, and
Clockwork-Muse
c# datetime time db2 ibm-midrange
I am working through an issue here. I have a C#.NET application that is uploading data to the i. In one application, I have the file defined as DDS (old habits don’t die) with a time field. In this new application, I am using DDL to create the file and it also has a time field. I have basically copied and pasted the line from the working application to the new application and still doesn’t work. The only difference I can see is DDS vs. DDL. Is anyone able to confirm there is some sort of differe
Eugene M
stored-procedures ibm-midrange rpgle
I am trying to create an external stored procedure on an IBM i (V5R4), but I’m getting an error when I try to run it.All I want to do is call an RPG program, without passing any parameters or worrying about returning any data. Sorry, I’m not an RPG programmer or an expert on IBM i, so I could be missing something very simple.The SQL to create the procedure:CREATE PROCEDURE SOMELIB.SOMEPROC ( ) LANGUAGE RPGLE NOT DETERMINISTIC NO SQLEXTERNAL NAME ‘OTHERLIB/SOMERG’ PARAMETER STYLE GENERAL;The erro
ysrb
c# db2 database-connection connection-string ibm-midrange
I am trying to connect to DB2 using the following connection string:<add name=”ConnectionString” providerName=”IBM.Data.DB2.iSeries” connectionString=”Data Source=xxxxxxx,1234;UserID=username;Password=password;”/>And it seems that if I specify the port (1234) it throws an error: CWBCO1004 – Remote address could not be resolved 11001 A communication error occurred.If I didn’t specify the port it throws (expectedly):Unhandled Exception: IBM.Data.DB2.iSeries.iDB2ConnectionTimeoutException: Th
ADAM MARSHALL
sql db2 sql-update ibm-midrange
Im trying to update a field in a table from another field in a different table. The table being updated will have multiple records that need updating from 1 match in the other table. Example, i have a 1 million row sales history file. Those million records have aproximately 40,000 different sku codes, each row has a date and time stamp. Each sku will have multiple records in there. I added a new field called MATCOST (material cost).I have a second table containing SKU and the MATCOST. So i want
danielrvt
php db2 ibm-midrange wampserver
I have been trying to connect to a ibm db2 database but it seems impposible. The as400 is in a different server than the one running php.Everytime I do a db2_connect I get the following error:Fatal error: Call to undefined function db2_connect()How can I make this function work?Tip: I’ve already tried with odbc and it was a lost of time, but I’m open to suggestions on that path as well.[EDIT]I finally changed to java… it was impossible with php…
Prasanna K Rao
java ibm-midrange jce java1.4
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:=====================================================import java.security.InvalidKeyException; import java.security.NoSuchAlgorithmException; import java.security.Security; import java.securit
Jason Plank
db2 ibm-midrange db2400
I want to drop a column called id which is an auto incrementing PK.The SQL: alter table “CO88GT”.”XGLCTL” drop column id cascade;And I get:Error: [SQL0952] Processing of the SQL statement ended. Reason code 10.SQLState: 57014ErrorCode: -952I could be wrong but I think it has something to do with preventing the table from losing data. To get around this issue I need to create a new table without the column and copy the data from the old table into the new table and then replace the old table w
skaffman
java ibm-midrange
I have a simple java program(using jtopen) to connect to an iSeries and open a IFS file:-System.out.println(“by ipaddress”);AS400 as400 = new AS400(“130.3.3.333”, “user”, “password”);System.out.println(“as400 connected? = ” + as400.getCcsid());//handle the exception if the file is null IFSFileInputStream as400File = new IFSFileInputStream(as400, “//PDF//00000104.PDF”);System.out.println(“is available” + as400File.getPath());as400File.close();On one server in DMZ) everything works fine but on an
Web site is in building