, August 31, 2012 4:49 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Friday type of question
In the DICT, in an I-descriptor you can specify LEN(@RECORD) If the record has
zero length it's empty.
-Original Message-
From: Morelli, David W. dmore...@pacificu.edu
To: U2 Users List
Is there an easy way to determine if a record is empty?
I have a saved list of a thousand or more records that have record ID's that
interfere with our Ellusian database.
If they are truly empty, I can do house cleaning on them. If they contain any
data, I have to do a different process.
Will your statements support something in the nature of :
SELECT
... ,
a.PID
, ...
FROM (
SELECT
... ,
substring(colname ,charindex('|',colname)+1, charindex('|',colname,
charindex('|',colname)+1) - charindex('|',colname) -1) as PID
, ...
FROM dbo.table
) a
WHERE PID = Selection
Thank you. The 'word'... format is the answer to a question that had
me banging my head yesterday.
David Morelli, UIS/Datatel Team
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Andre Meij
Sent: Wednesday, May 30, 2007 5:10 PM
To:
Is the audit trail allowed to keep a sorted list of rollback numbers?
Open a process
Request a number
...
If rollback Insert the number into the Rollback List
Else save record
Close process
Or if the goal is to consume all sequential numbers.
Open a process
Request the lowest number
I love learning new things! I had never thought that MV ID were treated this way by a
savedlists.
I can duplicate Philippe's results as he is using a common UniData application.
PST.ROOM.ASSIGNMENTS is a MV field.
SELECT PERSON.ST '0044560'
SELECT PERSON.ST SAVING UNIQUE PST.ROOM.ASSIGNMENTS
for example:
... EVAL OCONV(ARPI.AMT*100/3, 'MD12') CONV FMT 10R ...
and it will do what you expect. (The above is for UniVerse, but I hope
it will be similar for UniData.)
Regards
Thomas
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Morelli, David
Sent
I have seen little or no activity on [EMAIL PROTECTED]
since the changeover. Wouldn't this thread have belonged there?
David Morelli, UIS/Datatel Team
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Wednesday, May 05, 2004 8:39