[U2] Simple question - selecting and listing records
Hello, I have a quick question regarding listing multivalued fields. I hope the formatting is retained on this email so my example doesn't get confusing. This file is structured for multiple credit card entries under one @id. How can I alter my LIST command to only show the entries for the date specified? I tried using when in both the LIST and SELECT statements but didn't get the results I was looking for. I feel like I'm missing something really basic. Thanks in advance. }SELECT CREDITCARD.FILE WITH PMT.DATE EQ 11/19/2013 303 record(s) selected to SELECT list #0. }}LIST CREDITCARD.FILE PACKET STATUS TRACKING.ID PMT.DATE CREDITCARD.FILE PACKET.. STATUS. TRACKING ID. PMT DATE.. 5215216252152162 APPROVED25D6TGCD 11/19/2013 52152162 12/31/2013 52152162 01/31/2014 52152162 02/28/2014 52152162 03/31/2014 52152162 04/30/2014 52152162 05/30/2014 52152162 06/30/2014 52152162 07/31/2014 52152162 08/29/2014 52152162 09/30/2014 52152162 10/31/2014 5643649556436495 APPROVED259l17j2 02/18/2013 56436495 APPROVED25a0hfg7 03/18/2013 56436495 APPROVED25adf4bt 04/18/2013 56436495 APPROVED25ar1ofv 05/20/2013 56436495 APPROVED25b7a92o 06/18/2013 56436495 APPROVED25bk0tpv 07/18/2013 56436495 APPROVED25c11rl1 08/19/2013 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Simple question - selecting and listing records
You may be right :) I do no programming with this system, I'm just an end user that's trying to understand better. Field. Type Field Conversion.. Column. Output Depth Name.. Field. Definition... Code Heading Format Assoc.. Number @IDD0CREDITCARD.FILE 10L S PACKET D2PACKET 8R M STATUS D 10STATUS 15L M TRACKING.IDD9TRACKING ID 20L M PMT.DATE D7 D4/ PMT DATE10R M As far as WHEN clause, I tried: list creditcard.file packet status tracking.id pmt.date when pmt.date eq 11/19/2013 and it sorts those dates to be the first results, but it still lists all the other card entries on that packet before moving to the next record. Is this just a consequence of how the creditcard.file is set up? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, November 19, 2013 12:06 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Simple question - selecting and listing records Could you post the exact statement you're using with the WHEN clause, a and also the contents of the DICT items? I suspect one or more of them is not actually setup as a multivalued field -Original Message- From: Hilk, Brandon brandon.h...@iqor.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, Nov 19, 2013 8:29 am Subject: [U2] Simple question - selecting and listing records Hello, I have a quick question regarding listing multivalued fields. I hope the formatting is retained on this email so my example doesn't get confusing. This file is structured for multiple credit card entries under one @id. How can I alter my LIST command to only show the entries for the date specified? I tried using when in both the LIST and SELECT statements but didn't get the results I was looking for. I feel like I'm missing something really basic. Thanks in advance. }SELECT CREDITCARD.FILE WITH PMT.DATE EQ 11/19/2013 303 record(s) selected to SELECT list #0. }}LIST CREDITCARD.FILE PACKET STATUS TRACKING.ID PMT.DATE CREDITCARD.FILE PACKET.. STATUS. TRACKING ID. PMT DATE.. 5215216252152162 APPROVED25D6TGCD 11/19/2013 52152162 12/31/2013 52152162 01/31/2014 52152162 02/28/2014 52152162 03/31/2014 52152162 04/30/2014 52152162 05/30/2014 52152162 06/30/2014 52152162 07/31/2014 52152162 08/29/2014 52152162 09/30/2014 52152162 10/31/2014 5643649556436495 APPROVED259l17j2 02/18/2013 56436495 APPROVED25a0hfg7 03/18/2013 56436495 APPROVED25adf4bt 04/18/2013 56436495 APPROVED25ar1ofv 05/20/2013 56436495 APPROVED25b7a92o 06/18/2013 56436495 APPROVED25bk0tpv 07/18/2013 56436495 APPROVED25c11rl1 08/19/2013 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [JOB] Epicor is now in Denver?
They have a building just outside Minneapolis as well. Not sure which business units belong to which campuses. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Monday, October 28, 2013 12:03 PM To: u2-users@listserver.u2ug.org Subject: [U2] [JOB] Epicor is now in Denver? http://www.linkedin.com/jobs2/view/9263360?trk=rj_em I had them in a place called Yardley PA. Did they move? Or do they have multiple programming centers? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [JOB] in Colorado ?
iQor! Well that just so happens to be the banner I'm flying under right now. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Richard Lewis Sent: Tuesday, September 17, 2013 12:57 PM To: U2 Users List Subject: Re: [U2] [JOB] in Colorado ? After glancing over the posting to which you linked, at the bottom I find: To be considered for this role, please visit our website by clicking here (Insert hyperlink to www.iqor.com under here), click the CAREERS tab at the top of the page à United States à Universe Software Developer (New York, NY). There, you will apply for the position by clicking the Apply Online button at the top of this page where you will submit a cover letter, including your salary requirements, plus your resume. Please submit as a PDF, if possible. Seems like perfect instructions to me. On Tue, Sep 17, 2013 at 11:46 AM, Wjhonson wjhon...@aol.com wrote: I'm sure it's just me, but really if *I* were to post a job ad, I would at least tell people how to respond to it http://www.intl-spectrum.com/Multivalue_jobs.aspx No phone number, no address, no email, no way to actually respond. Unless Spectrum is now taking and forwarding resumes ? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Select from one file with save-list from another file
Thanks everyone, I've got some usable info to work with. Sorry if my original post was a bit vague, let me illustrate to clarify: X.INFO @PACKET.ID.NAME..DOB...STATUS 52781456.52781456..DOE, JOHN.06-17-1985CCC Y.INFO @BILL.DAY..BILL.AMT..TYPE..PACKET.ID 52781456*MPA*2...08/28/201350MPA...52781456 Hopefully showing a rough table structure helps me better convey what I was trying to do. Using criteria in X.INFO to create a selection list and then using that list to select and export information from Y.INFO like BILL.DAY and BILL.AMT that wasn't available in X.INFO. Since a select list made from X.INFO would have different record ID's, it wouldn't be able to be used to select from Y.INFO. Hence, me looking for some trickery to use Y.INFO's PACKET.ID field as the array for the select list to work against. Brandon -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On 8/27/2013 1:24 PM, Hilk, Brandon wrote: Hello! UniVerse 10.1, HP/UX, Pick. Is there a way I can build a save-list from a selection from one file X.INFO (where the record ID is an 8 digit number) and use that list to select from file Y.INFO (where that 8 digit number is not the record ID but does exist as a foreign key elsewhere in the file). In SQL this would be considered a join and would look something like this: select * from X.INFO, Y.INFO where X.INFO.packet.id=Y.INFO.packet.id and X.INFO.status='ccc'; I can run this in TCL and have it return the results I want but can't build a save-list from it because I don't know the UniVerse/SQL syntax to do so. So to summarize, is there a way to use a save-list built from X.INFO to make another save-list comprised of the record ID's from Y.INFO? Thanks for any advice you can give. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Select from one file with save-list from another file
Not myself, no. I could get with the programming staff and ask them to create fields in X.INFO that have the Y.INFO values that I need, but seems like a cop-out :) They are a grumpy bunch and if I have the ability to bypass them by writing a convoluted series of select statements then that would be my preferred route of action :) If there's no way to do it without programmer intervention then so be it. Thanks -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, August 28, 2013 10:51 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Select from one file with save-list from another file Do you have the ability to create new DICT entries in both X.INFO and Y.INFO ? -Original Message- From: Hilk, Brandon brandon.h...@iqor.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Aug 28, 2013 8:09 am Subject: Re: [U2] Select from one file with save-list from another file Thanks everyone, I've got some usable info to work with. Sorry if my original post was a bit vague, let me illustrate to clarify: X.INFO @PACKET.ID.NAME..DOB...STATUS 52781456.52781456..DOE, JOHN.06-17-1985CCC Y.INFO @BILL.DAY..BILL.AMT..TYPE..PACKET.ID 52781456*MPA*2...08/28/201350MPA...52781456 Hopefully showing a rough table structure helps me better convey what I was trying to do. Using criteria in X.INFO to create a selection list and then using that list to select and export information from Y.INFO like BILL.DAY and BILL.AMT that wasn't available in X.INFO. Since a select list made from X.INFO would have different record ID's, it wouldn't be able to be used to select from Y.INFO. Hence, me looking for some trickery to use Y.INFO's PACKET.ID field as the array for the select list to work against. Brandon -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On 8/27/2013 1:24 PM, Hilk, Brandon wrote: Hello! UniVerse 10.1, HP/UX, Pick. Is there a way I can build a save-list from a selection from one file X.INFO (where the record ID is an 8 digit number) and use that list to select from file Y.INFO (where that 8 digit number is not the record ID but does exist as a foreign key elsewhere in the file). In SQL this would be considered a join and would look something like this: select * from X.INFO, Y.INFO where X.INFO.packet.id=Y.INFO.packet.id and X.INFO.status='ccc'; I can run this in TCL and have it return the results I want but can't build a save-list from it because I don't know the UniVerse/SQL syntax to do so. So to summarize, is there a way to use a save-list built from X.INFO to make another save-list comprised of the record ID's from Y.INFO? Thanks for any advice you can give. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Select from one file with save-list from another file
Hello! UniVerse 10.1, HP/UX, Pick. Is there a way I can build a save-list from a selection from one file X.INFO (where the record ID is an 8 digit number) and use that list to select from file Y.INFO (where that 8 digit number is not the record ID but does exist as a foreign key elsewhere in the file). In SQL this would be considered a join and would look something like this: select * from X.INFO, Y.INFO where X.INFO.packet.id=Y.INFO.packet.id and X.INFO.status='ccc'; I can run this in TCL and have it return the results I want but can't build a save-list from it because I don't know the UniVerse/SQL syntax to do so. So to summarize, is there a way to use a save-list built from X.INFO to make another save-list comprised of the record ID's from Y.INFO? Thanks for any advice you can give. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Select from one file with save-list from another file
Very nifty Allen, thank you! Unfortunately, I'm a mere user in my
organization and not a programmer, so I don't have UniVerse permissions
to compile programs or even run the editor.
*sigh* Alas.
I hope someone else is able to utilize your program.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Allen Elwood
(TW)
Sent: Tuesday, August 27, 2013 3:51 PM
To: U2 Users List
Subject: Re: [U2] Select from one file with save-list from another file
i made a relational selection program many many moons ago - i'm retired
now - thanks to a crushed right hand i can only type with the left hand
which goes numb quickly thanks to an elbow injury
but i keep the code around and lurk on the list just in case :-)
* RSELECT - Relational File Selection Utility
* Usage:
* RSELECT LIST1 FILENAME ATTRNBR LIST2
Version=~Ver=~7.0.10~362202866~
*#* COPY COPY.TOOLS.BP STANDARD.VARIABLES.1 (REPLACING PGM.NAME BY
RSELECT, FN.NAME BY RSELECT, IO.OPEN.OPTS BY TERM.DATA:LOCK) ;*#* Copied
Source Follows (06-25-03)
$INCLUDE STANDARD.COMMON.VARIABLES FROM COPY.TOOLS.BP
$INCLUDE STANDARD.COMMON.APP.PROGRAMS FROM COPY.TOOLS.BP
$INCLUDE STANDARD.VARIABLES.END FROM COPY.TOOLS.BP
PGM.NAME='RSELECT'; FN.NAME ='RSELECT'
CALL IO.OPEN('TERM.DATA:LOCK',PASSWORDS)
*#*
*===
=
GOSUB GET.OPTIONS
GOSUB DETERMINE.TEMP.FILESIZE
GOSUB LOAD.TEMP.FILE
GOSUB CREATE.TEMP.DICT
GOSUB BUILD.LIST2
GOSUB FINISH.UP
STOP
*===
=
GET.OPTIONS:
PRINT 'Enter END at any prompt to abort'
PRINT
PRINT 'Enter Source List Name : ':;INPUT LIST1
IF LIST1 = 'END' THEN STOP
PRINT 'Enter the Selection Filename : ':;INPUT FILENAME
IF FILENAME = 'END' THEN STOP
PRINT 'Enter the Selection Attribute Number : ':;INPUT ATTRNBR
IF ATTRNBR = 'END' THEN STOP
PRINT 'Enter the Destination List Name : ':;INPUT LIST2
IF LIST2 = 'END' THEN STOP
PRINT
LOOP
PRINT 'Continue? (Y/END)':;INPUT YORN
IF YORN = 'END' THEN STOP
IF YORN = 'Y' THEN EXIT
REPEAT
RETURN
*===
=
DETERMINE.TEMP.FILESIZE:
MSG = 'GET.LIST ':LIST1
PERFORM MSG CAPTURING JUNK
SELECTION = @SYSTEM.RETURN.CODE
TBYTES= 0
LOOP WHILE READNEXT ID DO
TBYTES+=LEN(ID)
REPEAT
TEMP.MOD = INT(TBYTES/1024)
IF TEMP.MOD 1 THEN
TEMP.MOD = 5
END
TEMP.NAME = 'RSELECT':PROCESS.ID
MSG = 'CREATE.FILE ':TEMP.NAME:' ':TEMP.MOD
PERFORM MSG CAPTURING JUNK
OPEN '', TEMP.NAME TO TEMP.HANDLE ELSE PRINT 'Internal processing
error';STOP
OPEN 'DICT', TEMP.NAME TO TEMP.DICT ELSE PRINT 'Internal processing
error';STOP
RETURN
*===
=
LOAD.TEMP.FILE:
MSG = 'GET.LIST ':LIST1
PERFORM MSG CAPTURING JUNK
NADA = ''
LOOP WHILE READNEXT ID DO
WRITEV NADA ON TEMP.HANDLE, ID, 0
REPEAT
RETURN
*===
=
CREATE.TEMP.DICT:
DREC = ''
DREC1 = 'I'
DREC2 = 'TRANS(':TEMP.NAME:',F':ATTRNBR:',F0,X)'
DREC4 = 'Temporary Trans Dict'
DREC5 = '25L'
WRITE DREC ON TEMP.DICT, TRAN.DICT
DREC = ''
DREC1 = 'D'
DREC2 = ATTRNBR
DREC4 = 'Temprary Base Dict'
DREC5 = '25L'
DID = F:ATTRNBR
WRITE DREC ON TEMP.DICT, DID
RETURN
*===
=
BUILD.LIST2:
PRINT 'Now creating list ':LIST2
MSG = 'SELECT ':FILENAME:' WITH TRAN.DICT GT USING DICT ':
TEMP.NAME
PERFORM MSG
PERFORM 'SAVE.LIST ':LIST2
RETURN
*===
=
FINISH.UP:
CLOSE TEMP.HANDLE
CLOSE TEMP.DICT
MSG = 'DELETE.FILE ':TEMP.NAME
DATA 'Y'
PERFORM MSG CAPTURING JUNK
PRINT 'Program Completed'
RETURN
On 8/27/2013 1:24 PM, Hilk, Brandon wrote:
Hello!
UniVerse 10.1, HP/UX, Pick.
Is there a way I can build a save-list from a selection from one file
X.INFO (where the record ID is an 8 digit number) and use that list to
select from file Y.INFO (where that 8 digit number is not the record
ID
but does exist as a foreign key elsewhere in the file). In SQL this
would be considered a join and would look something like this:
select *
from X.INFO, Y.INFO
where X.INFO.packet.id=Y.INFO.packet.id
and X.INFO.status='ccc';
I can run this in TCL and have it return the results I want but can't
build a save-list from it because I don't know the UniVerse/SQL syntax
to do so.
So to summarize, is there a way to use a save-list built from X.INFO
to
make another save-list comprised of the record ID's from Y.INFO?
Thanks for any advice you can give
