Re: How to use SQR to extract data from SQL Server and put into PS in Oracle

[franz.a.diemel@US.PWCGLOBAL.COM]

Hi Joe:
     You will set the database name and password to log on to the SQL Server
when you run the
SQR and this could be done in via run control parameters. That is the easy part.
     The thing that you want to check is to make sure that the date format is
the same between the
databases. In my case, I have to code a SQR to run in SQL and Oracle. The SQL
server and Oracle
Server are running different date formats. This can cause a problem when I
execute the SQR to pull the
data from SQL Server or Oracle.
     So.. what I do is check the database type and set a conditional to pull the
date fields based on the
database type. This database type should be part of the setup and defined in the
setenv.sqc. You can
handle this in the SQL statement with a TO_CHAR statement to make sure that it
is the correct date format
or as part of a procedure to do the data format according to the database. I
generally prefer to do it in a
procedure and keep the SQL statement generic. This is merely a programming
preference as I believe that
it allows more flexibility in the SQR.
                                          Franz





Joe Johnson <jej1216@HOTMAIL.COM> on 09/26/2000 10:17:35 AM

Please respond to sqr-users@list.iex.net
To:   SQR-USERS@list.iex.net
cc:
Subject:  How to use SQR to extract data from SQL Server and put into PS in
      Oracle

1 file attached



Greetings, both groups!

I logged this request with PS, but I thought someone in one of these two groups
could shed some light for me.

We need to extract data from an application using SQL Server. Our PS apps are on
Oracle.

I want to use an SQR to do this, but I'm not sure how to 'tell' the SQR that I
want to go into a SQL Server database to get the data. Is the secret in the SQRW
application? Do we need to configure the existing Oracle-flavored SQRW to read
SQL Server? If so, how? If not, help!

Thanks In Advance for your help.

PS 7.0
PT 7.0
Oracle 8
I have an ODBC connection to the SQL Server database

Joe Johnson
PeopleSoft Systems Analyst
joejo@snellingcorp.com
972-776-1332




----------------------------------------------------------------
The information transmitted is intended only for the person or entity to which
it is addressed and may contain confidential and/or privileged material.  Any
review, retransmission, dissemination or other use of, or taking of any action
in reliance upon, this information by persons or entities other than the
intended recipient is prohibited.   If you received this in error, please
contact the sender and delete the material from any computer.