RE: [U2] UV: Select statement problem
Are the DATE.FORMAT settings the same on both machines? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Schalk van Zyl Sent: 13 January 2005 07:13 To: u2-users@listserver.u2ug.org Subject: Re: [U2] UV: Select statement problem Any active Index? Indices up to date on both boxes? Schalk van Zyl On Wed, 12 Jan 2005 13:45:13 -0500, Dianne Ackerman [EMAIL PROTECTED] wrote: Is it possible that the UV accounts you're running on are different flavors? SELECTs in different flavors definitely work differently. -Dianne [EMAIL PROTECTED] wrote: I have come across a problem with select statements behaving differently between my two RISC boxes. I have two RS6000 machines : one for production and the other for development. Both UV 10.0.14 and AIX 5.2 While testing a program change on the development box, I came across a situation where a SELECT statement gave me different results when compared to production. To get around this, I had to break up the SELECT statement into two parts. My question is: Is there a setting somewhere that is not in synch between production and development machines that could cause this. If so, what? Please accept the fact that the contents of the SELECT statement are good (I'd rather not explain the definitions of the dictionary items or the contents of the phrase PHRASE 0117: STATEMENT = 'SELECT DB.PSES WITH SUB.ID = ':ACTUAL.ID:' AND WITH TRANS.DT = AND WITH ISSUE.DT = ':ISSUE.DT:' AND WITH ACCOUNT # 600 AND WITH ACCOUNT # 506 AND WITH @ID UNLIKE DEL... ':PHRASE 0118: STATEMENT:[EMAIL PROTECTED]:SAVE.LIST PSES.TAPE.:ISSUE.DT:.:SUB.ID 0119: EXECUTE STATEMENT 0 record(s) selected to SELECT list #0. 0 record(s) SAVEd to SELECT list PSES.TAPE.03/31/02.M. This does work: 0117: STATEMENT = 'SELECT DB.PSES WITH SUB.ID = ':ACTUAL.ID:' AND WITH TRANS.DT = AND WITH ISSUE.DT = ':ISSUE.DT:'' 0118: STATEMENT:[EMAIL PROTECTED]:'SELECT DB.PSES WITH ACCOUNT # 600 AND WITH ACCOUNT # 506 AND WITH @ID UNLIKE DEL... ':PHRASE:' SELECT.ONLY' 0119: STATEMENT:[EMAIL PROTECTED]:SAVE.LIST PSES.TAPE.:ISSUE.DT:.:SUB.ID 0120: EXECUTE STATEMENT 265 record(s) selected to SELECT list #0. 265 record(s) selected to SELECT list #0. 265 record(s) SAVEd to SELECT list PSES.TAPE.03/31/02.M. On my production machine, the first statement works and yields the same results as the second statement from development Thanks Jim --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Schalk van Zyl - GWK BEPERK/LIMITED (REG: 1997/022252/06) POSBUS 47 PO BOX 8730 DOUGLAS Direkteure/Directors: NB Jacobs, FJ Lawrence, J v/d S Botes, JH Coetzee, JGD Smit, JF Jacobs, AO M|ller, JW Smit, WG M|lke, JG Stander, JH van Dyk(MD/BD), JG Jacobs, A M|ller, M van Zyl, Sekr/Secr: E van Niekerk. Hierdie e-pos is onderworpe aan 'n vrywaring beskikbaar by: http://www.gwk.co.za/DisclaimerVrywaring.asp This e-mail is subjected to the disclaimer that can be viewed at: http://www.gwk.co.za/DisclaimerVrywaring.asp --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV: Select statement problem
Isn't there a setting for command line statement length? Seems like I remember something about that but I don't get into the setup of systems often enough to be sure. BobW --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV: Select statement problem
I've executed some pretty long lines, never had a problem. But then again, I've never really tried and really long lines, just pretty long ones. George -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Bob Woodward Sent: Wednesday, January 12, 2005 12:51 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UV: Select statement problem Isn't there a setting for command line statement length? Seems like I remember something about that but I don't get into the setup of systems often enough to be sure. BobW --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UV: Select statement problem
Is it possible that the UV accounts you're running on are different flavors? SELECTs in different flavors definitely work differently. -Dianne [EMAIL PROTECTED] wrote: I have come across a problem with select statements behaving differently between my two RISC boxes. I have two RS6000 machines : one for production and the other for development. Both UV 10.0.14 and AIX 5.2 While testing a program change on the development box, I came across a situation where a SELECT statement gave me different results when compared to production. To get around this, I had to break up the SELECT statement into two parts. My question is: Is there a setting somewhere that is not in synch between production and development machines that could cause this. If so, what? Please accept the fact that the contents of the SELECT statement are good (I'd rather not explain the definitions of the dictionary items or the contents of the phrase PHRASE 0117: STATEMENT = 'SELECT DB.PSES WITH SUB.ID = ':ACTUAL.ID:' AND WITH TRANS.DT = AND WITH ISSUE.DT = ':ISSUE.DT:' AND WITH ACCOUNT # 600 AND WITH ACCOUNT # 506 AND WITH @ID UNLIKE DEL... ':PHRASE 0118: STATEMENT:[EMAIL PROTECTED]:SAVE.LIST PSES.TAPE.:ISSUE.DT:.:SUB.ID 0119: EXECUTE STATEMENT 0 record(s) selected to SELECT list #0. 0 record(s) SAVEd to SELECT list PSES.TAPE.03/31/02.M. This does work: 0117: STATEMENT = 'SELECT DB.PSES WITH SUB.ID = ':ACTUAL.ID:' AND WITH TRANS.DT = AND WITH ISSUE.DT = ':ISSUE.DT:'' 0118: STATEMENT:[EMAIL PROTECTED]:'SELECT DB.PSES WITH ACCOUNT # 600 AND WITH ACCOUNT # 506 AND WITH @ID UNLIKE DEL... ':PHRASE:' SELECT.ONLY' 0119: STATEMENT:[EMAIL PROTECTED]:SAVE.LIST PSES.TAPE.:ISSUE.DT:.:SUB.ID 0120: EXECUTE STATEMENT 265 record(s) selected to SELECT list #0. 265 record(s) selected to SELECT list #0. 265 record(s) SAVEd to SELECT list PSES.TAPE.03/31/02.M. On my production machine, the first statement works and yields the same results as the second statement from development Thanks Jim --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UV: Select statement problem
Any active Index? Indices up to date on both boxes? Schalk van Zyl On Wed, 12 Jan 2005 13:45:13 -0500, Dianne Ackerman [EMAIL PROTECTED] wrote: Is it possible that the UV accounts you're running on are different flavors? SELECTs in different flavors definitely work differently. -Dianne [EMAIL PROTECTED] wrote: I have come across a problem with select statements behaving differently between my two RISC boxes. I have two RS6000 machines : one for production and the other for development. Both UV 10.0.14 and AIX 5.2 While testing a program change on the development box, I came across a situation where a SELECT statement gave me different results when compared to production. To get around this, I had to break up the SELECT statement into two parts. My question is: Is there a setting somewhere that is not in synch between production and development machines that could cause this. If so, what? Please accept the fact that the contents of the SELECT statement are good (I'd rather not explain the definitions of the dictionary items or the contents of the phrase PHRASE 0117: STATEMENT = 'SELECT DB.PSES WITH SUB.ID = ':ACTUAL.ID:' AND WITH TRANS.DT = AND WITH ISSUE.DT = ':ISSUE.DT:' AND WITH ACCOUNT # 600 AND WITH ACCOUNT # 506 AND WITH @ID UNLIKE DEL... ':PHRASE 0118: STATEMENT:[EMAIL PROTECTED]:SAVE.LIST PSES.TAPE.:ISSUE.DT:.:SUB.ID 0119: EXECUTE STATEMENT 0 record(s) selected to SELECT list #0. 0 record(s) SAVEd to SELECT list PSES.TAPE.03/31/02.M. This does work: 0117: STATEMENT = 'SELECT DB.PSES WITH SUB.ID = ':ACTUAL.ID:' AND WITH TRANS.DT = AND WITH ISSUE.DT = ':ISSUE.DT:'' 0118: STATEMENT:[EMAIL PROTECTED]:'SELECT DB.PSES WITH ACCOUNT # 600 AND WITH ACCOUNT # 506 AND WITH @ID UNLIKE DEL... ':PHRASE:' SELECT.ONLY' 0119: STATEMENT:[EMAIL PROTECTED]:SAVE.LIST PSES.TAPE.:ISSUE.DT:.:SUB.ID 0120: EXECUTE STATEMENT 265 record(s) selected to SELECT list #0. 265 record(s) selected to SELECT list #0. 265 record(s) SAVEd to SELECT list PSES.TAPE.03/31/02.M. On my production machine, the first statement works and yields the same results as the second statement from development Thanks Jim --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Schalk van Zyl - GWK BEPERK/LIMITED (REG: 1997/022252/06) POSBUS 47 PO BOX 8730 DOUGLAS Direkteure/Directors: NB Jacobs, FJ Lawrence, J v/d S Botes, JH Coetzee, JGD Smit, JF Jacobs, AO M|ller, JW Smit, WG M|lke, JG Stander, JH van Dyk(MD/BD), JG Jacobs, A M|ller, M van Zyl, Sekr/Secr: E van Niekerk. Hierdie e-pos is onderworpe aan 'n vrywaring beskikbaar by: http://www.gwk.co.za/DisclaimerVrywaring.asp This e-mail is subjected to the disclaimer that can be viewed at: http://www.gwk.co.za/DisclaimerVrywaring.asp --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/