Has anyone successfully used ADO with the IBMDA400 provider to add new entries to a keyed data queue? I can't do it! I'm getting the format of the queue from a vendor supplied RPG program. I have tons of questions (in no particular order). The AddNew method of the rs uses 2 variant arrays - one for field names and one for field values. Do the strings have to be fixed-length or just simple variable length string? What about fields defined as NUMERIC - does the array value get defined with native VB numeric types (Integer, Long). What about the key field itself? Does it have to be defined as the first field in the OPEN DATAQUEUE statement? When I look at the queue via DSPDTAQ, the entries look funky (sometimes it looks like I have two queue entries from one AddNew; sometimes the leading bytes of the entry are blank!) Sorry, but I'm an AS/400 newbie. Any help would be greatly appreciated. Regards ... Mike

Reply With Quote