Search results for query: *

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

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

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

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

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

Anyone know of a tool that will allow me to generate scripts from an existing MQ manager and its objects ? WP http://www.neptune400.com

hi, I have a message file in my dev env and have added a new msgid to it. Now I want to deliver the program and the new msgid. However I cant deleiver the msgf as the UAT one may be contain messages not in the one in my dev env. Is there a way yo programatically add msgid to a msgf? w. WP...

Hi I have a problem where the .text value of a combo box will not change unless the item is selected from the list. The combo box is of type dropdown. Ideally I'd like to select the item in the list as the user enters the string in the combo box. I can't make the combo box a dropdownlist as...

I have 7 tabs and currently have code that that removes 4 tabs conditionally. If Not _server.User.ConfigAccess Then mainTab.TabPages.Remove(exchangeTab) mainTab.TabPages.Remove(tabBrokers) mainTab.TabPages.Remove(routeTab)...

hi, I have the following packaged function / view scenario that I'm hoping to improve the performance. CREATE OR REPLACE PACKAGE Pkg_Sub_Time AS FUNCTION CHGDATM(ts TIMESTAMP) RETURN TIMESTAMP; END Pkg_Order_Archive; / CREATE OR REPLACE PACKAGE BODY Pkg_Sub_Time AS FUNCTION...

Hi, Anyone have some code to stop my app bombing when the tester presses Ctrl C. Cant see the user doing this but it now a major defect :( WP http://www.neptune400.com

Hi, I have a SOAP call that fails and would like to get to the message being returned. This message resides in the exception object (ex) : ex system.xmlElenment Detail InnerText Does anyone know how to get at this from the vb.net code. The properties and...

Hi, I am trying to migrate data over the OTG from DB2. Some of my table have fields that contain SQL strings and the OTG is not coping with this. e.g. sample record OSMUSRFAV FAVUSR='PATONWI' FAVNAM='EXECUTED ORDERS' FAVSQL='SELECT * FROM OSMORD WHERE ORDSTAT='EXECUTED'' FAVSRT='ORDREF DESC'...

hi, I am migrating data and have the problem that the host has no ref integrity. Resulting in my script failing with ORA-00001: unique constraint (OMCOD.PK_OSMORUL) violated. Does anyone know how I can ignore the failed inserts and continue? declare cursor ORRCD IS SELECT ORORDREF, ORRULCD...