Re: [U2] [UV] How to return 'column' from dyn array?
@FM and @AM are one and the same so there is no need for the first line. snip - Original Message - From: Allen E. Elwood (CA) [EMAIL PROTECTED] A.TEMP = CHANGE(A,@FM,@AM) STUFF.YOU.WANT = A.TEMP1,3:@VM:A.TEMP2,3:@VM:A.TEMP3,3 --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] How to return 'column' from dyn array?
-Original Message- From: Ian McGowan [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 18, 2004 7:17 PM To: '[EMAIL PROTECTED]' Subject: RE: [U2] [UV] How to return 'column' from dyn array? From: Barry Brevik [mailto:[EMAIL PROTECTED] Yeah. I'm working on some code I inherited. I was banging my head trying to figure out why the author setup his array 'backwards'. Maybe *I'm* backwards, and that is a legitimate technique, but my brain does not want to go there. I think you're backwards, too :-) Accounts - files - items - attributes - values - subvalues in theory this works great! but...in reality (oh wait, poor choice of word). Say you have array of sales figures. x is the client and ,y is the year, so it's setup like you stated and the dictionary will show all the years for each client. Now..You want to pull an array of all the sales for year,3 That's where a function to grab a column would be nice. otherwise you have to either maintain (2) arrays, one x,y one y,x or use a subroutine (which usually isn't as fast as an intrinisc function). I forget if the FIELDS() method works, and/or why it didn't (if it didn't). I'll have to play with it. (from http://www.jes.com/pb/pb_wp1.html) Is the traditional pick terminology, where the values are multiple instances of some related things (invoice numbers, address lines 1 and 2, etc). If you keep multivalued data together, then you can display it using one dictionary attribute INVOICES, instead of having INVOICE.1, INVOICE.2 etc... Doing it your way round is less idiomatic, imnsho. Ian --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] How to return 'column' from dyn array?
I use this method, when I create files during the night with sales data. I'll create a matrix with columns being years and rows being client data, then write it out to an item. Now during the day, there are no calculation, read in the item and display the numbers. This isn't really an issue, as the transfile that is created during the night, isn't really meant to be listed, but rather as a storage bin for the program to read from. Once it's in this format, it's easier to create reports as well. Usually, the matrix I create is 5-6 dimensional. I do some converting to work with the dimensions beyond char(252)...but again, they weren't meant for human eyes to view. George -Original Message- From: Ian McGowan [mailto:[EMAIL PROTECTED] Sent: Thursday, August 19, 2004 11:38 AM To: '[EMAIL PROTECTED]' Subject: RE: [U2] [UV] How to return 'column' from dyn array? Accounts - files - items - attributes - values - subvalues in theory this works great! but...in reality (oh wait, poor choice of word). Say you have array of sales figures. x is the client and ,y is the year, so it's setup like you stated and the dictionary will show all the years for each client. Now..You want to pull an array of all the sales for year,3 That's where a function to grab a column would be nice. It's a bad idea to put the client info in an attribute - it should go in its own item :-) The only reason to structure things this way, rather than the way Barry originally had it, is so access or uniquery or whatever can deal with the data naturally - in basic there isn't much of a difference... Ian --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] How to return 'column' from dyn array?
Ah, I had it confused with @FM which is seq 251 I've never actually seen it in the @FM form before, and my guess is probably never again.:) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jerry Banker Subject: Re: [U2] [UV] How to return 'column' from dyn array? @FM and @AM are one and the same so there is no need for the first line. snip --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] How to return 'column' from dyn array?
@FM is 254 isn't it.. IM = 251 SM = 252 VM = 253 FM = 254 From: [EMAIL PROTECTED] on behalf of Allen E. Elwood (CA) Sent: Thu 19/08/2004 19:23 To: [EMAIL PROTECTED] Subject: RE: [U2] [UV] How to return 'column' from dyn array? Ah, I had it confused with @FM which is seq 251 I've never actually seen it in the @FM form before, and my guess is probably never again.:) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jerry Banker Subject: Re: [U2] [UV] How to return 'column' from dyn array? @FM and @AM are one and the same so there is no need for the first line. snip --- u2-users mailing list [EMAIL PROTECTED] 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. [demime 1.01d removed an attachment of type application/ms-tnef which had a name of winmail.dat] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] How to return 'column' from dyn array?
Did you ever have one of those days? I'm having one of them today.sigh. I *meant* to say: Ah, I had it confused with @TM which is seq 251 All the documentation I've seen before refers to TM, SVM, VM and AM. I've never seen FM before except on the radio.:) Is this the Universe method of notation? I've only worked with native pick and U2. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Adrian Matthews Sent: Thursday, August 19, 2004 13:03 To: [EMAIL PROTECTED] Subject: RE: [U2] [UV] How to return 'column' from dyn array? @FM is 254 isn't it.. IM = 251 SM = 252 VM = 253 FM = 254 snip --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] How to return 'column' from dyn array?
Allen, From what I've seen in UV literature, they tend to officially call CHAR(253) @FM for field mark, but use @AM attribute mark for compatibility with other PICK-like implementations. --Ron P. -Original Message- From: Allen E. Elwood (CA) [mailto:[EMAIL PROTECTED] Sent: Thursday, August 19, 2004 4:28 PM To: [EMAIL PROTECTED] Subject: RE: [U2] [UV] How to return 'column' from dyn array? snip All the documentation I've seen before refers to TM, SVM, VM and AM. I've never seen FM before except on the radio.:) Is this the Universe method of notation? I've only worked with native pick and U2. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] How to return 'column' from dyn array?
Being PI and UV only for years, seeing AM in an AP system confused the hell out of me. VM and FM are the ones for me. Couldn't squeeze any more two letter acronymns in there! From: [EMAIL PROTECTED] on behalf of Pingilley, Ron Sent: Thu 19/08/2004 22:51 To: '[EMAIL PROTECTED]' Subject: RE: [U2] [UV] How to return 'column' from dyn array? Allen, From what I've seen in UV literature, they tend to officially call CHAR(253) @FM for field mark, but use @AM attribute mark for compatibility with other PICK-like implementations. --Ron P. -Original Message- From: Allen E. Elwood (CA) [mailto:[EMAIL PROTECTED] Sent: Thursday, August 19, 2004 4:28 PM To: [EMAIL PROTECTED] Subject: RE: [U2] [UV] How to return 'column' from dyn array? snip All the documentation I've seen before refers to TM, SVM, VM and AM. I've never seen FM before except on the radio.:) Is this the Universe method of notation? I've only worked with native pick and U2. --- u2-users mailing list [EMAIL PROTECTED] 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. [demime 1.01d removed an attachment of type application/ms-tnef which had a name of winmail.dat] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] How to return 'column' from dyn array?
no. But, if you set up your dyn array backwards, then it works. That is 10 @vm 11 @vm 12 @fm 20 @vm 21 @vm 22 @fm 30 @vm 31 @vm 32 Now 1=col 1 2=col 2 So instead of filling it in as row, col fill it in as col,row OR subroutine get.column(var.in,var.out,col.no) * var.out= uu=dcount(var.in,char(253)) for t=1 to uu var.outt=var.int,col.no next t return stop end -Original Message- From: Barry Brevik [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 18, 2004 4:41 PM To: U2-users (E-mail) Subject: [U2] [UV] How to return 'column' from dyn array? I just realized that there seems to be no function for the following situation. Given the dynamic array: 10 @vm 20 @vm 30 @FM 11 @vm 21 @vm 31 @FM 12 @vm 22 @vm 32 ...I look at this as the fields being records, or rows, and the values being columns. I'd like a function that returns a dynamic array of just column 3, that is '30', '31' and '32'. Am I making sense? Is there something in UV basic that does this? Barry --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] How to return 'column' from dyn array?
Just a thought; does FIELDS work? I doubt that version 1 will work, but version 2 certainly will. Version 1 FIELDS(dynarray, @VM, 3, 1) Version 2 FIELDS(CONVERT(@VM,|,dynarray), |, 3, 1) - Original Message - From: Barry Brevik [EMAIL PROTECTED] Date: Wed, 18 Aug 2004 13:40:54 -0700 To: U2-users (E-mail) [EMAIL PROTECTED] Subject: [U2] [UV] How to return 'column' from dyn array? I just realized that there seems to be no function for the following situation. Given the dynamic array: 10 @vm 20 @vm 30 @FM 11 @vm 21 @vm 31 @FM 12 @vm 22 @vm 32 ...I look at this as the fields being records, or rows, and the values being columns. I'd like a function that returns a dynamic array of just column 3, that is '30', '31' and '32'. Am I making sense? Is there something in UV basic that does this? Barry --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] How to return 'column' from dyn array?
Assuming that the array was called A: A.TEMP = CHANGE(A,@FM,@AM) STUFF.YOU.WANT = A.TEMP1,3:@VM:A.TEMP2,3:@VM:A.TEMP3,3 Should work! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Barry Brevik Sent: Wednesday, August 18, 2004 13:41 To: U2-users (E-mail) Subject: [U2] [UV] How to return 'column' from dyn array? I just realized that there seems to be no function for the following situation. Given the dynamic array: 10 @vm 20 @vm 30 @FM 11 @vm 21 @vm 31 @FM 12 @vm 22 @vm 32 ...I look at this as the fields being records, or rows, and the values being columns. I'd like a function that returns a dynamic array of just column 3, that is '30', '31' and '32'. Am I making sense? Is there something in UV basic that does this? Barry --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] How to return 'column' from dyn array?
From: Barry Brevik [mailto:[EMAIL PROTECTED] Yeah. I'm working on some code I inherited. I was banging my head trying to figure out why the author setup his array 'backwards'. Maybe *I'm* backwards, and that is a legitimate technique, but my brain does not want to go there. I think you're backwards, too :-) Accounts - files - items - attributes - values - subvalues (from http://www.jes.com/pb/pb_wp1.html) Is the traditional pick terminology, where the values are multiple instances of some related things (invoice numbers, address lines 1 and 2, etc). If you keep multivalued data together, then you can display it using one dictionary attribute INVOICES, instead of having INVOICE.1, INVOICE.2 etc... Doing it your way round is less idiomatic, imnsho. Ian --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
