Hi, We now have this working after speaking with our support vendor (who in turn contacted Rocket).
Regards, Louise Blair -----Original Message----- From: Louise Blair (DHL GB) Sent: 20 January 2010 10:51 To: 'U2 Users List' Cc: Linda Christie (DHL UK); Yvonne Mowbray (DHL UK); William Pitt (DHL UK) Subject: @TMP file Good Morning, We are in the process of migrating from Current Future Sun Solaris 2.6 (SunOS 5.6) Sun Solaris 10 Universe 9.5.2.1 Universe 10.3.3 And have come across a problem with our subroutine which returns data to our Web Server. The problem is that we are using the @TMP virtual file and passing back 25 values rather than the documented maximum of 23. We do have it working on our current server however, we don't have documented how we managed to do this in the past. Would anyone have any information on what it is we need to do to allow the 25 values to be passed back. Example of the code being executed is as below: SELECT CONSIGNMENT.LIST TO 9 ST = SQLExecDirect(@HSTMT,"SELECT F1,F2,F3,F4,F5,F6,F7,F8,F9,F10,F11,F12,F13,F14,F15,F16,F17,F18,F19,F20,F 21,F22,F23,F24,F25 FROM @TMP SLIST 9") All help appreciated. Regards, Louise Blair _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
