Hey all-

I've managed to locate the Unidata Dictionary, Commands, Basic and Administrator manuals. But, after years of being on other platforms, I'm really struggling with queries and report formatting in UniData. Operators like BY-EXP, ID.SUPP, HEADING, etc, keep popping into my recollection, but I'm still having a difficult time with syntax and order. 

The UniBasic manual helps to some extent, but I'm hoping there might be a more in-depth Manual (or training) specific to creating and formatting reports from ECL.

thanks in advance for any assistance-

Rich

Richard was asking about the syntax for formatting which is essentially the same in both RetrieVe and UniVerseSQL statements except the SQL must use single quotes around the arguments.

Google Guide To RetrieVe

I use both the IBM and Rocket documentation as they cover aspects of UniVerse differently. I've spent a lot of time searching pdf documents for what I need to know and often rely on looking at my own examples now.

Things like FMT "20L" go straight after the field they relate to while those relating to the whole statement (NO.PAGE, HDR.SUPP, HEADER etc) go at the end.

Personally I find SQL's GROUP BY  and UNNEST a lot more useful than RetrieVe's BY.EXP

If you use UniVerseSQL with multivalues, make sure you understand the difference and how to use WHERE and WHEN clauses.

The JOIN capabilities are very limited and often perform poorly. Using TRANS () in the DICT of the main file is a better solution to connecting data from other files. EVAL is useful for this for ad hoc queries.

BTW For easier reporting and interfacing with other databases, I set up file based UniVerse as an ODBC linked server from MS SQL Server. Four part naming is supported if you configure it correctly and reaslise there is no schema, but they drag the whole table over.

OPENQUERY is better if you can use a where clause to reduce the number of records selected. The ODBC is single threaded, one connection at a time, so using Temp tables is often necessary for good performance on complex queries.

Native queries are supported via ODBC, are slightly faster then plain OPENQUERY, and don't required the HS configuration, but be aware you need to use the DICT names for the SQL while the column names returned are those defined in F4 of the DICT items unless you alias them in the SQL.
------------------------------
Greg Clitheroe
Rocket Forum Shared Account

Hey all-

I've managed to locate the Unidata Dictionary, Commands, Basic and Administrator manuals. But, after years of being on other platforms, I'm really struggling with queries and report formatting in UniData. Operators like BY-EXP, ID.SUPP, HEADING, etc, keep popping into my recollection, but I'm still having a difficult time with syntax and order. 

The UniBasic manual helps to some extent, but I'm hoping there might be a more in-depth Manual (or training) specific to creating and formatting reports from ECL.

thanks in advance for any assistance-

Rich

The thing you want is called UniQuery Commands Reference. 

For 8.2.4 the Book number: UDT-824-UNQR-1

Should be available with the rest of your U2 documentation.

Thanks Elaine. I'm locating and downloading these manuals piecemeal. Should I have expected a link to all with my product purchase?

Rich

If you have an RBC login it's under Resources, Product Availability. If I remember right (which I probably don't) there used to be a zip file with all the downloadable docs from that page. Now it seems to point to Rocket Software Documentation

The links you get in the license details are to download and authorize the product. No doc link that I know of but maybe someone from Rocket will chime in.

i

All the docs moved to being on line over a year ago, since then we have not added them in the old way we used with the product download. Follow the link below. From the online version you can download a whole manual or just a particular subject with the manual.

https://docs.rocketsoftware.com/

Exactly what I was looking for.
Thanks much, Jonathan and Elaine.

------------------------------
Richard Lucibella
Director
Rocket Forum Shared Account
------------------------------