Sample code for using IBM's PCOMM in C# o write an as400 screenscraper
Has anybody used C# to write a sample screen scraper for IBM as400? ...
iseries
Setting a key field on a view
I am creating an SQL view for a file that strips out the spaces in a particular field. My question is if there is a why to set a key on that new view so a person can still CHAIN the file. We are on V5R3. ...
Weird Output on SQL REPLACE
I am using REPLACE in an SQL view to remove the spaces from a property number. The function is setup like this REPLACE(pin, ' ', ''). On the green-screen the query looked fine. In anything else we get the hex values of the characters in the field. I am sure it is an encoding thing, but how do I fix it? Here is the statement I used to cr...
Retrieving an Record Problem
Okay, that may not be the best subject... I am setting up an approval workflow within an application. I pass the username and the dollar amount to the subprocedure and figure out what workflow I need to use for the approval process. I thought I had this working until I try to handle the condition when the user hasn't been setup. So in ...
Source Control on the IBM i (iSeries)
On the web side we are working on getting source control. Now, I want to see what can be done for the iSeries side. What is your favorite source control application for iSeries and why? I am looking for low-cost if possible. ...
iSeries Export to CSV
Is there an iSeries command to export the data in a table to CSV format? I know about the Windows utilities, but since this needs to be run automatically I need to run this from a CL program. ...
php + unixODBC + DB2 + DESCRIBE = token not valid?
Code I'm trying to run: $query = "DESCRIBE TABLE TABLENAME"; $result = odbc_exec($h, $query); The result: PHP Warning: odbc_exec(): SQL error: [unixODBC][IBM][iSeries Access ODBC Driver][DB2 UDB]SQL0104 - Token TABLENAME was not valid. Valid tokens: INTO., SQL state 37000 in SQLExecDirect in ... There were no other problems with S...
iSeries SQL Procedure - Check if already exists
I have an script that falls over if any of the procedures it is trying to create already exists. How can I check/drop if this procedure is already created? ...
Setting Format for Query Defined Field
I have the following query in iSeries SQL which I output to a file. SELECT SSLOTMAK, SSLOTMDL, SSLOTYER, sum(SSCOUNT) FROM prqhdrss GROUP BY SSLOTMAK, SSLOTMDL, SSLotyer HAVING sum(SSCOUNT) > 4 ORDER BY SSLOTMAK, SSLOTMDL, SSLOTYER When I run it, the field created be the sum(SSCOUNT) is a 31 Packed f...
Accessing RPG on iSeries from Java
Has anyone had good experiences of talking direct to RPG programs running on a V5R4 iSeries machine from Java? If so, what are the recommendations of the community, and what pitfalls should I try to avoid? From the various pieces of literature and spike solutions I have attempted it looks as though we can use ProgramCallBeans (either th...
Encrypt on iSeries
What tools are available to encrypt or password-protect a file stored on the IFS? *integrated file-system, accessible from Windows ...
Data structure definitions / templates in RPG(LE)
Say I have a data structure, such as d dog DS qualified d name 20 d breed 20 d birthdate 8 0 I can then define d poochie likeds(dog) and use poochie.name, etc. But can I just set up the 'dog' as a template w...
iSeries - Call SQL stored procedure from CL program
How can I run a stored procedure from a CL program? RUNSQLSTM requires a source member, but I just want to build a command so users can pass in variables easily, so this won't work. ...
XML and iSeries RPGLE - development tools?
I've got a iSeries to .Net compact framework project. It includes rgple programs exposed as web services and a Windows mobile app that uses the webservices. Each iSeries program has a specific webservice wrapper and the .net app reference each. I would like to come up with a more generic messaging service using XML. I am fairly fami...
Port 443 on iSeries v5r4 is ‘filtered’ to internet clients, even it is allowed in firewall rules. How can I make it ‘open’? Can it be i5/OS bug? [SOLVED]
Port was fitered by ISP. The problem is that HTTPS 443 port isn't accessible from internet, but it is open in our local network. Our iSeries v5r4 is connected to inet via L2TP withot IPSec. If no packet filters are active, nmap shows that ports 25, 80, 110 and even 10322 (WAS admin console) have state 'open' on internet ip address. 443 ...
Mail from iSeries with attachment
Is there a way to send an email from an iSeries terminal, adding an attachment from the IFS? I know how to send a normal email using the SNDDST utility. ...
Execute DB2 iSeries Stored Procedure from a SQL 2005 Linked Server
I am trying to execute a stored procedured from a linked database in MS SQL 2005. The linked database is a db2 database on a iseries server. I am using the iSeries IBMDASQL service provider. I am able to query the stored procedure without problems using a simple vbscript and ado. When I try to execute the same stored procedure in que...
List of source members in a file with SQL
Is it possible to generate a list of all source members within an iSeries source file using SQL? Might be similar to getting table definitions from SYSTABLES and SYSCOLUMNS, but I'm unable to find anything so far. ...
XML Webservice for iSeries
I need to pull item quantity from a DB2 database from an aspx page and then update after the quantity has been changed. I want to create a web service that will send XML data and then parse back to my page. Looking for any good references or examples that anyone has possibly tried. ...
Connect to iSeries with OdbcConnection: password prompting
Hello, I want to connect to DB using the iSeries Client Access driver. I use the following connection string: DRIVER=Client Access ODBC Driver (32-bit);QUERYTIMEOUT=0;PKG=QGPL/DEFAULT(IBM),2,0,1,0,512;LANGUAGEID=ENU;DFTPKGLIB=QGPL;DBQ=QGPL XXXXXXXX;SYSTEM=XXX.XXXXXXX.XXX;Signon=2 I get an exception when connecting: ERROR [28000] [IB...