[U2] UVODBC Account Activation
Hi, I have a friend who is try to activate ODBC access in an account running on a unix based server and is getting the following: DICT UV_ASSOC /uv/sql/catalog/D_UV_ASSOC2 1 CRITICAL ERROR! Notify the system administrator. Abnormal termination of UniVerse. Fault type is 11. Layer type is BASIC run machine. Fault occurred in BASIC program *LISTFILES at address 520. Any suggestions ? Thanks mac Mac Bhyat Software Engineer - Special Projects Unibase Solutions (Pty) Ltd. URL: http://www.unibase.co.za http://www.unibase.co.za/ Email: [EMAIL PROTECTED] Tel: 011 621 7000 Cell: 079 181 3266 Fax: 011 621 7029 DISCLAIMER AND CONFIDENTIALITY This message and any attachment contain information intended solely for the addressee which is confidential or private in nature and subject to legal privilege. If you receive this message in error please notify the sender immediately by email and thereafter delete the message and do not disclose the content in any way. Unibase Solutions (Pty) Ltd cannot assure the integrity of this communication, nor that it is free of errors, virus, interception or interference, and disclaims all liability for any such. Views and opinions are those of the sender unless clearly stated as being that of the company. The authority of the sender to bind the company should be verified by the recipient and not assumed. For contact and address information regarding the company please go to http://www.unibase.co.za/ www.unibase.co.za -- This message was scanned for spam and viruses by BitDefender. For more information please visit http://linux.bitdefender.com/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UVODBC Account Activation
Not that I know much about this error but ... What version of UV are you running? I've set up ODBC on both 9.6 and 10.2, and the later version seems to be a lot more robust ... Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mac Bhyat Sent: 25 June 2008 10:59 To: u2-users@listserver.u2ug.org Subject: [U2] UVODBC Account Activation Hi, I have a friend who is try to activate ODBC access in an account running on a unix based server and is getting the following: DICT UV_ASSOC /uv/sql/catalog/D_UV_ASSOC2 1 CRITICAL ERROR! Notify the system administrator. Abnormal termination of UniVerse. Fault type is 11. Layer type is BASIC run machine. Fault occurred in BASIC program *LISTFILES at address 520. Any suggestions ? Thanks mac Mac Bhyat Software Engineer - Special Projects Unibase Solutions (Pty) Ltd. URL: http://www.unibase.co.za http://www.unibase.co.za/ Email: [EMAIL PROTECTED] Tel: 011 621 7000 Cell: 079 181 3266 Fax: 011 621 7029 DISCLAIMER AND CONFIDENTIALITY This message and any attachment contain information intended solely for the addressee which is confidential or private in nature and subject to legal privilege. If you receive this message in error please notify the sender immediately by email and thereafter delete the message and do not disclose the content in any way. Unibase Solutions (Pty) Ltd cannot assure the integrity of this communication, nor that it is free of errors, virus, interception or interference, and disclaims all liability for any such. Views and opinions are those of the sender unless clearly stated as being that of the company. The authority of the sender to bind the company should be verified by the recipient and not assumed. For contact and address information regarding the company please go to http://www.unibase.co.za/ www.unibase.co.za -- This message was scanned for spam and viruses by BitDefender. For more information please visit http://linux.bitdefender.com/ --- 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] UVODBC Account Activation
Hi, I know it's a very old version of uv - maybye 9.5 or possibly even 9.4 Mac -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: 25 Jun 2008 12:41 To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] UVODBC Account Activation Not that I know much about this error but ... What version of UV are you running? I've set up ODBC on both 9.6 and 10.2, and the later version seems to be a lot more robust ... Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mac Bhyat Sent: 25 June 2008 10:59 To: u2-users@listserver.u2ug.org Subject: [U2] UVODBC Account Activation Hi, I have a friend who is try to activate ODBC access in an account running on a unix based server and is getting the following: DICT UV_ASSOC /uv/sql/catalog/D_UV_ASSOC2 1 CRITICAL ERROR! Notify the system administrator. Abnormal termination of UniVerse. Fault type is 11. Layer type is BASIC run machine. Fault occurred in BASIC program *LISTFILES at address 520. Any suggestions ? Thanks mac Mac Bhyat Software Engineer - Special Projects Unibase Solutions (Pty) Ltd. URL: http://www.unibase.co.za http://www.unibase.co.za/ Email: [EMAIL PROTECTED] Tel: 011 621 7000 Cell: 079 181 3266 Fax: 011 621 7029 DISCLAIMER AND CONFIDENTIALITY This message and any attachment contain information intended solely for the addressee which is confidential or private in nature and subject to legal privilege. If you receive this message in error please notify the sender immediately by email and thereafter delete the message and do not disclose the content in any way. Unibase Solutions (Pty) Ltd cannot assure the integrity of this communication, nor that it is free of errors, virus, interception or interference, and disclaims all liability for any such. Views and opinions are those of the sender unless clearly stated as being that of the company. The authority of the sender to bind the company should be verified by the recipient and not assumed. For contact and address information regarding the company please go to http://www.unibase.co.za/ www.unibase.co.za -- This message was scanned for spam and viruses by BitDefender. For more information please visit http://linux.bitdefender.com/ --- 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/ -- This message was scanned for spam and viruses by BitDefender. For more information please visit http://linux.bitdefender.com/ __ NOD32 3216 (20080625) Information __ This message was checked by NOD32 antivirus system. http://www.eset.com -- This message was scanned for spam and viruses by BitDefender. For more information please visit http://linux.bitdefender.com/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UVODBC Account Activation
Okay. Firstly, do you need this file in your account? Oddly enough, most of my hard to fix problems with ODBC have been caused by the various preparation/export programs crashing on system files we've never touched. If you don't need it, delete the VOC entry. I had it crash on PTERM.FILE - a system-supplied multi-part file. Secondly, go to pickwiki, find the page on Universe, and then look at the page on ODBC. You might find it useful as it describes my tribulations with 9.6. Bear in mind that these export routines process EVERYTHING, so the entire account needs to be nice and clean, not just the files you're exporting :-( Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mac Bhyat Sent: 25 June 2008 14:44 To: u2-users@listserver.u2ug.org Subject: RE: [U2] UVODBC Account Activation Hi, I know it's a very old version of uv - maybye 9.5 or possibly even 9.4 Mac -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: 25 Jun 2008 12:41 To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] UVODBC Account Activation Not that I know much about this error but ... What version of UV are you running? I've set up ODBC on both 9.6 and 10.2, and the later version seems to be a lot more robust ... Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mac Bhyat Sent: 25 June 2008 10:59 To: u2-users@listserver.u2ug.org Subject: [U2] UVODBC Account Activation Hi, I have a friend who is try to activate ODBC access in an account running on a unix based server and is getting the following: DICT UV_ASSOC /uv/sql/catalog/D_UV_ASSOC2 1 CRITICAL ERROR! Notify the system administrator. Abnormal termination of UniVerse. Fault type is 11. Layer type is BASIC run machine. Fault occurred in BASIC program *LISTFILES at address 520. Any suggestions ? Thanks mac Mac Bhyat Software Engineer - Special Projects Unibase Solutions (Pty) Ltd. URL: http://www.unibase.co.za http://www.unibase.co.za/ Email: [EMAIL PROTECTED] Tel: 011 621 7000 Cell: 079 181 3266 Fax: 011 621 7029 DISCLAIMER AND CONFIDENTIALITY This message and any attachment contain information intended solely for the addressee which is confidential or private in nature and subject to legal privilege. If you receive this message in error please notify the sender immediately by email and thereafter delete the message and do not disclose the content in any way. Unibase Solutions (Pty) Ltd cannot assure the integrity of this communication, nor that it is free of errors, virus, interception or interference, and disclaims all liability for any such. Views and opinions are those of the sender unless clearly stated as being that of the company. The authority of the sender to bind the company should be verified by the recipient and not assumed. For contact and address information regarding the company please go to http://www.unibase.co.za/ www.unibase.co.za -- This message was scanned for spam and viruses by BitDefender. For more information please visit http://linux.bitdefender.com/ --- 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/ -- This message was scanned for spam and viruses by BitDefender. For more information please visit http://linux.bitdefender.com/ __ NOD32 3216 (20080625) Information __ This message was checked by NOD32 antivirus system. http://www.eset.com -- This message was scanned for spam and viruses by BitDefender. For more information please visit http://linux.bitdefender.com/ --- 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] unsubscribe u2-users
--- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] How to tell if running a subroutine though RedBack
I have a need to call a standard subroutine from a RedBack application call. The subroutine is meant to be used in an interactive mode and can prompt the user if there is an error in the data. If the data is coming from RedBack, I want to suppress the prompting and write the error to a log file. Is there any environment variable I can look at to tell if I am executing under the RedBack API call? Thanks Doug This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software Corporation or any other company within its group. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] How to tell if running a subroutine though RedBack
I am not sure about a system variable, but as I understand it, rbadmin is the one doing the communication on the PICK box. If someone does not have a better idea, you could EXECUTE !whoami and if you are rbadmin (or some other pre-defined user) you could ignore the prompt. John Israel Sr. Programmer/Analyst Dayton Superior Corporation 721 Richard St. Dayton, OH 45342 937-866-0711 x44380 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Doug Farmer Sent: Wednesday, June 25, 2008 2:57 PM To: u2-users@listserver.u2ug.org Subject: [U2] How to tell if running a subroutine though RedBack I have a need to call a standard subroutine from a RedBack application call. The subroutine is meant to be used in an interactive mode and can prompt the user if there is an error in the data. If the data is coming from RedBack, I want to suppress the prompting and write the error to a log file. Is there any environment variable I can look at to tell if I am executing under the RedBack API call? Thanks Doug This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software Corporation or any other company within its group. --- 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] [UD] UD query anomoly
Bill; UO doesn't go through the LOGIN VOC so your UDT.OPTIONS may not be the same. You can use a globally catalogued program UOLOGIN to set them up (see IBM ref# 1181382). I tried a similar sort using IBM's Ucommand program which uses UniObjects to connect and run a command (ref# 105866). It didn't parse the 'V' properly so it wouldn't actually run the command. Not much help there. I don't use DB but I do use SB. It has a function to download reports to Excel. I noticed the other day that when dict format was set to '0R' it actually hid the column in Excel. My point being that SB doesn't actually run the sort command. It parses it and creates it's own data. Perhaps DB is doing something similar that is messing up the output. food for thought Colin Alfke Calgary, Canada -Original Message- From: Bill Haskett snip But I've noticed UD has some weird results with the query language. For instance, we have a BASIC program that creates a query and outputs to the spooler. Yesterday the output for a single column was different based on running the program from telnet or from UniObjects (DesignBais). Same report, same BASIC program, same account, same dictionaries, same data; but the output of a single column was different. From Telnet... 3 Intel (0)- SORT APOPEN BY ISPD LPTR INVDATE COMMENT FMT 25L ACCTS BREAK-ON ISPD 'V' TOTAL AMTS CHECKNO APOPEN INV-DATE DESCRIPTION.. ACCT. ACCT/AMTS CK# 1025*672 01-19-08 PMT ON ACCT#XXX8218 2920101.19 980*1033 05-15-08 EMPLOYER MCARE W/H5020 3.63 - NonPaid 5,594.14 Same query from UniObjects (DesignBais)... APOPEN INV-DATE DESCRIPTION.. ACCT. ACCT/AMTS CK# 1025*672 01-19-08 PMT ON ACCT#XXX8218 2920101.19 980*1033 05-15-08 EMPLOYER MCARE W/H5020 3.63 - N5,594.14 The dictionary used by the BREAK-ON looks like... 2 Intel (0)- AE DICT APOPEN ISPD Top of ISPD in DICT APOPEN, 9 lines, 212 characters. *--: p 001: I Output 'NonPaid' if invoice not paid and 'Paid' if it is. Used for break lines out output. 002: IF CHECK_ID = THEN NonPaid ELSE Paid 003: 004: \ 005: 0R 006: S 007: 008: ISPD2CHECK_ID 42IF CHECK_ID = THEN NonPaid ELSE Paid 009: APOPEN Bottom. Although I'm not having problems with the 1st issue (I was merely trying to recreate what the OP presented), this second issue does present some problems. Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] unsubscribe u2-users
--- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UVODBC Account Activation {unclassified}
Hi, A clean account is almost necessary. ODBC is very picky and we found that our data was OK but that the dictionaries were full of 10 years worth of difficulties :) It was easier to create a new account, populate the VOC with file pointers to the data files but create the dictionary locally. Then we could put only the data items we wanted to expose into the dictionary. This allowed us to format data differently from what the users needed to see and ensure that clean dictionaries were presented. Andy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: Thursday, 26 June 2008 2:34 a.m. To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] UVODBC Account Activation Okay. Firstly, do you need this file in your account? Oddly enough, most of my hard to fix problems with ODBC have been caused by the various preparation/export programs crashing on system files we've never touched. If you don't need it, delete the VOC entry. I had it crash on PTERM.FILE - a system-supplied multi-part file. Secondly, go to pickwiki, find the page on Universe, and then look at the page on ODBC. You might find it useful as it describes my tribulations with 9.6. Bear in mind that these export routines process EVERYTHING, so the entire account needs to be nice and clean, not just the files you're exporting :-( Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mac Bhyat Sent: 25 June 2008 14:44 To: u2-users@listserver.u2ug.org Subject: RE: [U2] UVODBC Account Activation Hi, I know it's a very old version of uv - maybye 9.5 or possibly even 9.4 Mac -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: 25 Jun 2008 12:41 To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] UVODBC Account Activation Not that I know much about this error but ... What version of UV are you running? I've set up ODBC on both 9.6 and 10.2, and the later version seems to be a lot more robust ... Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mac Bhyat Sent: 25 June 2008 10:59 To: u2-users@listserver.u2ug.org Subject: [U2] UVODBC Account Activation Hi, I have a friend who is try to activate ODBC access in an account running on a unix based server and is getting the following: DICT UV_ASSOC /uv/sql/catalog/D_UV_ASSOC2 1 CRITICAL ERROR! Notify the system administrator. Abnormal termination of UniVerse. Fault type is 11. Layer type is BASIC run machine. Fault occurred in BASIC program *LISTFILES at address 520. Any suggestions ? Thanks mac Mac Bhyat Software Engineer - Special Projects Unibase Solutions (Pty) Ltd. URL: http://www.unibase.co.za http://www.unibase.co.za/ Email: [EMAIL PROTECTED] Tel: 011 621 7000 Cell: 079 181 3266 Fax: 011 621 7029 DISCLAIMER AND CONFIDENTIALITY This message and any attachment contain information intended solely for the addressee which is confidential or private in nature and subject to legal privilege. If you receive this message in error please notify the sender immediately by email and thereafter delete the message and do not disclose the content in any way. Unibase Solutions (Pty) Ltd cannot assure the integrity of this communication, nor that it is free of errors, virus, interception or interference, and disclaims all liability for any such. Views and opinions are those of the sender unless clearly stated as being that of the company. The authority of the sender to bind the company should be verified by the recipient and not assumed. For contact and address information regarding the company please go to http://www.unibase.co.za/ www.unibase.co.za -- This message was scanned for spam and viruses by BitDefender. For more information please visit http://linux.bitdefender.com/ --- 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/ -- This message was scanned for spam and viruses by BitDefender. For more information please visit http://linux.bitdefender.com/ __ NOD32 3216 (20080625) Information __ This message was checked by NOD32 antivirus system. http://www.eset.com -- This message was scanned for spam and viruses by BitDefender. For more information please visit http://linux.bitdefender.com/ --- 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/ The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you
RE: [U2] How to tell if running a subroutine though RedBack
Check the content of the @AUTHORIZATION system variable. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Doug Farmer Sent: Thursday, 26 June 2008 2:57 AM To: u2-users@listserver.u2ug.org Subject: [U2] How to tell if running a subroutine though RedBack I have a need to call a standard subroutine from a RedBack application call. The subroutine is meant to be used in an interactive mode and can prompt the user if there is an error in the data. If the data is coming from RedBack, I want to suppress the prompting and write the error to a log file. Is there any environment variable I can look at to tell if I am executing under the RedBack API call? Thanks Doug DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] How to tell if running a subroutine though RedBack
Thanks for the advice, but that is a UniVerse command and this is UniData - Sorry I did not say that in the first place. Doug -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Womack, Adrian Sent: Wednesday, June 25, 2008 7:25 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] How to tell if running a subroutine though RedBack Check the content of the @AUTHORIZATION system variable. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Doug Farmer Sent: Thursday, 26 June 2008 2:57 AM To: u2-users@listserver.u2ug.org Subject: [U2] How to tell if running a subroutine though RedBack I have a need to call a standard subroutine from a RedBack application call. The subroutine is meant to be used in an interactive mode and can prompt the user if there is an error in the data. If the data is coming from RedBack, I want to suppress the prompting and write the error to a log file. Is there any environment variable I can look at to tell if I am executing under the RedBack API call? Thanks Doug DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software Corporation or any other company within its group. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] UD query anomoly
Thanks Colin. This gives me something to look into. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Colin Alfke Sent: Wednesday, June 25, 2008 12:59 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] UD query anomoly Bill; UO doesn't go through the LOGIN VOC so your UDT.OPTIONS may not be the same. You can use a globally catalogued program UOLOGIN to set them up (see IBM ref# 1181382). I tried a similar sort using IBM's Ucommand program which uses UniObjects to connect and run a command (ref# 105866). It didn't parse the 'V' properly so it wouldn't actually run the command. Not much help there. I don't use DB but I do use SB. It has a function to download reports to Excel. I noticed the other day that when dict format was set to '0R' it actually hid the column in Excel. My point being that SB doesn't actually run the sort command. It parses it and creates it's own data. Perhaps DB is doing something similar that is messing up the output. food for thought Colin Alfke Calgary, Canada -Original Message- From: Bill Haskett snip But I've noticed UD has some weird results with the query language. For instance, we have a BASIC program that creates a query and outputs to the spooler. Yesterday the output for a single column was different based on running the program from telnet or from UniObjects (DesignBais). Same report, same BASIC program, same account, same dictionaries, same data; but the output of a single column was different. From Telnet... 3 Intel (0)- SORT APOPEN BY ISPD LPTR INVDATE COMMENT FMT 25L ACCTS BREAK-ON ISPD 'V' TOTAL AMTS CHECKNO APOPEN INV-DATE DESCRIPTION.. ACCT. ACCT/AMTS CK# 1025*672 01-19-08 PMT ON ACCT#XXX8218 2920101.19 980*1033 05-15-08 EMPLOYER MCARE W/H5020 3.63 - NonPaid 5,594.14 Same query from UniObjects (DesignBais)... APOPEN INV-DATE DESCRIPTION.. ACCT. ACCT/AMTS CK# 1025*672 01-19-08 PMT ON ACCT#XXX8218 2920101.19 980*1033 05-15-08 EMPLOYER MCARE W/H5020 3.63 - N5,594.14 The dictionary used by the BREAK-ON looks like... 2 Intel (0)- AE DICT APOPEN ISPD Top of ISPD in DICT APOPEN, 9 lines, 212 characters. *--: p 001: I Output 'NonPaid' if invoice not paid and 'Paid' if it is. Used for break lines out output. 002: IF CHECK_ID = THEN NonPaid ELSE Paid 003: 004: \ 005: 0R 006: S 007: 008: ISPD2CHECK_ID 42IF CHECK_ID = THEN NonPaid ELSE Paid 009: APOPEN Bottom. Although I'm not having problems with the 1st issue (I was merely trying to recreate what the OP presented), this second issue does present some problems. Bill --- 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][UV] UV ODBC and SQL 2005 {unclassified}
Hi, We are looking at updating our MS SQL servers to MS SQL 2005. Currently we use UV ODBC build 7084 (Client 10.1.A) on the SQL server (Windows 2000) to connect to our UV 10.1.18 instance running on Windows 2003. Is anyone aware of any problems with the ODBC driver on the 10.1.B Client (build 7049)? Is it a better fit with SQL 2005 than the 10.1.A client or should I leave well enough alone? Any advice appreciated. Thanks. Andrew Mack Senior Database Manager (UV/SQL) Applications Development CIS Branch 342 5914 (DTelN) (04) 2371 914 (DDI) The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
