[U2] Run SQL statement through shell script?

Dear All How to run sql statement through shell? I am trying following way but no success. /unidata/udt !!Start SET LINESIZE 290; SET HEADING OFF; SET SPACE 2; SET PAGES 0; como on studentinfo; SELECT ID,LNAME,FNAME from STUDENT; como off; exit !!start Regards Dattatraya -- View

[U2] How to Extract Selected multivalue colums

NULL WEOFSEQ CSVFIL SELECT FIL LOOP WHILE READNEXT ID DO READ REC FROM FIL,ID THEN LINE = '' : CHANGE(CHANGE(REC,@AM,'|'),@VM,'|') : '|':ID WRITESEQ LINE ON CSVFIL ELSE CRT 'CAN NOT EWRITE TO CSV FILE' END REPEAT --- Regards Dattatraya -- View this message in context: http

Re: [U2] Unibasic: Sample program - to extract data from Table

E. 23rd St.,Arvada,CO,80276,3037768854,V4341,9611,D,7,R,6 Thanks Regards, Dattatraya Walgude -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Edward Brown Sent: Friday, October 16, 2009 12:39 PM To: U2 Users List

Re: [U2] Unibasic: Sample program - to extract data from Table

Thanks Ed, Will debug code, as you asked. Thanks Regards, Dattatraya Walgude DBA Team Rsystems International Ltd, Pune, ( : +91-20-22909212 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Edward Brown Sent

Re: [U2] Unibasic: Sample program - to extract data from Table

Thanks Regards, Dattatraya Walgude -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Edward Brown Sent: Friday, October 16, 2009 3:29 PM To: U2 Users List Subject: Re: [U2] Unibasic: Sample program - to extract data

Re: [U2] Unibasic: Sample program - to extract data from Table

Thanks Ed, It comes correct (only two records), missing another rows:- Jones, Bob,123 E. 23rd St.,Arvada,CO,80276,3037768854,V4341,04/24/94,D,7,6 Jones, Bob,123 E. 23rd St.,Arvada,CO,80276,3037768854,V4341,04/24/94,C,7,6 Thanks Regards, Dattatraya Walgude DBA Team Rsystems International Ltd

Re: [U2] Unibasic: Sample program - to extract data from Table

,5,210 Wagner, Esther,,Kenosha,WI,53140,4145527433,,,B,5,210 Thanks Regards, Dattatraya Walgude DBA Team Rsystems International Ltd, Pune, ( : +91-20-22909212 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Edward

Re: [U2] Unibasic: Sample program - to extract data from Table

Sorry Symeon and all for asking such silly question. I manage @ID column in output.csv in following way, now I want multivalue columns in new lines with all columns (now its comes in one row/line) LINE = '' : CHANGE(CHANGE(REC,@AM,','),@VM,',') : ',':ID Thanks Regards, Dattatraya Walgude

Re: [U2] Unibasic: Sample program - to extract data from Table

Thanks Jeff Sure, but right now preparing some basics concepts. Regards, Dattatraya Walgude -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Powell Sent: Thursday, October 15, 2009 5:42 PM To: u2-users

Re: [U2] Unibasic: Sample program - to extract data from Table

is (04/24/94) is it possible? Jones, Bob,123 E. 23rd St.,Arvada,CO,80276,3037768854,V4341,9611,D,7,6 Jones, Bob,123 E. 23rd St.,Arvada,CO,80276,3037768854,V4341,9611,C,7,6 Jones, Bob,123 E. 23rd St.,Arvada,CO,80276,3037768854,V4341,9611,R,7,6 Thanks Regards, Dattatraya Walgude -Original

Re: [U2] Unibasic: Sample program - to extract data from Table

--^ Expecting: ELSE compilation failed Thanks Regards, Dattatraya Walgude DBA Team Rsystems International Ltd, Pune, ( : +91-20-22909212 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun

Re: [U2] Unibasic: Sample program - to extract data from Table

Many Many Thanks Edward and Symeon Its work... Thanks Regards, Dattatraya Walgude -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Edward Brown Sent: Monday, October 12, 2009 4:55 PM To: U2 Users List Subject

Re: [U2] Unibasic: Sample program - to extract data from Table

6AEAýý5421,13942ýSAPý13942ý6RE1ý1ý60+DAY EA ROUTE 1ýQ6AEýAýý9757,13942ýSUSýFailed ValidationýýýWITH SIXTYD.ABOVE.AMT.OVRD GE 10.00 ý Thanks Regards, Dattatraya Walgude -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf

Re: [U2] Unibasic: Sample program - to extract data from Table

Jamieson Dale 999 Independence WaySeattle WI 98733 V6670 96118 One more query @ID column is missing in output.csv, please suggest how to get that @ID column in output.csv. Regards Dattatraya Walgude

[U2] Unibasic: Sample program - to extract data from Table

Dear All I am new in Unidata/Unibasic, I want a sample program to extract data from one of our big history table. Kindly give me any link/ suggestion. Thanks Regards, Dattatraya Walgude Disclaimer * This mail, including any attachments

[U2] How to check data dictionary?

* from )? 3) How to remove extra space from column ( like oracle Trim() ) Your suggestions are most well-come and waiting for your positive reply. Regards Dattatraya Thanks Regards, Dattatraya Walgude DBA Team Rsystems International Ltd, Pune, * : +91-20-22909212

Re: [U2] How to check data dictionary?

to extract/see data. I will be thankful to you, if you provide me all steps in details. This is urgent matter my work is stuck. Thanks in advance. Dattatraya Walgude -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf

[U2] How to extract data from such tables

to remove extra space from column ( like oracle Trim() ) Your suggestions are most well-come and waiting for your positive reply. Regards Dattatraya -- View this message in context: http://www.nabble.com/How-to-extract-data-from-such-tables-tp25745875p25745875.html Sent from the U2 - Users mailing