RE: [U2] Selection Problem - Index?

>David A. Green <[EMAIL PROTECTED]> wrote on 09/11/2006 10:50:40 AM: > > Also try using BETWEEN like this: > :SELECT WAREHOUSE WITH PRIM.BIN.NUM BETWEEN "131" "139" > >Also a problem in ECLTYPE P - the specified strings are NOT included with >the BETW

RE: [U2] Selection Problem - Index?

Looks like PRIM.BIN.NUM is left justified instead of right? Try making the dictionary Right justified or pad the data with zeros. Also try using BETWEEN like this: :SELECT WAREHOUSE WITH PRIM.BIN.NUM BETWEEN "131" "139" 123 records selected to list 0. Thanks, David A.

RE: [U2] Unidata LIMIT command

That is an OS limit. What you can do is create the file and then create a Synonym file pointer in VOC. This pointer can be up to 126 characters in length. Thanks, David A. Green DAG Consulting -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Buffington

RE: [U2] Unidata paragraphs?

ND, OR, ~(Not) > * How do I check a SELECT ? IF @SYSTEM.RETURN.CODE > 0 > * CONTINUATION CHARACTER Use \ (backslash) Thanks, David A. Green DAG Consulting --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Using DICT items in basic program

Brian, Here is a helpful hint, make the first value of your subroutine the Return Value. This way it can also be used from an I-Desc. Thanks, David A. Green DAG Consulting -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach Sent: Thursday

RE: [U2] Select with Multiple Indices Not Working

Dave, I'm not aware of any issues. UniData will only use one index per Select statement. What results do you get when you use the NO.INDEX keyword? Thanks, David A. Green DAG Consulting -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave S

RE: [U2] Convert to date and Time

Do you mean something like this: SUBR("-FIELDS", Mv_Dict, " ", 2); SUBR("-FIELDS", @1, "*", 1); SUBR("-FIELDS", @1, "*", 2); SUBR("-FIELDS", @, ".", 1); OCONVS(@2, "D2/"); OCONVS(@4, "MTH");

RE: [U2] Encrypt issue 8088

Why do programmers use result[LEN(result),1]? Doesn't result[1] do the same thing but easier, quicker, and more readable? Thanks, David A. Green DAG Consulting www.dagconsulting.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Symeon Breen

RE: [U2] Unable TO DELETE.INDEX ALL

If your index is corrupt then do the following: 1. delete it at the OS level 2. copy a good index over giving it the same name 3. delete it at the DB level Thanks, David A. Green DAG Consulting -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave S

RE: [U2] Unidata Query

I use: TOTAL EVAL "1" Thanks, David A. Green DAG Consulting -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Martin Scholl Sent: Monday, August 14, 2006 7:33 AM To: u2-users@listserver.u2ug.org Subject: [U2] Unidata Query I am a bit rus

RE: [U2] Reading Binary data from a file...

In UD you would use: OSOPEN OSBREAD NOCONVERT Thanks, David A. Green DAG Consulting -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen Sent: Thursday, July 27, 2006 11:16 AM To: u2-users@listserver.u2ug.org Subject: [U2] Reading Binary data

RE: [U2] Changed BASIC varname<1,-1>

Easier to read, but ABSOLUTLEY the slowest method, ok for small arrays that get assembled or disassembled once during execution, but if you are in a loop or if your arrays can be big use <-1> and REMOVE. David A. Green DAG Consulting > I always use A.VAR := > @AM[1,NOT(NOT(A.VAR

RE: [U2] @(0,0)

BPIOCPN Thanks, David A. Green DAG Consulting -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Kent Sent: Sunday, June 04, 2006 10:50 PM To: u2-users@listserver.u2ug.org Subject: [U2] @(0,0) I have seem some alternatives to the above that suppress

RE: [U2] interface into Unidata

agreed format with the 3rd party software, using ftp or some other method of delivery, email notifications and exception reports. Thanks, David A. Green DAG Consulting (480) 813-1725 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brad Davis Sent

RE: [U2] Phantom Question

Are you using a PRINTER CLOSE command? Thanks, David A. Green DAG Consulting -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, April 19, 2006 12:13 PM To: u2-users@listserver.u2ug.org Subject: [U2] Phantom Question

RE: [U2] [UD] Setptr

ETPTR ":PTR.INFO DATA "Y" PERFORM SET.PTR.CMD CAPTURING BUFF IF @SYSTEM.RETURN.CODE < 0 THEN PRINT BUFF RETURN ! RESTORE.PTR.OPTIONS: PTR.INFO = SAVE.PTR GOSUB SET.PTR.OPTIONS RETURN ! Thanks, David A. Green DAG Consulting

RE: [U2] [UD] How do I know when I'm in a CAPTURING

That only shows a phantom and redirected input. > Do you mean @USER.TYPE? HTH Colin Alfke Calgary Canada >-Original Message- >From: David A. Green > >If I do an EXECUTE or PERFORM with CAPTURING can the UniBasic >program that is being called know if the output h

RE: [U2] Dict Item

uses other dictionary items. Thanks, David A. Green DAG Consulting -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: Thursday, February 16, 2006 8:27 PM To: u2-users@listserver.u2ug.org Subject: [U2] Dict Item If a process has already star

RE: [U2] CC encrypting for unidata

Dana, I have a User Exit that will Encrypt CC numbers. The ICONV will bring back the encrypted, uuencoded, Unidata friendly data to store in the file. The OCONV displays it as 5612. David A. Green DAG Consulting (480) 813-1725 -Original Message- Anyone have or know of

RE: [U2] [UV] GOSUB variable-name?

How about using EQAUTES? EQUATE MYSUB1 TO 1 EQUATE MYSUB2 TO 2 Etc. SUB.TO.RUN = MYSUB1 CALL DO.THE.SUB(SUB.TO.RUN) ... SUBROUTINE DO.THE.SUB(SUB.NAME) ... ON SUB.NAME GOSUB MYSUB1, MYSUB2, Etc. ... MYSUB1: RETURN ! MYSUB2: RETURN Thanks, David A. Green DAG Consulting (480) 813-1725

RE: [U2] Dynamic Files

Selecting 134 167 157 965 Processing 1676 1740 1733 2410 The times are given in CPU Milliseconds as an average after 3 runs. The runs were done on a stand alone machine running Windows XP Pro. A COUNT SA command was issued before each run. David A. Green DAG Consulting

RE: [U2] Re: Identifying UD files

Have you tried running guide on the files? If you must do it from UniBasic then parse the guide output files or read the hash file populated by guide to determine which have errors and which do not. Thanks, David A. Green DAG Consulting -Original Message- files in question actually

RE: [U2] Identifying UD files

Adam, I just use the OPEN command with the THEN / ELSE clause. Thanks, David A. Green DAG Consulting -Original Message- Is it possible from inside a UniBasic program to identify whether or not a VOC pointer points to a valid UniData file? --- u2-users mailing list u2-users

RE: [U2] [UD] list output when captured

W CAPTURING BUFF ;* Reset term Thanks, David A. Green DAG Consulting -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: Thursday, January 19, 2006 5:15 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] list output when captured Dav

RE: [U2] [UD] list output when captured

Why not just suppress the heading? HDR.SUP David A. Green DAG Consulting -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: Wednesday, January 18, 2006 5:20 PM To: u2-users@listserver.u2ug.org Subject: [U2] [UD] list output when captured

RE: [U2] XML with UO7.1

How about a Virtual Attribute that reproduces the Single Valued items for the number of Multi-Values. Then add it to your Association. Thanks, David A. Green DAG Consulting -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Victor St Clair Sent: Monday

RE: [U2] CSVs' (Different Question)

You can do an HTML document but save it with the .XLS extension and EXCEL will open it by default. Thanks, David A. Green DAG Consulting -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: Sunday, January 15, 2006 7:54 AM To: u2-users

RE: [U2] [UD] Active select list in BASIC

Bill, This is the way a Select list works. The IDs that have already been used via the READNEXT will be gone. If you'd like you can select to one of the non-active list like 1. PERFORM "SELECT MYFILE TO 1" ... LOOP READNEXT ID FROM 1 ELSE EXIT ... REPEAT Thanks, Dav

RE: [U2] [UD] Active select list in BASIC

Also if you get this message and want to finish execution you can do an "N" to continue without prompting. Thanks, David A. Green DAG Consulting -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: Friday, January 13, 2006 5:48

RE: [U2] [UD] Active select list in BASIC

Bill, You can turn this feature off by using an @ print command i.e. PRINT @(-1) or if you don't want to clear the screen just do a DMY = @(-1), or issuing BPIOCPN command. Thanks, David A. Green DAG Consulting -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTE

RE: [U2] System Migration issues

Are you using Binary mode? Thanks, David A. Green DAG Consulting -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sirulnick, Steve Sent: Thursday, January 12, 2006 7:42 AM To: u2-users@listserver.u2ug.org Subject: [U2] System Migration issues I am

RE: [U2] [UD] How to determine the File Name within a dictionary called Subroutine

Can you send it into the Subroutine as a parameter? SUBR("MY.SUB", @FILENAME, Dict_Name, etc. ) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: Friday, January 06, 2006 2:04 PM To: u2-users@listserver.u2ug.org Subject: [U2] [UD] How to

RE: [U2] Record count from an I-descriptor in the VOC

You will lose your active SELECT list if you don't save it and restore it. Thank you, David A. Green DAG Consulting (480) 813-1725 www.dagconsulting.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Wendy Smoak Sent: Wednesday, December 28, 2005

RE: [U2] UniData phrases

Did you know you can force UniData flavor by using the lowercase verb equivalent? list, sort, etc. Thank you, David A. Green DAG Consulting (480) 813-1725 www.dagconsulting.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: Monday

RE: [U2] OCONV question

>For 1 --> 0014, use OCONV(value,'MR%4') FYI: You can zero fill with a FMT too. MY.NBR = FMT(MY.NBR, "4\0R") Thank you, David A. Green DAG Consulting (480) 813-1725 www.dagconsulting.com --- u2-users mailing list u2-users@listserver.u2ug.org To uns

RE: [U2] global catdir question - security hole

Can someone on the list do a test? 1. Create a test program like PRINT "Hello World!" 2. Secure the run-time code so that root only has update permissions i.e. rw-r--r-- 3. Login as a non root user 4. Run Program 5. Report the results back to the list Thank you, David A. Green

RE: [U2] SOX question (United States only, I believe)

contact of the enhancement so that they would know it was ready for them to test. After the end-user has tested it in the Test Account someone fills in the Approved By and it would trigger the "Move" into the Live Account and release the "lock". David A. Green DAG Consultin

RE: [U2] Getting flat files from UV on Win2k3 server

Why not just map a drive on their PC to the export folder? Thank you, David A. Green DAG Consulting (480) 813-1725 www.dagconsulting.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Waldron Sent: Friday, October 28, 2005 1:30 PM To: u2-users

RE: [U2] help with multivalue and when

Jeff, First make sure these dictionary items are properly associated. Second use WHEN with the ASD keyword. Example: "list order-log WHEN ASD(action="pck" and act.date="10/11/05") id.supp hdr.supp col.hdr.supp count.sup @id fmt "132l"" Thank you, Davi

RE: [U2] Unidata TCL - beginner question

How about: :SELECT FILE.NAME BY.DSND DATE >LIST FILE.NAME PART DATE FIRST 1 Thank you, David A. Green DAG Consulting (480) 813-1725 www.dagconsulting.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Ordway Sent: Thursday, October 06, 2005

RE: [U2] UniBasic

Jim, As a security feature a lot of VARS remove that command (verb) from the VOC. Or perhaps they have a utility that they want you to use instead? So first check with your VAR before changing your VOC. Thank you, David A. Green DAG Consulting (480) 813-1725 www.dagconsulting.com

RE: [U2] Good Programming Practice Question.........

Consulting -- WWW.DAGCONSULTING.COM * David A. Green -- 5/2/01 * * EQUATE TRUE TO 1, FALSE TO 0 EQUATE CLR TO @(-1) ! DEBUG.FLAG = TRUE ! GOSUB INIT GOSUB PRINT.SCREEN GOSUB OPEN.FILES ! IF NOT(ABORT.FLAG) THEN LOOP

RE: [U2] Good Programming Practice Question.........

Practice Question. I like these and would add another one - Add comments to tricky-looking code! -Dianne David A. Green wrote: >I've been teaching UniBasic for over 10 years and here are some of the >methods I teach: > >* Subroutines should only have one job. >* Subrout

RE: [U2] Good Programming Practice Question.........

onditional Statements. * Use UniData Internal Variables whenever possible; i.e. @AM, @VM, @DATE. Thank you, David A. Green DAG Consulting (480) 813-1725 www.dagconsulting.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Fawaz Ashraff Sent: Tuesday, Se

<    1   2   3