f



How to read long raw column data into a file

Hi all,

What would be easier way to read long raw column "data" into a file?

Oracle version 9.2.0.7

Thanks in advance

SS 


0
kalle4749 (34)
10/22/2006 11:10:51 AM
comp.databases.oracle.server 22978 articles. 1 followers. Post Follow

1 Replies
606 Views

Similar Articles

[PageSpeed] 2

Simo Silmu wrote:
> Hi all,
> 
> What would be easier way to read long raw column "data" into a file?
> 
> Oracle version 9.2.0.7
> 
> Thanks in advance
> 
> SS 

C, C++, or Java ... Depends on which one you know best.
-- 
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
0
damorgan3 (6326)
10/22/2006 6:21:00 PM
Reply:

Similar Artilces:

read raw data file from server
Hello, I have a lot of txt file on our server. I want to know how to write the infile statement in SAS since there is not any letter to identify the drive name? Thanks dd sf --------------------------------- New Yahoo! Messenger with Voice. Call regular phones from your PC and save big. Dd sf - You just need to specify the full UNC in the path. Check your server and share names. In my case "HQ-SRV43\GROUPS" is the server name and "INFSYS" is the share name. filename test '\\HQ-SRV43\GROUPS\INFSYS\DataX\PC\Jobs\test.txt'; data _null_; infile test; input...

Re: read raw data file from server
Dd sf - You just need to specify the full UNC in the path. Check your server and share names. In my case "HQ-SRV43\GROUPS" is the server name and "INFSYS" is the share name. filename test '\\HQ-SRV43\GROUPS\INFSYS\DataX\PC\Jobs\test.txt'; data _null_; infile test; input; put _infile_; run; Here's a little more information on UNC's: http://compnetworking.about.com/od/windowsnetworking/l/bldef_unc.htm hth Paul Choate DDS Data Extraction (916) 654-2160 > -----Original Message----- > From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of df ss > Sent: Friday, June 16, 2006 2:34 PM > To: SAS-L@LISTSERV.UGA.EDU > Subject: read raw data file from server > > Hello, > I have a lot of txt file on our server. I want to know how to write the > infile statement in SAS since there is not any letter to identify the > drive name? > Thanks > dd sf > > > --------------------------------- > New Yahoo! Messenger with Voice. Call regular phones from your PC and save > big. ...

Re: read raw data file from server #2
How do you specify the server, outside of SAS, when you try to copy a file to it? Art ---------- On Fri, 16 Jun 2006 14:33:46 -0700, df ss <tggsun@YAHOO.COM> wrote: >Hello, > I have a lot of txt file on our server. I want to know how to write the infile statement in SAS since there is not any letter to identify the drive name? > Thanks > dd sf > > >--------------------------------- >New Yahoo! Messenger with Voice. Call regular phones from your PC and save big. ...

reading data in a text file column-by-column
OK let us suppose I have a text file (*.txt or *.dat) in which the data is as follows: 1 100 1 1 2 1. 28.342 2 100 1 1 0.944 20.123 3 100 1 1 3 0.9 0. Now I want to read from this text file and store the data in each column in a separate matrix. For example, If I am able to store the first column into a matrix "item_no", the matrix shall be like [1 2 3] and the second column can be stored into a matrix "Quantity" and will look like [100 100 100]. Can someone please help me out on this? I have a project and I cannot proceed further witho...

About LONG data type: How to read LONG fileds when link two same tables?
Hi, all I'm developping an application. I have a table which has a "LONG" column. I need to run such sql by OCI: SELECT "TEST_LONG"."CONTENT", "TEST_LONG_1"."CONTENT" FROM "GUEST"."TEST_LONG" "TEST_LONG" INNER JOIN "GUEST"."TEST_LONG" "TEST_LONG_1" ON "TEST_LONG"."ID"="TEST_LONG_1"."ID" The TEST_LONG_1 is an alias of TEST_LONG. The CONTENT is a "LONG" datatype column. However, after executed the sql, I found that when...

Reading data from oracle database
Can anyone help me on understanding how data is read from oracle database.There is a db writer process which writes data in the dbf files from dirty buffers. Similary what is the the mechanism for reading data from dbf files of oracle database. If a user connect's to sqlplus session and gives the command 'select * from table x' ,what all process happens next. Thanks in Advance On Fri, 12 Dec 2008 00:23:54 -0800, oracle user wrote: > Can anyone help me on understanding how data is read from oracle > database.There is a db writer process which writes data in the dbf files > from dirty buffers. Similary what is the the mechanism for reading data > from dbf files of oracle database. > If a user connect's to sqlplus session and gives the command 'select > * from table x' ,what all process happens next. Thanks in Advance Many things can happen, depending on the version of database. Short story goes like this: - User connects to the database. User session structures are allocated in SGA. - User submits SQL statement and is given a server process to service his request. Server process does its own reading but writing is delegated to the database writer(s). The allocation process is complex as the allocated server can be shared, pooled or dedicated. - The server process executes the request and returns the result to the user. How is that done also depends on the allocated server. All of this is described in the lit...

Read column from Oracle with datatype LONG
I try to extract information about views defined i Oracle. The information is in the table SYS.VIEW$ Here is my SQL: proc sql noprint; connect to ODBC (dsn=fdwprd schema=sys uid=fdwprd pwd=XXXXXXXX); create table view_txt as select * from connection to odbc ( select obj# , text from sys.view$ ); disconnect from odbc; create table view_name as select object_id , object_id , last_ddl_time from fdwprd.user_objects where object_type = 'VIEW' ; create table views as select a.*, b.* from view_name a, ...

Reading data file with text column
Hello, Is anyone can read the following row? 1,06/05/2004,9:51:12,0.107,0.0834,31.064,0,0,17,0,26 I tried many ways like fscanf(fid,'%d, %d/%d/%d,%d:%d:%d, %f, %f, %f, %f, %f, %f, %f, %f',[11 1]) fscanf(fid,'%d, %10c,%s, %f, %f, %f, %f, %f, %f, %f, %f',[11 1]) ..... They never worked. Please save me out of this trap. Thank you in advance. Ciao, Jee Put the line that you have posted in a file (e.g. Edit.dat)and try with that command: [n,d,m,y,h,m,s,a1,a2,a3,a4,a5,a6,a7,a8]=textread('Edit.dat','%d,%d/%d/%d,%d: %d:%d,%f,%f,%f,%d,%d,%d,%d,%d') bye -- Al...

Read data file with changing number of columns
Hi, How can I read a data text file that features several vertical parts each one with a different number of data columns i.e. matrices of different sizes? Furthermore, each part begins with a text header. The command "textread" does not seem to be appropriate for this purpose, is it? Thank you try uiimport (see help for details) ...

Inserting a binary file into a Long Raw column
Hi Is there anybody who can give me some sample code for inserting a large binary file into a LONG RAW column? I have managed to do it if the file is less than 32Kb. Any jelp will be appreciated. Regards Ozzy ...

Data tool
Hello, I have long db with many records. When I want to use datatool package, records doesnt fit on one page but rest of them are lost (they try to be written outside page). So the question is: 1. Is there any possibility to somehow add \newpage after certain amount of iterations or 2. is there possible to list db content in two column mode on page (first records fills one column and then second). best regards Sebastian Szwarc On Jul 18, 9:10=A0am, Sebastian Szwarc <beyond...@tlen.pl> wrote: > Hello, > I have long db with many records. When I want to use datatool package, > records doesnt fit on one page but rest of them are lost (they try to be > written outside page). So the question is: I have never actually used datatool, but the documentation says that \DTLdisplaydb assembles the data into a tabular environment (no pagebreaks allowed), while \DTdisplaylongdb uses a longtable environment (page breaks automatically produced when needed). Would that do what you need? Dan > I have never actually used datatool, but the documentation says that > \DTLdisplaydb > assembles the data into a tabular environment (no pagebreaks allowed), > while > \DTdisplaylongdb > uses a longtable environment (page breaks automatically produced when > needed). > > Would that do what you need? > Longtable center content on the page, I cannot make it to work with minipage or column. I rather i...

Reading in multiple raw data files with headers
Hello all, I am trying to read in and stack multiple raw data files (file1, file2 etc)which contain the same variables (var1, var2 etc) but refer to different time periods. I also want to add a variable to the final dataset so that I can tell which file an observation originally came from. The following program works fine when I try to read in text files without a line of variable names at the top (omitting the firstobs=2 option). However, I get 'invalid data' error messages when I try to read in tab-delimited text files with a line of variable names at the top. data allfiles; in...

How to read every data in the first column corresponding to the every data in the second column in the TABLE CONTROL?
Hello everyone &nbsp; like this table &nbsp; 0.0001&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -4.6 0.0002&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -4.3 0.0004&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -4.0 0.0006 0.0008 0.001 &nbsp; I want to get&nbsp; pairs (0.0001, -4.6) (0.0001, -4.3)&nbsp; (0.0001,&nbsp; -4.0) (0.0002,&nbsp; -4.6) (0.0002,&nbsp; -4.3) (0.0002,&nbsp; -4.0) (0.0004,&nbsp; -4.6) (0.0004,&nbsp; -4.3) (0.0004,&nbsp; -4.0)........ to control the number of loop &nbsp; so how cam get this whole pairs? &nbsp; Thank you for any help! Jing &nbsp; &nbsp; &nbsp;??????06-20-2008 09:07 AM????? different F many measurement.vi: http://forums.ni.com/attachments/ni/170/333583/1/different F many measurement.vi I'm not sure I understand. Your code already shows you autoindexing the outer for-loop so it runs for each row. And the inner loop is set to run a constant 100 times for each row, and you're indexing out each column from the specific row that is currently being executed. So what's the problem? Hi,It's not pretty but how about this?<img src="http://forums.ni.com/attachments/ni/170/333596/2/col1%20with%20every%20value%20of%20col2.PNG"> First turn your input table into a 2D array.You can then auto index every row of the outpu...

Re: Reading in multiple raw data files with headers
Dear Katherine, Departing from your code I would propose the following *untested* amendment: data allfiles; infile 'C:\sasdata\file*.txt' dlm='09'x firstobs=2 eov=newfile missover; retain time 1; if newfile then do; * First record of each next, not first file; newfile=0; * Is this really necessary? Not auto-0 next record? ; time+1; INPUT; * Skip each first line of new file, no variables specified; end; ELSE input var1 var2 var3 var4 var5; * Read the variables as desired; run; Try this and tell us whether it works. Regards - Jim. -- Jim Groeneveld, Netherlands Statistician, SAS consultant home.hccnet.nl/jim.groeneveld On Fri, 19 May 2006 14:36:23 +1000, Katherine Smith <katherine.smith@MCRI.EDU.AU> wrote: >Hello all, > >I am trying to read in and stack multiple raw data files (file1, file2 >etc)which contain the same variables (var1, var2 etc) but refer to >different time periods. I also want to add a variable to the final dataset >so that I can tell which file an observation originally came from. The >following program works fine when I try to read in text files without a >line of variable names at the top (omitting the firstobs=2 option). >However, I get 'invalid data' error messages when I try to read in >tab-delimited text files with a line of variable names at the top. > >data allfiles; > infile 'C:\sasdata\file*.txt' dlm='09'x firstobs=2 eov=newfile missov...

Re: Reading an image file from an oracle database and storing it
Can't blobs be stored in a catalog entry? Clint -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU]On Behalf Of Richard A. DeVenezia Sent: Friday, June 09, 2006 2:16 PM To: SAS-L@LISTSERV.UGA.EDU Subject: Re: Reading an image file from an oracle database and storing it in a SAS data set. jbeeler@nc.rr.com wrote: > Is it possible to read an image (*.bmp, *.jpg, *.tif) file from an > oracle database and store it in a SAS data set? Generally no. Standard SAS library engines do not store the equivalent of Oracle blobs, clobs or other *obs. The SAS character type can store values upto 32767 bytes long, so you could store image data upto 32K in a character variable in a SAS table. To store larger image data, you would have to manually break it up into 32K chunks. You might need a oracle side function to convert the image file into a string value. -- Richard A. DeVenezia http://www.devenezia.com/ ...

Re: Importing a raw data file with 355 columns
254 characters, or 254 fields? If the former: 256 is the default record length, but not the maximum. So the INFILE statement needs to include lrecl=355 I don't know how to address this in EG. On Wed, 20 Sep 2006 10:16:27 -0300, =?ISO-8859-1?Q?Jos=E9_Angel_Alvarez?= <jalvares@GMAIL.COM> wrote: >I tried to import the file using Enterprise Guide but found that I could >only import 254 columns. Is this a hard limit in EG? >Would someone advice me about efficient ways to import the file to a SAS >format (sas7bdat)? The file has 355 columns and approx. 360.000 rows. It is >tab delimited. >Thank you all. > >-- >Jos� Angel Alvarez ...

Re: Reading an image file from an oracle database and storing
You can store some types of image files as catalog entries. One problem, pointed out by Richard, is getting the image/BLOB out of the Oracle database. SAS needs help for that. Using an Oracle tool may be the best choice. I'm currently working on a long-term project that requires extracting BLOBS from a SQL-Server database. I wrote a simple Java application to serve as SAS's helper. It writes the BLOBS as files. -Randy -----Original Message----- From: owner-sas-l@listserv.uga.edu [mailto:owner-sas-l@listserv.uga.edu] On Behalf Of Rickards, Clinton (GE Consumer Finance) Sent: Friday, June 09, 2006 4:36 PM To: Richard A. DeVenezia; SAS-L@LISTSERV.UGA.EDU Subject: RE: Re: Reading an image file from an oracle database and storing it in a SAS data set. Can't blobs be stored in a catalog entry? Clint -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU]On Behalf Of Richard A. DeVenezia Sent: Friday, June 09, 2006 2:16 PM To: SAS-L@LISTSERV.UGA.EDU Subject: Re: Reading an image file from an oracle database and storing it in a SAS data set. jbeeler@nc.rr.com wrote: > Is it possible to read an image (*.bmp, *.jpg, *.tif) file from an > oracle database and store it in a SAS data set? Generally no. Standard SAS library engines do not store the equivalent of Oracle blobs, clobs or other *obs. The SAS character type can store values upto 32767 bytes long, so you could store image data upto 32K in a character variable in a SAS ...

How a server oracle can read mdb(access) database
Hi. I have a server "A" with oracle 10g express (free) and a server "B" with an Access database. I need that an application that uses oracle server can reads tables on "B". How can i do this? Can do i make a Local View on "A" of "B"? thanks On Apr 30, 11:49 am, Raimo <m0...@yahoo.it> wrote: > Hi. I have a server "A" with oracle 10g express (free) and a server > "B" with an Access database. > I need that an application that uses oracle server can reads tables on > "B". How can i do this? > Can do i make a Local View on "A" of "B"? > thanks You can attach odbc tables in Access, but performance sucks big time when Access tries to resolve queries on remote tables. Keep all your data in Oracle and use passthrough queries so that Oracle does the clever stuff. (Or keep everything in Access - but concurrent access sucks). C. On 30 Apr, 14:28, "C. (http://symcbean.blogspot.com/)" <..> wrote: > On Apr 30, 11:49 am, Raimo <molok> wrote: > > > Hi. I have a server "A" with oracle 10g express (free) and a server > > "B" with an Access database. > > I need that an application that uses oracle server can reads tables on > > "B". How can i do this? > > Can do i make a Local View on "A" of "B"? > > thanks > > You can attach odbc tables in Access, ...

Validating form data against a SQL Server database or flat file
Hello, OK, I know, using client-side validation to validate form data like this isn't the best way in terms of security: <script language="JavaScript"> function GetContactName(formObj) { var sServer = "LOCAL"; var sDatabase = "Northwind"; var sUid = "test"; var sPwd = "password"; var sUserIdToLookup = formObj; var oConn = new ActiveXObject("ADODB.Connection"); var sConnString = "PROVIDER=MSDASQL" + ";DRIVER={SQL Server}" + ";SERVER=" + sServer + ";DATABASE=" + sDatabase + ";UID=" + sUid + ";PWD=" + sPwd + ";"; oConn.Open(sConnString); var oRS = oConn.Execute("SELECT ContactName FROM Customers WHERE CustomerID='" + sUserIdToLookup + "'"); if (!oRS.EOF) { alert("The contact name for " + sUserIdToLookup + " is " + oRS("ContactName").Value); } else { alert("User not found."); oConn.Close(); } } </script> <FORM> <INPUT TYPE="text" NAME="test"> <INPUT TYPE="submit" value="I'm Feeling Lucky" NAME=btn1 onClick="GetContactName(this)"> </FORM> But........, is there a way to compare the form object value against values in a flat file, like with arrays? I have an Excel sheet of 1300 values I'd like to be able to use as a comparator against the value I grab from the form to validate the input...

Create XML file from XMLTYPE column in oracle database #2
Hi All, Could someone please help me how to create xml doc from database with xmltype datatype? I want something like utl_file.put_line. Help appreciated. Thanks! ...

Re: Reading in multiple raw data files with headers #5
Katherine, Unfortunately, while I had just written and tested a solution that worked, my office is currently upgrading our system and I lost access to what I had written. I'll do my best to recall, but no guarantees. If it doesn't work, write me offline and I'll send you what I know had worked when I can again access my system on Tuesday. data allfiles; infile 'C:\sasdata\file*.txt' dlm='09'x eov=newfile missover; input x $255 @; retain newfile; if _n_ eq 1 or newfile then do; newfile=0; test+1; end; else do; input @1 var1 var2 var3 var4 var5; output; end; run; HTH, Art ---------- On Fri, 19 May 2006 14:36:23 +1000, Katherine Smith <katherine.smith@MCRI.EDU.AU> wrote: >Hello all, > >I am trying to read in and stack multiple raw data files (file1, file2 >etc)which contain the same variables (var1, var2 etc) but refer to >different time periods. I also want to add a variable to the final dataset >so that I can tell which file an observation originally came from. The >following program works fine when I try to read in text files without a >line of variable names at the top (omitting the firstobs=2 option). >However, I get 'invalid data' error messages when I try to read in >tab-delimited text files with a line of variable names at the top. > >data allfiles; > infile 'C:\sasdata\file*.txt' dlm='09'x firstobs=2 eov=newfile missover; > input ...

How can I read X data from one file (.txt), Y data from another file (.txt) and plot a fit of the graph?
I have two files (.txt), one with the X values&nbsp;&nbsp;and the other (.txt)&nbsp;with the Y values. Both the files are like this: &nbsp; 34 54 76 89 ... &nbsp;and the number of rows is of course the same in both cases. &nbsp; I want to read them, find a fit for the curve and then have the values of the fit curve&nbsp;disposable for plotting&nbsp;them or for further elaboration. &nbsp; I have tried using "read from spreadsheet.vi" and the&nbsp;"curve fitting"&nbsp;block but I experienced several problems. &nbsp; What can I do? Thank you very much. &nbsp; Best Regards, Emanuele Cornagliotti&nbsp; &nbsp; &nbsp; You would need two separate Read From Spreadsheet functions but if you are using the Curve Fitting Express VI, then you need to convert the x and y data to a dynamic data type. You do this and wire to the Signals and Locations inputs. Instead, you can use the lower level curve fittings functions (i.e. Linear Fit) which accept separate x and y arrays as inputs. <img src="http://forums.ni.com/attachments/ni/170/230818/1/Curve%20Fit%20from%20Two%20Files.PNG"> Message Edited by Dennis Knutson on 02-19-2007 09:37 AM Curve Fit from Two Files.PNG: http://forums.ni.com/attachments/ni/170/230818/1/Curve Fit from Two Files.PNG This is actually what I did. I used the curve fitting module (using a spline interpolant)&nbsp;and i converted the data to the dynamic data type: T...

Re: Reading in multiple raw data files with headers #4 1553854
you can use system pipe to do so very easily. Here is code and you might need to change something. /* SAMPLE DATA IN 4 FILES WITH UNKNOWN NAMES 12011997 M 09/08/04 12011997 F 01/26/01 .... */ /* USE PIPE TO RETURN A LIST OF FILENAMES */ filename indata pipe 'dir "C:\temp" /b'; data File Data; format path $100.; /* OPEN A PIPE FOR INPUT */ infile indata truncover; /* INPUT FILE NAMES */ input file $20.; /* SPECIFY FULL PATH OF FILES */ if index(file, "yourheader") >= 1 then path = 'C:\temp\'||file; put path; /* OPEN EACH FILE */ infile dummy filevar = path end = done truncover; do while(not done); /* INPUT DATA IN THE FILE */ input Account $ 1-8 Sex $ 10-10 Date mmddyy8.; format Date Date.; output; end; run; On 5/19/06, Katherine Smith <katherine.smith@mcri.edu.au> wrote: > Hello all, > > I am trying to read in and stack multiple raw data files (file1, file2 > etc)which contain the same variables (var1, var2 etc) but refer to > different time periods. I also want to add a variable to the final dataset > so that I can tell which file an observation originally came from. The > following program works fine when I try to read in text files without a > line of variable names at the top (omitting the firstobs=2 option). > However, I get 'invalid data' error messages when I try to read in > tab-delimited text files with a line of variable names at the top. > > data allfiles; > infile...

Can proc sql read raw data from a big text file?
Because I have a SQL codes provided for SQL server to read such data. I couldn't find any example that proc sql can read raw data from a file. Thank you for your answer. Andrew Andrew, No, it cannot. The only "proc" capable of reading raw data from a text file (regardless of size) is the Data step. The only exceptions are raw text files with a predetermined structure, such as CSV files. Kind regards, ---------------- Paul M. Dorfman Jacksonville, FL ---------------- > -----Original Message----- > From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On > Behalf Of...

Web resources about - How to read long raw column data into a file - comp.databases.oracle.server

Politics, Political News - The Capitol Column
Covering the politics of science, technology, business, entertainment, Capitol Hill, and health.

Column (typography) - Wikipedia, the free encyclopedia
In typography , a column is one or more vertical blocks of content positioned on a page, separated by gutters and/or rules . Columns are most ...

Column 8
&quot;In the 1970s, when I was manager at the Glebe Island container terminal for Columbus Line,&quot; recalls Joe Kensell, of &nbsp;Five Dock ...

Jeff Passan Column About Goose Gossage Blows Hot, Cold
On Friday, Yahoo Sports baseball writer Jeff Passan led off his column with the following paragraph: Goose Gossage , a giant bag of gas that ...

Tuesday Morning Open Thread: The (D) Column
… maybe that stands for (D)ueling (D)eities? Also, a bloc of supporters that only the Dems would, uhhh, solicit (and good for Hillary, doing ...

Why Men shouldn't write advice columns
Passed along by you guessed it Papa B. Hey, I'm just the messenger!

Sunil Sethi: Make in India or breaking India? - Business Standard Column Widgets Magazine Widgets Magazine ...
Centre's hamfisted reaction to JNU row doesn't bode well for its Make in India initiative

Column: Night of losers is another winner for UFC
LAS VEGAS (AP) — Her face marked and still red, Holly Holm stared blankly ahead as Conor McGregor walked in, looking a lot worse for the wear ...

‘Crouching Tiger’ Sequel: An American Filmmaker’s Quest To Make The First Eastern Western – Guest Column ...
Sixteen years after Crouching Tiger, Hidden Dragon became a worldwide phenomenon, the sequel has been released today in China ahead of its U.S. ...


Resources last updated: 3/20/2016 12:58:56 AM