Re: [U2] [JOB] Epicor is now in Denver?

The offices in Minneapolis houses Epicor 9 (I believe the current flagship ERP system) as well as the Manage 2000 folks. Albert DeWitt, CPIM Sr. Programmer Analyst Stylmark, Inc. Minneapolis MN 55432 | USA -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users

[U2] SB: Character Mode Works Great, GUI Does Not

I am creating a simple screen. Two fields. The Before Process in the Definition defines @KEY, reads @RECORD and loads @RECORD<6> into @WORK<1> which is displayed on the screen (lines of text). @WORK<1> is a multivalue field. The Before Process invokes the text editior. The user is allowed t

Re: [U2] OPENSEQ

when I'm creating new files I use THEN and put the "abort" in there. When you borrowed this code did it have all of the validation? I don't have my error codes handy - but if you let it continue does it let you do the writeseq? Hth Colin -Original Message- From: Al

Re: [U2] OPENSEQ

g] On Behalf Of bradley.sch...@usbank.com Sent: Monday, August 05, 2013 9:10 AM To: U2 Users List Subject: Re: [U2] OPENSEQ Does the code still fail with the dummy file out there? If not, I'd guess permissions. From: Al DeWitt To: U2 Users List , Date: 08/05/2013 09:04 AM Subject:

Re: [U2] OPENSEQ

really does exist in that directory file? On Mon, Aug 5, 2013 at 7:10 AM, Al DeWitt wrote: > Please educate me on OPENSEQ. I have some code that is giving me an > error. The funny thing is that I stole the code from a working program: > The code: > > 064: FNAME = 'LLV&#

[U2] OPENSEQ

Please educate me on OPENSEQ. I have some code that is giving me an error. The funny thing is that I stole the code from a working program: The code: 064: FNAME = 'LLV':FNAME:'.XLS' 065: OPENSEQ "\\SERVER\SHARE-NAME\FOLDER-NAME\LrgLbrVariances",FNAME TO OUT.FILE ELSE 066: *OPENSEQ "LRGLBRVARS

[U2] SBClient , TU.DDE.WRITE and WIFI

I have a program that opens an Excel template on a network drive and outputs rows of data. When I have a direct connection (wire) it works fine. However, WIFI it opens the Excel template; acts like it's doing its thing and goes to EOJ, but nothing outputs to Excel. I tried it using WIFI + VPN

[U2] SBClient Issue

SB+ / SBClient 5.4.2 We have a custom report that was written using paragraphs and the DDE functionality. Our process is to 1)Open an Excel Worksheet 2)Run the report which outputs to the worksheet. We are encountering situations where the report appears to work normally but not all

[U2] OT: Monitoring Program: Can This Be Done?

Tried sending this to sbsolutions but it didn't appear to get there so I'll try here in hopes some of you are using SB+/SBClient We are having an issue where we are using all of our licenses by midday. Our current procedure is to send out a broadcast e-mail asking those who are not using the a

Re: [U2] WRITESEQ Error

arted fine and automatically started the application, however, the share-name stopped working. When the IT person tried to restart it he didn't do it correctly. Now that we have correctly recreated share-name all is well. Thanks for all your help. Al DeWitt > -Original Message---

Re: [U2] WRITESEQ Error

I initially thought it was a permissions issue as well, however, I am a domain admin and I get the same error. If it is a permissions error than something has changed that I am not aware of. Al DeWitt > -Original Message- > From: Wjhonson [mailto:wjhon...@aol.com] > Sent:

[U2] WRITESEQ Error

I have a program that has been working fine until today. The users are now experiencing an error at the following statement #: 508: WRITESEQ RECRD APPEND ON FILEIN ELSE ... at line 508 write error, errno = 9 Can someone tell me what errno 9 is and what my cause it?The file resides on a

Re: [U2] Clearing Input Buffer

Ding, ding, ding; we have a winner! Apparently the scanner I was using had a CR suffix. When I changed it to a Tab suffix it worked fine without needing to clear the buffer. Thanks for all the input. Al DeWitt > -Original Message- > From: u2-users-boun...@listserver.u2

Re: [U2] FW: Clearing Input Buffer

How do I flush the buffer? What is the name or function I need? I can't put my finger on the right page in the Unidata manuals. Thanks. Al DeWitt > -Original Message- > From: Kevin King [mailto:ke...@precisonline.com] > Sent: Friday, February 22, 2013 1:25 PM >

[U2] FW: Clearing Input Buffer

I have an input screen (built with System Builder) where data can either be entered manually or via a barcode scanner. The screen has 3 text boxes for input. The barcode option fills two of the text boxes and is supposed to land on the third box to await input. However, the scanner must be ad

Re: [U2] Select Statement Invalid

Have never used PROCs. I was, however, able to adapt this and it worked great! Thanks. Al DeWitt -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Eric Neu Sent: Wednesday, July 11, 2012 7:43 PM To: U2 Users List

[U2] Select Statement Invalid

Unidata 7.1.20, pick flavor I have this quick paragraph to select records based on partial keys: 001: PA 002: SELECT WIPMTLRQ WITH @ID = "299486]""302667]""318583]""337991]""374396]""376742]""382767]""385661]" "398932]""415256]""445409]""453821]" "454353]""478175]""478845]""502457]" Botto

Re: [U2] FW: Multivalue Question

So the 5500 values in one field is not stretching any limits? Al DeWitt -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Thursday, June 07, 2012 11:33 AM To: u2-users@listserver.u2ug.org Subject: Re

[U2] FW: Multivalue Question

Unidata 7.1.20 Pick Flavor I am going to end up with a situation where I will have a multivalue field that contains 5500 +/- values. Each value will be 5-characters long. I'm concerned that this will issues with the following statement: X = RECORD<31> I've tried searching the manuals a

[U2] Unidata 7.1.20 Pick Flavor & Selecting Multi-Values

I'm am trying to help out my users by helping them make sense of what they have done to themselves. The field in question, Bin Number, is alphanumeric. About three quarters of the entries are all numeric and one quarter are alphanumeric. Below is a perfect example of my issue. LIST INVWHS

Re: [U2] OPENSEQ and the LOCKED Option

That did it! Thank you very much. Al DeWitt -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Colin Alfke Sent: Friday, October 28, 2011 5:01 PM To: 'U2 Users List' Subject: Re: [U2] OPENSEQ and the LOC

Re: [U2] OPENSEQ and the LOCKED Option

*--: FIB Filed "ALD1" in file "BP". Compiling Unibasic: ..\..\..\FLOPROGS\DEV\DEV.IIBASE8\BP8.0\ALD1 in mode 'p'. main program: syntax error at or before ^ Expecting: ELSE compilation failed It works fine if I take

[U2] OPENSEQ and the LOCKED Option

Unidata 7.1.20 ECLTYPE P Whenever I try to include the LOCKED option in the OPENSEQ statement my test program does not compile. If I leave it out it does compile. When two users run this program one executes the OPENSEQ command and the other appears hung...no message, nothing. When the fi

Re: [U2] Sequential Files Question

This is what finally worked. I was hoping to do it w/o having to create a VOC entry, but that was not to be. Thank you all for your help. Al DeWitt -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Colin Alfke

Re: [U2] Sequential Files Question

I GET THE FOLLOWING MESSAGE [FATAL ERROR: - Cannot open file C:\OUTPUT\APCHECKS1002] and I'm sent to the colon prompt. Al DeWitt -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath Sent: Wedn

Re: [U2] Sequential Files Question

since APCHECKS would be unique each time it doesn't exist. BTW when I try to display OUTFILE it gives me an Unitialized Variable, zero assumed error. Al DeWitt -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan Mc

[U2] Sequential Files Question

ll be using OPENSEQ to open the file. However, since each file needs to be created at time of opening what do I use to create the file? My reading of OPENSEQ doesn't indicate that it will create it automatically if it doesn't exist. Than

[U2] Different Number of Arguments Error

I have downloaded one of the barcode programs ( PLS.BAR128) to test barcode printing. I needed to make two changes. One was the name change to fit within our naming convention and the other was the name of a the variable VALUE because it's a reserved word in System Builder. So I have this state

Re: [U2] Windows 2003, UniData 7.1.20: Please Explain This Message

Thanks Susan, you were correct. Al DeWitt Stylmark, Inc. 763.574.8705 (V) 763.574.1052 (F) adew...@stylmark.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Susan Lynch Sent: Tuesday, November 10, 2009 11:03 AM

[U2] Windows 2003, UniData 7.1.20: Please Explain This Message

I noticed in UDT.ERRLOG the following message: Tue Nov 10 09:25:05 Warning - The size of CFORDER (ino=207201, dno=2154331439, cwd=E:\AVANTE95\FLODATA\LIVE\LIVE.DATA) is approaching system limitation. According to Windows the size is 1,612,720kb in size and I know that the limit is 2-GB.What

[U2] What Next?

For the last 14 years or so I have been doing programming support and light DBA work; first in Universe (Prime Information) and now in Unidata (Pick). I'm basically a one-trick pony (UniBasic and System Builder) because my goal has always been to move into a business analyst role, but that has nev

[U2] UniData Dict Item Question

I don't do these enough to get this right in the first 10 or so tries. Can one of you more knowledgeable people tell me what's wrong with this Derived Value? V(IF BTC9000_MFGLOC1 = '' THEN 'CRB' ELSE IF BTC9000_MFGLOC1 = 'WAR' OR BTC9000_MFGLOC1 = 'CFB' THEN BTC9000_MFGLOC2 ELSE BTC9000_MFGLOC1)

[U2] Dictionary Help

UniData 6.1 + System Builder I have a COMBO box that got change way back when. Nobody knows way it was changed as the person who did has long since left the company. I want to revert it back to standard. However I want to know all the dictionary items that use it. I'm thinking I need to wr

[U2] Dictionary Help!

UniData 6.0.12. I'm trying to remember where there is list of subroutines I can use when creating v-descriptors/i-descriptors. Since I don't do it very often I have forgotten which manual they can be found in. Can anybody enlighten me? Thanks. Albert DeWitt Sr. Programmer Analyst Sty

[U2] ODBC Error

Has anybody know what this error means? SQL Status: IM985 Error code: 81001 [Ardent][UniData ODBC Driver][UniData RDBMS][IBM][SQL Client][RPC] error code = 81001 Albert L. DeWitt Jr. Senior Programmer Analyst Stylmark, Inc. (V) 763-574-8705 (F) 763-574-1052 [EMAIL PROTECTED] --

[U2] ODBC to Open Office

We are running UniData 6.0.12. We currently have ODBC and use it to import data into Excel. We are thinking of migrating to Open Office's Calc. What ODBC driver do I need to do this with? Anybody have any instructions? Thanks Albert L. DeWitt Jr. Senior Programmer Analyst Stylmark

RE: [U2] client ip

You can see it when using UniAdmin. Will this work? Al DeWitt Stylmark, Inc. 763-574-8705 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Craig Peterson Sent: Tuesday, June 06, 2006 1:43 PM To: u2-users@listserver.u2ug.org Subject: [U2] client ip Is

RE: [U2] Newbies need love too

g the consultant back for a week of solid level 1, level 2 training. I think that, along with all the help and advice you will get from the kind folks here will get your people through. My $.02 worth of advice. Al DeWitt Stylmark, Inc. 763-574-8705 -Original Message- From: [EMAIL PROTECTED] [m

RE: [U2] Sort help needed

ot found, POS will contain the position that the new value should be in so just use it. Don't override the value by setting it to zero. BobW > -Original Message- > From: [EMAIL PROTECTED] [mailto:owner-u2- > [EMAIL PROTECTED] On Behalf Of Al DeWitt > Sent: Monday, Novemb

[U2] Sort help needed

14,x>) and use that position to insert data into associated attributes. My problem is that I haven't done this in a while and when I did it was in Universe. So not only am I suffering a senior moment I'm dealing with a language barrier. Any help would be greatly appreciated. Thank

RE: [U2] Mixing flavors

"named" COMMON from DMSKELCODE. Al DeWitt --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

[U2] Mixing flavors

stand COMMON all that well. So do any of you run mixed systems? If so, what do you do to keep the flavors from stepping on each other? Thanks. Al DeWitt Stylmark, Inc. 763-574-8705 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

[U2] Formatting Data Update

Thanks to all your help I was able to finally get it working. However, it did mean that I had to compile as a BASICTYPE "U" and not as a BASICTYPE "P". I did this by writing a little paragraph that does the following: PA BASICTYPE "U" BASIC BP EPCS9010.4 CATALOG BP EPCS9010.4 DIRECT FORCE BASI

RE: [U2] Formatting Data

Part of the problem, I believe is that our ECLTYPE and BASICTYPE are P, Pick. Commands are not working the way I expect because I'm approaching this from a UV mindset (I can't help it, it's what I know). I'm being told that NEWLINE = FMT(TRIM(LINE),'55T') would turn 'Fourscore and seven years a

[U2] Formatting Data

Yesterday I posed the question about reformatting a multi-value down to l or more lines of no more than 55 characters each. I received some great suggestions, but I can't get them to work. The FMT command doesn't seem to want to return anthing more than the first 55 characters. Below I have mock

[U2] Formatting Help

" the reformatted value takes up so that if it's greater than the page length I can do a page eject and new headings before I print the value. I've never do this before so how should I approach this? Al DeWitt Stylmark, Inc. 763-574-8705 --- u2-users mailing list u2-users@li

[U2] Stopping HP Laser Printer line creep

after the PRINTER ON stmt and didn't seem to do anything when I placed it before. I have spend way too much time on this little project. Anybody have any suggestions? Going to Optio or Universe is not an option. Al DeWitt Stylmark, Inc. 763-574-8705 [EMAIL PROTECTED] --- u2-users mail

[U2] Copying _HOLD_ records to Windows folders

.REC = '' IF HOLD.REC THEN NEW.NAME = TRIM(HOLD.REC<1>[40,30]) WRITE HOLD.REC ON WINDOWS.FOLDER,NEW.NAME END I know I can't just 'write' it to the folder. But I know there has to be a way to do this through UniBasic. Any ideas? Thanks. Al DeWitt Stylma

[U2] DIR Function

_HOLD_ as records, not files. Am I correct? If so, is there no way find out the Date Modified of a file in the _HOLD_ folder? Al DeWitt Stylmark, Inc. 763-574-8705 [EMAIL PROTECTED] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/

[U2] File Creation Date

Using UniData 6.0.12 with SBClient. Print files that go to the _HOLD_ have an id that is the user id,port #, an underscore and a numerically ascending number. I want to write a program that changes the name to something more understandable. However, my users want me to save the original files so I

[U2] Creating a comma seperated flat file in UniData.

otten how to the command(s) to create a new flat file in an existing folder. So some examples would be helpful. Al DeWitt Stylmark, Inc. 763-574-8705 [EMAIL PROTECTED] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/

[U2] Monitoring a count of users logged on

otallogins=`/usr/ud60/bin/listuser |head -4| tail -1 |awk '{print $6}'` wwwlogins=`ps -eaf |grep udapi_slave |grep -v grep | wc -l |sed "s/ //g"` ssllogins=`ps -eaf |grep udtelnet |grep -v grep |wc -l |sed "s/ //g"` dat=`date` echo "TOT=$totallogins,WWW=$wwwlogins

[U2] Monitoring a count of users logged on

logged in. Is this something I can do via UniAdmin? Do I need to write a basic program and run it as a phantom? Thanks. Al DeWitt Stylmark, Inc. 763-574-8705 [EMAIL PROTECTED] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/