Re: [U2] SQL a possibility?
For the SAVING syntax to work, you need to use a Pick-like flavour version of SELECT. Something like this: ASELECT 0001 V 0002 SELECT 0003 Q 0004 GHKSXA Note the A processor mode in attribute 4. HTH Brett George Gallen ggal...@wyanokegroup.com wrote in message news:6d57ef06d84b5541af530227504bb68f58c8daf...@34093-mbx-c06.mex07a.mlsrvr.com... -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2- us...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Thursday, April 02, 2009 4:21 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] SQL a possibility? George NowHow can I put that data into a saved-list? (Using either TCL or SQL?) for that matter, how do you save a list using SQL on Universe? I tried creating a view, but was told I had to create a schema in order to create tables...that's no fun... SQL - SELECT SWITCHIT TO SLIST 0 FROM FILENAME WHERE @ID = 'somename'; This gave me an error, about not being able to use a multivalued field.. RetrieVe - SELECT FILENAME somename SAVING SWITCHIT This did not work, instead of giving me a listing of just the ID, it saved the original line without parsing. Both create active select lists you can then SAVE.LIST. Brian --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] SQL a possibility?
SQL - SELECT SWITCHIT TO SLIST 0 FROM FILENAME WHERE @ID = 'somename'; This gave me an error, about not being able to use a multivalued field.. Sorry forgot it was multivalued. For the record: SELECT SWITCHIT TO SLIST 0 FROM UNNEST FILENAME ON SWITCHIT WHERE @ID = 'somename'; Brian --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] SQL a possibility?
Yes...that worked (After created the ASELECT as below).
ASELECT FILENAME ITEMNAME SAVING SWITCHIT
SAVE-LIST listname
DICT FILENAME SWITCHIT
0001: I
0002: CONVERT(REUSE(@AM),REUSE(@VM),@RECORD) ; FIELDS(@1,REUSE(,),REUSE(1)) ;
CONVERT(REUSE('# '),REUSE(''),@2)
0003:
0004: DATA
0005: 20L
0006: M
Saved the first column of the csv item, after removing any /# or spaces.
George
-Original Message-
From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-
us...@listserver.u2ug.org] On Behalf Of Brett Callacher
Sent: Friday, April 03, 2009 4:58 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] SQL a possibility?
For the SAVING syntax to work, you need to use a Pick-like flavour
version of SELECT. Something like this:
ASELECT
0001 V
0002 SELECT
0003 Q
0004 GHKSXA
Note the A processor mode in attribute 4.
HTH
Brett
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] SQL a possibility?
George NowHow can I put that data into a saved-list? (Using either TCL or SQL?) for that matter, how do you save a list using SQL on Universe? I tried creating a view, but was told I had to create a schema in order to create tables...that's no fun... SQL - SELECT SWITCHIT TO SLIST 0 FROM FILENAME WHERE @ID = 'somename'; RetrieVe - SELECT FILENAME somename SAVING SWITCHIT Both create active select lists you can then SAVE.LIST. Brian I could open a como file, list the output with no headings close the como file, edit it clean, the form-list the como file (work around 1) George --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] SQL a possibility?
I Didn't really want to do that. I opted for the COMO solution, then
used the editor to delete out all the TOF's, then saved what was left
in SAVEDLISTS. At that point I did a GET.LIST, followed by a SELECT
on the file that the ID's were to point to. This weeded out all of the
blank lines that the editor was not able to remove.
Moving over to Excel and deleting columns would have been choice #2
George
-Original Message-
From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-
us...@listserver.u2ug.org] On Behalf Of Ron Hutchings
Sent: Wednesday, April 01, 2009 10:30 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] SQL a possibility?
If you can move between your PC and the server. Open the spreadsheet,
delete
all the columns you don't want, save the one column as a text file,
move the
file back to the server in SAVEDLISTS and you have created a list.
From: ggal...@wyanokegroup.com
To: u2-users@listserver.u2ug.org
Date: Wed, 1 Apr 2009 16:21:28 -0500
Subject: [U2] SQL a possibility?
I'm trying to save the first field of a .csv file to a select list,
Yes, I
can
write a program,
but I also wanted to try to do it on the fly.
Using UV10.0.2 , unix on Information format
The source data looks like:
'#12345566#','first','last',.
'#12344555#','first','last',.
Basically, field one has the item ID of another file.
The source file gets read into a tempory file input file
I created an I-desc of the following:
SWITCHIT
0001: I
0002: CONVERT(REUSE(@AM),REUSE(@VM),@RECORD) ;
FIELDS(@1,REUSE(,),REUSE(1))
;
CONVERT(REUSE('# '),REUSE(''),@2)
0003:
0004: DATA
0005: 20L
0006: M
The above will convert the whole record into one mutlivalue
attribute,
then strip off the first field delimited by the ,
then strip out the # ,' and spaces
LIST FILENAME ITEMNAME SWITCHIT ID-SUPP will list to the screen
exactly
what
I want
and so does
SELECT SWITCHIT FROM FILENAME WHERE @ID = 'ITEMNAME';
NowHow can I put that data into a saved-list? (Using either TCL
or
SQL?)
for that matter, how do you save a list using SQL on Universe? I
tried
creating a view, but was told I
had to create a schema in order to create tables...that's no
fun...
I could open a como file, list the output with no headings close the
como
file,
edit it clean, the form-list the como file (work around 1)
George
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
_
Rediscover Hotmail.: Get e-mail storage that grows with you.
http://windowslive.com/RediscoverHotmail?ocid=TXT_TAGLM_WL_HM_Rediscove
r_Stor
age1_042009
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] SQL a possibility?
-Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2- us...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Thursday, April 02, 2009 4:21 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] SQL a possibility? George NowHow can I put that data into a saved-list? (Using either TCL or SQL?) for that matter, how do you save a list using SQL on Universe? I tried creating a view, but was told I had to create a schema in order to create tables...that's no fun... SQL - SELECT SWITCHIT TO SLIST 0 FROM FILENAME WHERE @ID = 'somename'; This gave me an error, about not being able to use a multivalued field.. RetrieVe - SELECT FILENAME somename SAVING SWITCHIT This did not work, instead of giving me a listing of just the ID, it saved the original line without parsing. Both create active select lists you can then SAVE.LIST. Brian --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] SQL a possibility? [ad]
*gasp!* The pain we see when people try to move data from Excel into MV. Just have a look at this: nospamNebula-RnD.com/blog/tech/2009/03/xchange-intro1.html Screenshots in blog. Beta available soon... BTW, it wouldn't help with this project but if anyone wants to export Excel sheets to CSV, see the ExcelExport utility on our freeware page here (no for-fee components of any kind required): nospamNebula-RnD.com/freeware/ Tony Gravagno Nebula Research and Development From: George Gallen I Didn't really want to do that. I opted for the COMO solution, then used the editor to delete out all the TOF's, then saved what was left in SAVEDLISTS. At that point I did a GET.LIST, followed by a SELECT on the file that the ID's were to point to. This weeded out all of the blank lines that the editor was not able to remove. Moving over to Excel and deleting columns would have been choice #2 From: Ron Hutchings If you can move between your PC and the server. Open the spreadsheet, delete all the columns you don't want, save the one column as a text file, move the file back to the server in SAVEDLISTS and you have created a list. From: ggallen I'm trying to save the first field of a .csv file to a select list, Yes, I can write a program, but I also wanted to try to do it on the fly. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] SQL a possibility?
George
Did you end up creating one process or did you opt for steps.
Laurie Blain
Unidata Programmer Analyst
Live, Love, Code!
Columbus, Ohio
laurie_bl...@yahoo.com
--- On Thu, 4/2/09, George Gallen ggal...@wyanokegroup.com wrote:
From: George Gallen ggal...@wyanokegroup.com
Subject: RE: [U2] SQL a possibility?
To: u2-users@listserver.u2ug.org u2-users@listserver.u2ug.org
Date: Thursday, April 2, 2009, 1:23 PM
I Didn't really want to do that. I opted for the COMO solution,
then
used the editor to delete out all the TOF's, then saved what was left
in SAVEDLISTS. At that point I did a GET.LIST, followed by a SELECT
on the file that the ID's were to point to. This weeded out all of the
blank lines that the editor was not able to remove.
Moving over to Excel and deleting columns would have been choice #2
George
-Original Message-
From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-
us...@listserver.u2ug.org] On Behalf Of Ron Hutchings
Sent: Wednesday, April 01, 2009 10:30 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] SQL a possibility?
If you can move between your PC and the server. Open the spreadsheet,
delete
all the columns you don't want, save the one column as a text file,
move the
file back to the server in SAVEDLISTS and you have created a
list.
From: ggal...@wyanokegroup.com
To: u2-users@listserver.u2ug.org
Date: Wed, 1 Apr 2009 16:21:28 -0500
Subject: [U2] SQL a possibility?
I'm trying to save the first field of a .csv file to a select
list,
Yes, I
can
write a program,
but I also wanted to try to do it on the fly.
Using UV10.0.2 , unix on Information format
The source data looks like:
'#12345566#','first','last',.
'#12344555#','first','last',.
Basically, field one has the item ID of another file.
The source file gets read into a tempory file input file
I created an I-desc of the following:
SWITCHIT
0001: I
0002: CONVERT(REUSE(@AM),REUSE(@VM),@RECORD) ;
FIELDS(@1,REUSE(,),REUSE(1))
;
CONVERT(REUSE('# '),REUSE(''),@2)
0003:
0004: DATA
0005: 20L
0006: M
The above will convert the whole record into one mutlivalue
attribute,
then strip off the first field delimited by the ,
then strip out the # ,' and spaces
LIST FILENAME ITEMNAME SWITCHIT ID-SUPP will list to the screen
exactly
what
I want
and so does
SELECT SWITCHIT FROM FILENAME WHERE @ID = 'ITEMNAME';
NowHow can I put that data into a saved-list? (Using either TCL
or
SQL?)
for that matter, how do you save a list using SQL on Universe? I
tried
creating a view, but was told I
had to create a schema in order to create tables...that's no
fun...
I could open a como file, list the output with no headings close the
como
file,
edit it clean, the form-list the como file (work around 1)
George
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
_
Rediscover Hotmail.: Get e-mail storage that grows with you.
http://windowslive.com/RediscoverHotmail?ocid=TXT_TAGLM_WL_HM_Rediscove
r_Stor
age1_042009
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] SQL a possibility?
Is this Unidata or Universe? In Unidata, when using the Unidata ECL, I
could use SAVING SWITCHIT
-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Wednesday, April 01, 2009 4:21 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] SQL a possibility?
I'm trying to save the first field of a .csv file to a select list, Yes,
I can
write a program,
but I also wanted to try to do it on the fly.
Using UV10.0.2 , unix on Information format
The source data looks like:
'#12345566#','first','last',.
'#12344555#','first','last',.
Basically, field one has the item ID of another file.
The source file gets read into a tempory file input file
I created an I-desc of the following:
SWITCHIT
0001: I
0002: CONVERT(REUSE(@AM),REUSE(@VM),@RECORD) ;
FIELDS(@1,REUSE(,),REUSE(1))
;
CONVERT(REUSE('# '),REUSE(''),@2)
0003:
0004: DATA
0005: 20L
0006: M
The above will convert the whole record into one mutlivalue attribute,
then strip off the first field delimited by the ,
then strip out the # ,' and spaces
LIST FILENAME ITEMNAME SWITCHIT ID-SUPP will list to the screen
exactly what
I want
and so does
SELECT SWITCHIT FROM FILENAME WHERE @ID = 'ITEMNAME';
NowHow can I put that data into a saved-list? (Using either TCL or
SQL?)
for that matter, how do you save a list using SQL on Universe? I tried
creating a view, but was told I
had to create a schema in order to create tables...that's no fun...
I could open a como file, list the output with no headings close the
como
file,
edit it clean, the form-list the como file (work around 1)
George
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] SQL a possibility?
SELECT FILENAME SAVING SWITCHIT
Will work from TCL I believe
-Original Message-
From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-
us...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Thursday, 2 April 2009 11:01 a.m.
To: u2-users@listserver.u2ug.org
Subject: [U2] SQL a possibility?
I'm trying to save the first field of a .csv file to a select list,
Yes, I can
write a program,
but I also wanted to try to do it on the fly.
Using UV10.0.2 , unix on Information format
The source data looks like:
'#12345566#','first','last',.
'#12344555#','first','last',.
Basically, field one has the item ID of another file.
The source file gets read into a tempory file input file
I created an I-desc of the following:
SWITCHIT
0001: I
0002: CONVERT(REUSE(@AM),REUSE(@VM),@RECORD) ;
FIELDS(@1,REUSE(,),REUSE(1))
;
CONVERT(REUSE('# '),REUSE(''),@2)
0003:
0004: DATA
0005: 20L
0006: M
The above will convert the whole record into one mutlivalue attribute,
then strip off the first field delimited by the ,
then strip out the # ,' and spaces
LIST FILENAME ITEMNAME SWITCHIT ID-SUPP will list to the screen
exactly what
I want
and so does
SELECT SWITCHIT FROM FILENAME WHERE @ID = 'ITEMNAME';
NowHow can I put that data into a saved-list? (Using either TCL or
SQL?)
for that matter, how do you save a list using SQL on Universe? I tried
creating a view, but was told I
had to create a schema in order to create tables...that's no
fun...
I could open a como file, list the output with no headings close the
como
file,
edit it clean, the form-list the como file (work around 1)
George
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] SQL a possibility?
George,
I use to pull a little trick saving a list of ids to the SAVEDLISTS file.
Think of the SAVEDLISTS as any file name and your list as a Record.
Within the Record write each cleaned Id on a new line.
There is a limit to the number of Ids you can place in each record.
The first record you save should be name001. After you hit your limit save
the
record and start name002. When you are finished writing your ids use
a GET.LIST name to have an active save list within your program.
To view a SAVEDLISTS name just create a SAVE.LIST and list the
SELECT SAVEDLISTS name then LIST SAVEDLISTS by Id this will give you a way to
test
for any issues. If your list has name001 name002 name003 look at name002 for
the limit.
Also check your SAVEDLISTS structure some admins have all SAVEDLISTS in one
area
others each user has there own SAVEDLISTS.
Just another way to control the task.
Laurie Blain
Unidata Programmer Analyst
Live, Love, Code!
Columbus, Ohio
laurie_bl...@yahoo.com
--- On Wed, 4/1/09, phil walker p...@gnosys.co.nz wrote:
From: phil walker p...@gnosys.co.nz
Subject: RE: [U2] SQL a possibility?
To: u2-users@listserver.u2ug.org
Date: Wednesday, April 1, 2009, 6:21 PM
SELECT FILENAME SAVING SWITCHIT
Will work from TCL I believe
-Original Message-
From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-
us...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Thursday, 2 April 2009 11:01 a.m.
To: u2-users@listserver.u2ug.org
Subject: [U2] SQL a possibility?
I'm trying to save the first field of a .csv file to a select list,
Yes, I can
write a program,
but I also wanted to try to do it on the fly.
Using UV10.0.2 , unix on Information format
The source data looks like:
'#12345566#','first','last',.
'#12344555#','first','last',.
Basically, field one has the item ID of another file.
The source file gets read into a tempory file input file
I created an I-desc of the following:
SWITCHIT
0001: I
0002: CONVERT(REUSE(@AM),REUSE(@VM),@RECORD) ;
FIELDS(@1,REUSE(,),REUSE(1))
;
CONVERT(REUSE('# '),REUSE(''),@2)
0003:
0004: DATA
0005: 20L
0006: M
The above will convert the whole record into one mutlivalue attribute,
then strip off the first field delimited by the ,
then strip out the # ,' and spaces
LIST FILENAME ITEMNAME SWITCHIT ID-SUPP will list to the screen
exactly what
I want
and so does
SELECT SWITCHIT FROM FILENAME WHERE @ID = 'ITEMNAME';
NowHow can I put that data into a saved-list? (Using either TCL or
SQL?)
for that matter, how do you save a list using SQL on Universe? I tried
creating a view, but was told I
had to create a schema in order to create tables...that's no
fun...
I could open a como file, list the output with no headings close the
como
file,
edit it clean, the form-list the como file (work around 1)
George
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] SQL a possibility?
If you can move between your PC and the server. Open the spreadsheet, delete
all the columns you don't want, save the one column as a text file, move the
file back to the server in SAVEDLISTS and you have created a list.
From: ggal...@wyanokegroup.com
To: u2-users@listserver.u2ug.org
Date: Wed, 1 Apr 2009 16:21:28 -0500
Subject: [U2] SQL a possibility?
I'm trying to save the first field of a .csv file to a select list, Yes, I
can
write a program,
but I also wanted to try to do it on the fly.
Using UV10.0.2 , unix on Information format
The source data looks like:
'#12345566#','first','last',.
'#12344555#','first','last',.
Basically, field one has the item ID of another file.
The source file gets read into a tempory file input file
I created an I-desc of the following:
SWITCHIT
0001: I
0002: CONVERT(REUSE(@AM),REUSE(@VM),@RECORD) ;
FIELDS(@1,REUSE(,),REUSE(1))
;
CONVERT(REUSE('# '),REUSE(''),@2)
0003:
0004: DATA
0005: 20L
0006: M
The above will convert the whole record into one mutlivalue attribute,
then strip off the first field delimited by the ,
then strip out the # ,' and spaces
LIST FILENAME ITEMNAME SWITCHIT ID-SUPP will list to the screen exactly
what
I want
and so does
SELECT SWITCHIT FROM FILENAME WHERE @ID = 'ITEMNAME';
NowHow can I put that data into a saved-list? (Using either TCL or
SQL?)
for that matter, how do you save a list using SQL on Universe? I tried
creating a view, but was told I
had to create a schema in order to create tables...that's no fun...
I could open a como file, list the output with no headings close the como
file,
edit it clean, the form-list the como file (work around 1)
George
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
_
Rediscover Hotmail.: Get e-mail storage that grows with you.
http://windowslive.com/RediscoverHotmail?ocid=TXT_TAGLM_WL_HM_Rediscover_Stor
age1_042009
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
