Stack Overflow
Stack Overflow

Questions tagged [uniquery]

UniQuery is the database query language supported by UniData.

UniQuery is the database query language supported by UniData.

Useful links:

20 questions
2
votes
3 answers

In UniQuery, how do you get the count of unique values found while doing a BREAK.ON

I know I can get the counts for how many individual entries are in each unique groups of records with the following. LIST CUSTOMER BREAK-ON CITY TOTAL EVAL "1" COL.HDG "Customer Count" TOTAL CUR_BALANCE BY CITY And I end up with something like…
Script Wolf
  • 106
  • 2
  • 12
2
votes
1 answer

UniData - record count of all files / tables

Looking for a shortcut here. I am pretty adept with SQL database engines and ERPs. I should clarify... I mean databases like MS SQL, MySQL, postresql, etc. One of the things that I like to do when I am working on a new project is to get a feel for…
MrGoodfix
  • 317
  • 2
  • 14
2
votes
3 answers

Sanitize Input for UniData

Can anyone provide a function to sanitize input for a UniData query? Or provide a list of things to remove?
Ronnie Overby
  • 45,287
  • 73
  • 267
  • 346
2
votes
2 answers

How to do a UniData Case Insensitive Search with Uniquery

Unfortunately I have to do some interaction with IBM's UniData database system. I am doing this from c# code with UniObjects for .net. I am building an ASP.NET search page that has a single search box. The problem I am having is that the criteria is…
Ronnie Overby
  • 45,287
  • 73
  • 267
  • 346
1
vote
2 answers

UniData UniQuery - two WITH

Alright I have little to no knowledge of SQL language, and am wondering what are the possible reasons for the slowness of two WITH vs one WITH in unidata. Database has around ~1 million rows. Ie/ SELECT somewhere WITH Column1 = "str" AND WITH…
Phoenix
  • 23
  • 4
1
vote
2 answers

In a Paragraph can we use the results of a SELECT statement in another SELECT criteria?

Within a paragraph, is there a way to take the results of one SELECT statement and use them in another SELECT statement? For example, if I have the following SELECT statement: SELECT PROGRAM.REQ WITH CREDITS GT 0 AND CREDITS LT 15 SAVING UNIQUE…
Jeremy
  • 23
  • 4
1
vote
2 answers

UniQuery - How to find the largest length of a field in a file

I'm trying to figure out how to find the largest length of records for a field in a file on a Unix-based Unidata database in a Manage2000 (M2k) MRP system. I currently have the "Using Uniquery" and "Uniquery Command Reference" both for v7.2 and the…
Ken Stulce
  • 23
  • 1
  • 5
1
vote
2 answers

UniQuery LIST without page breaks

This should be simple but it's just not working. I have a list of records that I want to display in the terminal without anything besides the list of record keys. No Headers, page gaps, etc. The problem is I can't get rid of the page gaps that keep…
Script Wolf
  • 106
  • 2
  • 12
1
vote
1 answer

Best way to handle Uniquery and identity autoincrement cloumn of a postgresql Table

I get this error: field "bankid" must have a value. For solving this I must add the field using Uniquery Fields editor and set "required" property to False, also autogeneratedvalue to arAutoInc . Is it the only way doing this?adding fields to…
Shahram Banazadeh
  • 500
  • 1
  • 5
  • 15
1
vote
1 answer

Question about taking sample and saving data from U2 files with headers

Relative newbie to using Uniquery. I've found some helpful documentation and answers from prior users posting here, and on other sites. I'm trying to document what we have in our U2 files, as we are exploring options to migrate historical data…
JasonC
  • 13
  • 2
1
vote
1 answer

How to select by elements in a UniData multivalued field

I'm trying to do an ad hoc search of records that contain duplicate values in the first and second elements of a multivalued UniData field. I was hoping something like this would work but I'm not having any luck. LIST PERSON WITH EVAL "STATUS[1] =…
Script Wolf
  • 106
  • 2
  • 12
1
vote
2 answers

How to pass current date from one UniQuery paragraph to another

How can I pass the current date from one PA to another in UniQuery? A colleague taught me the trick of having the date written by cron to a file and using a inline prompt to read it with <>, but that adds extra parts that can…
Script Wolf
  • 106
  • 2
  • 12
1
vote
2 answers

Show UniData SELECT results that are not record keys

I'm looking over some UniData fields for distinct values but I'm hoping to find a simpler way of doing it. The values aren't keys to anything so right now I'm selecting the records I'm interested in and selecting the data I need with SAVING UNIQUE.…
Script Wolf
  • 106
  • 2
  • 12
0
votes
0 answers

How to get InsertedID from UniQuery's UpdateSQLs statement

I am using Uniquery in delphi-rio. UniQuery's SQL.Text is: Select ID, Column1 From Table Here ID is an auto-incrementing ID. The insert statement in UpdateSQLs is: INSERT INTO table (Column1) VALUES (:Column1) SET :ID = SCOPE_IDENTITY() After…
jeongSoo
  • 1
0
votes
1 answer

UniData Concatinate in SELECT

I need to search on the concatenated data in UniData using UniQuery. what are my options? Something like below: SELECT CUSTOMER.DETAILS WITH (FIRSTNAME:LASTNAME) = "????" Basically below is search criteria: FIRSTNAME + LASTNAME = ? Cheers
Barsham
  • 749
  • 8
  • 30
1
2