Rocket® U2 | UniVerse & UniData®

i am looking for information about XMAPAppendRec beyond what is published in the BASIC Extensions Version 11.3.3 document. Specifically, I am seeking details on why the serialized output to XML omits elements when the corresponding field value in the data base is empty. I am also curious about the function appearing to only process attribute 7 of dict items instead of processing attribute 8 for correlatives and attribute 7 for conversions. If I could just "look at" the source code for the function all my questions would be answered.------------------------------Brian ArnoldprincipalRocket Forum Shared Account------------------------------

[Rocket U2][U2ODBC][2300701]Error ID: 46  Severity: ERROR  Facility: DBCAPERR - UCI Error. Func: SQLFetch(XIO); State: S1000; U2 Database code: 20085; Msg: [U2][SQL Client][UNIVERSE]Program ".ITYPE.": pc = 6, "*PAID.AR.CALC012" is not in the CATALOG space. .".Back in November, I was able to get connected to this U2 database from SQL Server, PowerBI, and other tools using OLEDB and ODBC as outlined in this previous thread:Rocket U2 | UniVerse & UniData

Where could I find / how could I capture the output of a phantom started by a phantom?We have the code: EXECUTE 'PHANTOM ':TASKNAME CAPTURING EXECMSGE executed by a phantom program.Display statements in the first phantom are output as normal to its &PH& file.'EXECMSGE' contains "Phantom process started -nnnnn"The secondary process does its job, but any display statements are not written to any &PH& fileRunning the secondary process from TCL shows the display outputs at the terminalRunning the secondary process as a first phantom send displays  to &PH&.Running Universe 11.1.4 on Linux.. I'm not in a position to be able to change how it runs (but still need to support it)Thank you in advance for any help :)

I do LIST filename NAME   .... and got back results -- it was pulling Attribute 4 of the file.  Which, was just odd.  Turns out filename does not have a DICT called NAMEVOC does not have a DICT called NAMESO ... where did the system FIND this dict to display attribute 4?Once I installed a DICT called NAME In either DICT filename. or  VOC, it worked as expected.But still -- where was it looking to 'find' something called "NAME" that was returning attribute 4??THANKS!------------------------------David WolvertonIndependentSunset Programming IncWaltham MA US------------------------------

We had an unusual issue where it APPEARS Attb 2 of a DIR VOC type cannot exceed a certain length.LIST / SELECT both work as expected.However, AE using an Active SELECT list or just 'raw' would return "New Item" and anything Filed would issue a WRITE error (Status =1) with a 'check for triggers' message -- which cannot be true on UD DIR types.After a while of not figuring out the issue, we moved the folder to make Attb2 of the VOC shorter and viola - the issue resolved.Does anyone know the character count allowed in attribute 2 of a DIR VOC type?  And more weirdly, why is only AE was impacted?  We might have found the issue earlier if SELECT and LIST did not work either -- as it was, we were running down to see if there were some weird permissions issues - and was about 30 minutes in when we realized the path was much longer than usual do to where the folder had been nested.------------------------------

Want to prohibit users from using the DELETE Verb from tcl or the Command prompt, but want to be able to use DELETE from Unibasicif there a way that i can tell where the command is being executed fromUsing Unidata system ------------------------------robert modrichDeveloperRocket Forum Shared AccountTEMECULA CA US------------------------------

Greetings, all! We're running UniVerse 11.3.4 on AIX 7.2If I remember correctly from some previous posts, UniVerse has it's own embedded version of openssl that it uses instead of the AIX version.  If that is correct, is there a way to list (or somehow look up) the ciphers that UniVerse is using? We're making https (443) API calls to a middleware server (Windows-based, running Apache Tomcat) from within the UniVerse environment and we're getting the message:    This combination of host and port requires TLS.If we make the calls over http (80), they work just fine, but we need them to be over 443.Our network folks are thinking we might have a cipher conflict (one side or the other not using the same ciphers), but I don't know how to determine which ciphers UniVerse is using.  Any help with this would be greatly appreciated.  Or, if anyone has seen this issue before and knows the solution to the issue, that would be even better! 

Easter greetings to you  ,Anyone can point me to how to add fields that are in Universe are not showing in our SQL db tables. Please assist show steps to include the missing fields not found in SQL tables for easy access and reporting purposes. Thanks. ------------------------------Roland KayverCore Banking SupportTeachers Savings and Loan Society Limited------------------------------

I am trying to connect to an API and need some helpUsing RHEL 7 and Universe 11.3.4The curl example they provided works in RHEL. curl -X 'GET'   'https://stagingapi.vagustracker.com/CoreVagusAPI/trip/AvailableTrips?vagusAPIKey=1A2B3C-1533-CMBD-8537-123456789'   -H 'accept: text/plain' This is my BASIC Code      URL = "https://stagingapi.vagustracker.com/CoreVagusAPI/trip/AvailableTrips"      KEY = '1A2B3C-1533-CMBD-8537-123456789'      X = addAuthenticationRule(X.CONTEXT,2, "VerificationStrength", "generous")      X.DEPTH = 2      X.SERVER.OR.CLIENT = 2             ; * CLIENT      X.RTN.CODE = setAuthenticationDepth(X.CONTEXT, X.DEPTH, X.SERVER.OR.CLIENT)      X.RTN.CODE = addAuthenticationRule(X.CONTEXT, 2, "ServerName", "stagingapi.vagustracker.com")&nbs

I can capture output from LIST.READU command as follows:EXECUTE 'LIST.READU' CAPTURING OUTPUTEach row can be extracted by looping through using @am to determine number of rows my question is how can one parse out the individual column fields - what delimiter is used to do parsing oris  the  data in each row  simply fixed length.------------------------------robert modrichDeveloperRocket Forum Shared AccountTEMECULA CA US------------------------------

In UniVerse Basic, if we read a record, not present in a file, with locking (after each read the record is not unlocked), it looks like this: OPEN "VOC" TO VOC ELSE STOP 201,"VOC" READU RECORD FROM VOC,"LISTY" THEN    CRT "1: [":RECORD:"]" END ELSE   CRT "1: NOT ON FILE" END READU RECORD FROM VOC,"LISTY" THEN    CRT "2: [":RECORD:"]" END ELSE   CRT "2: NOT ON FILE" END READU RECORD FROM VOC,"LISTY" THEN    CRT "3: [":RECORD:"]" END ELSE   CRT "3: NOT ON FILE" END Running program, the result is: 1: NOT ON FILE 2: NOT ON FILE 3: NOT ON FILE and is as expected, but if we tray this in UniObjects ActiveX o UniObjects .Net, the result looks like this: 1: NOT ON FILE 2: [] 3: [] Oops!! The first read is as expected but the next reads return an empty record like exiting for the THEN clause rather ELSE. If we unl

Hello everyone, I am trying to parse a string against a pattern and return a delimited list of tokens.  OpenQM has a Parse() function but there is no equivalent in Universe that I can see.  Has anyone done something similar? For instance, if I have something like below: string = "Give me 97 bananas" tokens = Parse(string, "0X0N0X", Char(254)) I would like tokens variable to contain "Give me ":Char(254):"97":Char(254):" bananas" Any help or suggestions would be appreciates. ------------------------------Joseph von ArxSoftware DeveloperData Management Associates Inc DMACincinnati OH US------------------------------

ODBC Driver. Good day all, thanks for the help with the previous post. Its given me plenty to work on. Along with this, I've had another issue that has risen this week. When Live Partition Mobile'ing a AIX Server, we hit problems with the OCDB driver. Namely that the server moves live with no issue, until you restart UniVerse, then we get license problems. If the server is moved back to the original machine, the license problem still occurs. So it needs to be reset. Now I know that on our Redhat VMware environments this is not a problem, and I'm sure its something that I could fix, but before I re-invent the wheel, I figured I'd ask here. Thanks, ------------------------------Daniel Martin-CorbenRocket Forum Shared Account------------------------------

At Rocket Software we are committed to and value product security.  Rocket Software continually reviews security compliance policies and trends to strengthen our products. We've  recently implemented the Rocket Vulnerability Disclosure Program (VDP) as an added measure of vigilance.  This progr

In Unidata can you disable the LOGTO verb based upon a user login?------------------------------robert modrichDeveloperRocket Forum Shared AccountTEMECULA CA US------------------------------

What are all the valid ways to quote literal strings when assigning them to variables in unibasic on Unidata?------------------------------Shawn Waldieenterprise application developerRocket Forum Shared AccountLos Angeles CA US------------------------------

Any idea what this message means? In /data/pub/TEST/SMART/LIVE/CTLG/UOLOGIN at line 56 index: 201 to one dimension                                                                                                                                                              matrix is out of rangelobal HScript=`Set BackPages="18"`lobal HScript=`Set Columns="132"`xecute HScript ------------------------------David Rivera------------------------------

Good day, I am trying to connect to a Universe database using ODBC and have set up my DSN. However when testing the ODBC DSN or opening an ODBC connection to that DSN from C# results in the following error message. System.Data.Odbc.OdbcException: 'ERROR [00000] [Rocket U2][U2ODBC][0302086]Error ID: 46  Severity: ERROR  Facility: DBCAPERR - UCI Error. Func: SQLExecDirect(); State: S1000; U2 Database code: 950088; Msg: [U2][SQL Client][UNIVERSE]UniVerse/SQL: syntax error.  Unexpected symbol.  Token was "?". Scanned command was CALL "*HS.SCHEMA" ( ? .ERROR [00000] [Rocket U2][U2ODBC][0302086]Error ID: 46  Severity: ERROR  Facility: DBCAPERR - UCI Error. Func: SQLExecDirect(); State: S1000; U2 Database code: 950088; Msg: [U2][SQL Client][UNIVERSE]UniVerse/SQL: syntax error.  Unexpected symbol.  Token was "?". Scanned command was CALL "*HS.SCHEMA" ( ? .[Rocket U2][U2ODBC][0400182]Connection not open.' I unfort

Our ERP vendor is suggesting that the following compilation errors stem from "...a known UniBasic limitation on the number of constants. Tech Note 1193075 on Rocket Software's support site explains that there is a limit to the number of variables and constants that can be used in a BASIC program. The limits are 32767 variables and 32765 constants. However, the maximum space that constants can take up in a program is 50,000 bytes and this figure is reduced by the actual number of constants." too many constants near line 115 of...too many constants near line 121 of...too many constants near line 149 of...too many constants near line 149 of... However, all that is required to get past it is is commenting out the following variable assignment, which suggests to me that there is something the string that is freaking out the compiler: X.XML.LINE = '<w:p w14:paraId="50845D62" w14:

Hello  I am doing some testing , and I wanted to use a u2 acocunt that i have in other box, so i don't have to copy the thing  i am getting this error, when a try to ub\\bin : Problem determining if file VOC is an NFS file. the share is ro, nfsv4 in origin . Readonly is a must since i dont want to mess anything by mistake  any ideas out there ?  thanks in advance  ------------------------------David Ricardo Lopez BonaecheaDirector of Software StrategyQuiter Servicios Informaticos SLSantander ES------------------------------

On unidata 8.2.1 My objective is to assign a string of characters (xml code) to a variable, and then write said variable as a record on a sequential file.  However, I get the following error when attempting to compile the program if the length of the string exceeds  ~2K (I'm not certain of what that limit is precisely): It will successfully compile as long as I break up the string in chunks that stay under the limit. However, the same program has no issues reading in a string, the length of which is over 80K characters. Any suggestions would be appreciated.------------------------------Shawn WaldieManager, Enterprise Application DevelopmentRocket Forum Shared AccountLos Angeles CA US------------------------------

Does Rocket / Universe support converting a base64 string to a .PNG file and routing that file item to a label printer? Any advice or direction would be appreciated. ------------------------------Jim ScottSenior Programmer/AnalystGardens AliveLawrenceburg IN US------------------------------

Hello  I would like to know, what is the position regarding NUMA enabled / disabled for a Universe database ?  It is well documented for other databases, and we would like to know if Universe is NUMA aware and what is the preferred configuration on or off.  We are talking about boxes with  512GBB RAM, 64 CPUS, and 2 NUMA nodes  thanks in advance  ------------------------------David Ricardo Lopez BonaecheaDirector of Software StrategyQuiter Servicios Informaticos SLSantander ES------------------------------

Hey All, We updated to unidata 8.2 from 8.1, and seem to have broken ssh. Everything seems fine when called from an AIX session, but Unidata sessions are failing when calling same commands... we do recieve the above message X.COMMAND = '-C !scp N19.POSPA…CALL S.EXECUTE(X.COMMAND) This code has been running for years, so any idea on where I should look? Thanks! Rick------------------------------Rick BrownSysadminRocket Forum Shared Account------------------------------

Hi guys - here with a pretty basic question... I am on universe 11.3.4 on linux redhat. We use AWForms here but that app was not able to give me what I wanted so I just wrote the report - but this company does not have a separate printer queue defined for a landscape print(which is what I'm used to). I tried using the printer command within the program but it just prints my characters: PRINT CHAR(27):"&l1O" Can someone tell me the simplest way to flip a report automatically to landscape?------------------------------Kathleen HambrickProgrammer at Colwell------------------------------