RE: [U2] -ve INDEX,OCONV
Hi Sanjeeb - as Phil states these are simple questions - I think it worries some people that you may be coding systems with little knowledge. This is not just a programming language it is a whole DBMS and application environment. The answer to the -1 question is that it appends to the dynamic array. However care must be taken as depending on type and setup of u2 system a null value will not be appended. The conversion code d2/ means the year is in 2 digits and that the date is / delimited i.e. dd/mm/yy or mm/dd/yy depending on your DATE.FORMAT settings. There are a whole host of conversion codes documented in the U2 documentation. As suggested, I would recommend some form of training as well ! Regards Symeon. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of phil walker Sent: 19 March 2007 19:57 To: u2-users@listserver.u2ug.org Subject: RE: [U2] -ve INDEX,OCONV Hi Sanjeeb, If you have not already attended the base U2 training courses I would suggest that you convince your employers to arrange for you to do so. To be able to offer outsourcing to a company using U2 it is usually necessary for the outsourcing companies staff to be conversant in the environment. There are a couple of people on this list, most notably Ray Wurlod and Brian Leach who offer training. As do IBM. Most of these simple questions would be able to be answered in that forum and then you would be able to fully support your clients. Regards, Phil -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sanjeebkumar Sarangi Sent: Tuesday, 20 March 2007 6:01 a.m. To: u2-users@listserver.u2ug.org Subject: [U2] -ve INDEX,OCONV Hi, What does a negative index mean in an array .If LIST-1=ID is a segment of the code what does this -ve number mean is it by default the first element. If we do a external conversion usng OCONV(sysdate,'D2/'),the D indicates the date conversion specification but why is the 2/ being used here...what can be the change in the conversion? Thanks Sanjeeb =-=-= Notice: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the message and any attachments. Thank you --- 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] -ve INDEX,OCONV
There is always the self taught method as well. I read Jonathan Sisk's PICK basic book 19 years ago and learn PICK while slaving for the man who would *NOT* pay for me to convert my DG Business basic skills to PICK basic. http://www.databasecorner.com/resource,1962.aspx This is not an [AD], but a recommendation to Sanjeebkumar so he can get his own answers and progress more rapidly. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of phil walker Sent: Monday, March 19, 2007 12:57 To: u2-users@listserver.u2ug.org Subject: RE: [U2] -ve INDEX,OCONV Hi Sanjeeb, If you have not already attended the base U2 training courses I would suggest that you convince your employers to arrange for you to do so. To be able to offer outsourcing to a company using U2 it is usually necessary for the outsourcing companies staff to be conversant in the environment. There are a couple of people on this list, most notably Ray Wurlod and Brian Leach who offer training. As do IBM. Most of these simple questions would be able to be answered in that forum and then you would be able to fully support your clients. Regards, Phil -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sanjeebkumar Sarangi Sent: Tuesday, 20 March 2007 6:01 a.m. To: u2-users@listserver.u2ug.org Subject: [U2] -ve INDEX,OCONV Hi, What does a negative index mean in an array .If LIST-1=ID is a segment of the code what does this -ve number mean is it by default the first element. If we do a external conversion usng OCONV(sysdate,'D2/'),the D indicates the date conversion specification but why is the 2/ being used here...what can be the change in the conversion? Thanks Sanjeeb =-=-= Notice: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the message and any attachments. Thank you --- 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] -ve INDEX,OCONV
p.s. oops sent the wrong linkdoh And now I find the book is out of print Hey, give me a break it's my 51st birthday, I'm signing off and going to the back room to play some guitar. http://jes.com/picklist.html There are, however, some books that Jonathan mentions here: http://jes.com/picklist.html Breaking News! While cleaning up our warehouse recently, we discovered a cache of some of the titles below. This is a very rare (and final) chance to purchase copies of these books long out of print in brand-new condition, optionally signed by the author, if you desire. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of phil walker Sent: Monday, March 19, 2007 12:57 To: u2-users@listserver.u2ug.org Subject: RE: [U2] -ve INDEX,OCONV Hi Sanjeeb, If you have not already attended the base U2 training courses I would suggest that you convince your employers to arrange for you to do so. To be able to offer outsourcing to a company using U2 it is usually necessary for the outsourcing companies staff to be conversant in the environment. There are a couple of people on this list, most notably Ray Wurlod and Brian Leach who offer training. As do IBM. Most of these simple questions would be able to be answered in that forum and then you would be able to fully support your clients. Regards, Phil -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sanjeebkumar Sarangi Sent: Tuesday, 20 March 2007 6:01 a.m. To: u2-users@listserver.u2ug.org Subject: [U2] -ve INDEX,OCONV Hi, What does a negative index mean in an array .If LIST-1=ID is a segment of the code what does this -ve number mean is it by default the first element. If we do a external conversion usng OCONV(sysdate,'D2/'),the D indicates the date conversion specification but why is the 2/ being used here...what can be the change in the conversion? Thanks Sanjeeb =-=-= Notice: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the message and any attachments. Thank you --- 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] -ve INDEX,OCONV
I may be wrong but I don't think that Sanjeeb wants to learn anything more than what is necessary to export data from a U2 system as part of a system migration. This is an effort to get off of a U2 system, not embrace it. [snip] Hi Sanjeeb - as Phil states these are simple questions - I think it worries some people that you may be coding systems with little knowledge. This is not just a programming language it is a whole DBMS and application environment. [/snip] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] -ve INDEX,OCONV
Hi Negative number: This is used to append a new element to an array: Array-1 = NewValue is the same as: ArrayDCount(Array,@FM)+1 = NewValue There is a note of caution: if NewValue is empty, it may not add a new marker character depending on the compiler options in force. For example: Array = NewValue = Array-1 = NewValue Array-1 = NewValue Array-1 = last If $OPTIONS EXTRA.DELIM is in force, this will create 3 fields. If not, there will just be one field. Date Conversion There are reams of possible date conversions for different formats. This one means Date Use a / as the delimiter between day, month and year Use a two digit year. For full details, type HELP CONV D. There are too many to list here :) Brian Hi, What does a negative index mean in an array .If LIST-1=ID is a segment of the code what does this -ve number mean is it by default the first element. If we do a external conversion usng OCONV(sysdate,'D2/'),the D indicates the date conversion specification but why is the 2/ being used here...what can be the change in the conversion? Thanks Sanjeeb =-=-= Notice: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the message and any attachments. Thank you --- 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] -ve INDEX,OCONV
Sanjeeb, -1 means add to the end. It forces the system to find the last attribute and create a new one after it. This can be done at any level: Add a new attribute to the end: MySuff.Rec-1 = WOW Add a new multivalue to the end of attribute 4: MySuff.Rec4,-1 = WOW Add a new submultivalue to the end of attribute 2, multivalue 6: MySuff.Rec2,6,-1 = WOW and so on. - Chuck Sanjeebkumar Sarangi wrote: Hi, What does a negative index mean in an array .If LIST-1=ID is a segment of the code what does this -ve number mean is it by default the first element. If we do a external conversion usng OCONV(sysdate,'D2/'),the D indicates the date conversion specification but why is the 2/ being used here...what can be the change in the conversion? Thanks Sanjeeb =-=-= Notice: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the message and any attachments. Thank you --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Charles Barouch ([EMAIL PROTECTED]) www.KeyAlly.com (718) 762-3884 x 1 P. O. Box 540957, Queens, NY 11354 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] -ve INDEX,OCONV
The UniVerse BASIC documentation should detail out the OCONV choices -- I know UniData's does -- do you have access to the BASIC documentation? The 2/ means use / as the delimitter (it could be - for example) and make the year 2 digits (it could be 4.) The -1 connotation means 'put as the last element' -- so if the array was already [EMAIL PROTECTED]@amC The -1 = ID would put the value of ID after C with an attribute mark delimitter. SO if ID were F, you'd have [EMAIL PROTECTED]@[EMAIL PROTECTED] I see from your company you guys specialize in Offshore development -- I figured our little corner of the database world would escape offshoring! No such luck I guess! g -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sanjeebkumar Sarangi Sent: Monday, March 19, 2007 8:41 AM To: u2-users@listserver.u2ug.org Subject: [U2] -ve INDEX,OCONV Hi, What does a negative index mean in an array .If LIST-1=ID is a segment of the code what does this -ve number mean is it by default the first element. If we do a external conversion usng OCONV(sysdate,'D2/'),the D indicates the date conversion specification but why is the 2/ being used here...what can be the change in the conversion? Thanks Sanjeeb --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] -ve INDEX,OCONV
Sanjeeb, 'D2/' breaks dow as follows: 'D' for date, '2' for two digit year, and '/' shows which delimiter is to be used. Examples: D2/= 12/01/04 D4/= 12/01/2004 D2- = 12-01-04 DM = 12 DD= 01 There are a ton of variations. It's worth looking the command up in the manuals. - Chuck Sanjeebkumar Sarangi wrote: If we do a external conversion usng OCONV(sysdate,'D2/'),the D indicates the date conversion specification but why is the 2/ being used here...what can be the change in the conversion? -- Charles Barouch ([EMAIL PROTECTED]) www.KeyAlly.com (718) 762-3884 x 1 P. O. Box 540957, Queens, NY 11354 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] -ve INDEX,OCONV
Sanjeebkumar Sarangi wrote:
Hi,
What does a negative index mean in an array .If LIST-1=ID is a segment
of the code what does this -ve number mean is it by default the first
element.
LIST-1 = X assigns X to the next element in the dynamic array.
Used most commonly when adding to an array without calculating the
index. It's fast and easy. The trap to watch out for, depending upon
version, is when you're building related/associated multi-value fields.
Quick example - say you're describing multiple cars held by a single
owner, and you decide to store make, model, year color for each in
associated fields.
So, you start with:
CHEVY, MALIBU, 1991, {NULL}
FORD, F150, 1992, BLUE
CHEVY, SUBURBAN, 1993, RED
You initialize the arrays like this:
MV.MAKE =
MV.MODEL =
MV.YEAR =
MV.COLOR =
Then you loop through your data fields, using the -1 notation to build
the multi-value fields.
MV.MAKE-1 = SPECIFIC.MAKE
MV.MODEL-1 = SPECIFIC.MODEL
MV.YEAR-1 = SPECIFIC.YEAR
MV.COLOR-1 = SPECIFIC.COLOR
BUT - BUT - BUT
Since the FIRST value of the COLOR was null, you'll end up with:
CHEVY; FORD; CHEVY
MALIBU; F150; SUBURBAN
1991; 1992; 1993
BLUE;RED
Since the first instance was null, when you assigned it to the MV.COLOR,
MV.COLOR remained null, and thus the second value assigned to it was
stored in the first location - which corrupts your data.
If we do a external conversion usng OCONV(sysdate,'D2/'),the D indicates
the date conversion specification but why is the 2/ being used
here...what
can be the change in the conversion?
D2/ is date conversion in mm/dd/yy format, (in US). Probably the most
common date conversion I've seen. Another very common one is D4/
which would provide you with a 4 digit year.
--
Allen Egerton
aegerton at pobox dot com
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] -ve INDEX,OCONV
Sanjeeb, The D2/ is a conversion code and specifies a date with 2 digits in the year and to use '/' as delimiters e.g. 03/19/07 rather than 03/19/2007 (D4/). You can get a list of conversion codes at ECL: HELP CONV And the manuals cover conversion codes in significant depth. Cheers, dAVID mURRAY - case sensitive? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sanjeebkumar Sarangi Sent: Monday, March 19, 2007 9:41 AM To: u2-users@listserver.u2ug.org Subject: [U2] -ve INDEX,OCONV Hi, What does a negative index mean in an array .If LIST-1=ID is a segment of the code what does this -ve number mean is it by default the first element. If we do a external conversion usng OCONV(sysdate,'D2/'),the D indicates the date conversion specification but why is the 2/ being used here...what can be the change in the conversion? Thanks Sanjeeb =-=-= Notice: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the message and any attachments. Thank you --- 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] -ve INDEX,OCONV
Sanjeeb, A -1 used in a dynamic array means to append to the end of the array. See HELP at ECL: HELP BASIC ARRAY.VARIABLES, HELP BASIC DYAMNIC.ARRAY.OPERATIONS, HELP BASIC REUSE(), and HELP BASIC INSERT. There are some differences how -1 is used between U2 account flavours. This is explained in some detail in the HELP BASIC INSERT online help. Cheers, David Murray -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sanjeebkumar Sarangi Sent: Monday, March 19, 2007 9:41 AM To: u2-users@listserver.u2ug.org Subject: [U2] -ve INDEX,OCONV Hi, What does a negative index mean in an array .If LIST-1=ID is a segment of the code what does this -ve number mean is it by default the first element. If we do a external conversion usng OCONV(sysdate,'D2/'),the D indicates the date conversion specification but why is the 2/ being used here...what can be the change in the conversion? Thanks Sanjeeb =-=-= Notice: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the message and any attachments. Thank you --- 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] -ve INDEX,OCONV
Hi Sanjeeb, If you have not already attended the base U2 training courses I would suggest that you convince your employers to arrange for you to do so. To be able to offer outsourcing to a company using U2 it is usually necessary for the outsourcing companies staff to be conversant in the environment. There are a couple of people on this list, most notably Ray Wurlod and Brian Leach who offer training. As do IBM. Most of these simple questions would be able to be answered in that forum and then you would be able to fully support your clients. Regards, Phil -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sanjeebkumar Sarangi Sent: Tuesday, 20 March 2007 6:01 a.m. To: u2-users@listserver.u2ug.org Subject: [U2] -ve INDEX,OCONV Hi, What does a negative index mean in an array .If LIST-1=ID is a segment of the code what does this -ve number mean is it by default the first element. If we do a external conversion usng OCONV(sysdate,'D2/'),the D indicates the date conversion specification but why is the 2/ being used here...what can be the change in the conversion? Thanks Sanjeeb =-=-= Notice: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the message and any attachments. Thank you --- 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/
