Bob/Darrin, There is no option in Config_EMULATE to treat null as zero in a SELECT statement.
Dan Ell From: [email protected] [mailto:[email protected]] On Behalf Of Bob Wyatt Sent: Monday, February 04, 2013 12:00 PM To: [email protected] Subject: RE: jBASE migration 3.4 to 5.2 - How difficult? Darrin, You might wish to check out $JBCRELEASWEDIR/config/Config_EMULATE.txt, which defines many options you can control by changing the value in $JBCRELEASEDIR/config/Config_EMULATE. There is an option that affects null handling in jQL for UniVerse right-justified fields, but I suspect it may do more harm than good, and may not even apply (the definition is very specific regarding its application). None-the-less, it may be worth a look to see if there other settings of value or import to you. Bob Wyatt From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Darrin Sent: Monday, February 04, 2013 9:51 AM To: [email protected]<mailto:[email protected]> Subject: Re: jBASE migration 3.4 to 5.2 - How difficult? Ran into another one this morning... JQL now appears to be doing string comparison rather than value comparison when dealing with the value of zero. For example, to process every record in IM with a non-zero quantity on hand. SELECT IM WITH QOH NE "0" Previously this excluded records with a QOH of "". Now it does not. Off the top of my head, the easiest fix is the following: SELECT IM WITH QOH > "0" Time to get friendly with regular expressions and see how many occurrences of this we have in our code base.... -- -- IMPORTANT: T24/Globus posts are no longer accepted on this forum. To post, send email to [email protected]<mailto:[email protected]> To unsubscribe, send email to [email protected]<mailto:[email protected]> For more options, visit this group at http://groups.google.com/group/jBASE?hl=en --- You received this message because you are subscribed to the Google Groups "jBASE" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/groups/opt_out. -- -- IMPORTANT: T24/Globus posts are no longer accepted on this forum. To post, send email to [email protected]<mailto:[email protected]> To unsubscribe, send email to [email protected]<mailto:[email protected]> For more options, visit this group at http://groups.google.com/group/jBASE?hl=en --- You received this message because you are subscribed to the Google Groups "jBASE" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/groups/opt_out. -- -- IMPORTANT: T24/Globus posts are no longer accepted on this forum. To post, send email to [email protected] To unsubscribe, send email to [email protected] For more options, visit this group at http://groups.google.com/group/jBASE?hl=en --- You received this message because you are subscribed to the Google Groups "jBASE" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
