Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> What can I do with a *.sqr file?

What can I do with a *.sqr file?

From: Ramon F Herrera <ramon_at_conexus.net>
Date: 5 Apr 2005 23:50:21 -0700
Message-ID: <1112770221.729914.88470@o13g2000cwo.googlegroups.com>


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,

PTPRC,PSPTDMOT,
BNAPP,,4
HRAPP6,,4
HRLARGE,,4
/
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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US