Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by WP

  1. WP

    Checksum of FIX message

    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...
  2. WP

    Foreign key with a constant

    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
  3. WP

    Foreign key with a constant

    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...
  4. WP

    RNX1215 error

    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
  5. WP

    RNX1215 error

    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
  6. WP

    Big variables in RPGILE debugger

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

    Big variables in RPGILE debugger

    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...
  8. WP

    ACCESS 2003 on Vista

    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
  9. WP

    PERFORM STATEMENT

    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...
  10. WP

    SQL of file with many members

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

    Embedded SQL

    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
  12. WP

    SQLRPG dynamic SQL

    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...
  13. WP

    Removed Access ...

    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...
  14. WP

    Setting off a range of indicators

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

    Setting off a range of indicators

    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
See more

Part and Inventory Search

Back
Top