Recent content by WP

Hi, Has anyone got sample RPG code that works out the checksum of a string? What code should do: - take the FIX message stream (string) - loop through each byte (character): 1) determine the integer value of that byte (e.g. 'A'=65, 'a'=97, '.'=46, note will be <= 256) 2) accumulate...

Well ... alter table ExchangeMap add constraint FK_EXC foreign key (issuer,value) references OSMEXC ('MIC',EXCID); didn't work but I wasn't sure if there was new syntax for using a constant instead of a field WP http://www.neptune400.com

I have two tables with data ... Exchange EXCID DESCRIPTION XLON London XMAD Madrid ExchangeMap CODEID MAPID ISSUER NAME 100 55 REUTERS L 101 55 MIC XLON 103 56 REUTERS MA 104 56 MIC I'd like to show the relationship between the two...

Thanks guys. Much appreciated. Been a while since I had to do this stuff. Yeah I'm trying to open an open file but I guess the real issue is why is being left open! 3 programs down the stack and two service programs ... it's been a long debugging day. W WP http://www.neptune400.com

I'm getting an RNX1215 error in a UAT system and I can't get access to the box to debug it!! Anyone know what this error alludes to? W WP http://www.neptune400.com

Thanks! WP http://www.neptune400.com

Hi, I have an MQ put program that has a message field(MsgData) size 4000A. When I debug and view I only see the 1st 1024 chars. Is there a way to configure the debugger to show all the data in the field. Also on the MQ Q I can only view 1024 can this be changed? I know the message is bigger...

Hi, I installed Access 2003 on my new Vista PC. It csme up with a security message to block malicooud stuff and I duly answered with yes... Now none of my code runs! I read that Jet4 SP8 fixes this but this patch is not for Vista. Any ideas what I need to do? W WP http://www.neptune400.com

I have a function CREATE OR REPLACE FUNCTION rules_broken(ordref bigint) RETURNS character varying AS DECLARE rules RECORD; rulesbroken character varying; ordsource character varying; BEGIN FOR rules IN SELECT rul_id,rul_sql FROM sd_stp_rules ORDER BY rul_id LOOP...

Is it possible to select a specific member when querying a file in SQL/400? WP http://www.neptune400.com

Hi, Does anyone know if I can get to the completion details of an embedded delete statement? e.g. 300 record deleted. I am writing a purge program that has parameters Lib, file and where clause and I want write an advice record of the deletion. W. WP http://www.neptune400.com

Is this possible ... I want to purge a load of files and have their names in a table. I have to use SQL because some are selective purges. Anyway I want I have ... 0129.01 C PRGALL BegSR 0136.00...

Hi, I have an Excel form that uses a calendar control to select dates. The IT people have decided to save money by removing Access from my box. Now my calendar has gone! Any ideas how I can get it back withouth installing Access. Also does the calendar control belong to Access? W. WP...

cool yes 61-70 ... wonderful. Mnay thanks WP http://www.neptune400.com

Anyone have the one line piece of code that sets off say 10 indicators at once e.g. 61-71 WP http://www.neptune400.com