Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> What can I do with a *.sqr file?
A client company has been sending us data in the usual ASCII
fixed-length records which we load into our Oracle server with
SQL*Plus. One day, they said: "hey, would you like us to send you the
Oracle binary tables instead?". I was puzzled since I have never heard
of such a thing, and agreed to give it a try.
What they sent me is a file 'tax1234.sqr' which contains the words:
"Copyright (C) 2004 PeopleSoft, Inc. All Rights Reserved"
#DEFINE TAX960US !Used for Tax Locality Sort
#include 'setenv.sqc' !Set environment
#define PRINTER_TYPE LINEPRINTER
plus a bunch of *.dat files that begin like this:
PTTLRG,PSPTDMO, PTTREE,PSPTDMO, PTWORK,PSPTDMO,
B(BPAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABAAAAAA)A(J)B(AAAAAA)A(C)B(AA)A(R)B(AA) B()A(E)B(AA)A(A)B(AA)A(T)B(AA)A(E)B(AA)A( )B(AA)A(T)B(AA)A(A)B(AA)A(B) A()B(AA)A(L)B(AA)A(E)B(AA)A( )B(AAFLAA)A(T)B(AA)A(B)B(AA)A(N)B(AA)A(A) A()B(AA)A(M)B(AA)A(E)B(AAFNAA)A( )B(AA)A(\()B(AAFLAA)A(T)B(AA)A(B)B(AA) B()A(C)B(AA)A(O)B(AA)A(L)B(AA)A(L)B(AA)A(I)B(AA)A(S)B(AA)A(T)B(AAFNAA) B()A(\))B(AA)A(;)B(AAAAAAAAAAAAAAAAAAAAAAACAAAAAAABAAABAAJAAAAAAA)A(C)A()B(AA)A(R)B(AA)A(E)B(AA)A(A)B(AA)A(T)B(AA)A(E)B(AA)A( )B(AA)A(T)B(AA) B()A(A)B(AA)A(B)B(AA)A(L)B(AA)A(E)B(AA)A( )B(AA)A(*)B(AA)A(*)B(AA)A(O)
I have read in the net about some programming language or report writer called 'SQR'. My Solaris and Linux boxes have a lot of compilers and interpreters, but I am afraid this 'SQR' is not one of them.
Could someone with knowledge of SQR explain what is the advantage of sending me the data that way? I honestly thought that this was some 100% Oracle thing, that would avoid the SQL*Loader step, but now it looks like I will have to learn SQR and buy the SQR system.
TIA, -Ramon Received on Wed Apr 06 2005 - 01:50:21 CDT